You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?

1. A. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
2. B. Set up Serverless VPC Access.
3. C. Set up Private Service Connect.
4. D. Set up Traffic Director.

Correct Answer: A
https://medium.com/google-cloud/shared-vpc-in-google-cloud-64527e0a409e#:~:text=Unlike%20VPC%20peering%2C%20Shared%20VPC%20connects%20projects%20within%20the%20same%20organization.&text=There%20are%20a%20lot%20of,between%20VPCs%20in%20different%20projects.

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?

1. A. Use Database Migration Service to migrate all databases to Cloud SQL.
2. B. Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
3. C. Use data replication tools and CDC tools to enable migration.
4. D. Use a combination of Database Migration Service and partner tools to support the data migration strategy.

Correct Answer: A
https://cloud.google.com/blog/products/databases/tips-for-migrating-across-compatible-database-engines

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?

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

Correct Answer: C
Binary Logging enabled, with that you can identify the point of time the data was good and recover from that point time. https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#perform_the_point-in-time_recovery_using_binary_log_positions

You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?

1. A. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
2. B. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
3. C. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
4. D. Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.

Correct Answer: C
https://cloud.google.com/sql/docs/mysql/import-export#serverless

Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports. Application C is responsible for automatic backups.
You need to assign roles to team members for Cloud Spanner. Which roles should you assign?

1. A. roles/spanner.databaseAdmin for Person A roles/spanner.databaseReader for Person B roles/spanner.backupWriter for Application C
2. B. roles/spanner.databaseAdmin for Person A roles/spanner.databaseReader for Person B roles/spanner.backupAdmin for Application C
3. C. roles/spanner.databaseAdmin for Person A roles/spanner.databaseUser for Person B roles/spanner databaseReader for Application C
4. D. roles/spanner.databaseAdmin for Person A roles/spanner.databaseUser for Person B roles/spanner.backupWriter for Application C

Correct Answer: A
https://cloud.google.com/spanner/docs/iam#spanner.backupWriter