Exam 70-762 topic 1 question 142 discussion

Actual exam question from Microsoft's 70-762

Question #: 142
Topic #: 1

DRAG DROP -
You must troubleshoot performance issues that users report. You identify the following representative user sessions:

You need to configure the appropriate Extended Events.
Which target should you use for each session? To answer, drag the appropriate Extended Event targets to the correct sessions. Each Extended Event target may be used once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

Show Suggested Answer

Suggested Answer:

Session 1: Event Files -
Event files use to write event session output from complete memory buffers to disk. This is an asynchronous target.

Session 2: Histogram -
Histogram use to count the number of times that a specified event occurs, based on a specified event column or action. This is an asynchronous target.
Incorrect Answers:
ETW:
The Extended Events infrastructure supports the correlation of data from SQL Server, and under certain conditions, the correlation of data from the operating system and database applications. In the latter case, Extended Events output must be directed to Event Tracing for Windows (ETW) to correlate the event data with operating system or application event data.
Event Counter:
An event counter counts all specified events that occur during an Extended Events session. Use to obtain information about workload characteristics without adding the overhead of full event collection. This is a synchronous target.
References:
https://docs.microsoft.com/en-us/sql/database-engine/sql-server-extended-events-targets?

by Brandontay09 at Feb. 13, 2020, 2:48 p.m.

Comments

Submit Cancel

melvin9900

Highly Voted 4 years, 12 months ago

Answer is correct . Asynchronous • Event file - Writes event session output from complete memory buffers to disk. • Event pairing - Used to determine when a specified paired event does not occur in a matched set. An example of an event pair would be lock acquired/lock released. • Histogram - Used to count the number of times that a specified event occurs based on a specific event column or action. • Ring buffer - Used to hold the event data in memory on a first-in first-out (FIFO) basis. Synchronous • Event Tracing for Windows (ETW) - Used to correlate SQL Server events with Windows operating system or application event data. • Event counter - Counts the number of occurrences of each event in the session. Avoids the extra overhead of capturing the full event details.

upvoted 5 times

...

MML

Most Recent 5 years ago

Answer is correct

upvoted 4 times

...

Brandontay09

5 years, 5 months ago

Session 2 would be Event Counter

upvoted 2 times

Bartek

5 years, 5 months ago

No, answer is correct "event_counter This target counts the number of times that a specific event occurred." "histogram Like the event_counter target, the histogram target counts the occurrences of an event, but can count occurrences for multiple items separately and for both event fields or actions." Histogram works asynch type, and event_counter works sync type. REF: Exam Ref 70-762 Developing SQL Databases Louis Davidson Stacia Varga

upvoted 13 times

JohnFan

5 years, 4 months ago

histogram Like the event_counter target, the histogram target counts the occurrences of an event, but can count occurrences for multiple items separately and for both event fields or actions. You can use the DBCC SHOW_STATISTICS command to check the histogram and index densities for an index.

upvoted 2 times