Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 15

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

Accepted Answer

Correct answer: D, E. The correct answer is D, E. Option D: Promote high-cardinality attributes in multi-attribute primary keys. Option E: Use bit-reverse sequential value as the primary key.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 15