Google Professional Cloud Database Engineer Question 184
Select 2Google Cloud PlatformYou are managing a Cloud SQL instance hosting a MySQL database for an e-commerce application. To reduce manual intervention during regular database maintenance, which of the following solutions can you implement to automate database tasks such as backups, scaling, and failover?
- A
Enable automated backups in the Cloud SQL settings.
- B
Configure database triggers to handle database scaling automatically.
- C
Set up high availability for the Cloud SQL instance.
- D
Use Cloud Scheduler to trigger maintenance tasks via custom scripts.
- E
Configure the instance to use auto-scaling by enabling CPU and memory thresholds.
Show answer and explanation
Correct answers: A, C
Explanation
Automating database tasks in Cloud SQL can be achieved by enabling built-in features such as automated backups and high availability. These features provide out-of-the-box automation for key maintenance activities like backups and failover, reducing the need for manual intervention. Other options, such as using custom scripts or configuring triggers, may require additional effort and are not natively supported for these tasks.
- A. Correct.
Enabling automated backups in Cloud SQL settings ensures that backups are taken regularly without requiring manual intervention. This is a key feature of Cloud SQL for automating database tasks.
- B. Incorrect.
Database triggers are used to automate actions at the database level based on specific events, but they are not designed for automating infrastructure-level tasks like scaling.
- C. Correct.
Setting up high availability in Cloud SQL configures automatic failover, ensuring that the database remains available during instance failures, which is a form of task automation.
- D. Incorrect.
Cloud Scheduler can automate custom maintenance tasks using scripts, but it requires additional manual setup and maintenance, making it less ideal for fully automating database tasks.
- E. Incorrect.
Cloud SQL does not support auto-scaling based on CPU and memory thresholds. While instance resizing is possible, it requires either manual intervention or integration with external tools.