Question 1

You are configuring a new application that has access to an existing Cloud Spanner database. The new

application reads from this database to gather statistics for a dashboard. You want to follow

Google-recommended practices when granting Identity and Access Management (IAM) permissions. What

should you do?

Options :

A :

Reuse the existing service account that populates this database.

B :

Create a new service account, and grant it the Cloud Spanner Database Admin role.

C :

Create a new service account, and grant it the Cloud Spanner Database Reader role.

D :

Create a new service account, and grant it the spanner.databases.select permission.

Answer: C

Question 2

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally

accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow

Google-recommended practices. What should you do? (Choose two.)

Options :

A : Set up manual backups.

B : Create a PostgreSQL database on-premises as the HA option.

C : Configure single zone availability for automated backups.

D : Enable point-in-time recovery.

E : Schedule automated backups.

Answer: D,E

Question 3

You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a

PITR-enabled production environment. When you analyzed the game statistics, you realized that some players

are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an

emergency bugfix script that corrupted some of the data in the production environment. You need to determine

the extent of the data corruption and restore the production environment. What should you do? (Choose two.)

Options :

A : If the corruption is significant, use backup and restore, and specify a recovery timestamp.

B :

If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.

C : If the corruption is significant, use import and export.

D : If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.

E :

If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.

Answer: A,E

Question 4

You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?

Options :

A : Take no backups, and turn off transaction log retention.

B : Take one manual backup per day, and turn off transaction log retention.

C : Turn on automated backup, and turn off transaction log retention.

D : Turn on automated backup, and turn on transaction log retention.

Answer: C

Question 5

You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in

production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the

application that is originating the inefficient queries. You want to follow Google-recommended practices.

What should you do?

Options :

A :

Shut down and restart each application.

B :

Write a utility to scan database query logs.

C :

Write a utility to scan application logs.

D : Use query tags to add application-centric database monitoring.

Answer: D