Exam 70-462 topic 2 question 2 discussion

Actual exam question from Microsoft's 70-462

Question #: 2
Topic #: 2

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.

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.

Show Suggested Answer

Suggested Answer: CDE 🗳️

by mr_corte at Nov. 25, 2019, 8:03 a.m.

Comments

Submit Cancel

Selam

Highly Voted 5 years, 3 months ago

its asking for 3, if its says 4 yeah we can do the differential too

upvoted 5 times

...

mickeygeorge

Most Recent 4 years, 5 months ago

So actually is it E,B,C in that order?

upvoted 1 times

...

mr_corte

5 years, 5 months ago

it miss the B option, we could do a differential too

upvoted 2 times

Fame

4 years, 7 months ago

What should you do? Choose three.