Question 1

Your startup has a web application that currently serves customers out of a single region in Asia. You are

targeting funding that will allow your startup lo serve customers globally. Your current goal is to optimize for

cost, and your post-funding goat is to optimize for global presence and performance. You must use a native

JDBC driver. What should you do?

Options :

A : Use Cloud Spanner to configure a single region instance initially. and then configure multi-region C oud

Spanner instances after securing funding.

B : Use a Cloud SQL for PostgreSQL highly available instance first, and 8»gtable with US. Europe, and

Asia replication alter securing funding

C : Use a Cloud SQL for PostgreSQL zonal instance first and Bigtable with US. Europe, and Asia after

securing funding.

D : Use a Cloud SOL for PostgreSQL zonal instance first, and Cloud SOL for PostgreSQL with highly

available configuration after securing funding.

Answer: A

Question 2

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?

Options :

A : Make a call to the Stackdriver API to list all logs, and apply an advanced filter.

B : In the Stackdriver logging admin interface, and enable a log sink export to BigQuery.

C : In the Stackdriver logging admin interface, enable a log sink export to Google Cloud Pub/Sub, and subscribe to the topic from your monitoring tool.

D : Using the Stackdriver API, create a project sink with advanced log filter to export to Pub/Sub, and subscribe to the topic from your monitoring tool.

Answer: B

Question 3

A data analyst currently has the bigquery.dataViewer role and can successfully query a materialized view. They also want to be able to refresh the materialized view. You want to use a predefined role but not grant them any more permissions than needed to refresh the materialized view. What predefined role would you grant to the user?

Options :

A : bigquery.dataOwner

B : bigquery.admin

C : bigquery.dataEditor

D : bigquery.mvUpdater

Answer: C

Question 4

Messages are unexpectedly accumulating in service using Cloud Pub/Sub. A developer unfamiliar with Cloud Pub/Sub has asked for our help in diagnosing the problem. What would you point out with respect to how messages are removed from Cloud Pub/Sub topics?

Options :

A : Once at least one subscriber for each topic has acknowledged the message it will be deleted from storage.

B : Once at least one subscriber for each bucket has acknowledged the message it will be deleted from storage.

C : Once at least one subscriber for any subscription has acknowledged the message it will be deleted from storage.

D : Once at least one subscriber for each subscription has acknowledged the message it will be deleted from storage.

Answer: D

Question 5

You are migrating a table to BigQuery and are deeding on the data model. Your table stores information related to purchases made across several store locations and includes information like the time of the transaction, items purchased, the store ID and the city and state in which the store is located You frequently query this table to see how many of each item were sold over the past 30 days and to look at purchasing trends by state city and individual store. You want to model this table to minimize query time and cost. What should you do?

Options :

A : Partition by transaction time; cluster by state first, then city then store ID

B : Partition by transaction tome cluster by store ID first, then city, then stale

C : Top-level cluster by stale first, then city then store

D : Top-level cluster by store ID first, then city then state.

Answer: C