Practice Professional-Data-Engineer Exam Online

Question 1

Which of these operations can you perform from the BigQuery Web UI?

A : Upload a file in SQL format.

B : Load data with nested and repeated fields.

C : Upload a 20 MB file.

D : Upload multiple files using a wildcard.

Answer: B

Question 2

You need to migrate a 2TB relational database to Google Cloud Platform. You do not have the resources to

significantly refactor the application that uses this database and cost to operate is of primary concern.

Which service do you select for storing and serving your data?

A : Cloud Spanner

B : Cloud Bigtable

C : Cloud Firestore

D : Cloud SQL

Answer: D

Question 3

Why do you need to split a machine learning dataset into training data and test data?

A : So you can try two different sets of features

B : To make sure your model is generalized for more than just the training data

C : To allow you to create unit tests in your code

D : So you can use one dataset for a wide model and one for a deep model

Answer: B

Question 4

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 : Publisher throughput quota is too small.

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

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

D : The subscriber code cannot keep up with the messages.

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

Answer: C,D

Question 5

You have a data pipeline that writes data to Cloud Bigtable using well-designed row keys. You want to monitor your pipeline to determine when to increase the size of you Cloud Bigtable cluster. Which two actions can you take to accomplish this? Choose 2 answers.

A : Review Key Visualizer metrics. Increase the size of the Cloud Bigtable cluster when the Read pressure index is above 100

B : Review Key Visualizer metrics. Increase the size of the Cloud Bigtable cluster when the Write pressure index is above 100.

C : Monitor the latency of write operations. Increase the size of the Cloud Bigtable cluster when there is a sustained increase in write latency.

D : Monitor storage utilization. Increase the size of the Cloud Bigtable cluster when utilization increases above 70% of max capacity

E : Monitor latency of read operations. Increase the size of the Cloud Bigtable cluster of read operations take longer than 100 ms

Answer: A,C

Name:	Cloud Certified Professional Data Engineer
Exam Code:	Professional-Data-Engineer
Certification:	Google Cloud Certified
Vendor:	Google
Total Questions:	472
Last Updated:	Sep 04, 2026

Google Professional-Data-Engineer Answers