Câu 40: 70-462: MCSA Administering Microsoft SQL Server 20122014 Databases

You administer a Microsoft SQL Server 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. The database is configured to use the FULL recovery model. 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? Each correct answer presents part of the solution.

1. A. Create a LOG backup every 5 minutes. — đáp án hiện tại
2. B. Configure the database to use the SIMPLE recovery model.
3. C. Create a DIFFERENTIAL database backup every 4 hours.
4. D. Create a DIFFERENTIAL database backup every 24 hours.
5. E. Create a FULL database backup every 24 hours. — đáp án hiện tại