70-465 · Question #132
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. 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…
Question
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
How the community answered
(34 responses)- A9% (3)
- B6% (2)
- C18% (6)
- D68% (23)
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.
Topics
Community Discussion
No community discussion yet for this question.