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.
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.
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.
Why wouldn’t it be A? If you want to minimize downtime?
I think the correct answer is B
https://msdn.microsoft.com/en-us/library/azure/dn249504.aspx
What is the difference between A Nd B ?
Both of them will connect the database to a windows azur machine as a backup. !!!!
i think A is SAAS and B is IAAS.
i think D is the correct answer in a current context of a question.
Why “direct all backups to a different geographical location”, if in question says that “providing the smallest amount of data loss and downtime”?! Smallest data loss and downtime can provide Always ON technology.
I think SQL Azure dont’t support Always ON, therefore, correct answer is “B”.
SQL Azure supports AlwaysON, it just does not yet support SQL Server FCI because you CAN NOT set up Azure as a Replica. Quite frankly, options A & B would result in the same outcome. I think option D is the best answer for this scenario.
I meant to say SQL Azure does not yet support AlwaysON FCI HA & DR, because Azure Virtual Machine does not provide support for Shared Storage Mechanism.
But really, the question is not only about BEST solution for ensuring backup of the database. The bigger aim is to achieve minimal data loss and service outage; I think AlwaysON technology is best at providing this. So, maybe option B is the best.
It won’t be D if this part of the question is to be achieved: “…without leasing or purchasing additional physical locations.”
A is correct
D is correct
B
https://azure.microsoft.com/nl-nl/documentation/articles/virtual-machines-windows-classic-sql-onprem-availability/
https://azure.microsoft.com/nl-nl/documentation/articles/virtual-machines-windows-classic-sql-onprem-availability/
This should Be the correct link.
B: gives the least downtime
@suduku you send a link stating answer is B however your link refer to answer A .
i would say the difference between A and B is that A extend your on premise always on infra by adding a replica and that B ask you to create you re AOA infra from scratch on Azure.
i would go for A
Problem with A: A replica should be a server, not a database.
It’s “D” because it’s a new feature and Microsoft loves to ask about new shit. xD