Microsoft
70-450 · Question #64
70-450 Question #64: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #64. The question stem and answer options stay visible for context.
Question
You are a professional level SQL Sever 2008 Database Administrator. Log shipping should be implemented for several databases on three SQL Server instances. The logs are migrated to a fourth SQL Server instance. A manual failover will be implemented. You need to ensure that the database applications utilize the secondary server after failover. Since you are the technical support, you are required to confirm that the latest data should be available to users. Which actions should you perform to achieve the goal? (Choose more than one)
Options
- ATo achieve the goal, you should utilize the WITH RECOVERY option on the last log to apply
- BTo achieve the goal, you should redirect client computers to the secondary instance.
- CTo achieve the goal, you should replicate all log shipping network shares to the secondary
- DTo achieve the goal, you should utilize the WITH NORECOVERY option to back up the tail
- ETo achieve the goal, you should back up all databases on the secondary instance.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.