2.3 Design Database Backup and Recovery Solutions PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   A database administrator needs to manage transaction log retention for a Cloud SQL instance to balance recovery needs and storage costs. What is the maximum transaction log retention period for Cloud SQL?

   • A365 days
   • B7 days
   • C30 days
   • DUnlimited
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   A team wants to ensure that automatic backups for a Cloud Spanner instance are taken at a consistent point across all nodes. Which feature of Cloud Spanner provides this capability?

   • AEnabling point-in-time recovery with a 7-day retention window.
   • BBackup schedules with a configurable frequency and retention period.
   • CExporting data to Cloud Storage using Dataflow templates.
   • DUsing Cloud Scheduler to trigger a backup API call every day.
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   A company runs a Cloud Spanner instance with a multi-region configuration. They need to ensure that backups are available in a different region than the primary for disaster recovery. What is the recommended approach?

   • ARely on the multi-region configuration to provide automatic backup redundancy.
   • BUse export to Cloud Storage and replicate the bucket to another region using Cloud Storage replication.
   • CConfigure cross-region replication for backups by enabling the 'cross-region backup' option.
   • DTake manual backups and store them in a Cloud Storage bucket in the same region as the instance.
   Reveal Solution Discussion Select an answer first
5. 19expert · hard

   A company runs a Cloud Spanner instance with a regional configuration in us-central1. The application is critical and the business requires an RPO of 15 minutes and an RTO of 2 hours in the event of a regional outage. The team is considering moving to a multi-region configuration. What is the primary benefit of this change?

   • AIt provides automatic failover with near-zero RPO and minimal manual intervention.
   • BIt allows you to take more frequent automated backups.
   • CIt reduces the cost of storage for backups.
   • DIt enables PITR with a longer retention window.
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   A team is designing a backup strategy for a Cloud SQL instance that must be recoverable in a different region. What is the recommended way to achieve this?

   • ACreate a read replica in another region and use it as a backup.
   • BEnable automatic backups and set the backup location to a different region.
   • CUse the Cloud Console to change the backup region for the instance.
   • DExport the database to Cloud Storage and copy the export to a bucket in another region.
   Reveal Solution Discussion Select an answer first