nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #185

You are designing a new ecommerce application on Google Cloud. You expect high and bursty write volumes during peak sales periods. You need to configure Spanner to ensure consistent database…

The correct answer is D. Enable autoscaling in the Spanner instance, and set the maximum number of nodes to match the. By enabling Spanner’s autoscaler and configuring the maximum node count to match your anticipated peak write throughput, you ensure that Spanner automatically adds nodes ahead of surges and drops them afterward - delivering consistent performance without manual intervention or…

Managing Cloud Spanner performance and scalability

Question

You are designing a new ecommerce application on Google Cloud. You expect high and bursty write volumes during peak sales periods. You need to configure Spanner to ensure consistent database performance during this sales period. What should you do-

Options

  • AImplement sharding to distribute the write load across multiple Spanner instances.
  • BConfigure read-only transactions to improve read performance during peak periods.
  • CUse interleaved tables to reduce the number of cross-node transactions.
  • DEnable autoscaling in the Spanner instance, and set the maximum number of nodes to match the

How the community answered

(57 responses)
  • A
    11% (6)
  • B
    2% (1)
  • C
    7% (4)
  • D
    81% (46)

Explanation

By enabling Spanner’s autoscaler and configuring the maximum node count to match your anticipated peak write throughput, you ensure that Spanner automatically adds nodes ahead of surges and drops them afterward - delivering consistent performance without manual intervention or over-provisioning.

Topics

#Spanner scaling#Database performance#Autoscaling#Write workload management

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice