exam questions

Exam 70-765 All Questions

View all questions & answers for the 70-765 exam

Exam 70-765 topic 3 question 84 discussion

Actual exam question from Microsoft's 70-765
Question #: 84
Topic #: 3
[All 70-765 Questions]

DRAG DROP -
You have on-premises database server.
The database files for a user database are configured as shown in the following table:

You plan to migrate the on-premises database server to Microsoft SQL Server on a Microsoft Azure virtual machine.
You need to provision storage for the virtual machine to meet the following requirements:
✑ Support the same configurations as the on-premises database server.
✑ Provide a Service Level Agreement (SLA) for performance.
✑ Minimize costs.
Which type of storage should you provision for each file type? To answer, drag the appropriate storage types to the correct file types. Each storage type may be used once, more than once or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Standard Storage has varying latencies and bandwidth and is only recommended for dev/test workloads. Production workloads should use Premium Storage.
References: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance

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
da
4 years, 8 months ago
i agree
upvoted 1 times
...
jolsca
4 years, 9 months ago
There is no service level agreement (SLA) for standard storage, for this reason it must be Premium
upvoted 3 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
Loading ...