ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam
Go to Exam

Exam 70-764 topic 1 question 249 discussion

Actual exam question from Microsoft's 70-764
Question #: 249
Topic #: 1
[All 70-764 Questions]

You deploy a SQL Server instance named SQLProd that uses SQL Server 2014.
You need to recommend a solution to monitor the transactions that are running currently against SQLProd.
The solution must minimize the amount of custom code required.
What should you recommend?

  • A. Statistics
  • B. A dynamic management view
  • C. A trigger
  • D. User-defined views
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.
Transactions can be monitored.
by TheSwedishGuy at Jan. 31, 2020, 2:15 p.m.

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
Submit Cancel
TheSwedishGuy
5 years, 5 months ago
DMV shows server state health, and you can even use it to check current transactions https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/system-dynamic-management-views?view=sql-server-ver15
upvoted 1 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