Question 1

Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime

during the month of December. The company is also concerned with cost, so you need the most cost-effective

solution. What should you do?

Options :

A :

Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the

month of December.

B :

Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.

C :

Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act

as the primary instance during the month of December.

D :

Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the

primary instance during the month of December.

Answer: B

Question 2

Your organization has a ticketing system that needs an online marketing analytics and reporting application.

You need to select a relational database that can manage hundreds of terabytes of data to support this new

application. Which database should you use?

Options :

A : Cloud SQL

B : BigQuery

C : Cloud Spanner

D : Bigtable

Answer: B

Question 3

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 4

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 5

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