Answer-first summary for fast verification
Answer: Cloud SQL
The correct answer is A: Cloud SQL. Cloud SQL is a fully-managed relational database service for MySQL, PostgreSQL, and SQL Server. It can handle up to 64 TB of data, which is sufficient for the 20 TB database described in the question. While Cloud Spanner (option C) is also suitable for large databases and supports SQL, it is generally more complex and expensive than Cloud SQL. Cloud Spanner is ideal for use cases requiring global distribution and stronger consistency, but for a mid-sized enterprise with a 20 TB operational system transaction database, Cloud SQL is the more straightforward and cost-effective choice.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You work as a data engineer for a mid-sized enterprise that is currently planning to transition its operational system transaction data from an on-premises database to Google Cloud Platform (GCP). The on-premises database holds approximately 20 TB of data. Given these requirements and the data size, which GCP database service is the most appropriate choice for this task?
A
Cloud SQL
B
Cloud Bigtable
C
Cloud Spanner
D
Cloud Datastore
No comments yet.