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?

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

Correct Answer: B
This answer is correct because it meets the requirements of having an optimal and highly available environment with automatic failover. According to the Google Cloud documentation1, a regional Cloud SQL instance is an instance that has a primary server in one zone and a standby server in another zone within the same region. The primary and standby servers are kept in sync using synchronous replication, which ensures zero data loss and minimal downtime in case of a zonal outage or an instance failure. If the primary server becomes unavailable, Cloud SQL automatically fails over to the standby server, which becomes the new primary server1.

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

1. A. Place the bulk of the read and write workloads closer to the default leader region.
2. B. Use staleness of at least 15 seconds.
3. C. Add more read-write replicas.
4. D. Keep the total CPU utilization under 45% in each region.

Correct Answer: A
https://cloud.google.com/spanner/docs/instance-configurations#multi-region- best-practices Best practices For optimal performance, follow these best practices: Design a schema that prevents hotspots and other performance issues. For optimal write latency, place compute resources for write-heavy workloads within or close to the default leader region. For optimal read performance outside of the default leader region, use staleness of at least 15 seconds. To avoid single-region dependency for your workloads, place critical compute resources in at least two regions. A good option is to place them next to the two different read-write regions so that any single region outage will not impact all of your application. Provision enough compute capacity to keep high priority total CPU utilization under 45% in each region.

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?

1. A. Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.
2. 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.
3. 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.
4. D. Migrate the Oracle databases to Compute Engine, and store backups on tapes on- premises.

Correct Answer: B
https://www.actifio.com/solutions/cloud/google/

You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached data. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?

1. A. Use Firestore and ensure that the PersistenceEnabled option is set to true.
2. B. Use Memorystore for Memcached.
3. C. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
4. D. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.

Correct Answer: A
https://firebase.google.com/docs/firestore/manage-data/enable-offline

Your company is developing a new global transactional application that must be ACID- compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

1. A. Use Firestore.
2. B. Use Cloud Spanner.
3. C. Use Cloud SQL.
4. D. Use Bigtable.

Correct Answer: B