Question 1

Your startup has a web application that currently serves customers out of a single region in Asia. You aretargeting funding that will allow your startup lo serve customers globally. Your current goal is to optimize forcost, and your post-funding goat is to optimize for global presence and performance. You must use a nativeJDBC driver. What should you do?

Options :

A : Use Cloud Spanner to configure a single region instance initially. and then configure multi-region C oudSpanner instances after securing funding.

B : Use a Cloud SQL for PostgreSQL highly available instance first, and 8»gtable with US. Europe, andAsia replication alter securing funding

C : Use a Cloud SQL for PostgreSQL zonal instance first and Bigtable with US. Europe, and Asia aftersecuring funding.

D : Use a Cloud SOL for PostgreSQL zonal instance first, and Cloud SOL for PostgreSQL with highlyavailable configuration after securing funding.

Answer: A

Question 2

You have a BigQuery table that ingests data directly from a Pub/Sub subscription. The ingested data isencrypted with a Google-managed encryption key. You need to meet a new organization policy that requiresyou to use keys from a centralized Cloud Key Management Service (Cloud KMS) project to encrypt data atrest. What should you do?

Options :

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

Question 3

You work for a bank. You have a labelled dataset that contains information on already granted loan application and whether these applications have been defaulted. You have been asked to train a model to predict default rates for credit applicants. What should you do?

Options :

A : Increase the size of the dataset by collecting additional data.

B : Train a linear regression to predict a credit default risk score.

C : Remove the bias from the data and collect applications that have been declined loans.

D : Match loan applicants with their social profiles to enable feature engineering.

Answer: B

Question 4

You are developing a software application using Google's Dataflow SDK, and want to use conditional, for loops and other complex programming structures to create a branching pipeline. Which component will be used for the data processing operation?

Options :

A : PCollection

B : Transform

C : Pipeline

D : Sink API

Answer: B

Question 5

Your company is currently setting up data pipelines for their campaign. For all the Google Cloud Pub/Sub streaming data, one of the important business requirements is to be able to periodically identify the inputs and their timings during their campaign. Engineers have decided to use windowing and transformation in Google Cloud Dataflow for this purpose. However, when testing this feature, they find that the Cloud Dataflow job fails for the all streaming insert. What is the most likely cause of this problem?

Options :

A : They have not assigned the timestamp, which causes the job to fail

B : They have not set the triggers to accommodate the data coming in late, which causes the job to fail

C : They have not applied a global windowing function, which causes the job to fail when the pipeline is created

D : They have not applied a non-global windowing function, which causes the job to fail when the pipeline is created

Answer: C

Free Professional-Data-Engineer Mock Exam – Practice Online Confidently

Buying Options: