Google Professional Data Engineer
Get started today
Ultimate access to all questions.
You are tasked with selecting a database for a new project that must meet the following criteria: fully managed, capable of automatic scaling, transactionally consistent, able to scale up to 6 TB, and queryable using SQL. Which database would you recommend for this project?
You are tasked with selecting a database for a new project that must meet the following criteria: fully managed, capable of automatic scaling, transactionally consistent, able to scale up to 6 TB, and queryable using SQL. Which database would you recommend for this project?
Explanation:
Cloud Spanner is the most suitable database for this project due to its fully managed nature, automatic scaling capabilities, transactional consistency, scalability up to and beyond 6 TB, and support for SQL queries. While Cloud SQL is fully managed and supports SQL, its scalability might be limited for a 6 TB database. Cloud Bigtable is not designed for SQL queries, and Cloud Datastore is a NoSQL document database, making them unsuitable for SQL-based queries.