☎  076 959 6407✉  support@quizcrazepro.co.za
Learn. Practice. Build your future.
BlogHelpContact
G

Google Professional Data Engineer Actual Exam Questions

307 Questions120 Minutes70% Passing Score▣ Updated: Sep 2026

Question 94 of 307

Single answer
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?
AUse Cloud SQL for storage. Add secondary indexes to support query patterns.
BUse Cloud SQL for storage. Use Cloud Dataflow to transform data to support query patterns.
CUse Cloud Spanner for storage. Add secondary indexes to support query patterns.
DUse Cloud Spanner for storage. Use Cloud Dataflow to transform data to support query patterns.
Correct Answer: C

Use Cloud Spanner for storage. Add secondary indexes to support query patterns.

Explanation

The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.

About this practice exam

Review 307 Google questions with answers and explanations. Use the navigation to move through the exam at your own pace.