Microsoft
70-459 · Question #125
70-459 Question #125: Real Exam Question with Answer & Explanation
Sign in or unlock 70-459 to reveal the answer and full explanation for question #125. The question stem and answer options stay visible for context.
Question
You are the administrator for a SQL Server 2014 instance that stores the data for an online transaction processing sales system. The company takes full backups every week; differential backups on the days with no full backups; and hourly transaction backups. These backups are stored on a backup server in the company's data center. Every week, the company places the full backup on a tape and sends it to a third-party backup storage system. The company is worried that a disaster might occur that could destroy their computer center and cause them to lose orders. You need to determine the best method for providing the smallest amount of data loss and downtime without leasing or purchasing additional physical locations. What should you do? More than one answer choice may achieve the goal. Select the BEST answer.
Options
- ASet up SQL Server Always On with a SQL Azure database as a replica.
- BSet up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine.
- CPut the differential backup on tape and send it to the third-party backup storage system.
- DUse the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups to a
Unlock 70-459 to see the answer
You've previewed enough free 70-459 questions. Unlock 70-459 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.