DP-700 Warehouse1 Practice Questions

You have a Fabric workspace that contains a warehouse named Warehouse1. While monitoring Warehouse1, you discover that query performance has degraded during the last 60 minutes. You need to isolate all the queries that were run during the last 60 minutes. The results must include the username of the users that submitted the queries and the query statements. What should you use?

• AA. the Microsoft Fabric Capacity Metrics app
• BB. views from the queryinsights schema
• CC. Query activity
• DD. the sys.dm_exec_requests dynamic management view

You have a Fabric workspace that contains a warehouse named Warehouse1. Data is loaded daily into Warehouse1 by using data pipelines and stored procedures. You discover that the daily data load takes longer than expected. You need to monitor Warehouse1 to identify the names of users that are actively running queries. Which view should you use?

• AA. sys.dm_exec_connections
• BB. sys.dm_exec_requests
• CC. queryinsights.long_running_queries
• DD. queryinsights.frequently_run_queries
• EE. sys.dm_exec_sessions