Microsoft
70-473 · Question #8
70-473 Question #8: Real Exam Question with Answer & Explanation
Sign in or unlock 70-473 to reveal the answer and full explanation for question #8. The question stem and answer options stay visible for context.
Question
You have Microsoft SQL Server installed on a Microsoft Azure virtual machine. The virtual machine is on the Standard D3 service tier. All of the data files for the databases on the virtual machine are located on a single volume that is mounted as drive E. The virtual machine experiences performance issues. You view the wait statistics and discover a high number of GEIOLATCH_SH waits associated to the tempdb data files. You need to resolve the performance issues. What should you do?
Options
- AMove the tempdb data files to drive D.
- BMove the tempdb data files to drive
- CChange the service tier of the virtual machine to Standard D12.
- DChange the service tier of the virtual machine to Standard DS3.
Unlock 70-473 to see the answer
You've previewed enough free 70-473 questions. Unlock 70-473 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.