Microsoft
70-458 · Question #71
70-458 Question #71: Real Exam Question with Answer & Explanation
Sign in or unlock 70-458 to reveal the answer and full explanation for question #71. The question stem and answer options stay visible for context.
Question
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 all that apply.
Options
- AConfigure the database to use the SIMPLE recovery model.
- BCreate a DIFFERENTIAL database backup every 4 hours.
- CCreate a LOG backup every 5 minutes.
- DConfigure the database to use the FULL recovery model.
- ECreate a FULL database backup every 24 hours.
- FCreate a DIFFERENTIAL database backup every 24 hours.
Unlock 70-458 to see the answer
You've previewed enough free 70-458 questions. Unlock 70-458 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.