Exam DP-300 topic 3 question 49 discussion

Actual exam question from Microsoft's DP-300

Question #: 49
Topic #: 3

HOTSPOT
-

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.

Show Suggested Answer

Suggested Answer:

by vcloudpmp at July 15, 2023, 8:42 p.m.

Comments

Submit Cancel

pjfunner

7 months, 2 weeks ago

Answer given is correct: event_file and ALLOW_MULTIPLE_EVENT_LOSS https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/targets-for-extended-events-in-sql-server?view=sql-server-ver16#event_file-target https://learn.microsoft.com/en-us/sql/t-sql/statements/create-event-session-transact-sql?view=sql-server-ver16

upvoted 3 times

...

igorclapa

1 year, 2 months ago

CREATE EVENT SESSION [YourSession] ON SERVER ADD EVENT sqlserver.sql_statement_completed ( ACTION(sqlserver.sql_text) WHERE ( [sqlserver].[like_i_sql_unicode_string]([sqlserver].[sql_text], N'%SELECT%HAVING%') ) ) ADD TARGET package0.event_file (SET filename = N'C:\Junk\YourSession_Target.xel', max_file_size = (2), max_rollover_files = (2) ) WITH ( MAX_MEMORY = 2048 KB, EVENT_RETENTION_MODE = ALLOW_MULTIPLE_EVENT_LOSS, MAX_DISPATCH_LATENCY = 3 SECONDS, MAX_EVENT_SIZE = 0 KB, MEMORY_PARTITION_MODE = NONE, TRACK_CAUSALITY = OFF, STARTUP_STATE = OFF ); GO https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/quick-start-extended-events-in-sql-server?view=sql-server-ver16

upvoted 2 times

...

vcloudpmp

1 year, 4 months ago

https://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-db-diff-from-svr?view=azuresql-mi Event File target code for extended events in Azure SQL Database Phase 1 is PowerShell to create an Azure Storage container. Phase 2 is Transact-SQL that uses the Azure Storage container.

upvoted 2 times

...