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

Questions 6–10

1. 6application · medium

   A company runs a Cloud Bigtable instance for time-series data. The operations team needs to export a subset of the data to Cloud Storage for archival purposes. The export must not impact the production workload. What should they use?

   • AUse the Cloud Bigtable Dataflow connector to export the data to Avro files in Cloud Storage.
   • BUse the Bigtable CLI to run a scan and write the results to a local file, then upload to Cloud Storage.
   • CCreate a backup of the Bigtable table and then export the backup.
   • DUse the gcloud bigtable instances tables export command.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A company runs a Cloud SQL for SQL Server instance for a critical application. The database has automated backups every 6 hours and PITR enabled. The application team is about to deploy a schema migration that is known to be risky. They want to be able to undo the migration quickly if something goes wrong. What should you do before the migration?

   • ACreate a manual backup immediately before the migration.
   • BIncrease the automated backup frequency to every hour temporarily.
   • CRely on the next automated backup, which will occur within 6 hours.
   • DDisable PITR to prevent transaction logs from growing during the migration.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   A database administrator needs to configure automatic backups for a Cloud SQL for PostgreSQL instance. The requirement is to have backups taken daily and retained for 30 days. Which Cloud SQL setting should be configured to meet this requirement?

   • AEnable automatic backups and set the backup retention to 30 days.
   • BSet the automatic backup start time and the number of backups to retain to 30.
   • CEnable point-in-time recovery and set the transaction log retention to 30 days.
   • DCreate a scheduled Cloud Scheduler job that triggers an on-demand backup daily and deletes backups older than 30 days.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A company runs a Cloud SQL for MySQL instance for a customer-facing application. The database has a daily automated backup at 02:00 UTC and PITR enabled with a 7-day log retention. The compliance team now requires that backups be retained for 30 days, but the finance team wants to minimize storage costs. What should you do?

   • ASet both automated backup retention and PITR log retention to 30 days.
   • BKeep automated backup retention at 7 days and increase PITR log retention to 30 days.
   • CDisable PITR and increase automated backup retention to 30 days.
   • DIncrease the automated backup retention to 30 days and keep PITR at 7 days.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   A team needs to validate that their backup and recovery procedures meet the RTO and RPO requirements. What should they do?

   • ACheck the backup retention period to ensure it covers the RPO.
   • BVerify that backups are stored in a different region.
   • CReview the backup schedule and ensure backups are taken frequently enough.
   • DPerform a restore test and measure the time taken to restore and the data loss.
   Reveal Solution Discussion Select an answer first