GoogleGoogle
PROFESSIONAL-DATA-ENGINEER · Question #156
PROFESSIONAL-DATA-ENGINEER Question #156: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #156. The question stem and answer options stay visible for context.
Submitted by yuriko_h· Mar 30, 2026
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.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.