Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database.
Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us- central1 and the backup region of us-east1. What should you do?

• A.Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-west1-b.
  Create a read replica in us-east1-c.
• B.Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-central1-b.
  Create a read replica in us-east1-b.
• C.Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-east-b.
  Create a read replica in us-east1-c.
• D.Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-east1-b.
  Create a read replica in us-central1-b.

Comment: *

Name: *

Email: *

Verification: *

Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day.
Theapplication team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?

• A.Isolate the data analysts and operations user groups to use different Bigtable instances.
• B.Check the Cloud Monitoring table/bytes_used metric from Bigtable.
• C.Use Key Visualizer for Bigtable.
• D.Add more nodes to the Bigtable cluster.

Comment: *

Name: *

Email: *

Verification: *

You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

• A.Use Cloud SQL with cross-region replicas.
• B.Use high availability (HA) Cloud SQL with multiple zones.
• C.Use zonal Cloud SQL without high availability (HA).
• D.Use Cloud Spanner in a regional configuration.

Comment: *

Name: *

Email: *

Verification: *

You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?

• A.Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.
• B.Use Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
• C.Use HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
• D.Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.

Comment: *

Name: *

Email: *

Verification: *

Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

• A.Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-east-b.
  Create a read replica in us-east1-c.
• B.Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-central1-b.
  Create a read replica in us-east1-b.
• C.Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-west1-b.
  Create a read replica in us-east1-c.
• D.Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-east1-b.
  Create a read replica in us-central1-b.

Comment: *

Name: *

Email: *

Verification: *