Google Cloud Associate Cloud Engineer — Question 239

You are building a backend service for an ecommerce platform that will persist transaction data from mobile and web clients. After the platform is launched, you expect a large volume of global transactions. Your business team wants to run SQL queries to analyze the data. You need to build a highly available and scalable data store for the platform. What should you do?

Answer options

• A. Create a multi-region Cloud Spanner instance with an optimized schema.
• B. Create a multi-region Firestore database with aggregation query enabled.
• C. Create a multi-region Cloud SQL for PostgreSQL database with optimized indexes.
• D. Create a multi-region BigQuery dataset with optimized tables.

Correct answer: A

Explanation

The correct answer is A because Cloud Spanner is designed for high availability and scalability, making it suitable for handling large volumes of transactions while allowing SQL queries for analysis. Options B and C do not provide the same level of scalability and availability required for handling global transactions, and D, while suitable for analytics, is not optimized for transactional workloads.