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

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 2

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 3

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 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

Which Cloud Dataflow / Beam feature should you use to aggregate data in an unbounded data source every hour based on the time when the data entered the pipeline?

A : hourly watermark

B : event time trigger

C : with Allowed Lateness method

D : processing time trigger

Answer: D

Page: 1 / 95

Total 472 Questions | Updated On: Sep 22, 2026

Add To Cart