Google Cloud Professional Data Engineer — Question 100

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?

Answer options

• A. Cloud SQL
• B. Cloud Bigtable
• C. Cloud Spanner
• D. Cloud Datastore

Correct answer: C

Explanation

Cloud Spanner is the correct choice as it is a fully managed, horizontally scalable database that maintains strong consistency and supports SQL queries. Cloud SQL, while managed, does not automatically scale to the same extent and is limited in size. Cloud Bigtable is designed for analytical workloads rather than transactional consistency, and Cloud Datastore is not built for SQL queries or scaling to 6 TB in the same manner.