Question 1

Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?

Options :

A :

Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your

database changes to Cloud SQL.

Select the Backfill historical data check box on your stream configuration to initiate Datastream to

backfill any data that is out of sync between the source and destination.

Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application

to use the new instance.

B :

Create migration job using Database Migration Service.

Set the migration job type to Continuous, and allow the databases to complete the full dump phase and

start sending data in change data capture (CDC) mode.

Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and

wait for the migration job to complete.

Update your application connections to the new instance.

C :

Create migration job using Database Migration Service.

Set the migration job type to One-time, and perform this migration during a maintenance window.

Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded

into the Cloud SQL destination database and the destination database to be promoted to the primary

database.

Update your application connections to the new instance.

D :

Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance

window.

Move the files to Cloud Storage, and import each database into your Cloud SQL instance.

Continue to dump each database until all the databases are migrated.

Update your application connections to the new instance.

Answer: B

Question 2

You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in

production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the

application that is originating the inefficient queries. You want to follow Google-recommended practices.

What should you do?

Options :

A :

Shut down and restart each application.

B :

Write a utility to scan database query logs.

C :

Write a utility to scan application logs.

D : Use query tags to add application-centric database monitoring.

Answer: D

Question 3

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

Question 4

Your company is developing a global ecommerce website on Google Cloud. Your development team is

working on a shopping cart service that is durable and elastically scalable with live traffic. Business

disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the

application needs to have very low latency writes. You need a data storage solution that has high write

throughput and provides 99.99% uptime. What should you do?

Options :

A : Use Cloud SQL for data storage.

B : Use Cloud Spanner for data storage.

C : Use Memorystore for data storage.

D : Use Bigtable for data storage.

Answer: B

Question 5

You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest data. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?

Options :

A : Create a read replica for the Sales Reporting application.

B :

Create two separate databases in the instance, and perform dual writes from the Order Management application.

C : Use a Cloud SQL federated query for the Sales Reporting application.

D : Queue up all the requested reports in PubSub, and execute the reports at night.

Answer: A