Google Cloud Professional Data Engineer — Question 89

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?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because Cloud Spanner is designed to handle horizontal scalability and supports secondary indexes, making it suitable for large databases and optimizing range queries. Options A and B, which use Cloud SQL, do not provide the necessary scalability for a 10-TB database. Option D, while using Cloud Spanner, incorrectly suggests using Cloud Dataflow, which is not needed for optimizing query patterns in this scenario.