You have SQL Server on an Azure virtual machine. You need to add a 4-TB volume that meets the following requirements: ✑ Maximizes IOPs ✑ Uses premium solid state drives (SSDs) What should you do?
A.
Attach two mirrored 4-TB SSDs.
B.
Attach a stripe set that contains four 1-TB SSDs.
C.
Attach a RAID-5 array that contains five 1-TB SSDs.
Suggested Answer:B🗳️
For more throughput, you can add additional data disks and use disk striping. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storage-configuration?tabs=windows2016
Out of all options, this should provide the best performance:
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
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.
Ciupaz
Highly Voted 6 months, 4 weeks agoCaptainJameson
Most Recent 1 year, 4 months agoCaptainJameson
1 year, 4 months agoo2091
1 year, 5 months ago