Options: is_user_process dm_exec_query_stats wait_type dm_exec_requests wait_time query_store_query Solution: Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs" >

Test Index

Administering Relational Databases on Microsoft Azure (DP-300) Test 2

Question : 30

Total: 40

HOTSPOT
You have an Azure subscription that contains an Azure SQL database.
The database fails to respond to queries in a timely manner.
You need to identify whether the issue relates to resource_semaphore waits.
How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Hot Area:

is_user_process
dm_exec_query_stats
wait_type
dm_exec_requests
wait_time
query_store_query

Validate

Go to Question:

Prev Question

Next Question

More Free Exams:

Amazon AWS Certification Exams
Microsoft Azure AI Certification Exams
Microsoft Azure Certification Exams
TOGAF 9 Practice tests