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 03, 2026

Add To Cart

Question 1

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 2

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 3

Your company is running their first dynamic campaign, serving different offers by analyzing real-time data during the holiday season. The data scientists are collecting terabytes of data that rapidly grows every hour during their 30-day campaign. They are using Google Cloud Dataflow to preprocess the data and collect the feature (signals) data that is needed for the machine learning model in Google Cloud Bigtable. The team is observing suboptimal performance with reads and writes of their initial load of 10 TB of data. They want to improve this performance while minimizing cost. What should they do?

A : define the schema by evenly distributing reads and writes across the row space of the table.

B : performance issue should be resolved over time as the site of the BigDate cluster is increased.

C : design the schema to use a single row key to identify values that need to be updated frequently in the cluster.

D : design the schema to use row keys based on numeric IDs that increase sequentially per user viewing the offers.

Answer: A

Question 4

You are deploying MariaDB SQL databases on GCE VM Instances and need to configure monitoring and alerting. You want to collect metrics including network connections, disk IO and replication status from MariaDB with minimal development effort and use StackDriver for dashboards and alerts.

What should you do?

A : tall the OpenCensus Agent and create a custom metric collection application with a StackDriver exporter.

B : ace the MariaDB instances in an Instance Group with a Health Check.

C : tall the StackDriver Logging Agent and configure fluentd in_tail plugin to read MariaDB logs.

D : tall the StackDriver Agent and configure the MySQL plugin.

Answer: C

Question 5

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

A : load a file in SQL format.

B : ad data with nested and repeated fields.

C : load a 20 MB file.

D : load multiple files using a wildcard.

Answer: B

Page: 1 / 95

Total 472 Questions | Updated On: Sep 03, 2026

Add To Cart