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 are responsible for designing a new database for an airline ticketing application in Google Cloud. This

application must be able to:

Work with transactions and offer strong consistency.

Work with structured and semi-structured (JSON) data.

Scale transparently to multiple regions globally as the operation grows.

You need a Google Cloud database that meets all the requirements of the application. What should you do?

Options :

A : Use Cloud SQL for PostgreSQL with both cross-region read replicas.

B : Use Cloud Spanner in a multi-region configuration.

C : Use Firestore in Datastore mode.

D : Use a Bigtable instance with clusters in multiple regions.

Answer: B

Question 3

You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps

network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose

two.)

Options :

A :

Use a change data capture (CDC) migration strategy.

B :

Move the physical database servers from on-premises to Google Cloud.

C : Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.

D :

Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.

E :

Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

Answer: A,E

Question 4

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

Options :

A : Bring DB-1 back online.

B : Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

C : Delete DB-2 so that DB-1 automatically reverts to the primary instance.

D : Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

Answer: D

Question 5

You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

Options :

A :

Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

B : Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.

C : Use Database Migration Service to migrate your database.

D : Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

Answer: D

Higher Test Marks with Free Online Professional-Cloud-Database-Engineer Exam Practice

Buying Options: