What should you include in the recommendation?

You need to recommend a disaster recovery solution for the Dev database.

What should you include in the recommendation?
A . The simple recovery model and full backups
B . The bulk-logged recovery model and full backups
C . The full recovery model, full backups, and differential backups
D . The full recovery model, full backups, and transaction log backups

View Answer

Answer: A

Explanation:

* Scenario: You must be able to recover data from the Dev database if data is lost accidentally. You have a Recovery Point Objective (RPO) of one day.

* The simple recovery model provides the simplest form of backup and restore. This recovery model supports both database backups and file backups, but does not support log backups. Transaction log data is backed up only with the associated user data. The absence of log backups simplifies managing backup and restore. . However, a database can be restored only to the end of the most recent backup.

Incorrect:

Not B: The bulk-logged recovery model is a special-purpose recovery model that should be used only intermittently to improve the performance of certain large-scale bulk operations, such as bulk imports of large amounts of data.