What should you do?

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.

Answer: C,D,E

Latest 70-462 Dumps Valid Version with 301 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments