GoogleGoogle
PROFESSIONAL-CLOUD-DEVELOPER · Question #104
PROFESSIONAL-CLOUD-DEVELOPER Question #104: Real Exam Question with Answer & Explanation
The correct answer is C: The use of Version 1 UUIDs as primary keys that increase monotonically.. https://cloud.google.com/spanner/docs/schema-and-data-model#choosing_a_primary_key
Optimizing Cloud Spanner Database Performance
Question
You are developing an ecommerce application that stores customer, order, and inventory data as relational tables inside Cloud Spanner. During a recent load test, you discover that Spanner performance is not scaling linearly as expected. Which of the following is the cause?
Options
- AThe use of 64-bit numeric types for 32-bit numbers.
- BThe use of the STRING data type for arbitrary-precision values.
- CThe use of Version 1 UUIDs as primary keys that increase monotonically.
- DThe use of LIKE instead of STARTS_WITH keyword for parameterized SQL queries.
Explanation
https://cloud.google.com/spanner/docs/schema-and-data-model#choosing_a_primary_key
Topics
#Cloud Spanner#Primary Keys#Hotspots#Performance Optimization
Community Discussion
No community discussion yet for this question.