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: Nov 24, 2025

Add To Cart

Question 1

You are developing a data pipeline that will run several data transformation programs on Compute Engine virtual machines. You do not want to use your credentials for authenticating and authorizing these programs. You want to follow Google Cloud recommended practices, how would you authenticate and authorize the data transformation programs?

A : Create a Gmail account and use that account to create an IAM group. Store the password for the group in Secret Manager.

B : Create a service account and assign roles to the service account that are needed to execute the data transformation programs. Use Google managed keys to store both public and private portion of the service account keys.

C : Create a Gmail account and use that account to create an IAM user. Store the password for the account in Secret Manager.

D : Create a service account and assign roles to the service account that are needed to execute the data transformation programs. Use Secret Manager to store service account keys.

Answer: B

Question 2

Which methods can be used to reduce the number of rows processed by BigQuery?

A : litting tables into multiple tables; putting data in partitions

B : litting tables into multiple tables; putting data in partitions; using the LIMIT clause

C : tting data in partitions; using the LIMIT clause

D : litting tables into multiple tables; using the LIMIT clause

Answer: A

Question 3

A shipping company has live package-tracking data that is sent to an Apache Kafka stream in real time. This is then loaded into BigQuery. Analysts in your company want to query the tracking data in BigQuery to analyze geospatial trends in the lifecycle of a package. The table was originally created with ingest-date partitioning. Over time, the query processing time has increased. You need to implement a change that would improve query performance in BigQuery. What should you do?

A : plement clustering in BigQuery on the ingest date column.

B : plement clustering in BigQuery on the package-tracking ID column.

C : er older data onto Cloud Storage files, and leverage extended tables.

D : -create the table using data partitioning on the package delivery date.

Answer: A

Question 4

You are building a model to make clothing recommendations. You know a user’s fashion preference is likely to change over time, so you build a data pipeline to stream new data back to the model as it becomes available. How should you use this data to train the model?

A : ntinuously retrain the model on just the new data.

B : ntinuously retrain the model on a combination of existing data and the new data.

C : ain on the existing data while using the new data as your test set.

D : ain on the new data while using the existing data as your test set.

Answer: C

Question 5

You are designing a Dataflow pipeline for a batch processing job. You want to mitigate multiple zonal failures

at job submission time. What should you do?

A : Specify a worker region by using the —region flag.

B : Set the pipeline staging location as a regional Cloud Storage bucket.

C : Submit duplicate pipelines in two different zones by using the —zone flag.

D : Create an Eventarc trigger to resubmit the job in case of zonal failure when submitting the job.

Answer: A

Page: 1 / 95

Total 472 Questions | Updated On: Nov 24, 2025

Add To Cart