nerdexam
Microsoft

70-459 · Question #125

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 correct answer is D. Use the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups to a. SQL Server 2012 was the first version to provide the ability to back up databases to the Cloud, and SQL Server 2014 improves on the process. Microsoft SQL Server Backup to Windows Azure Tool enables backup to Windows Azure Blob Storage and encrypts and compresses SQL Server…

Design and implement high availability

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

How the community answered

(25 responses)
  • A
    8% (2)
  • B
    4% (1)
  • C
    12% (3)
  • D
    76% (19)

Explanation

SQL Server 2012 was the first version to provide the ability to back up databases to the Cloud, and SQL Server 2014 improves on the process. Microsoft SQL Server Backup to Windows Azure Tool enables backup to Windows Azure Blob Storage and encrypts and compresses SQL Server backups stored locally or in the cloud. Exam Questions, Study Guides, Practice Tests. Lead the way to help you pass any IT Certification exams, 100% Pass Guaranteed or Full Refund. Especially Cisco, CompTIA, Citrix, EMC, HP, Oracle, VMware, Juniper, Check Point, LPI, Nortel, EXIN and so on. Our Slogan: First Test, First Pass. Help you to pass any IT Certification exams at the first try. You can reach us at any of the email addresses listed below. Any problems about IT certification or our products, you could rely upon us, we will give you satisfactory answers in 24 hours.

Topics

#disaster recovery#Azure backup#business continuity#backup strategy

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-459 Practice