Google Cloud Professional Data Engineer PDE — Topic 1 Question 73

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?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Use Cloud Spanner for storage. Add secondary indexes to support query patterns. Cloud Spanner is a horizontally scalable, strongly consistent relational database with global reach.

Google Cloud Professional Data Engineer PDE — Question 73