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 Compute Engine, and store backups on tapes on-premises.
• B.Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.
• C.Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.
• D.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.

Comment: *

Name: *

Email: *

Verification: *

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

• A.Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
• B.Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
• C.Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
• D.Create one regional Cloud SQL instance with a read replica in another region.

Comment: *

Name: *

Email: *

Verification: *

You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?

• A.Ensure that the service account has the Storage Admin role.
• B.Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
• C.Increase the amount of memory allocated to your instance.
• D.Close idle connections or restart the instance before beginning the import operation.

Comment: *

Name: *

Email: *

Verification: *

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

• A.Edit the instance to change the storage type from HDD to SSD.
• B.Create a read replica of the instance with SSDs, and perform a failover to the new instance
• C.Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
• D.Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).

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 Cloud SQL for PostgreSQL with both cross-region read replicas.
• C.Use Cloud Spanner in a multi-region configuration.
• D.Use Firestore in Datastore mode.

Comment: *

Name: *

Email: *

Verification: *