Backup and Disaster Recovery Strategies CSE Practice Questions (Page 6)

Questions 26–30

1. 26expert · hard

   A company has a primary site in the cloud and a secondary site in a different cloud provider. The company wants to implement failover and failback between the two sites. The application data is replicated asynchronously. Which consideration is most important when planning failback?

   • AFail back immediately after the primary site is restored to minimize downtime
   • BDisable replication during failback to avoid conflicts
   • CEnsure that the secondary site has the latest data before failing back to avoid data loss
   • DUse the same backup vendor for both sites to simplify failback
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   An online payment system processes transactions continuously. The compliance team sets an RPO of 5 minutes. The database team currently takes a full backup every night and transaction log backups every hour. Which adjustment is necessary to meet the RPO?

   • ASwitch to daily differential backups
   • BTake a full backup every 5 minutes
   • CIncrease the frequency of transaction log backups to every 5 minutes
   • DKeep hourly log backups but add a second full backup at noon
   Reveal Solution Discussion Select an answer first
4. 28expert · hard

   A company has a database with an RPO of 1 hour and an RTO of 4 hours. The database is 1 TB. The backup team is considering two strategies: (A) nightly full backups with hourly transaction log backups, or (B) daily differential backups with a weekly full backup. Which strategy should be chosen?

   • AStrategy A, because hourly transaction logs meet the 1-hour RPO and the full backup plus logs can be restored within the 4-hour RTO
   • BNeither strategy, because the RPO cannot be met with backups alone
   • CEither strategy, because both meet the RPO and RTO
   • DStrategy B, because differential backups are faster to restore than transaction logs
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   A company requires an RPO of 15 minutes and an RTO of 1 hour for its database. Which backup strategy best meets these requirements?

   • AWeekly full backups and daily incremental backups.
   • BDaily full backups with weekly testing.
   • CContinuous replication to a standby database with automated failover.
   • DMonthly snapshots stored in archive storage.
   Reveal Solution Discussion Select an answer first
6. 30application · medium

   A financial services company runs a critical database on a cloud VM. The compliance team mandates that in the event of a regional outage, the database can be restored with at most 15 minutes of lost transactions, and the application must be fully operational within 2 hours. The database is 500 GB and changes constantly. Which backup strategy best meets these requirements?

   • AA single full backup taken at the start of each month, replicated to object storage
   • BDaily full backups with a 30-day retention, stored in a different region
   • CTransaction log backups every 10 minutes, with the latest full backup and all logs stored in a secondary region
   • DHourly incremental backups plus a weekly full backup, with the backup vault configured for cross-region restore
   Reveal Solution Discussion Select an answer first