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: Jan 15, 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 are designing a data warehouse in BigQuery to analyze sales data for a telecommunication service

provider. You need to create a data model for customers, products, and subscriptions All customers, products,

and subscriptions can be updated monthly, but you must maintain a historical record of all data. You plan to

use the visualization layer for current and historical reporting. You need to ensure that the data model is

simple, easy-to-use. and cost-effective. What should you do?

A : Create a normalized model with tables for each entity. Use snapshots before updates to track historical data

B : Create a normalized model with tables for each entity. Keep all input files in a Cloud Storage bucket to track historical data

C : Create a denormalized model with nested and repeated fields Update the table and use snapshots to track historical data

D : Create a denormalized, append-only model with nested and repeated fields Use the ingestion timestamp to track historical data.

Answer: D

Question 3

You are designing a Dataflow pipeline for a batch processing job. You want to mitigate multiple zonal failures

at job submission time. What should you do?

A : Specify a worker region by using the —region flag.

B : Set the pipeline staging location as a regional Cloud Storage bucket.

C : Submit duplicate pipelines in two different zones by using the —zone flag.

D : Create an Eventarc trigger to resubmit the job in case of zonal failure when submitting the job.

Answer: A

Question 4

You stream order data by using a Dataflow pipeline, and write the aggregated result to Memorystore. You

provisioned a Memorystore for Redis instance with Basic Tier. 4 GB capacity, which is used by 40 clients for

read-only access. You are expecting the number of read-only clients to increase significantly to a few hundred

and you need to be able to support the demand. You want to ensure that read and write access availability is

not impacted, and any changes you make can be deployed quickly. What should you do?

A : Create multiple new Memorystore for Redis instances with Basic Tier (4 GB capacity) Modify theDataflow pipeline and new clients to use all instances

B : Create a new Memorystore for Redis instance with Standard Tier Set capacity to 4 GB and read replicato No read replicas (high availability only). Delete the old instance.

C : Create a new Memorystore for Memcached instance Set a minimum of three nodes, and memory pernode to 4 GB. Modify the Dataflow pipeline and all clients to use the Memcached instance Delete theold instance.

D : Create a new Memorystore for Redis instance with Standard Tier Set capacity to 5 GB and createmultiple read replicas Delete the old instance.

Answer: D

Question 5

You are developing a software application using Google's Dataflow SDK, and want to use conditional, for loops and other complex programming structures to create a branching pipeline. Which component will be used for the data processing operation?

A : ollection

B : ansform

C : peline

D : nk API

Answer: B

Page: 1 / 95

Total 472 Questions | Updated On: Jan 15, 2026

Add To Cart