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

Add To Cart

Question 1

You receive data files in CSV format monthly from a third party. You need to cleanse this data, but every third

month the schema of the files changes. Your requirements for implementing these transformations include:

Executing the transformations on a schedule

Enabling non-developer analysts to modify transformations

Providing a graphical tool for designing transformations

What should you do?

A : Cloud Dataprep to build and maintain the transformation recipes, and execute them on a scheduled basis

B : ad each month’s CSV data into BigQuery, and write a SQL query to transform the data to a standard schema. Merge the transformed tables together with a SQL query

C : lp the analysts write a Cloud Dataflow pipeline in Python to perform the transformation. The Python code should be stored in a revision control system and modified as the incoming data’s schema changes

D : Apache Spark on Cloud Dataproc to infer the schema of the CSV file before creating a Dataframe. Then implement the transformations in Spark SQL before writing the data out to Cloud Storage and loading into BigQuery

Answer: D

Question 2

An online brokerage company requires a high volume trade processing architecture. You need to create a secure queuing system that triggers jobs. The jobs will run in Google Cloud and cat the company's Python API to execute trades. You need to efficiently implement a solution. What should you do?

A : Cloud Composer to subscribe to a Pub/Sub tope and can the Python API.

B : a Pub/Sub push subscription to trigger a Cloud Function to pass the data to tie Python API.

C : ite an application that makes a queue in a NoSQL database

D : ite an application hosted on a Compute Engine instance that makes a push subscription to the Pub/Sub topic

Answer: C

Question 3

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 4

Your company's customer_order table in BigOuery stores the order history for 10 million customers, with a

table size of 10 PB. You need to create a dashboard for the support team to view the order history. The

dashboard has two filters, countryname and username. Both are string data types in the BigQuery table. When

a filter is applied, the dashboard fetches the order history from the table and displays the query results.

However, the dashboard is slow to show the results when applying the filters to the following query:

How should you redesign the BigQuery table to support faster access?

A : Cluster the table by country field, and partition by username field.

B : Partition the table by country and username fields.

C : Cluster the table by country and username fields

D : Partition the table by _PARTITIONTIME.

Answer: C

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

Add To Cart