MicrosoftMicrosoft
70-465 · Question #38
70-465 Question #38: Real Exam Question with Answer & Explanation
Sign in or unlock 70-465 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
Submitted by yuki_2020· Mar 5, 2026Design and implement database solutions for SQL Server
Question
You manage a SQL Server 2014 instance that contains a database named DB1. Users report that some queries to DB1 take longer than expected. Although most queries run in less than one second, some queries take up to 20 seconds to run. You need to view all of the performance statistics for each database file. Which method should you use?
Options
- AQuery the sys.dm_os_tasks dynamic management view.
- BQuery the sys.dm_os_performance_counters dynamic management view.
- CQuery the sys.dm_io_virtual_file_stats dynamic management function.
- DExamine the Data File I/O pane in Activity Monitor.
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 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.
Topics
#performance monitoring#DMVs#I/O performance#database files