70-465 Free Dumps Study Materials
Question 10: 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
Correct 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.
Reference: Recovery Models (SQL Server)