Question 1

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 2

You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?

Options :

A : For each application code, set up a common shared user account.

B : For each application code, set up a dedicated user account.

C : For the application server, set up a service account.

D : For the application server, set up a common shared user account.

Answer: C

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 online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

Options :

A : Set up all read replicas in a different region using asynchronous replication.

B : Set up all read replicas in the same region as the primary instance with synchronous replication.

C :

Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.

D :

Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.

Answer: C

Question 5

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