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: May 24, 2026

Add To Cart

Question 1

You have Cloud Functions written in Node.js that pull messages from Cloud Pub/Sub and send the data to BigQuery. You observe that the message processing rate on the Pub/Sub topic is orders of magnitude higher than anticipated, but there is no error logged in Stackdriver Log Viewer. What are the two most likely causes of this problem? Choose 2 answers.

A : blisher throughput quota is too small.

B : tal outstanding messages exceed the 10-MB maximum.

C : ror handling in the subscriber code is not handling run-time errors properly.

D : subscriber code cannot keep up with the messages.

E : subscriber code does not acknowledge the messages that it pulls.

Answer: C,D

Question 2

You want to optimize your queries for cost and performance. How should you structure your data?

A : Partition table data by create_date, location_id and device_version

B : rtition table data by create_date cluster table data by location_Id and device_version

C : uster table data by create_date location_id and device_version

D : uster table data by create_date partition by locationed and device_version

Answer: B

Question 3

You are working on a sensitive project involving private user data. You have set up a project on Google Cloud Platform to house your work internally. An external consultant is going to assist with coding a complex transformation in a Google Cloud Dataflow pipeline for your project. How should you maintain users’ privacy?

A : ant the consultant the Viewer role on the project.

B : ant the consultant the Cloud Dataflow Developer role on the project.

C : eate a service account and allow the consultant to log on with it.

D : eate an anonymized sample of the data for the consultant to work with in a different project.

Answer: C

Question 4

You are developing an Apache Beam pipeline to extract data from a Cloud SQL instance by using JdbclO.

You have two projects running in Google Cloud. The pipeline will be deployed and executed on Dataflow in

Project A. The Cloud SQL instance is running jn Project B and does not have a public IP address. After

deploying the pipeline, you noticed that the pipeline failed to extract data from the Cloud SQL instance due to

connection failure. You verified that VPC Service Controls and shared VPC are not in use in these projects.

You want to resolve this error while ensuring that the data does not go through the public internet. What

should you do?

A : Set up VPC Network Peering between Project A and Project B. Add a firewall rule to allow the peeredsubnet range to access all instances on the network.

B : Turn off the external IP addresses on the Dataflow worker. Enable Cloud NAT in Project A.

C : Set up VPC Network Peering between Project A and Project B. Create a Compute Engine instance without external IP address in Project B on the peered subnet to serve as a proxy server to the Cloud SQL database.

D : Add the external IP addresses of the Dataflow worker as authorized networks in the Cloud SOL instance.

Answer: C

Question 5

You have several Spark jobs that run on a Cloud Dataproc cluster on a schedule. Some of the jobs run in sequence, and some of the jobs run concurrently. You need to automate this process. What should you do?

A : eate a Cloud Dataproc Workflow Template

B : eate an initialization action to execute the jobs

C : eate a Directed Acyclic Graph in Cloud Composer

D : eate a Bash script that uses the Cloud SDK to create a cluster, execute jobs, and then tear down the cluster

Answer: C

Page: 1 / 95

Total 472 Questions | Updated On: May 24, 2026

Add To Cart