100% Free Professional-Data-Engineer Practice Exam Questions and Answers

Stay Ahead with Latest Professional-Data-Engineer Google Cloud Certified Practice Test Questions 2026

Page: 1 / 95

Total 472 Questions | Updated On: Sep 25, 2026

Add To Cart

Question 1

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

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

B : The only supported export destination is Google Cloud Storage.

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

D : The only compression option available is GZIP.

Answer: C

Question 2

MJTelco’s Google Cloud Dataflow pipeline is now ready to start receiving data from the 50,000 installations. You want to allow Cloud Dataflow to scale its compute power up as required. Which Cloud Dataflow pipeline configuration setting should you update?

A : The zone

B : The number of workers

C : The disk size per worker

D : The maximum number of workers

Answer: A

Question 3

You are consulting to a company developing an IoT application that analyzes data from sensors deployed on drones. The application depends on a database that can write large volumes of data at low latency. The company has used Hadoop HBase in the past but wants to migrate to a managed database service. What service would you recommend?

A : Bigtable

B : Cloud Firestore

C : Cloud Spanner

D : BigQuery

Answer: A

Question 4

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 5

You are loading CSV files from Cloud Storage to BigQuery. The files have known data quality issues,

including mismatched data types, such as STRINGS and INT64s in the same column, and inconsistent

formatting of values such as phone numbers or addresses. You need to create the data pipeline to maintain data quality and perform the required cleansing and transformation. What should you do?

A : Use Data Fusion to transform the data before loading it into BigQuery.

B : Load the CSV files into a staging table with the desired schema, perform the transformations with SQL. and then write the results to the final destination table.

C : Create a table with the desired schema, toad the CSV files into the table, and perform the transformations in place using SQL.

D : Use Data Fusion to convert the CSV files lo a self-describing data formal, such as AVRO. before loading the data to BigOuery.

Answer: A

Page: 1 / 95

Total 472 Questions | Updated On: Sep 25, 2026

Add To Cart