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: Feb 19, 2026

Add To Cart

Question 1

You are creating a new pipeline in Google Cloud to stream IoT data from Cloud Pub/Sub through Cloud Dataflow to BigQuery. While previewing the data, you notice that roughly 2% of the data appears to be corrupt. You need to modify the Cloud Dataflow pipeline to filter out this corrupt data. What should you do?

A : a SideInput that returns a Boolean if the element is corrupt.

B : a ParDo transform in Cloud Dataflow to discard corrupt elements

C : a Partition transform in Cloud Dataflow to separate valid data from corrupt data.

D : a GroupByKey transform in Cloud Dataflow to group all of the valid data together and discard the rest.

Answer: B

Question 2

How would you query specific partitions in a BigQuery table?

A : the DAY column in the WHERE clause

B : the EXTRACT(DAY) clause

C : the __PARTITIONTIME pseudo-column in the WHERE clause

D : DATE BETWEEN in the WHERE clause

Answer: C

Question 3

You operate a database that stores stock trades and an application that retrieves average stock price for a given company over an adjustable window of time. The data is stored in Cloud Bigtable where the datetime of the stock trade is the beginning of the row key. Your application has thousands of concurrent users, and you notice that performance is starting to degrade as more stocks are added. What should you do to improve the performance of your application?

A : ange the row key syntax in your Cloud Bigtable table to begin with the stock symbol.

B : ange the row key syntax in your Cloud Bigtable table to begin with a random number per second.

C : ange the data pipeline to use BigQuery for storing stock trades, and update your application.

D : Cloud Dataflow to write summary of each day’s stock trades to an Avro file on Cloud Storage. Update your application to read from Cloud Storage and Cloud Bigtable to compute the responses.

Answer: A

Question 4

A European health care company uses Cloud Pub/Sub as part of a data processing pipeline. The CTO of the company is concerned that data might accidentally be written to a region outside the European Union, which would violate the GDPR regulation. What would you recommend the company does to ensure data stays within Google Cloud regions in the European Union?

A : Set a Resource Location Restriction organization policy to ensure all topics are stored only in acceptable regions.

B : Set a Resource Location Restriction organization policy to ensure all buckets are stored only in acceptable regions.

C : Only define Cloud Pub/Sub endpoints in acceptable regions when creating topics.

D : Only define Cloud Pub/Sub endpoints in acceptable regions when creating subscriptions.

Answer: A

Question 5

You use a dataset in BigQuery for analysis. You want to provide third-party companies with access to the same dataset. You need to keep the costs of data sharing low and ensure that the data is current. Which solution should you choose?

A : eate an authorized view on the BigQuery table to control data access, and provide third-party companies with access to that view.

B : Cloud Scheduler to export the data on a regular basis to Cloud Storage, and provide third-party companies with access to the bucket.

C : eate a separate dataset in BigQuery that contains the relevant data to share, and provide third-party companies with access to the new dataset.

D : eate a Cloud Dataflow job that reads the data in frequent time intervals, and writes it to the relevant BigQuery dataset or Cloud Storage bucket for third-party companies to use.

Answer: B

Page: 1 / 95

Total 472 Questions | Updated On: Feb 19, 2026

Add To Cart