DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ52

VerifiedMonitor and optimize an analytics solution

You have a Fabric workspace that includes a warehouse named Warehouse1.

While monitoring Warehouse1, you determine that query performance has deteriorated over the last 60 minutes.

You need to isolate every query that ran during the last 60 minutes. The results must include the usernames of the users who submitted the queries and the query statements.

What should you use?

Explanation

Query activity provides a query-run history that can be filtered by submit time. It exposes the query text and the submitter—the user or system that sent the query—so it can identify the queries submitted during a selected one-hour period. The monitoring experience retains historical query information, whereas a request DMV is limited to currently running requests.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!