Administering Microsoft SQL Server 2012/2014 Databases — Question 13

You administer a Microsoft SQL Server 2012 instance.
The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week.
You plan to define a backup strategy for the database. You need to ensure that the following requirements are met:
✑ No more than 5 minutes worth of transactions are lost.
✑ Data can be recovered by using the minimum amount of administrative effort.
What should you do? Choose three.

Answer options

• A. Configure the database to use the SIMPLE recovery model.
• B. Create a DIFFERENTIAL database backup every 4 hours.
• C. Create a LOG backup every 5 minutes.
• D. Configure the database to use the FULL recovery model.
• E. Create a FULL database backup every 24 hours.
• F. Create a DIFFERENTIAL database backup every 24 hours.

Correct answer: C, D, E

Explanation

The correct answer includes creating a LOG backup every 5 minutes (C), which ensures that no more than 5 minutes of transactions are lost, and configuring the database to use the FULL recovery model (D), which allows point-in-time recovery. Additionally, creating a FULL database backup every 24 hours (E) provides a comprehensive backup that is essential for recovery. The other options either do not meet the transaction loss requirement or do not facilitate efficient recovery.