PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #128
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #128: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #128. The question stem and answer options stay visible for context.
Question
Your 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.)
Options
- 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.
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.