Ultimate access to all questions.
In your organization, you are utilizing a Fabric tenant that includes a data warehouse. One of the users has encountered an issue where a specific report, which typically completes rendering within two minutes, has been running for 45 minutes without completing. Your task is to diagnose the underlying cause of this prolonged execution time. To achieve this, you need to determine which dynamic management view (DMV) is most appropriate for identifying the factors that are preventing the report query from finishing in a Fabric data warehouse environment.