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

Questions 1–5

1. 1application · medium

   A company runs a Cloud SQL for PostgreSQL instance for a financial application. The compliance team requires that the database can be restored to any point within the last 24 hours, with a recovery time objective (RTO) of 2 hours. The operations team wants to minimize the number of manual steps during a recovery. What should you configure?

   • ACreate a manual backup every hour and keep 24 backups, restoring the most recent one during an incident.
   • BConfigure cross-region replication and rely on the replica for recovery.
   • CEnable point-in-time recovery (PITR) with a transaction log retention of 24 hours, and rely on automated backups for the base restore.
   • DEnable automated backups with a 24-hour retention and disable PITR to reduce storage costs.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   A team needs to import data into a Cloud Spanner database from a set of CSV files stored in Cloud Storage. Which tool should be used for this task?

   • AUse the gcloud spanner databases import command.
   • BUse the gcloud spanner databases restore command to restore from a backup.
   • CUse Dataflow with a template to read from Cloud Storage and write to Cloud Spanner.
   • DUse the Cloud Console to upload the CSV files directly to the database.
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   A company runs a Cloud SQL for PostgreSQL database for an e-commerce platform. The database has PITR enabled with a 7-day retention. An application bug caused incorrect updates to a table over the past 3 hours. The team needs to restore the database to a point before the bug started, but they also need to preserve all transactions that occurred after that point. What should you do?

   • ADisable PITR and rely on the latest automated backup to restore the table.
   • BRestore the database to a new instance at the desired point-in-time, then export the affected table and import it into the production instance.
   • CUse PITR to restore the transaction logs only, without restoring the base backup.
   • DRestore the entire production instance to the desired point-in-time, losing all transactions after that point.
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A company has a Cloud SQL for PostgreSQL database with PITR enabled and a 7-day retention. The team has never tested a restore. The compliance team now requires that the database be restorable to any point in the last 24 hours with an RTO of 30 minutes. What should you do first?

   • ADisable PITR to simplify the restore process and reduce complexity.
   • BCreate a manual backup before every change to ensure a recent recovery point.
   • CIncrease the PITR retention to 30 days to ensure more recovery points are available.
   • DPerform a test restore to a new instance and verify the data and application connectivity.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   A team needs to restore a Cloud Spanner database to a specific timestamp to recover from an accidental data deletion. Which feature should be used?

   • ARestore from the latest automatic backup.
   • BPoint-in-time recovery (PITR) with a retention period that covers the deletion time.
   • CUse the export and import feature to load data from a previous export.
   • DUse the Cloud Console to undo the deletion.
   Reveal Solution Discussion Select an answer first