Google Professional Cloud Database Engineer Question 185
Select 3Google Cloud PlatformYou are managing a Cloud SQL for PostgreSQL database for a rapidly growing e-commerce application. The database requires regular backups, monitoring for long-running queries, and automatic scaling of read replicas during peak traffic. Which combination of solutions would you implement to automate these tasks effectively?
- A
Enable automated backups in the Cloud SQL settings and configure the backup schedule.
- B
Use Cloud Monitoring and create an alerting policy to notify you of long-running queries.
- C
Manually review logs every hour to identify long-running queries and address them in real-time.
- D
Set up read replicas and configure Cloud SQL to enable automatic scaling of replicas.
- E
Write custom scripts to handle automated backups and query monitoring.
Show answer and explanation
Correct answers: A, B, D
Explanation
The correct combination of solutions leverages Cloud SQL's built-in automation features and integration with Cloud Monitoring to handle backups, query monitoring, and read replica scaling. These solutions minimize manual effort and improve reliability and scalability, aligning with best practices for automating database management tasks.
- A. Correct.
This is correct. Enabling automated backups in Cloud SQL ensures that database backups occur on a regular basis without manual intervention.
- B. Correct.
This is correct. Cloud Monitoring can be configured to track database metrics and alert you when long-running queries are detected, automating the monitoring process.
- C. Incorrect.
This is incorrect. Manually reviewing logs is not an automated solution and requires significant manual effort, making it inefficient.
- D. Correct.
This is correct. Setting up read replicas and enabling automatic scaling in Cloud SQL allows the system to scale read replicas dynamically during high traffic periods.
- E. Incorrect.
This is incorrect. Writing custom scripts requires significant maintenance and effort, whereas Cloud SQL provides built-in solutions for these tasks.