Question 1

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?

Options :

A : Create the "gdpr" tag template with private visibility. Assign the bigquery -dataViewer role to the HR

group on the tables that contain sensitive data.

B : Create the ~gdpr" tag template with private visibility. Assign the datacatalog. tagTemplateViewer role

on this tag to the all employees

group, 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 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.

Answer: D

Question 2

Each analytics team in your organization is running BigQuery jobs in their own projects. You want to enable each team to monitor slot usage within their projects. What should you do?

Options :

A : Create a Stackdriver Monitoring dashboard based on the BigQuery metric query/scanned_bytes

B : Create a Stackdriver Monitoring dashboard based on the BigQuery metric slots/allocated_for_project

C : Create a log export for each project, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

D : Create an aggregated log export at the organization level, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric

Answer: D

Question 3

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 4

You are designing the architecture of your application to store data in Cloud Storage. Your application consists of pipelines that read data from a Cloud Storage bucket that contains raw data, and write the data to a second bucket after processing. You want to design an architecture with Cloud Storage resources that are capable of being resilient if a Google Cloud regional failure occurs. You want to minimize the recovery point objective (RPO) if a failure occurs, with no impact on applications that use the stored data. What should you do?

Options :

A :

Adopt two regional Cloud Storage buckets, and update your application to write the output on both buckets.

B : Adopt multi-regional Cloud Storage buckets in your architecture.

C : Adopt two regional Cloud Storage buckets, and create a daily task to copy from one bucket to the other.

D : Adopt a dual-region Cloud Storage bucket, and enable turbo replication in your architecture.

Answer: D

Question 5

Which role must be assigned to a service account used by the virtual machines in a Dataproc cluster so they can execute jobs?

Options :

A : Dataproc Worker

B : Dataproc Viewer

C : Dataproc Runner

D : Dataproc Editor

Answer: A