Google Professional Data Engineer

Get started today

Ultimate access to all questions.

Explanation:

The best choice for such a project is Cloud Spanner due to its unique combination of features:

Automatic scaling: Adjusts resources dynamically to meet workload demands, optimizing performance and cost.
Transactional consistency: Offers ACID (Atomicity, Consistency, Isolation, Durability) properties, ensuring reliable transactions.
Scalability: Capable of handling up to petabytes of data and thousands of queries per second, ideal for large-scale applications.
SQL querying: Utilizes a SQL-like language, facilitating easy integration and development.

While alternatives like Cloud SQL and Cloud Datastore provide some of these capabilities, Cloud Spanner stands out for projects with these specific, demanding requirements.

Explanation:

The best choice for such a project is Cloud Spanner due to its unique combination of features:

Automatic scaling: Adjusts resources dynamically to meet workload demands, optimizing performance and cost.
Transactional consistency: Offers ACID (Atomicity, Consistency, Isolation, Durability) properties, ensuring reliable transactions.
Scalability: Capable of handling up to petabytes of data and thousands of queries per second, ideal for large-scale applications.
SQL querying: Utilizes a SQL-like language, facilitating easy integration and development.

While alternatives like Cloud SQL and Cloud Datastore provide some of these capabilities, Cloud Spanner stands out for projects with these specific, demanding requirements.

Comments (0)

No comments yet.

For a new project requiring a fully managed database that automatically scales, ensures transactional consistency, can scale up to 6 TB, and supports SQL queries, which option is the best?

Real Exam

Last updated: July 15, 2026 at 14:06

Cloud Bigtable

8.6%

Cloud Spanner

55.2%

Cloud Datastore

8.6%

Cloud SQL

27.6%