Free Google Professional-Data-Engineer Exam Questions

Become Google Certified with updated Professional-Data-Engineer exam questions and correct answers

Page: 1 / 95

Total 472 Questions | Updated On: May 12, 2026

Add To Cart

Question 1

You are using Google BigQuery as your data warehouse. Your users report that the following simple query is running very slowly, no matter when they run the query: SELECT country, state, city FROM [myproject:mydataset.mytable] GROUP BY country You check the query plan for the query and see the following output in the Read section of Stage:1:

What is the most likely cause of the delay for this query?

A : ers are running too many concurrent queries in the system

B : [myproject:mydataset.mytable] table has too many partitions

C : ther the state or the city columns in the [myproject:mydataset.mytable] table have too many NULL values

D : t rows in the [myproject:mydataset.mytable] table have the same value in the country column, causing data skew

Answer: A

Question 2

Each analytics team in your organization is running BigQuery jobs in their own projects. You want to enable each team to monitor slot usage within their projects. What should you do?

A : eate a Stackdriver Monitoring dashboard based on the BigQuery metric query/scanned_bytes

B : eate a Stackdriver Monitoring dashboard based on the BigQuery metric slots/allocated_for_project

C : eate a log export for each project, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

D : eate an aggregated log export at the organization level, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

Answer: D

Question 3

You are consulting to a company developing an IoT application that analyzes data from sensors deployed on drones. The application depends on a database that can write large volumes of data at low latency. The company has used Hadoop HBase in the past but wants to migrate to a managed database service. What service would you recommend?

A : Bigtable

B : Cloud Firestore

C : Cloud Spanner

D : BigQuery

Answer: A

Question 4

You are designing a data warehouse in BigQuery to analyze sales data for a telecommunication service

provider. You need to create a data model for customers, products, and subscriptions All customers, products,

and subscriptions can be updated monthly, but you must maintain a historical record of all data. You plan to

use the visualization layer for current and historical reporting. You need to ensure that the data model is

simple, easy-to-use. and cost-effective. What should you do?

A : Create a normalized model with tables for each entity. Use snapshots before updates to track historical data

B : Create a normalized model with tables for each entity. Keep all input files in a Cloud Storage bucket to track historical data

C : Create a denormalized model with nested and repeated fields Update the table and use snapshots to track historical data

D : Create a denormalized, append-only model with nested and repeated fields Use the ingestion timestamp to track historical data.

Answer: D

Question 5

You work for a manufacturing plant that batches application log files together into a single log file once a day at 2:00 AM. You have written a Google Cloud Dataflow job to process that log file. You need to make sure the log file in processed once per day as inexpensively as possible. What should you do?

A : ange the processing job to use Google Cloud Dataproc instead

B : nually start the Cloud Dataflow job each morning when you get into the office.

C : eate a cron job with Google App Engine Cron Service to run the Cloud Dataflow job.

D : nfigure the Cloud Dataflow job as a streaming job so that it processes the log data immediately.

Answer: C

Page: 1 / 95

Total 472 Questions | Updated On: May 12, 2026

Add To Cart