nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #45

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…

The correct answer is B. Use Cloud Spanner. Cloud Spanner is Google's globally distributed relational database that provides full ACID transactions, external consistency (strong consistency), and a 99.999% SLA in its multi-region configuration. No other option meets all requirements: Firestore (option A) is a NoSQL…

Designing Database Solutions

Question

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?

Options

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

How the community answered

(44 responses)
  • A
    7% (3)
  • B
    80% (35)
  • C
    2% (1)
  • D
    11% (5)

Explanation

Cloud Spanner is Google's globally distributed relational database that provides full ACID transactions, external consistency (strong consistency), and a 99.999% SLA in its multi-region configuration. No other option meets all requirements: Firestore (option A) is a NoSQL document store and does not offer full relational ACID semantics at global scale. Cloud SQL (option C) is ACID-compliant but its 99.999% availability and global scalability are limited. Bigtable (option D) is a NoSQL wide-column store and does not support ACID transactions.

Topics

#Database selection#Cloud Spanner#ACID transactions#High availability

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice