Two relational tables from a 10 TB database need horizontally scalable transactions and optimized range queries on non-key columns. Which storage and optimization should you use?
Choose an answer
Tap an option to check your answer.
Correct answer: Use Cloud Spanner and add secondary indexes to support query patterns..
Why this is the answer
Cloud Spanner is the correct choice because it is a globally distributed, strongly consistent, and horizontally scalable relational database service, making it ideal for 10 TB databases requiring scalable transactions. Adding secondary indexes directly within Spanner optimizes range queries on non-key columns by providing efficient lookup paths. Cloud SQL, while relational, is not designed for the same level of horizontal scalability as Spanner for such large datasets and high transaction volumes. Using Cloud Dataflow to transform data for query patterns would be an ETL process, not a direct solution for optimizing live transactional queries on non-key columns within the database itself.
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