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.