Google Cloud Professional Data Engineer — Question 101

You work for a mid-sized enterprise that needs to move its operational system transaction data from an on-premises database to GCP. The database is about 20
TB in size. Which database should you choose?

Answer options

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

Correct answer: A

Explanation

Cloud SQL is suitable for managing relational databases and can handle the size of 20 TB, making it the correct choice for operational system transaction data. Cloud Bigtable is designed for large analytical workloads and is not optimized for transactional data, while Cloud Spanner is meant for horizontal scaling of relational databases and Cloud Datastore is a NoSQL database suited for unstructured data, making them less appropriate for this scenario.