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

Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?

• A.Migrate the Oracle databases to Cloud SQL.
• B.Migrate the Oracle databases to Bare Metal Solution for Oracle.
• C.Migrate the Oracle databases to Cloud Spanner.
• D.Migrate the Oracle databases to Compute Engine.

Comment: *

Name: *

Email: *

Verification: *

You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
Work with transactions and offer strong consistency.
Work with structured and semi-structured (JSON) data.
Scale transparently to multiple regions globally as the operation grows.
You need a Google Cloud database that meets all the requirements of the application. What should you do?

• A.Use a Bigtable instance with clusters in multiple regions.
• B.Use Firestore in Datastore mode.
• C.Use Cloud Spanner in a multi-region configuration.
• D.Use Cloud SQL for PostgreSQL with both cross-region read replicas.

Comment: *

Name: *

Email: *

Verification: *

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?

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

Comment: *

Name: *

Email: *

Verification: *

Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?

• A.Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.
• B.Migrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.
• C.Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.
• D.Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.

Comment: *

Name: *

Email: *

Verification: *