You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains two SQL Server 2005 computers named Certkiller -DB01 and Certkiller -DB02
You have been informed by the CIO that the transaction log shipping occurs from Certkiller -DB01 to Certkiller -DB02 by using default SQL Server Agent schedule settings. A Domain.com user named Kara Lang is a junior technician appointed in the Research and Development department. You instruct Kara Lang to reconfigure the transaction log shipping to provide minimum latency on Certkiller -DB02.
What should Kara Lang do?
A.
Kara Lang should reschedule the transaction log backup job on Certkiller -DB01 in order for it to occur every minute.
It is vital that the reschedule the transaction log backup job on Certkiller -DB01 in order for it occur every minute.
Thereafter she should reschedule the log shipping copy as well as the restore jobs on Certkiller -DB01 in order for it to occur every minute.
B.
Kara Lang should maintain default schedule settings for the transaction log backup job on Certkiller -DB01.
It is important that she changes the schedule types for the log shipping copy on Certkiller -DB02.
Then she should restore jobs on Certkiller -DB02 to start automatically when SQL Server Agent commences.
C.
Thereafter she should maintain default schedule settings on Certkiller -DB02 for both the log shipping copy and the restore jobs.
D.
It is important that Kara Lang change the schedule type for the transaction log backup on Certkiller -DB01 to start automatically when SQL Server Agent starts.
Then she should change the schedule types for the log shipping copy on Certkiller -DB02.
Thereafter Kara Lang should change the schedule types on Certkiller -DB02 to restore jobs to start automatically, as soon as the SQL Server Agent commences.
Explanation:
In order to reduce latency on Certkiller -DB02 Kara Lang needs to get a copy from Certkiller -DB01 as soon as possible after every write. One minute is the shortest possible interval for the transaction log backup. As soon as the backup is complete Kara Lang should copy it and restore it on Certkiller -DB02 as soon as possible.