You are experiencing performance issues with the database server. You need to evaluate schema locking issues, plan cache memory pressure points, and backup I/O problems. What should you create?
A.
a System Monitor report
B.
a sys.dm_tran_database_transaction dynamic management view query
C.
an Extended Events session that uses Query Editor
D.
an Activity Monitor session in Microsoft SQL Management Studio.
In this case, sys.dm_tran_locks, instead of sys.dm_tran_database_transaction , may works for viewing all current locks, the lock resources, lock modes and so on..
this #76 has a different option for C - create an Extended Events session that uses Query Editor - although this can be done (writing and changing code from scratch), better option would be - create an Extended Events session using New session wizard. The answer can be C or D, but D (activity Monitor session) is high level overview of what is happening.
sys.dm_exec_session_wait_stats
This DMV is new in SQL Server 2016 and is identical in structure to
sys.dm_os_wait_stats, but has an additional column for session ID.
but it's not a choice here.
i guess D
Activity Monitor displays information about SQL Server processes and how these processes affect the current instance of SQL Server.
Activity Monitor is a tabbed document window with the following expandable and collapsible panes: Overview, Processes, Resource Waits, Data File I/O, Recent Expensive Queries, and Active Expensive Queries
There is no difference between Questions 36 and 76. The correct answer should be to create a sys.dm_exec_session_wait_stats dynamicmanagement view query (Correct)
This section is not available anymore. Please use the main Exam Page.70-762 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.
Kinggun9
Highly Voted 5 years, 4 months agoals2kool
5 years, 4 months agoJohnFan
5 years, 4 months agokiri2020
4 years, 8 months agoMML
Highly Voted 5 years agoMarcusJB
4 years, 9 months agostm22
Most Recent 5 years agostm22
5 years agoExaminers
5 years, 2 months agoAnette
5 years agolukadataowner
5 years, 3 months agoAnette
5 years agoAnette
5 years agoJohnFan
5 years, 4 months ago