nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #51

You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to…

The correct answer is A. Use Cloud Spanner in a regional configuration. Cloud Spanner regional (option A) is the right starting point for a single-country pilot. It provides 99.999% availability within the region with zero scheduled maintenance downtime - unlike Cloud SQL, which requires maintenance windows. It is fully ACID-compliant and can…

Designing and Implementing Cloud Databases

Question

You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?

Options

  • AUse Cloud Spanner in a regional configuration.
  • BUse Cloud Spanner in a multi-region configuration.
  • CUse Cloud SQL with cross-region replicas.
  • DUse highly available Cloud SQL with multiple zones.

How the community answered

(38 responses)
  • A
    61% (23)
  • B
    24% (9)
  • C
    11% (4)
  • D
    5% (2)

Explanation

Cloud Spanner regional (option A) is the right starting point for a single-country pilot. It provides 99.999% availability within the region with zero scheduled maintenance downtime - unlike Cloud SQL, which requires maintenance windows. It is fully ACID-compliant and can horizontally scale to millions of users. A regional configuration is significantly more cost-effective than multi-region (option B) for an initial pilot where global reach is not yet needed. Cloud SQL with cross-region replicas (option C) or multi-zone HA (option D) cannot match Cloud Spanner's maintenance-free operation or its ability to scale to millions of global users without re-architecting.

Topics

#Cloud Spanner#Global Scalability#High Availability#Database Design

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice