Free Google Professional-Data-Engineer Exam Questions

Question 1

You have a data processing application that runs on Google Kubernetes Engine (GKE). Containers need to be

launched with their latest available configurations from a container registry. Your GKE nodes need to have

GPUs. local SSDs, and 8 Gbps bandwidth. You want to efficiently provision the data processing infrastructure

and manage the deployment process. What should you do?

A : Use Compute Engi.no startup scriots to pull container Images, and use gloud commands to provision theinfrastructure.

B : Use GKE to autoscale containers, and use gloud commands to provision the infrastructure.

C : Use Cloud Build to schedule a job using Terraform build to provision the infrastructure and launch with the most current container images.

D : Use Dataflow to provision the data pipeline, and use Cloud Scheduler to run the job.

Answer: C

Question 2

You want to schedule a number of sequential load and transformation jobs Data files will be added to a Cloud

Storage bucket by an upstream process There is no fixed schedule for when the new data arrives Next, a

Dataproc job is triggered to perform some transformations and write the data to BigQuery. You then need to

run additional transformation jobs in BigQuery The transformation jobs are different for every table These

jobs might take hours to complete You need to determine the most efficient and maintainable workflow to

process hundreds of tables and provide the freshest data to your end users. What should you do?

A : 1Create an Apache Airflow directed acyclic graph (DAG) in Cloud Composer with sequential tasks byusing the Cloud Storage. Dataproc. and BigQuery operators2 Use a single shared DAG for all tables that need to go through the pipeline3 Schedule the DAG to run hourly

B : 1 Create an Apache Airflow directed acyclic graph (DAG) in Cloud Composer with sequential tasks byusing the Dataproc and BigQuery operators.2 Create a separate DAG for each table that needs to go through the pipeline3 Use a Cloud Storage object trigger to launch a Cloud Function that triggers the DAG

C : 1 Create an Apache Airflow directed acyclic graph (DAG) in Cloud Composer with sequential tasks byusing the Cloud Storage, Dataproc. and BigQuery operators2 Create a separate DAG for each table that needs to go through the pipeline3 Schedule the DAGs to run hourly

D : 1 Create an Apache Airflow directed acyclic graph (DAG) in Cloud Composer with sequential tasks byusing the Dataproc and BigQuery operators2 Use a single shared DAG for all tables that need to go through the pipeline.3 Use a Cloud Storage object trigger to launch a Cloud Function that triggers the DAG

Answer: B

Question 3

You operate a database that stores stock trades and an application that retrieves average stock price for a given company over an adjustable window of time. The data is stored in Cloud Bigtable where the datetime of the stock trade is the beginning of the row key. Your application has thousands of concurrent users, and you notice that performance is starting to degrade as more stocks are added. What should you do to improve the performance of your application?

A : ange the row key syntax in your Cloud Bigtable table to begin with the stock symbol.

B : ange the row key syntax in your Cloud Bigtable table to begin with a random number per second.

C : ange the data pipeline to use BigQuery for storing stock trades, and update your application.

D : Cloud Dataflow to write summary of each day’s stock trades to an Avro file on Cloud Storage. Update your application to read from Cloud Storage and Cloud Bigtable to compute the responses.

Answer: A

Question 4

Messages are unexpectedly accumulating in service using Cloud Pub/Sub. A developer unfamiliar with Cloud Pub/Sub has asked for our help in diagnosing the problem. What would you point out with respect to how messages are removed from Cloud Pub/Sub topics?

A : Once at least one subscriber for each topic has acknowledged the message it will be deleted from storage.

B : Once at least one subscriber for each bucket has acknowledged the message it will be deleted from storage.

C : Once at least one subscriber for any subscription has acknowledged the message it will be deleted from storage.

D : Once at least one subscriber for each subscription has acknowledged the message it will be deleted from storage.

Answer: D

Question 5

You have a BigQuery table that ingests data directly from a Pub/Sub subscription. The ingested data is

encrypted with a Google-managed encryption key. You need to meet a new organization policy that requires

you to use keys from a centralized Cloud Key Management Service (Cloud KMS) project to encrypt data at

rest. What should you do?

A : Create a new BigOuory table by using customer-managed encryption keys (CMEK), and migrate thedata from the old BigQuery table

B : Create a new BigOuery table and Pub/Sub topic by using customer-managed encryption keys (CMEK),and migrate the data from the old Bigauery table.

C : Create a new Pub/Sub topic with CMEK and use the existing BigQuery table by using Google-managedencryption key.

D : Use Cloud KMS encryption key with Dataflow to ingest the existing Pub/Sub subscription to theexisting BigQuery table.

Answer: A