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

Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database

performance. You need to identify the root cause of the performance degradation. What should you do?

Options :

A : Use Logs Explorer to analyze log data.

B : Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.

C : Use Error Reporting to count, analyze, and aggregate the data.

D : Use Cloud Debugger to inspect the state of an application.

Answer: B

Question 3

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 4

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?

Options :

A : Use Identity and Access Management (IAM) authentication.

B : Use Managed Active Directory authentication.

C : Use Cloud SQL federated queries.

D : Use PostgreSQL database-s built-in authentication.

Answer: A

Question 5

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are

planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to

follow Google-recommended practices and use Google native data migration tools. You also want to closely

monitor the migrations as part of the cutover strategy. What should you do?

Options :

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

B :

Use Database Migration Service for one-time migrations, and use third-party or partner tools for change

data capture (CDC) style migrations.

C :

Use data replication tools and CDC tools to enable migration.

D :

Use a combination of Database Migration Service and partner tools to support the data migration

strategy.

Answer: A