DP-300 · Question #337
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADatum has a Microsoft…
The correct answer is D. an Azure Blob Storage container. Explanation When using Extended Events in Azure SQL Database, the event_file target must write to Azure Blob Storage, as this is the only supported external storage destination for event files in the Azure SQL Database environment - replacing the local disk file share…
Question
Options
- Aa SQL Server filegroup
- Ban Azure SQL database
- Can Azure Files share
- Dan Azure Blob Storage container
How the community answered
(26 responses)- A4% (1)
- B15% (4)
- C8% (2)
- D73% (19)
Explanation
Explanation
When using Extended Events in Azure SQL Database, the event_file target must write to Azure Blob Storage, as this is the only supported external storage destination for event files in the Azure SQL Database environment - replacing the local disk file share previously used on SVR3. This aligns with the management requirement to continue using Extended Events after migration to Azure SQL Database.
Why the distractors are wrong:
- A (SQL Server filegroup): Filegroups are internal database storage structures used for data files, not valid targets for Extended Events session output.
- B (Azure SQL database): While Azure SQL Database is the migration destination, it is not a valid
event_filetarget; thering_buffertarget can write within the database, butevent_filerequires an external storage location. - C (Azure Files share): Although Azure Files provides SMB-based file sharing, Azure SQL Database's Extended Events
event_filetarget only supports Azure Blob Storage - not Azure Files shares - as the external write destination.
Memory Tip
Think "Blob for the job" - in Azure SQL Database, Extended Events need to write outside the database to persistent storage, and the only supported external target is Azure Blob Storage (using a SAS URL). If you remember that Azure SQL Database is serverless/managed with no local disk access, Blob Storage is the logical answer.
Topics
Community Discussion
No community discussion yet for this question.