Question 1

What are the minimum permissions needed for a service account used with Google Dataproc?

Options :

A : Execute to Google Cloud Storage; write to Google Cloud Logging

B : Write to Google Cloud Storage; read to Google Cloud Logging

C : Execute to Google Cloud Storage; execute to Google Cloud Logging

D : Read and write to Google Cloud Storage; write to Google Cloud Logging

Answer: D

Question 2

When you store data in Cloud Bigtable, what is the recommended minimum amount of stored data?

Options :

A : 500 TB

B : 1 GB

C : 1 TB

D : 500 GB

Answer: C

Question 3

You receive data files in CSV format monthly from a third party. You need to cleanse this data, but every third

month the schema of the files changes. Your requirements for implementing these transformations include:

Executing the transformations on a schedule

Enabling non-developer analysts to modify transformations

Providing a graphical tool for designing transformations

What should you do?

Options :

A : Use Cloud Dataprep to build and maintain the transformation recipes, and execute them on a scheduled basis

B : Load each month’s CSV data into BigQuery, and write a SQL query to transform the data to a standard schema. Merge the transformed tables together with a SQL query

C : Help the analysts write a Cloud Dataflow pipeline in Python to perform the transformation. The Python code should be stored in a revision control system and modified as the incoming data’s schema changes

D : Use Apache Spark on Cloud Dataproc to infer the schema of the CSV file before creating a Dataframe. Then implement the transformations in Spark SQL before writing the data out to Cloud Storage and loading into BigQuery

Answer: D

Question 4

A team of data scientists has been using an on-premises cluster running Hadoop and HBase. They want to migrate to a managed service in Google Cloud. They also want to minimize changes to programs that make extensive use of the HBase API. What GCP service would you recommend?

Options :

A : Bigtable

B : BigQuery

C : Cloud Spanner

D : Cloud Dataflow

Answer: A

Question 5

A insurance claim review company provides expert opinion on contested insurance claims. The company uses Google Cloud for it's data analysis pipelines. Clients of the company upload documents to Cloud Storage. When a file is uploaded, the company wants to immediately move the files to a Classified Data bucket if the file contains personally identifying information. What method would you recommend to accomplish this?

Options :

A : Create a quarantine bucket for uploading, once a file is uploaded trigger a Cloud Function to call a custom built machine learning model trained to detect PII. If PII is detected, move the file to the Classified Data bucket.

B : Create a quarantine bucket for uploading, once a file is uploaded trigger a Cloud Function to call the Data Loss Prevention API to apply infotypes to detect PII. If PII is detected, move file to the Classified Data bucket.

C : Create a quarantine bucket for uploading, use Cloud Scheduler to run a job to run hourly that will call a custom built machine learning model trained to detect PII. If PII is detected, move file to the Classified Data bucket.

D : Create a quarantine bucket for uploading, use Cloud Scheduler to run a job to run hourly that will call the Data Loss Prevention API to apply infotypes to detect PII. If PII is detected, move file to the Classified Data bucket.

Answer: B