Google Certified Professional Data Engineer Exam (Professional-Data-Engineer) Free Practice Test

Question 1

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, andinconsistent 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 convert the CSV files lo a self-describing data formal, such as AVRO. before loading the data to BigOuery.

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 transform the data before loading it into BigQuery.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

You store historic data in Cloud Storage. You need to perform analytics on the historic data. You want to use a solution to detect invalid data entries and perform data transformations that will not require programming or knowledge of SQL.
What should you do?

A. Use Cloud Dataflow with Beam to detect errors and perform transformations.

B. Use Cloud Dataproc with a Hadoop job to detect errors and perform transformations.

C. Use Cloud Dataprep with recipes to detect errors and perform transformations.

D. Use federated tables in BigQuery with queries to detect errors and perform transformations.

Correct Answer: C

Question 3

You need to choose a database for a new project that has the following requirements:
Fully managed
Able to automatically scale up
Transactionally consistent
Able to scale up to 6 TB
Able to be queried using SQL
Which database do you choose?

A. Cloud Bigtable

B. Cloud Datastore

C. Cloud Spanner

D. Cloud SQL

Correct Answer: C

Question 4

You manage your company's BigQuery data warehouse. You need to implement a solution that enables the data science team to modify data for experiments without affecting the original tables, while minimizing additional storage costs. What should you do?

A. Create table clones of all the tables for the data science team to use.

B. Create a separate dataset with full copies of all the tables for each member of the data science team.

C. Set up authorized views in a shared dataset that reference the original tables.

D. Create snapshots of all the tables and restore them for the data science team to use.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

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 thedashboard. You check the logs, and all messages are being published to Cloud Pub/Sub successfully. What should you do next?

A. Run a fixed dataset through the Cloud Dataflow pipeline and analyze the output.

B. Check the dashboard application to see if it is not displaying correctly.

C. Switch Cloud Dataflow to pull messages from Cloud Pub/Sub instead of Cloud Pub/Sub pushing messages to Cloud Dataflow.

D. Use Google Stackdriver Monitoring on Cloud Pub/Sub to find the missing messages.

Correct Answer: A

Question 6

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 datacatalog. tagTemplateViewer role on this tag to the all employeesgroup, and assign the bigquery.dataViewer role to the HR group on the tables that contain sensitive data.

B. Create the "gdpr" tag template with public visibility. Assign the bigquery. dataViewer role to the HR group on the tables that containsensitive data.

C. Create the "gdpr" tag template with private visibility. Assign the bigquery -dataViewer role to the HR group on the tables that contain sensitive data.

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

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

You want to analyze hundreds of thousands of social media posts daily at the lowest cost and with the fewest steps.
You have the following requirements:
You will batch-load the posts once per day and run them through the Cloud Natural Language API.
You will extract topics and sentiment from the posts.
You must store the raw posts for archiving and reprocessing.
You will create dashboards to be shared with people both inside and outside your organization.
You need to store both the data extracted from the API to perform analysis as well as the raw social media posts for historical archiving. What should you do?

A. Feed to social media posts into the API directly from the source, and write the extracted data from the API into BigQuery.

B. Store the social media posts and the data extracted from the API in Cloud SQL.

C. Store the social media posts and the data extracted from the API in BigQuery.

D. Store the raw social media posts in Cloud Storage, and write the data extracted from the API into BigQuery.

Correct Answer: A

Question 8

Cloud Dataproc is a managed Apache Hadoop and Apache _____ service.

A. Spark

B. Ignite

C. Fire

D. Blaze

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 9

You are operating a streaming Cloud Dataflow pipeline. Your engineers have a new version of the pipeline with a different windowing algorithm and triggering strategy. You want to update the running pipeline with the new version. You want to ensure that no data is lost during the update. What should you do?

A. Update the Cloud Dataflow pipeline inflight by passing the --update option with the --jobName set to a new unique job name

B. Update the Cloud Dataflow pipeline inflight by passing the --update option with the --jobName set to the existing job name

C. Stop the Cloud Dataflow pipeline with the Cancel option. Create a new Cloud Dataflow job with the updated code

D. Stop the Cloud Dataflow pipeline with the Drain option. Create a new Cloud Dataflow job with the updated code

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 10

Your United States-based company has created an application for assessing and responding to user actions.
The primary table's data volume grows by 250,000 records per second. Many third parties use your application's APIs to build the functionality into their own frontend applications. Your application's APIs should comply with the following requirements:
Single global endpoint
ANSI SQL support
Consistent access to the most up-to-date data
What should you do?

A. Implement BigQuery with no region selected for storage or processing.

B. Implement Cloud Bigtable with the primary cluster in North America and secondary clusters in Asia and Europe.

C. Implement Cloud SQL for PostgreSQL with the master in Norht America and read replicas in Asia and Europe.

D. Implement Cloud Spanner with the leader in North America and read-only replicas in Asia and Europe.

Correct Answer: D

Question 11

You are collecting loT sensor data from millions of devices across the world and storing the data in BigQuery.
Your access pattern is based on recent data tittered by location_id and device_version with the following query:
You want to optimize your queries for cost and performance. How should you structure your data?

A. Cluster table data by create_date location_id and device_version

B. Partition table data by create_date, location_id and device_version

C. Cluster table data by create_date, partition by location and device_version

D. Partition table data by create_date cluster table data by tocation_id and device_version

Correct Answer: A

Question 12

You have data pipelines running on BigQuery, Cloud Dataflow, and Cloud Dataproc. You need to perform health checks and monitor their behavior, and then notify the team managing the pipelines if they fail. You also need to be able to work across multiple projects. Your preference is to use managed products of features of the platform. What should you do?

A. Export the information to Cloud Stackdriver, and set up an Alerting policy

B. Export the logs to BigQuery, and set up App Engine to read that information and send emails if you find a failure in the logs

C. Run a Virtual Machine in Compute Engine with Airflow, and export the information to Stackdriver

D. Develop an App Engine application to consume logs using GCP API calls, and send emails if you find a failure in the logs

Correct Answer: C

Welcome to TestSimulate

Google Certified Professional Data Engineer (Professional-Data-Engineer) Free Practice Test