nerdexam
Google

PROFESSIONAL-DATA-ENGINEER · Question #242

You need to choose a database for a new project that has the following requirements: Fully managed Able to automatically scale up Transactionally consistent Able to scale up to 6 TB Able to be…

The correct answer is A. Cloud SQL. Explanation/Reference: It asks for scaling up which can be done in cloud sql, horizontal scaling is not possible in cloud sql Automatic storage increase If you enable this setting, Cloud SQL checks your available storage every 30 seconds. If the available storage falls below a…

Submitted by lucia.co· Mar 30, 2026Designing data processing systems

Question

You need to choose a database for a new project that has the following requirements: Fully managed Able to automatically scale up Transactionally consistent Able to scale up to 6 TB Able to be queried using SQL Which database do you choose?

Options

  • ACloud SQL
  • BCloud Bigtable
  • CCloud Spanner
  • DCloud Datastore

How the community answered

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

Explanation

Explanation/Reference: It asks for scaling up which can be done in cloud sql, horizontal scaling is not possible in cloud sql Automatic storage increase If you enable this setting, Cloud SQL checks your available storage every 30 seconds. If the available storage falls below a threshold size, Cloud SQL automatically adds additional storage capacity. If the available storage repeatedly falls below the threshold size, Cloud SQL continues to add storage until it reaches the maximum of 30 TB.

Topics

#Cloud Spanner#Cloud SQL#database selection#scalability requirements

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-DATA-ENGINEER Practice