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: Jun 17, 2026

Add To Cart

Question 1

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 2

You have a BigQuery dataset named "customers". All tables will be tagged by using a Data Catalog tag

template named "gdpr". The template contains one mandatory field, "has sensitive data~. with a boolean value.

All employees must be able to do a simple search and find tables in the dataset that have either true or false in

the "has sensitive data" field. However, only the Human Resources (HR) group should be able to see the data

inside the tables for which "hass-ensitive-data" is true. You give the all employees group the

bigquery.metadataViewer and bigquery.connectionUser roles on the dataset. You want to minimize

configuration overhead. What should you do next?

A : Create the "gdpr" tag template with private visibility. Assign the bigquery -dataViewer role to the HRgroup on the tables that contain sensitive data.

B : Create the ~gdpr" tag template with private visibility. Assign the datacatalog. tagTemplateViewer roleon this tag to the all employeesgroup, and assign the bigquery.dataViewer role to the HR group on the tables that contain sensitive data.

C : Create the "gdpr" tag template with public visibility. Assign the bigquery. dataViewer role to the HRgroup on the tables that containsensitive data.

D : Create the "gdpr" tag template with public visibility. Assign the datacatalog. tagTemplateViewer role onthis tag to the all employees.group, and assign the bijquery.dataViewer role to the HR group on the tables that contain sensitive data.

Answer: D

Question 3

You need to migrate a 2TB relational database to Google Cloud Platform. You do not have the resources to

significantly refactor the application that uses this database and cost to operate is of primary concern.

Which service do you select for storing and serving your data?

A : oud Spanner

B : oud Bigtable

C : oud Firestore

D : oud SQL

Answer: D

Question 4

When using Cloud Data Fusion you receive an error that a Dataproc operation failed and the user is not authorized to act as a service account. What would you do to correct this problem?

A : Create a Cloud Dataproc cluster before starting Cloud Data Fusion.

B : Grant the Service Account User role to Cloud Data Fusion.

C : Grant the Service Account User role to Cloud Dataproc.

D : Ensure both Cloud Data Fusion and Cloud Dataproc are running in the same zone.

Answer: B

Question 5

Which of these statements about exporting data from BigQuery is false?

A : export more than 1 GB of data, you need to put a wildcard in the destination filename.

B : only supported export destination is Google Cloud Storage.

C : ta can only be exported in JSON or Avro format.

D : only compression option available is GZIP.

Answer: C

Page: 1 / 95

Total 472 Questions | Updated On: Jun 17, 2026

Add To Cart