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: Jan 04, 2026

Add To Cart

Question 1

You are creating a model to predict housing prices. Due to budget constraints, you must run it on a single resource-constrained virtual machine. Which learning algorithm should you use?

A : near regression

B : gistic classification

C : current neural network

D : edforward neural network

Answer: A

Question 2

Your startup has never implemented a formal security policy. Currently, everyone in the company has access to the datasets stored in Google BigQuery. Teams have freedom to use the service as they see fit, and they have not documented their use cases. You have been asked to secure the data warehouse. You need to discover what everyone is doing. What should you do first?

A : Google Stackdriver Audit Logs to review data access.

B : t the identity and access management IIAM) policy of each table

C : Stackdriver Monitoring to see the usage of BigQuery query slots.

D : the Google Cloud Billing API to see what account the warehouse is being billed to.

Answer: A

Question 3

Messages are unexpectedly accumulating in service using Cloud Pub/Sub. A developer unfamiliar with Cloud Pub/Sub has asked for our help in diagnosing the problem. What would you point out with respect to how messages are removed from Cloud Pub/Sub topics?

A : Once at least one subscriber for each topic has acknowledged the message it will be deleted from storage.

B : Once at least one subscriber for each bucket has acknowledged the message it will be deleted from storage.

C : Once at least one subscriber for any subscription has acknowledged the message it will be deleted from storage.

D : Once at least one subscriber for each subscription has acknowledged the message it will be deleted from storage.

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

You are loading CSV files from Cloud Storage to BigQuery. The files have known data quality issues,

including mismatched data types, such as STRINGS and INT64s in the same column, and inconsistent

formatting of values such as phone numbers or addresses. You need to create the data pipeline to maintain data quality and perform the required cleansing and transformation. What should you do?

A : Use Data Fusion to transform the data before loading it into BigQuery.

B : Load the CSV files into a staging table with the desired schema, perform the transformations with SQL. and then write the results to the final destination table.

C : Create a table with the desired schema, toad the CSV files into the table, and perform the transformations in place using SQL.

D : Use Data Fusion to convert the CSV files lo a self-describing data formal, such as AVRO. before loading the data to BigOuery.

Answer: A

Page: 1 / 95

Total 472 Questions | Updated On: Jan 04, 2026

Add To Cart