You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

• A.Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
• B.Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
• C.Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
• D.Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.

Comment: *

Name: *

Email: *

Verification: *

Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?

• A.Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
• B.Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
• C.Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
• D.Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.

Comment: *

Name: *

Email: *

Verification: *

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?

• 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.

Comment: *

Name: *

Email: *

Verification: *

During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?

• A.Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
• B.Shut down your existing Cloud SQL for MySQL instance, and enable HA.
• C.Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
• D.Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

Comment: *

Name: *

Email: *

Verification: *

You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

• A.Use Migrate for Compute Engine to complete the migration.
• B.Use Database Migration Service to complete the migration.
• C.Use Datastream to complete the migration.
• D.Export the data from the existing database, and load the data into a new Cloud SQL database.

Comment: *

Name: *

Email: *

Verification: *