Google Cloud Associate Cloud Engineer — Question 302

Your company wants to migrate your data from an on-premises relational database to Google Cloud. Your current database can no longer scale with respect to the growth of your users, and you expect the number of users to rapidly grow. You need to choose a relational database that allows you to globally scale while minimizing your management and administration efforts. You also want to follow Google-recommended practices. What should you do?

Answer options

• A. Use Cloud SQL.
• B. Use Spanner.
• C. Use Firestore.
• D. Use BigQuery.

Correct answer: B

Explanation

The correct answer is B, as Spanner is designed for global scalability and offers a fully managed relational database service. Cloud SQL (A) is suitable for smaller, single-region applications and may not handle the expected growth effectively. Firestore (C) is a NoSQL database, which does not meet the requirement for a relational database, and BigQuery (D) is primarily used for data analytics rather than transactional workloads.