Migrate a 20 TB on-prem transactional operational database to GCP. Which managed database should you choose?
Choose an answer
Tap an option to check your answer.
Correct answer: Cloud SQL.
Why this is the answer
Cloud SQL is the best choice for migrating an on-prem transactional operational database because it is a fully managed relational database service that supports popular engines like PostgreSQL, MySQL, and SQL Server. Its relational structure and ACID compliance are ideal for transactional workloads. While 20 TB is a large dataset, Cloud SQL can handle it, especially with proper sharding or read replicas. Cloud Bigtable is a NoSQL wide-column store, unsuitable for transactional relational data. Cloud Spanner is a globally distributed relational database, overkill and more complex for a direct migration of a single operational database unless global consistency is a strict requirement. Cloud Datastore (now part of Firestore) is a NoSQL document database, also not suitable for relational transactional data.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed