DP-300 Certification Practice Question #150

Question

You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines. The virtual machine hosts a database named DB1.

You need to monitor DB1 by using Extended Events. The solution must meet the following requirements:

•	Capture raw event data and store the data in Azure Storage.
•	Minimize the performance impact of capturing extended events.

How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

Requirement 1 (store in Azure Storage): `package0.event_file` is the only Extended Events target that can write to a file path — including Azure Blob Storage URLs. Requirement 2 (minimize performance impact): `ALLOW_MULTIPLE_EVENT_LOSS` allows events to be dropped during high-load scenarios, preventing the session from blocking the database engine. `NO_EVENT_LOSS` has the highest performance impact; `ALLOW_MULTIPLE_EVENT_LOSS` has the least. Both requirements align with event_file + ALLOW_MULTIPLE_EVENT_LOSS.

More DP-300 practice questions