Question 14 of 139
Choose 2Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available.
You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed
hotspots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to
avoid performance degradation. What should you do? (Choose two.)
AUse an auto-incrementing value as the primary key.
BNormalize the data model.
CPromote low-cardinality attributes in multi-attribute primary keys.
✓DPromote high-cardinality attributes in multi-attribute primary keys.
✓EUse bit-reverse sequential value as the primary key.
✓
Correct Answer: D, E
Promote high-cardinality attributes in multi-attribute primary keys.
▥
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.