Question 1

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 2

You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?

Options :

A : Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

B :

Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

C : Create a read replica in another region, and promote the read replica if a failure occurs.

D : Enable high availability (HA) for the database to make it regional.

Answer: D

Question 3

Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?

Options :

A :

Create the database on a Bare Metal Solution server with the database running on flash storage.

Keep a local backup copy on all flash storage.

Keep backups older than one day stored in Actifio OnVault storage.

B :

Create the database on a Bare Metal Solution server with the database running on flash storage.

Keep a local backup copy on standard storage.

Keep backups older than one day stored in Actifio OnVault storage.

C :

Create the database on a Bare Metal Solution server with the database running on flash storage.

Keep a local backup copy on standard storage.

Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a

Coldline Storage bucket.

D :

Create the database on a Bare Metal Solution server with the database running on flash storage.

Keep a local backup copy on all flash storage.

Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an

Archive Storage bucket.

Answer: B

Question 4

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

Options :

A : Place the bulk of the read and write workloads closer to the default leader region.

B : Use staleness of at least 15 seconds.

C : Add more read-write replicas.

D : Keep the total CPU utilization under 45% in each region.

Answer: A

Question 5

You are building an Android game that needs to store data on a Google Cloud serverless database. The

database will log user activity, store user preferences, and receive in-game updates. The target audience

resides in developing countries that have intermittent internet connectivity. You need to ensure that the game

can synchronize game data to the backend database whenever an internet network is available. What should

you do?

Options :

A :

Use Firestore.

B :

Use Cloud SQL with an external (public) IP address.

C : Use an in-app embedded database

D : Use Cloud Spanner.

Answer: A