Google Professional Data Engineer
Get started today
Ultimate access to all questions.
You are working on a new project, and part of the initial setup involves selecting an appropriate database. Here are the key requirements that the database must meet:
✑ It must be fully managed, meaning that the operational tasks such as backups, patching, and scaling are handled automatically by the service provider.
✑ It should have the capability to automatically scale up in response to the workload demands.
✑ The database must maintain transactional consistency to ensure that all transactions are processed reliably and in a manner that preserves data integrity.
✑ It should be able to scale up to a storage capacity of 6 TB.
✑ The database must be accessible through SQL queries for data manipulation and retrieval.
Based on these requirements, which database solution should you choose?
You are working on a new project, and part of the initial setup involves selecting an appropriate database. Here are the key requirements that the database must meet:
✑ It must be fully managed, meaning that the operational tasks such as backups, patching, and scaling are handled automatically by the service provider. ✑ It should have the capability to automatically scale up in response to the workload demands. ✑ The database must maintain transactional consistency to ensure that all transactions are processed reliably and in a manner that preserves data integrity. ✑ It should be able to scale up to a storage capacity of 6 TB. ✑ The database must be accessible through SQL queries for data manipulation and retrieval.
Based on these requirements, which database solution should you choose?
Explanation:
The correct answer is C: Cloud Spanner. Cloud Spanner is fully managed, can automatically scale, is transactionally consistent, can scale up to multiple terabytes (including 6 TB), and supports SQL querying. While Cloud SQL is also fully managed and can scale up, it doesn't scale as seamlessly as Cloud Spanner, which can automatically adjust resources without requiring a restart.