Google
PROFESSIONAL-DATA-ENGINEER · Question #156
You are designing storage for two relational tables that are part of a 10-TB database on Google Cloud. You want to support transactions that scale horizontally. You also want to optimize data for…
The correct answer is C. Use Cloud Spanner for storage. Add secondary indexes to support query patterns. Explanation/Reference: Spanner allows transaction tables to scale horizontally and secondary indexes for range queries.
Submitted by yuriko_h· Mar 30, 2026Designing data processing systems
Question
You are designing storage for two relational tables that are part of a 10-TB database on Google Cloud. You want to support transactions that scale horizontally. You also want to optimize data for range queries on non-key columns. What should you do?
Options
- AUse Cloud SQL for storage. Add secondary indexes to support query patterns.
- BUse Cloud SQL for storage. Use Cloud Dataflow to transform data to support query patterns.
- CUse Cloud Spanner for storage. Add secondary indexes to support query patterns.
- DUse Cloud Spanner for storage. Use Cloud Dataflow to transform data to support query patterns.
How the community answered
(39 responses)- A8% (3)
- B5% (2)
- C85% (33)
- D3% (1)
Explanation
Explanation/Reference: Spanner allows transaction tables to scale horizontally and secondary indexes for range queries.
Topics
#Cloud Spanner#secondary indexes#horizontal scaling#range queries
Community Discussion
No community discussion yet for this question.