You are building a backend service for an ecommerce platform that will persist transaction data...

Vendor: Google
Product: Associate-Cloud-Engineer
Update on: Dec 16, 2025
Questions: 343

Google Associate-Cloud-Engineer Question Answer

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?

Create a multi-region Cloud Spanner instance with an optimized schema.

Create a multi-region Firestore database with aggregation query enabled.

Create a multi-region Cloud SQL for PostgreSQL database with optimized indexes.

Create a multi-region BigQuery dataset with optimized tables.