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

Add To Cart

Question 1

You want to schedule a number of sequential load and transformation jobs Data files will be added to a Cloud

Storage bucket by an upstream process There is no fixed schedule for when the new data arrives Next, a

Dataproc job is triggered to perform some transformations and write the data to BigQuery. You then need to

run additional transformation jobs in BigQuery The transformation jobs are different for every table These

jobs might take hours to complete You need to determine the most efficient and maintainable workflow to

process hundreds of tables and provide the freshest data to your end users. What should you do?

A : 1Create an Apache Airflow directed acyclic graph (DAG) in Cloud Composer with sequential tasks byusing the Cloud Storage. Dataproc. and BigQuery operators2 Use a single shared DAG for all tables that need to go through the pipeline3 Schedule the DAG to run hourly

B : 1 Create an Apache Airflow directed acyclic graph (DAG) in Cloud Composer with sequential tasks byusing the Dataproc and BigQuery operators.2 Create a separate DAG for each table that needs to go through the pipeline3 Use a Cloud Storage object trigger to launch a Cloud Function that triggers the DAG

C : 1 Create an Apache Airflow directed acyclic graph (DAG) in Cloud Composer with sequential tasks byusing the Cloud Storage, Dataproc. and BigQuery operators2 Create a separate DAG for each table that needs to go through the pipeline3 Schedule the DAGs to run hourly

D : 1 Create an Apache Airflow directed acyclic graph (DAG) in Cloud Composer with sequential tasks byusing the Dataproc and BigQuery operators2 Use a single shared DAG for all tables that need to go through the pipeline.3 Use a Cloud Storage object trigger to launch a Cloud Function that triggers the DAG

Answer: B

Question 2

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 3

A European health care company uses Cloud Pub/Sub as part of a data processing pipeline. The CTO of the company is concerned that data might accidentally be written to a region outside the European Union, which would violate the GDPR regulation. What would you recommend the company does to ensure data stays within Google Cloud regions in the European Union?

A : Set a Resource Location Restriction organization policy to ensure all topics are stored only in acceptable regions.

B : Set a Resource Location Restriction organization policy to ensure all buckets are stored only in acceptable regions.

C : Only define Cloud Pub/Sub endpoints in acceptable regions when creating topics.

D : Only define Cloud Pub/Sub endpoints in acceptable regions when creating subscriptions.

Answer: A

Question 4

You are designing an Apache Beam pipeline to enrich data from Cloud Pub/Sub with static reference data from BigQuery. The reference data is small enough to fit in memory on a single worker. The pipeline should write enriched results to BigQuery for analysis. Which job type and transforms should this pipeline use?

A : tch job, PubSubIO, side-inputs

B : reaming job, PubSubIO, JdbcIO, side-outputs

C : reaming job, PubSubIO, BigQueryIO, side-inputs

D : reaming job, PubSubIO, BigQueryIO, side-outputs

Answer: C

Question 5

A team of researchers is running a high performance distributed computing platform on premises but wants to migrate to Google Cloud. The platform uses virtual machines. The researchers want to be able to scale up the number of virtual machines in the cluster based on CPU load. What would you recommend they use?

A : Kubernetes cluster

B : Managed instance groups

C : Unmanaged instance groups

D : Cloud Run

Answer: B

Page: 1 / 95

Total 472 Questions | Updated On: Jul 13, 2026

Add To Cart