Google Cloud Professional Data Engineer — Question 124

You need to migrate a 2TB relational database to Google Cloud Platform. You do not have the resources to significantly refactor the application that uses this database and cost to operate is of primary concern.
Which service do you select for storing and serving your data?

Answer options

• A. Cloud Spanner
• B. Cloud Bigtable
• C. Cloud Firestore
• D. Cloud SQL

Correct answer: D

Explanation

Cloud SQL is the most suitable option for migrating a 2TB relational database without requiring significant changes to the application, as it supports relational databases and is cost-effective for this use case. Cloud Spanner is designed for high scalability but can be more expensive than necessary, while Cloud Bigtable and Cloud Firestore are not relational databases, making them incompatible for this scenario.