Answer: Exec Requests

The correct diagnostic setting for capturing the start and end times of each completed query in an Azure Synapse Analytics dedicated SQL pool is **Exec Requests**. ## Why Exec Requests is the Optimal Choice **Exec Requests** provides comprehensive information about SQL requests or queries in a dedicated SQL pool, including: - **Request ID**: Unique identifier for each query - **Status**: Current state of the query (Running, Finished, Aborted, Queued) - **Start Time**: Timestamp when the query began execution - **End Time**: Timestamp when the query completed execution - **Total Elapsed Time**: Duration of query execution in milliseconds This setting directly captures the exact start and end times for completed queries, which aligns perfectly with the monitoring requirement. ## Comparison with Other Options **Sql Requests (Option A)**: While this setting captures query information, it focuses more on query distributions and the steps of SQL requests rather than providing the comprehensive execution timeline that Exec Requests offers. **Request Steps (Option B)**: This setting provides granular details about individual steps within a query execution but does not capture the overall start and end times of complete queries. **Dms Workers (Option C)**: This setting monitors Data Movement Service workers and is unrelated to query execution timing capture. ## Best Practice Consideration For monitoring query performance and capturing execution timelines in Azure Synapse Analytics dedicated SQL pools, Exec Requests is the recommended diagnostic setting as it provides the most comprehensive view of query lifecycle including precise start and end timestamps for completed queries.

Author: LeetQuiz Editorial Team