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?
A. Use Cloud SQL for storage. Add secondary indexes to support query patterns.
B. Use Cloud SQL for storage. Use Cloud Dataflow to transform data to support query patterns.
C. Use Cloud Spanner for storage. Add secondary indexes to support query patterns.
D. Use Cloud Spanner for storage. Use Cloud Dataflow to transform data to support query patterns.
horizontal scalability only is supported in spanner, so only options available are C and D.
In cloud spanner , you can also create secondary indexes for other columns. Adding a secondary index on a column makes it more efficient to look up data in that column.
Dataflow doent belong to this war.
So it’s C. I bet Gomez’s life on this.