Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
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:
Which Cloud SQL backup option should the company choose to meet these requirements?
Standard backups are the traditional backup option for Cloud SQL instances. They are managed directly by Cloud SQL within the same Google Cloud project as the instance itself. This option provides essential backup capabilities, including automated daily backups and on-demand backups.
Standard backups fall short of several key requirements outlined in the scenario:
The company only needed daily automated backups, retention for up to one year, and did not require centralized management across projects or protection against project deletion. It would also be suitable if cross-region or multi-region backup capabilities were a primary requirement, as Standard backups support these, unlike Enhanced backups.
Cloud SQL read replicas are exact copies of a primary Cloud SQL instance that asynchronously replicate data changes from the primary. Their primary purpose is to offload read traffic from the primary instance, improve read performance, and provide high availability and disaster recovery capabilities by allowing promotion to a standalone instance in case of primary instance failure.
Cloud SQL read replicas are a crucial component of a robust database architecture but do not serve as a backup solution in the way described by the requirements:
The company's primary concern was to improve read performance, distribute read traffic, or have a hot standby for quick failover in case of a primary instance outage, without the need for historical point-in-time recovery from data corruption or long-term archival. Read replicas are excellent for increasing read scalability and improving RTO (Recovery Time Objective) in a DR scenario, but not for RPO (Recovery Point Objective) related to data corruption.
Cloud Storage exports involve creating a dump of your Cloud SQL database (or specific tables/databases) and storing it as a file (e.g., SQL dump, CSV, BAK) in a Cloud Storage bucket. This is a manual or script-driven process, where you manage the lifecycle of the exported files.
While Cloud Storage exports can be part of a data protection strategy, they do not fulfill the requirements for a comprehensive Cloud SQL backup solution:
The company needed to archive specific subsets of data, migrate data between different database versions, or perform custom data transformations before storing the data, and was willing to manage the export and import process manually or with custom automation. It is not suitable for a primary, robust, and automated disaster recovery solution requiring point-in-time recovery.
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.
Enhanced backups directly address all the requirements outlined in the scenario:
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.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated