ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-465 All Questions

View all questions & answers for the 70-465 exam
Go to Exam

Exam 70-465 topic 1 question 54 discussion

Actual exam question from Microsoft's 70-465
Question #: 54
Topic #: 1
[All 70-465 Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
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.
Reference:
Smart, Secure, Cost-Effective: SQL Server Back Up to Windows Azure - SQL Server Team Blog - Site Home - TechNet Blogs
by KiranAChaugule at July 1, 2020, 4:34 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
prprgndr
4 years, 4 months ago
Option C would still incur (up to) 24 hours loss. Requirement: You need to determine the best method for providing the smallest amount of data loss and downtime without leasing or purchasing additional physical locations.
upvoted 1 times
...
KiranAChaugule
4 years, 10 months ago
I think Option C is the correct answer.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago