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: Aug 13, 2026

Add To Cart

Question 1

You have historical data covering the last three years in BigQuery and a data pipeline that delivers new data to BigQuery daily. You have noticed that when the Data Science team runs a query filtered on a date column and limited to 30–90 days of data, the query scans the entire table. You also noticed that your bill is increasing more quickly than you expected. You want to resolve the issue as cost-effectively as possible while maintaining the ability to conduct SQL queries. What should you do?

A : -create the tables using DDL. Partition the tables by a column containing a TIMESTAMP or DATE Type.

B : commend that the Data Science team export the table to a CSV file on Cloud Storage and use Cloud Datalab to explore the data by reading the files directly.

C : dify your pipeline to maintain the last 30–90 days of data in one table and the longer history in a different table to minimize full table scans over the entire history.

D : ite an Apache Beam pipeline that creates a BigQuery table per day. Recommend that the Data Science team use wildcards on the table name suffixes to select the data they need.

Answer: C

Question 2

You work for a bank. You have a labelled dataset that contains information on already granted loan application and whether these applications have been defaulted. You have been asked to train a model to predict default rates for credit applicants. What should you do?

A : crease the size of the dataset by collecting additional data.

B : ain a linear regression to predict a credit default risk score.

C : move the bias from the data and collect applications that have been declined loans.

D : tch loan applicants with their social profiles to enable feature engineering.

Answer: B

Question 3

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 4

When using Cloud Data Fusion you receive an error that a Dataproc operation failed and the user is not authorized to act as a service account. What would you do to correct this problem?

A : Create a Cloud Dataproc cluster before starting Cloud Data Fusion.

B : Grant the Service Account User role to Cloud Data Fusion.

C : Grant the Service Account User role to Cloud Dataproc.

D : Ensure both Cloud Data Fusion and Cloud Dataproc are running in the same zone.

Answer: B

Question 5

Analysts are using Cloud Data Studio for analyzing data sets. They would like to improve the performance of the time required to update tables and charts when working with the data. What would you recommend they try to improve performance?

A : Use an imported data source

B : Use a blended data source

C : Use a live data source

D : Use an extracted data source

Answer: D

Page: 1 / 95

Total 472 Questions | Updated On: Aug 13, 2026

Add To Cart