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.Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
• B.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.
• C.Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
• D.Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.

Comment: *

Name: *

Email: *

Verification: *

Your organization is running a critical production database on a virtual machine (VM) on Compute Engine. The VM has an ext4-formatted persistent disk for data files. The database will soon run out of storage space. You need to implement a solution that avoids downtime. What should you do?

• A.In the Google Cloud Console, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.
• B.In the Google Cloud Console, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use
• C.In the Google Cloud Console, create a snapshot of the persistent disk, restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service.
• D.In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.

Comment: *

Name: *

Email: *

Verification: *

You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?

• A.Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
• B.Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
• C.Start the original primary instance and resume replication.
• D.Verify that the new replica is created automatically.

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 Database Migration Service to complete the migration.
• B.Use Migrate for Compute Engine to complete the migration.
• C.Export the data from the existing database, and load the data into a new Cloud SQL database.
• D.Use Datastream to complete the migration.

Comment: *

Name: *

Email: *

Verification: *

Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?

• A.Use Cloud SQL Auth proxy.
• B.Use customer-managed encryption keys with Cloud SQL.
• C.Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
• D.Connect to Cloud SQL using a connection that has SSL encryption.

Comment: *

Name: *

Email: *

Verification: *