You need to ensure that the following requirements are met: • No more than 5 minutes worth of transactions are lost

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.

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.

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.

Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms187048.aspx
http://msdn.microsoft.com/en-us/library/ms186289.aspx
http://msdn.microsoft.com/en-us/library/ms175477.aspx
http://msdn.microsoft.com/en-us/library/ms189860.aspx
http://msdn.microsoft.com/en-us/library/ms179314.aspx
http://msdn.microsoft.com/en-us/library/ms175526.aspx

http://msdn.microsoft.com/en-us/library/ms191539.aspx
http://msdn.microsoft.com/en-us/library/ms191429.aspx
http://msdn.microsoft.com/en-us/library/ms191253.aspx



Leave a Reply 0

Your email address will not be published. Required fields are marked *