How many hours are needed to restore the database from the last backup?

How many hours are needed to restore the database from the last backup?

• A. 2 hours
• B. 6 hours
• C. 4 hours
• D. 8 hours

Answer: (C)

Restoring from the last backup involves two steps: restoring the backup itself and replaying transaction logs to bring the database to the desired point in time. The total time depends on the backup size, disk and network performance, and how much log data must be applied. In this scenario, those steps add up to four hours, making that duration the correct estimate for the complete restore. A shorter timeframe wouldn’t cover both restoring the backup and replaying the necessary logs, while longer estimates would imply additional data or steps not described in the scenario.

Restoring from the last backup involves two steps: restoring the backup itself and replaying transaction logs to bring the database to the desired point in time. The total time depends on the backup size, disk and network performance, and how much log data must be applied. In this scenario, those steps add up to four hours, making that duration the correct estimate for the complete restore. A shorter timeframe wouldn’t cover both restoring the backup and replaying the necessary logs, while longer estimates would imply additional data or steps not described in the scenario.