nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #69

Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires…

The correct answer is D. Use Cloud Spanner. Cloud Spanner is Google Cloud's fully managed, globally distributed relational database built for exactly these requirements. It offers strong (external) consistency across regions, ACID transactions, and a 99.999% SLA for multi-region configurations-exceeding the 99.99%…

Designing and planning a database solution

Question

Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

Options

  • AUse Bigtable.
  • BUse Firestore.
  • CUse Cloud SQL for MySQL
  • DUse Cloud Spanner.

How the community answered

(22 responses)
  • A
    5% (1)
  • B
    5% (1)
  • C
    9% (2)
  • D
    82% (18)

Explanation

Cloud Spanner is Google Cloud's fully managed, globally distributed relational database built for exactly these requirements. It offers strong (external) consistency across regions, ACID transactions, and a 99.999% SLA for multi-region configurations-exceeding the 99.99% requirement. Bigtable (A) is a NoSQL wide-column store without global transactional consistency. Firestore (B) is a NoSQL document database unsuitable for relational inventory data with strict consistency needs. Cloud SQL for MySQL (C) is a regional service that does not natively support global distribution or global ACID transactions.

Topics

#Cloud Spanner#Global Databases#Transactional Consistency#High Availability

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice