Question 1

You are designing a Dataflow pipeline for a batch processing job. You want to mitigate multiple zonal failures

at job submission time. What should you do?

Options :

A : Specify a worker region by using the —region flag.

B : Set the pipeline staging location as a regional Cloud Storage bucket.

C : Submit duplicate pipelines in two different zones by using the —zone flag.

D : Create an Eventarc trigger to resubmit the job in case of zonal failure when submitting the job.

Answer: A

Question 2

You are designing a data warehouse in BigQuery to analyze sales data for a telecommunication service

provider. You need to create a data model for customers, products, and subscriptions All customers, products,

and subscriptions can be updated monthly, but you must maintain a historical record of all data. You plan to

use the visualization layer for current and historical reporting. You need to ensure that the data model is

simple, easy-to-use. and cost-effective. What should you do?

Options :

A :

Create a normalized model with tables for each entity. Use snapshots before updates to track historical data

B :

Create a normalized model with tables for each entity. Keep all input files in a Cloud Storage bucket to track historical data

C :

Create a denormalized model with nested and repeated fields Update the table and use snapshots to track historical data

D :

Create a denormalized, append-only model with nested and repeated fields Use the ingestion timestamp to track historical data.

Answer: D

Question 3

Why do you need to split a machine learning dataset into training data and test data?

Options :

A : So you can try two different sets of features

B : To make sure your model is generalized for more than just the training data

C : To allow you to create unit tests in your code

D : So you can use one dataset for a wide model and one for a deep model

Answer: B

Question 4

Analysts are using Cloud Data Studio for analyzing data sets. They would like to improve the performance of the time required to update tables and charts when working with the data. What would you recommend they try to improve performance?

Options :

A : Use an imported data source

B : Use a blended data source

C : Use a live data source

D : Use an extracted data source

Answer: D

Question 5

You are using BigQuery with a regional dataset that includes a table with the daily sales volumes. This table is updated multiple times per day. You need to protect your sales table in case of regional failures with a recovery point objective (RPO) of less than 24 hours, while keeping costs to a minimum. What should you do?

Options :

A :

Schedule a daily BigQuery snapshot of the table.

B :

Schedule a daily export of the table to a Cloud Storage dual or multi-region bucket.

C :

Schedule a daily copy of the dataset to a backup region.

D :

Modify ETL job to load the data into both the current and another backup region.

Answer: A