Answer-first summary for fast verification
Answer: Use Cloud Spanner for storage. Add secondary indexes to support query patterns.
Cloud Spanner is a fully-managed, horizontally scalable relational database service that supports transactions and allows you to optimize data for range queries on non-key columns. By using Cloud Spanner for storage, you can ensure that your database can scale horizontally to meet the needs of your application. To optimize data for range queries on non-key columns, you can add secondary indexes, which will allow you to perform range scans efficiently.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are tasked with designing storage solutions for two relational tables within a 10-terabyte database hosted on Google Cloud. Your primary objectives include supporting horizontally scalable transactions and optimizing data accessibility for range queries on non-key columns. What approach should you take to accomplish these goals?
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.
No comments yet.