You administer a Microsoft SQL Server 2016 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 all that apply.
正解:B,C,D,E
Explanation/Reference:
If there are only three options, the CDE (exclude differential backup), is the best answer.