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: Mar 26, 2025

Add To Cart

Question 1

You are designing a basket abandonment system for an ecommerce company. The system will send a message

to a user based on these rules:

No interaction by the user on the site for 1 hour

Has added more than $30 worth of products to the basket

Has not completed a transaction

You use Google Cloud Dataflow to process the data and decide if a message should be sent. How should you

design the pipeline?

A : a fixed-time window with a duration of 60 minutes.

B : a sliding time window with a duration of 60 minutes.

C : a session window with a gap time duration of 60 minutes.

D : a global window with a time based trigger with a delay of 60 minutes.

Answer: C

Question 2

You operate a database that stores stock trades and an application that retrieves average stock price for a given company over an adjustable window of time. The data is stored in Cloud Bigtable where the datetime of the stock trade is the beginning of the row key. Your application has thousands of concurrent users, and you notice that performance is starting to degrade as more stocks are added. What should you do to improve the performance of your application?

A : ange the row key syntax in your Cloud Bigtable table to begin with the stock symbol.

B : ange the row key syntax in your Cloud Bigtable table to begin with a random number per second.

C : ange the data pipeline to use BigQuery for storing stock trades, and update your application.

D : Cloud Dataflow to write summary of each day’s stock trades to an Avro file on Cloud Storage. Update your application to read from Cloud Storage and Cloud Bigtable to compute the responses.

Answer: A

Question 3

By default, which of the following windowing behavior does Dataflow apply to unbounded data sets?

A : ndows at every 100 MB of data

B : ngle, Global Window

C : ndows at every 1 minute

D : ndows at every 10 minutes

Answer: B

Question 4

You are part of a healthcare organization where data is organized and managed by respective data owners in

various storage services. As a result of this decentralized ecosystem, discovering and managing data has

become difficult You need to quickly identify and implement a cost-optimized solution to assist your

organization with the following

• Data management and discovery

• Data lineage tracking

• Data quality validation

How should you build the solution?

A : Use BigLake to convert the current solution into a data lake architecture.

B : Build a new data discovery tool on Google Kubernetes Engine that helps with new source onboarding and data lineage tracking

C : Use BigOuery to track data lineage, and use Dataprep to manage data and perform data quality validation

D : Use Dataplex to manage data, track data lineage, and perform data quality validation.

Answer: D

Question 5

Your software uses a simple JSON format for all messages. These messages are published to Google Cloud Pub/Sub, then processed with Google Cloud Dataflow to create a real-time dashboard for the CFO. During testing, you notice that some messages are missing in the dashboard. You check the logs, and all messages are being published to Cloud Pub/Sub successfully. What should you do next?

A : eck the dashboard application to see if it is not displaying correctly.

B : n a fixed dataset through the Cloud Dataflow pipeline and analyze the output.

C : Google Stackdriver Monitoring on Cloud Pub/Sub to find the missing messages.

D : itch Cloud Dataflow to pull messages from Cloud Pub/Sub instead of Cloud Pub/Sub pushing messages to Cloud Dataflow.

Answer: B

Page: 1 / 95

Total 472 Questions | Updated On: Mar 26, 2025

Add To Cart