Google Professional Cloud Database Engineer Question 170
Select 3Google Cloud PlatformYour organization runs a PostgreSQL database on Cloud SQL to handle an e-commerce application. During flash sales, the application experiences a heavy spike in traffic, which requires scaling the database to accommodate the increased workload. As a Professional Cloud Database Engineer, what steps should you take to ensure the database instance can handle the increased traffic while minimizing downtime?
- A
Enable Cloud SQL automatic storage increase to ensure sufficient disk space during traffic spikes.
- B
Manually upgrade the instance to a larger machine type during the flash sale period.
- C
Set up read replicas to handle read-heavy traffic and distribute the workload.
- D
Enable high availability for the instance to prevent potential downtime during scaling operations.
- E
Implement horizontal scaling by adding multiple primary instances to distribute the traffic.
Show answer and explanation
Correct answers: A, C, D
Explanation
To effectively scale a Cloud SQL database instance for high traffic events, proactive measures like enabling automatic storage increase, setting up read replicas, and ensuring high availability are essential. These ensure scalability, reliability, and minimal downtime during workload spikes. Horizontal scaling with multiple primary instances is not supported in Cloud SQL, and manual upgrades during the event are not ideal due to potential downtime.
- A. Correct.
Enabling automatic storage increase ensures that the database can dynamically expand its storage capacity, avoiding downtime due to storage exhaustion during high traffic periods. This is a scalable and proactive measure.
- B. Incorrect.
Manually upgrading the instance during the flash sale period introduces potential downtime and is not an ideal approach for scaling to handle sudden spikes in traffic.
- C. Correct.
Setting up read replicas allows the database to distribute read-heavy traffic across multiple instances, improving performance and ensuring the database can handle the increased workload.
- D. Correct.
Enabling high availability ensures minimal downtime and increases reliability during scaling operations, which is critical during high traffic events like flash sales.
- E. Incorrect.
Cloud SQL does not support horizontal scaling by adding multiple primary instances. Instead, it supports setting up read replicas and scaling vertically by upgrading the instance size.