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: Nov 24, 2025

Add To Cart

Question 1

Each analytics team in your organization is running BigQuery jobs in their own projects. You want to enable each team to monitor slot usage within their projects. What should you do?

A : eate a Stackdriver Monitoring dashboard based on the BigQuery metric query/scanned_bytes

B : eate a Stackdriver Monitoring dashboard based on the BigQuery metric slots/allocated_for_project

C : eate a log export for each project, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

D : eate an aggregated log export at the organization level, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

Answer: D

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

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 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 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

Page: 1 / 95

Total 472 Questions | Updated On: Nov 24, 2025

Add To Cart