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:
The full recovery model uses log backups to prevent data loss in the broadest range of failure scenarios, and
backing and restoring the transaction log (log backups) is required. The advantage of using log backups is that
they let you restore a database to any point of time that is contained within a log backup (point-in-time
recovery). You can use a series of log backups to roll a database forward to any point in time that is contained
in one of the log backups. Be aware that to minimize your restore time, you can supplement each full backup
with a series of differential backups of the same data.
https://technet.microsoft.com/en-us/library/ms190217(v=sql.105).aspx