A US-based application ingests 250,000 records per second into a primary table and must provide: a single global endpoint, ANSI SQL, and consistent, up-to-date reads. Which database architecture meets these requirements?
Choose an answer
Tap an option to check your answer.
Correct answer: Use Cloud Spanner with a leader in North America and read-only replicas in Asia and Europe..
Why this is the answer
Cloud Spanner is the only option that satisfies all requirements. It provides a single global endpoint, supports ANSI SQL, and offers strong consistency for up-to-date reads across globally distributed data. Its architecture, with a leader in North America and read-only replicas elsewhere, ensures low-latency reads for global users while maintaining data consistency. BigQuery is not a transactional database and does not provide consistent, up-to-date reads for individual records at this ingestion rate. Cloud SQL for PostgreSQL, while supporting ANSI SQL, does not inherently offer a single global endpoint with strong consistency across continents for high-volume transactional workloads. Bigtable is a NoSQL wide-column store, lacking ANSI SQL support.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed