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: Feb 11, 2026

Add To Cart

Question 1

A data pipeline uses Cloud Pub/Sub for ingesting data. The data is stored in topics and a Dataflow workflow reads from a subscription to that topic, processes the data, and writes output to BigQuery. What is the recommended way to authenticate when reading data from Cloud Pub/Sub?

A : Custom role

B : Google Workspace Identity

C : Use service accounts

D : Basic role

Answer: C

Question 2

You work for a shipping company that uses handheld scanners to read shipping labels. Your company has strict data privacy standards that require scanners to only transmit recipients’ personally identifiable information (PII) to analytics systems, which violates user privacy rules. You want to quickly build a scalable solution using cloud-native managed services to prevent exposure of PII to the analytics systems. What should you do?

A : eate an authorized view in BigQuery to restrict access to tables with sensitive data.

B : tall a third-party data validation tool on Compute Engine virtual machines to check the incoming data for sensitive information

C : Stackdriver logging to analyze the data passed through the total pipeline to identify transactions that may contain sensitive information

D : ild a Cloud Function that reads the topics and makes a call to the Cloud Data Loss Prevention API. Use the tagging and confidence levels to either pass or quarantine the data in a bucket for review.

Answer: D

Question 3

You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQuery as a sink?

A : th batch and streaming

B : gQuery cannot be used as a sink

C : ly batch

D : ly streaming

Answer: A

Question 4

You have historical data covering the last three years in BigQuery and a data pipeline that delivers new data to BigQuery daily. You have noticed that when the Data Science team runs a query filtered on a date column and limited to 30–90 days of data, the query scans the entire table. You also noticed that your bill is increasing more quickly than you expected. You want to resolve the issue as cost-effectively as possible while maintaining the ability to conduct SQL queries. What should you do?

A : -create the tables using DDL. Partition the tables by a column containing a TIMESTAMP or DATE Type.

B : commend that the Data Science team export the table to a CSV file on Cloud Storage and use Cloud Datalab to explore the data by reading the files directly.

C : dify your pipeline to maintain the last 30–90 days of data in one table and the longer history in a different table to minimize full table scans over the entire history.

D : ite an Apache Beam pipeline that creates a BigQuery table per day. Recommend that the Data Science team use wildcards on the table name suffixes to select the data they need.

Answer: C

Question 5

You create a new report for your large team in Google Data Studio 360. The report uses Google BigQuery as

its data source. It is company policy to ensure employees can view only the data associated with their region,

so you create and populate a table for each region. You need to enforce the regional access policy to the data.

Which two actions should you take? (Choose two.)

A : ure all the tables are included in global dataset.

B : ure each table is included in a dataset for a region.

C : just the settings for each table to allow a related region-based security group view access.

D : just the settings for each view to allow a related region-based security group view access.

E : just the settings for each dataset to allow a related region-based security group view access.

Answer: A,D

Page: 1 / 95

Total 472 Questions | Updated On: Feb 11, 2026

Add To Cart