Exam 70-765 topic 3 question 124 discussion

Actual exam question from Microsoft's 70-765

Question #: 124
Topic #: 3

You are the administrator for a SQL Server 2016 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.

A. Set up SQL Server Always On with a SQL Azure database as a replica.
B. Set up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine.
C. Put the differential backup on tape and send it to the third-party backup storage system.
D. Use the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups to a different geographical location.

Show Suggested Answer

Suggested Answer: D 🗳️
Expalantion:
Microsoft SQL Server Backup to Microsoft Azure Tool enables backup to Azure Blob Storage and encrypts and compresses SQL Server backups stored locally or in the cloud.
References: https://www.microsoft.com/en-us/download/details.aspx?id=40740

by manman at July 19, 2019, 10:34 a.m.

Comments

Submit Cancel

manman

Highly Voted 5 years, 10 months ago

D may not be the best answer because the question request the smallest amount of downtime . Restore the database will take a long time. B. Set up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine should be the right answer because it can take tasks if the primary server down. Answer A is incorrect because we must have a Azure SQL server to replicate databases. Answer C is incorrect because the question requests not to use physical location.

upvoted 7 times

...

MSG

Most Recent 5 years ago

I think C is the best option, as the question says solution should be "without leasing or purchasing additional physical locations". The full backups are already being sent to the existing location, by sending differentials too will reduce the time to recover if the data center goes down

upvoted 3 times

Cococo

4 years, 7 months ago

They are already doing this... and want to get rid of it

upvoted 1 times

...