Question 1

- (Exam Topic 1)
You want to use Google Stackdriver Logging to monitor Google BigQuery usage. You need an instant notification to be sent to your monitoring tool when new data
is appended to a certain table using an insert job, but you do not want to receive notifications for other tables. What should you do?

Accepted Answer

Correct answer: B

Question 2

- (Exam Topic 1)
Your weather app queries a database every 15 minutes to get the current temperature. The frontend is powered by Google App Engine and server millions of
users. How should you design the frontend to respond to a database failure?

Accepted Answer

https://cloud.google.com/sql/docs/mysql/manage-connections#backoff

Question 3

- (Exam Topic 1)
Your company is in a highly regulated industry. One of your requirements is to ensure individual users have access only to the minimum amount of information
required to do their jobs. You want to enforce this requirement with Google BigQuery. Which three approaches can you take? (Choose three.)

Accepted Answer

Correct answer: BDF

Question 4

- (Exam Topic 1)
You are building new real-time data warehouse for your company and will use Google BigQuery streaming inserts. There is no guarantee that data will only be
sent in once but you do have a unique ID for each row of data and an event timestamp. You want to ensure that duplicates are not included while interactively
querying data. Which query type should you use?

Accepted Answer

https://cloud.google.com/bigquery/docs/reference/standard-sql/analytic-function-concepts

Question 5

- (Exam Topic 1)
You have Google Cloud Dataflow streaming pipeline running with a Google Cloud Pub/Sub subscription as the source. You need to make an update to the code
that will make the new Cloud Dataflow pipeline incompatible with the current version. You do not want to lose any data when making this update. What should you
do?

Accepted Answer

Correct answer: D

Question 6

- (Exam Topic 1)
Your company’s on-premises Apache Hadoop servers are approaching end-of-life, and IT has decided to migrate the cluster to Google Cloud Dataproc. A like-forlike migration of the cluster would require 50 TB of Google Persistent Disk per node. The CIO is concerned about the cost of using that much block storage. You
want to minimize the storage cost of the migration. What should you do?

(268 New Questions)

Accepted Answer

Correct answer: B

Question 7

- (Exam Topic 1)
Your company’s customer and order databases are often under heavy load. This makes performing analytics against them difficult without harming operations.
The databases are in a MySQL cluster, with nightly backups taken using mysqldump. You want to perform analytics with minimal impact on operations. What
should you do?

Accepted Answer

Correct answer: C

Question 8

- (Exam Topic 1)
You have spent a few days loading data from comma-separated values (CSV) files into the Google BigQuery table CLICK_STREAM. The column DT stores the
epoch time of click events. For convenience, you chose a simple schema where every field is treated as the STRING type. Now, you want to compute web session
durations of users who visit your site, and you want to change its data type to the TIMESTAMP. You want to minimize the migration effort without making future
queries computationally expensive. What should you do?

Accepted Answer

Correct answer: D

Question 9

- (Exam Topic 1)
Your company is migrating their 30-node Apache Hadoop cluster to the cloud. They want to re-use Hadoop jobs they have already created and minimize the
management of the cluster as much as possible. They also want to be able to persist data beyond the life of the cluster. What should you do?

Accepted Answer

Correct answer: D

Question 10

- (Exam Topic 1)
An external customer provides you with a daily dump of data from their database. The data flows into Google Cloud Storage GCS as comma-separated values
(CSV) files. You want to analyze this data in Google BigQuery, but the data could have rows that are formatted incorrectly or corrupted. How should you build this
pipeline?

Accepted Answer

Correct answer: D