Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER Online Practice Questions and Exam Preparation

Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER Online Questions & Answers

• Question 131:

  You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?

  A. Use Cloud Spanner to deploy the database.
  B. Use Bigtable with clusters in multiple regions to deploy the database
  C. Use BigQuery to deploy the database
  D. Use Cloud SQL with a regional read replica to deploy the database.
  A. Use Cloud Spanner to deploy the database.

  ---

  Explanation/Reference:

  Cloud Spanner is a fully managed, mission-critical, relational database service that offers transactional consistency at global scale, automatic, synchronous replication for high availability, and support for two SQL dialects: Google Standard SQL (ANSI 2011 with extensions) and PostgreSQL.

• Question 132:

  Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?

  A. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
  B. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
  C. Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.
  D. Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.
  B. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.

  ---

  Explanation/Reference:

  https://cloud.google.com/sql/docs/mysql/maintenance?hl=fr