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 27, 2025

Add To Cart

Question 1

You are designing the architecture of your application to store data in Cloud Storage. Your application consists of pipelines that read data from a Cloud Storage bucket that contains raw data, and write the data to a second bucket after processing. You want to design an architecture with Cloud Storage resources that are capable of being resilient if a Google Cloud regional failure occurs. You want to minimize the recovery point objective (RPO) if a failure occurs, with no impact on applications that use the stored data. What should you do?

A : Adopt two regional Cloud Storage buckets, and update your application to write the output on both buckets.

B : Adopt multi-regional Cloud Storage buckets in your architecture.

C : Adopt two regional Cloud Storage buckets, and create a daily task to copy from one bucket to the other.

D : Adopt a dual-region Cloud Storage bucket, and enable turbo replication in your architecture.

Answer: D

Question 2

Which of these operations can you perform from the BigQuery Web UI?

A : load a file in SQL format.

B : ad data with nested and repeated fields.

C : load a 20 MB file.

D : load multiple files using a wildcard.

Answer: B

Question 3

You are responsible for writing your company’s ETL pipelines to run on an Apache Hadoop cluster. The pipeline will require some checkpointing and splitting pipelines. Which method should you use to write the pipelines?

A : gLatin using Pig

B : veQL using Hive

C : va using MapReduce

D : thon using MapReduce

Answer: D

Question 4

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 5

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

Page: 1 / 95

Total 472 Questions | Updated On: Aug 27, 2025

Add To Cart