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: Jan 28, 2026

Add To Cart

Question 1

Analysts are using Cloud Data Studio for analyzing data sets. They would like to improve the performance of the time required to update tables and charts when working with the data. What would you recommend they try to improve performance?

A : Use an imported data source

B : Use a blended data source

C : Use a live data source

D : Use an extracted data source

Answer: D

Question 2

You are loading CSV files from Cloud Storage to BigQuery. The files have known data quality issues,

including mismatched data types, such as STRINGS and INT64s in the same column, and inconsistent

formatting of values such as phone numbers or addresses. You need to create the data pipeline to maintain data quality and perform the required cleansing and transformation. What should you do?

A : Use Data Fusion to transform the data before loading it into BigQuery.

B : Load the CSV files into a staging table with the desired schema, perform the transformations with SQL. and then write the results to the final destination table.

C : Create a table with the desired schema, toad the CSV files into the table, and perform the transformations in place using SQL.

D : Use Data Fusion to convert the CSV files lo a self-describing data formal, such as AVRO. before loading the data to BigOuery.

Answer: A

Question 3

An aerospace company uses a proprietary data format to store its night dat

a. You need to connect this new data source to BigQuery and stream the data into BigQuery. You want to efficiency import the data into BigQuery where consuming as few resources as possible. What should you do?

A : a standard Dataflow pipeline to store the raw data in BigQuery and then transform the format later when the data is used.

B : ite a shell script that triggers a Cloud Function that performs periodic ETL batch jobs on the new data source

C : Apache Hive to write a Dataproc job that streams the data into BigQuery in CSV format

D : an Apache Beam custom connector to write a Dataflow pipeline that streams the data into BigQuery in Avro format

Answer: D

Question 4

When using Cloud Data Fusion you receive an error that a Dataproc operation failed and the user is not authorized to act as a service account. What would you do to correct this problem?

A : Create a Cloud Dataproc cluster before starting Cloud Data Fusion.

B : Grant the Service Account User role to Cloud Data Fusion.

C : Grant the Service Account User role to Cloud Dataproc.

D : Ensure both Cloud Data Fusion and Cloud Dataproc are running in the same zone.

Answer: B

Question 5

You are developing a software application using Google's Dataflow SDK, and want to use conditional, for loops and other complex programming structures to create a branching pipeline. Which component will be used for the data processing operation?

A : ollection

B : ansform

C : peline

D : nk API

Answer: B

Page: 1 / 95

Total 472 Questions | Updated On: Jan 28, 2026

Add To Cart