- (Exam Topic 5)
Which role must be assigned to a service account used by the virtual machines in a Dataproc cluster so they can execute jobs?

1. A. Dataproc Worker
2. B. Dataproc Viewer
3. C. Dataproc Runner
4. D. Dataproc Editor

Correct Answer: A
Service accounts used with Cloud Dataproc must have Dataproc/Dataproc Worker role (or have all the permissions granted by Dataproc Worker role).
Reference: https://cloud.google.com/dataproc/docs/concepts/service-accounts#important_notes

- (Exam Topic 1)
Your company is using WHILECARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error:
# Syntax error : Expected end of statement but got “-“ at [4:11] SELECT age
FROM
bigquery-public-data.noaa_gsod.gsod WHERE
age != 99
AND_TABLE_SUFFIX = ‘1929’ ORDER BY
age DESC
Which table name will make the SQL statement work correctly?

1. A. ‘bigquery-public-data.noaa_gsod.gsod‘
2. B. bigquery-public-data.noaa_gsod.gsod*
3. C. ‘bigquery-public-data.noaa_gsod.gsod’*
4. D. ‘bigquery-public-data.noaa_gsod.gsod*`

Correct Answer: D

- (Exam Topic 6)
Your company receives both batch- and stream-based event data. You want to process the data using Google Cloud Dataflow over a predictable time period. However, you realize that in some instances data can arrive late or out of order. How should you design your Cloud Dataflow pipeline to handle data that is late or out of order?

1. A. Set a single global window to capture all the data.
2. B. Set sliding windows to capture all the lagged data.
3. C. Use watermarks and timestamps to capture the lagged data.
4. D. Ensure every datasource type (stream or batch) has a timestamp, and use the timestamps to define the logic for lagged data.

Correct Answer: B

- (Exam Topic 1)
You are working on a sensitive project involving private user data. You have set up a project on Google Cloud Platform to house your work internally. An external consultant is going to assist with coding a complex transformation in a Google Cloud Dataflow pipeline for your project. How should you maintain users’ privacy?

1. A. Grant the consultant the Viewer role on the project.
2. B. Grant the consultant the Cloud Dataflow Developer role on the project.
3. C. Create a service account and allow the consultant to log on with it.
4. D. Create an anonymized sample of the data for the consultant to work with in a different project.

Correct Answer: C

- (Exam Topic 6)
You are using BigQuery and Data Studio to design a customer-facing dashboard that displays large quantities of aggregated data. You expect a high volume of concurrent users. You need to optimize tie dashboard to provide quick visualizations with minimal latency. What should you do?

1. A. Use BigQuery BI Engine with materialized views
2. B. Use BigQuery BI Engine with streaming data.
3. C. Use BigQuery Bl Engine with authorized views
4. D. Use BigQuery Bl Engine with logical reviews

Correct Answer: B