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: Dec 18, 2025

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

You need to migrate a 2TB relational database to Google Cloud Platform. You do not have the resources to

significantly refactor the application that uses this database and cost to operate is of primary concern.

Which service do you select for storing and serving your data?

A : oud Spanner

B : oud Bigtable

C : oud Firestore

D : oud SQL

Answer: D

Question 3

MJTelco’s Google Cloud Dataflow pipeline is now ready to start receiving data from the 50,000 installations. You want to allow Cloud Dataflow to scale its compute power up as required. Which Cloud Dataflow pipeline configuration setting should you update?

A : zone

B : number of workers

C : disk size per worker

D : maximum number of workers

Answer: A

Question 4

If you're running a performance test that depends upon Cloud Bigtable, all the choices except one below are recommended steps. Which is NOT a recommended step to follow?

A : not use a production instance.

B : n your test for at least 10 minutes.

C : fore you test, run a heavy pre-test for several minutes.

D : at least 300 GB of data.

Answer: A

Question 5

You work for a shipping company that uses handheld scanners to read shipping labels. Your company has strict data privacy standards that require scanners to only transmit recipients’ personally identifiable information (PII) to analytics systems, which violates user privacy rules. You want to quickly build a scalable solution using cloud-native managed services to prevent exposure of PII to the analytics systems. What should you do?

A : eate an authorized view in BigQuery to restrict access to tables with sensitive data.

B : tall a third-party data validation tool on Compute Engine virtual machines to check the incoming data for sensitive information

C : Stackdriver logging to analyze the data passed through the total pipeline to identify transactions that may contain sensitive information

D : ild a Cloud Function that reads the topics and makes a call to the Cloud Data Loss Prevention API. Use the tagging and confidence levels to either pass or quarantine the data in a bucket for review.

Answer: D

Page: 1 / 95

Total 472 Questions | Updated On: Dec 18, 2025

Add To Cart