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

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 3

Which of these statements about exporting data from BigQuery is false?

A : export more than 1 GB of data, you need to put a wildcard in the destination filename.

B : only supported export destination is Google Cloud Storage.

C : ta can only be exported in JSON or Avro format.

D : only compression option available is GZIP.

Answer: C

Question 4

You are creating a new pipeline in Google Cloud to stream IoT data from Cloud Pub/Sub through Cloud Dataflow to BigQuery. While previewing the data, you notice that roughly 2% of the data appears to be corrupt. You need to modify the Cloud Dataflow pipeline to filter out this corrupt data. What should you do?

A : a SideInput that returns a Boolean if the element is corrupt.

B : a ParDo transform in Cloud Dataflow to discard corrupt elements

C : a Partition transform in Cloud Dataflow to separate valid data from corrupt data.

D : a GroupByKey transform in Cloud Dataflow to group all of the valid data together and discard the rest.

Answer: B

Question 5

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

Page: 1 / 95

Total 472 Questions | Updated On: Aug 02, 2026

Add To Cart