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

Add To Cart

Question 1

You are creating a model to predict housing prices. Due to budget constraints, you must run it on a single resource-constrained virtual machine. Which learning algorithm should you use?

A : near regression

B : gistic classification

C : current neural network

D : edforward neural network

Answer: A

Question 2

You receive data files in CSV format monthly from a third party. You need to cleanse this data, but every third

month the schema of the files changes. Your requirements for implementing these transformations include:

Executing the transformations on a schedule

Enabling non-developer analysts to modify transformations

Providing a graphical tool for designing transformations

What should you do?

A : Cloud Dataprep to build and maintain the transformation recipes, and execute them on a scheduled basis

B : ad each month’s CSV data into BigQuery, and write a SQL query to transform the data to a standard schema. Merge the transformed tables together with a SQL query

C : lp the analysts write a Cloud Dataflow pipeline in Python to perform the transformation. The Python code should be stored in a revision control system and modified as the incoming data’s schema changes

D : Apache Spark on Cloud Dataproc to infer the schema of the CSV file before creating a Dataframe. Then implement the transformations in Spark SQL before writing the data out to Cloud Storage and loading into BigQuery

Answer: D

Question 3

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 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

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

Page: 1 / 95

Total 472 Questions | Updated On: Sep 22, 2026

Add To Cart