
Ultimate access to all questions.
You are tasked with developing a backend service for an ecommerce platform designed to store transaction data received from both mobile and web clients. Following the launch, you anticipate handling a significant volume of transactions from users all around the world. The business team requires the capability to perform SQL queries for data analysis purposes. Your objective is to create a data store that is both highly available and scalable for the platform. What action should you take?
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.