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: Jul 02, 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

A shipping company has live package-tracking data that is sent to an Apache Kafka stream in real time. This is then loaded into BigQuery. Analysts in your company want to query the tracking data in BigQuery to analyze geospatial trends in the lifecycle of a package. The table was originally created with ingest-date partitioning. Over time, the query processing time has increased. You need to implement a change that would improve query performance in BigQuery. What should you do?

A : plement clustering in BigQuery on the ingest date column.

B : plement clustering in BigQuery on the package-tracking ID column.

C : er older data onto Cloud Storage files, and leverage extended tables.

D : -create the table using data partitioning on the package delivery date.

Answer: A

Question 3

You are designing storage for very large text files for a data pipeline on Google Cloud. You want to support ANSI SQL queries. You also want to support compression and parallel load from the input locations using Google recommended practices. What should you do?

A : ansform text files to compressed Avro using Cloud Dataflow. Use BigQuery for storage and query.

B : ansform text files to compressed Avro using Cloud Dataflow. Use Cloud Storage and BigQuery permanent linked tables for query.

C : mpress text files to gzip using the Grid Computing Tools. Use BigQuery for storage and query.

D : mpress text files to gzip using the Grid Computing Tools. Use Cloud Storage, and then import into Cloud Bigtable for query.

Answer: D

Question 4

You want to optimize your queries for cost and performance. How should you structure your data?

A : Partition table data by create_date, location_id and device_version

B : rtition table data by create_date cluster table data by location_Id and device_version

C : uster table data by create_date location_id and device_version

D : uster table data by create_date partition by locationed and device_version

Answer: B

Question 5

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

Page: 1 / 95

Total 472 Questions | Updated On: Jul 02, 2026

Add To Cart