A company operates a critical Cloud SQL for PostgreSQL production database and needs to implement a robust data protection strategy. They have the following requirements for their backup solution: - **Centralized management** of backups for multiple Cloud SQL instances across different Google Cloud projects. - **Long-term retention** for compliance, requiring backups to be kept for several years. - **Granular scheduling** for automated backups, allowing for more frequent than daily backups. - The ability to perform **point-in-time recovery** to restore the database to any specific moment. - Backups must be protected and recoverable even if the original Cloud SQL instance's project is accidentally deleted. Which Cloud SQL backup option should the company choose to meet these requirements?

Enhanced backups: ### What Enhanced backups are **Enhanced backups** is a Cloud SQL backup option that leverages the **Backup and DR Service** to provide advanced data protection capabilities. It introduces a centralized approach to managing backups, storing them in a dedicated **backup vault** within a separate management project. This separation ensures that backups are immutable, indelible, and independent of the source Cloud SQL instance's project. ### How it meets the requirements Enhanced backups directly address all the requirements outlined in the scenario: - **Centralized management (✓):** Enhanced backups are managed through a centralized backup management project. This allows the company to define **backup plans** and a **backup vault** that can be associated with multiple Cloud SQL instances across various Google Cloud projects, providing a single pane of glass for backup operations. - **Long-term retention (✓):** The backup vault, which stores enhanced backups, supports retention periods of up to **99 years**. This far exceeds the 'several years' requirement for compliance, making it ideal for long-term data archival needs. - **Granular scheduling (✓):** Enhanced backups offer highly flexible and granular scheduling options for automated backups, including **hourly, daily, weekly, monthly, and yearly** cadences. This allows the company to tailor backup frequency precisely to their operational and recovery point objective (RPO) needs. - **Point-in-time recovery (✓):** Like Standard backups, Enhanced backups fully support **point-in-time recovery (PITR)** using transaction logs, enabling restoration of the database to any specific moment in time, crucial for recovering from data corruption or accidental changes. - **Protection on project deletion (✓):** Since enhanced backups are stored in a **backup vault** managed by the Backup and DR Service in a *separate* Google Cloud project, they are inherently protected even if the original Cloud SQL instance's project is accidentally deleted. The backups remain accessible and recoverable from the centralized backup project. ### Key advantages/capabilities - **Centralized Management:** Unified management, monitoring, and reporting of backup operations across multiple projects. - **Immutable and Indelible Backups:** Backups are stored in a secured, isolated backup vault, making them resistant to accidental or malicious alteration. - **Enforced Retention with Retention Lock:** Provides strong controls over how long backups are kept, critical for compliance. - **Extended Retention:** Supports backup retention for up to 99 years. - **Granular Scheduling:** Offers flexible automated backup schedules (hourly, daily, weekly, monthly, yearly). - **Protection Against Project Deletion:** Backups are independent of the source project, ensuring recoverability even if the source project is deleted. ### Why this is optimal Enhanced backups are the optimal choice because they are purpose-built for enterprise-grade data protection, offering features like centralized management, long-term retention, and robust protection against project-level failures that Standard backups lack. While Standard backups are suitable for simpler use cases, the specific requirements for multi-project management, extended compliance retention, and enhanced disaster recovery scenarios make Enhanced backups the superior solution.