Question 1

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

Question 2

You are migrating an on-premises application to Google Cloud. The application requires a high availability

(HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy

requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure.

You plan to use a Google Cloud managed service. What should you do to maximize uptime for your

application?

Options :

A :

Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone

in the same region and a read replica in another region for disaster recovery.

B :

Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic

backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region

during a disaster recovery event.

C :

Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region

read replica, and promote the read replica as the primary node for disaster recovery.

D :

Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not

affect your application. Update the schema to support Cloud Spanner data types, and refactor the

application.

Answer: C

Question 3

Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)

Options :

A : Use Database Migration Service to migrate the databases to Cloud SQL.

B : Use a cross-region read replica to migrate the databases to Cloud SQL.

C : Use replication from an external server to migrate the databases to Cloud SQL.

D : Use an external read replica to migrate the databases to Cloud SQL.

E : Use a read replica to migrate the databases to Cloud SQL.

Answer: C,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 are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

Options :

A : Use Cloud SQL with cross-region replicas.

B : Use high availability (HA) Cloud SQL with multiple zones.

C : Use zonal Cloud SQL without high availability (HA).

D : Use Cloud Spanner in a regional configuration.

Answer: D