Ultimate access to all questions.
Answer-first summary for fast verification
Answer: Use interleaving to co-locate parent and child rows., Use granular instance sizing in Cloud Spanner and Autoscaler.
To address the issue of high costs while maintaining performance and high availability in Cloud Spanner, the recommended practices include using granular instance sizing and Autoscaler (Option D) to automatically adjust the number of nodes based on the current load, thus optimizing costs without manual intervention. Additionally, using interleaving to co-locate parent and child rows (Option B) can improve query performance by reducing the amount of data scanned, which can also contribute to cost savings by minimizing the resources used for queries. Manually scaling down nodes (Option A) is not a scalable or efficient solution, and relying solely on the query optimizer (Option C) does not directly address the cost issue.
Author: LeetQuiz Editorial Team
No comments yet.
How can you optimize Cloud Spanner for cost efficiency while maintaining performance and high availability when using it as the backend database for an augmented reality game's state storage, player authentication, and in-game reward tracking, given that current costs exceed expectations despite meeting SLA response times?
A
Manually scale down the number of nodes after the peak period has passed.
B
Use interleaving to co-locate parent and child rows.
C
Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
D
Use granular instance sizing in Cloud Spanner and Autoscaler.