Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
You are tasked with migrating a 3TB relational database to the Google Cloud Platform, but you do not have the resources to make significant changes to the application that uses this database. The primary consideration is the cost of operating the database. Which Google Cloud Platform service would you choose to store and serve your data under these constraints?
Explanation:
Cloud SQL is the most suitable choice for this scenario because it is a fully-managed service that supports MySQL, PostgreSQL, and SQL Server databases. It offers a cost-effective solution for running and managing relational databases in the cloud with minimal application changes. Features like automatic backups, automated patching, and high availability reduce administrative overhead and enhance database availability. While Cloud Spanner, Cloud Bigtable, and Cloud Firestore provide scalability and performance, they may necessitate more significant application modifications and could be less cost-effective for a 3TB relational database.