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: Sep 17, 2026

Add To Cart

Question 1

Which Cloud Dataflow / Beam feature should you use to aggregate data in an unbounded data source every hour based on the time when the data entered the pipeline?

A : hourly watermark

B : event time trigger

C : with Allowed Lateness method

D : processing time trigger

Answer: D

Question 2

A manufacturer of delivery drones is implementing a new data analysis pipeline to detect part failures before they occur. The drones have multiple sensors that send performance and environment data to an analytics pipeline. Currently, data is sent to a REST API endpoint. The REST API endpoint that receives data cannot always keep up with the pace data is arriving. When that happens, data is lost. Machine learning engineers have asked you to change the ingestion process to reduce this data loss. What would you do?

A : Write data to a Cloud Pub/Sub topic instead of a REST API endpoint and have the ingestion application read from the topic.

B : Write data to a Cloud Storage bucket instead of a REST API endpoint and have the ingestion application read from the bucket.

C : Write data to a Cloud SQL Postgres database endpoint and have the ingestion application query the database.

D : Create a Hadoop cluster in Compute Engine using managed instance groups and write data to an Hbase database and have the application query the database.

Answer: A

Question 3

Which role must be assigned to a service account used by the virtual machines in a Dataproc cluster so they can execute jobs?

A : taproc Worker

B : taproc Viewer

C : taproc Runner

D : taproc Editor

Answer: A

Question 4

You create a new report for your large team in Google Data Studio 360. The report uses Google BigQuery as

its data source. It is company policy to ensure employees can view only the data associated with their region,

so you create and populate a table for each region. You need to enforce the regional access policy to the data.

Which two actions should you take? (Choose two.)

A : ure all the tables are included in global dataset.

B : ure each table is included in a dataset for a region.

C : just the settings for each table to allow a related region-based security group view access.

D : just the settings for each view to allow a related region-based security group view access.

E : just the settings for each dataset to allow a related region-based security group view access.

Answer: A,D

Question 5

You are designing a data warehouse in BigQuery to analyze sales data for a telecommunication service

provider. You need to create a data model for customers, products, and subscriptions All customers, products,

and subscriptions can be updated monthly, but you must maintain a historical record of all data. You plan to

use the visualization layer for current and historical reporting. You need to ensure that the data model is

simple, easy-to-use. and cost-effective. What should you do?

A : Create a normalized model with tables for each entity. Use snapshots before updates to track historical data

B : Create a normalized model with tables for each entity. Keep all input files in a Cloud Storage bucket to track historical data

C : Create a denormalized model with nested and repeated fields Update the table and use snapshots to track historical data

D : Create a denormalized, append-only model with nested and repeated fields Use the ingestion timestamp to track historical data.

Answer: D

Page: 1 / 95

Total 472 Questions | Updated On: Sep 17, 2026

Add To Cart