Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 46 discussion

Actual exam question from Microsoft's DP-600

Question #: 46
Topic #: 1

You have a Fabric tenant that contains a warehouse.
A user discovers that a report that usually takes two minutes to render has been running for 45 minutes and has still not rendered.
You need to identify what is preventing the report query from completing.
Which dynamic management view (DMV) should you use?

A. sys.dm_exec_requests
B. sys.dm_exec_sessions
C. sys.dm_exec_connections
D. sys.dm_pdw_exec_requests

Show Suggested Answer

Suggested Answer: A 🗳️

by Momoanwar at Feb. 18, 2024, 1:32 a.m.

Comments

Submit Cancel

Sanji931

Highly Voted 1 year, 4 months ago

Selected Answer: A

Answer is A. https://learn.microsoft.com/en-us/fabric/data-warehouse/monitor-using-dmv

upvoted 14 times

thuss

1 year, 4 months ago

Yeah they finally got rid of the PDW bit.

upvoted 2 times

a_51

1 year, 3 months ago

If you look at docs it is still out there for a parallel datawarehouse, but considering this is an exam about fabric, then the link mentioned for fabric monitor would make the answer A I agree.

upvoted 1 times

...

MultiCloudIronMan

Most Recent 6 months, 3 weeks ago

Selected Answer: D

Given that Fabric uses a Massively Parallel Processing (MPP) architecture similar to Azure Synapse Analytics, sys.dm_pdw_exec_requests (Option D) could indeed be relevant for monitoring requests in this environment.

upvoted 1 times

...

Rakesh16

7 months, 2 weeks ago

Selected Answer: A

sys.dm_exec_requests

upvoted 1 times

...

Pegooli

11 months, 1 week ago

Selected Answer: D

sys.dm_pdw_exec_requests: This DMV provides information about the status of requests (queries) executed in SQL Data Warehouse (now known as Azure Synapse Analytics) environments. It includes details about query execution, such as start time, end time, status, and any error messages. This DMV is particularly useful for diagnosing long-running or stuck queries.

upvoted 2 times

Pegooli

8 months ago

correcting my above comments is about Synapse Analytics. The Fabric data warehouse is using sys.dm_exec_requests command similar to Azure SQL DB

upvoted 1 times

...

rlo123

1 year, 1 month ago

D. A or D are really close, but since it is Azure Synapse Analytics D is probably the best answer. Why sys.dm_pdw_exec_requests is better for this Fabric scenario: Fabric's MPP architecture: Fabric warehouses utilize a distributed architecture where queries are broken down and processed across multiple compute nodes. This is why sys.dm_pdw_exec_requests is the ideal tool. MPP-specific insights: This DMV gives you visibility into how the query is being executed across the nodes, which can reveal bottlenecks or performance issues that wouldn't be apparent in sys.dm_exec_requests. Targeted troubleshooting: With the MPP-specific data from sys.dm_pdw_exec_requests, you can pinpoint the exact steps or nodes causing the slow performance, leading to a more efficient resolution.

upvoted 3 times

rlo123

1 year, 1 month ago

sys.dm_exec_requests is the correct answer after a lot more review and searching, can't delete my original comment, but here is why....In the context of Microsoft Fabric, sys.dm_exec_requests would be the appropriate DMV to use for monitoring running queries, as it is specifically designed for the SQL engine within Fabric. sys.dm_pdw_exec_requests is a DMV designed for Azure Synapse Analytics dedicated SQL pools (formerly SQL Data Warehouse). While Fabric's warehouse engine is based on SQL Server technology, it's not directly compatible with the DMVs specific to Azure Synapse Analytics.

upvoted 3 times

...

stilferx

1 year, 1 month ago

Selected Answer: A

IMHO, "A", it may be found here: https://learn.microsoft.com/en-us/fabric/data-warehouse/monitor-using-dmv#identify-and-kill-a-long-running-query

upvoted 1 times

...

Estratech

1 year, 2 months ago

Selected Answer: A

You can use the sys.dm_exec_requests dynamic management view (DMV) to identify what is preventing the report query from completing 1.

upvoted 1 times

...

dvenkatesh

1 year, 2 months ago

Answer would be D, I guess... Here the key word might be warehouse... The sys.dm_exec_requests dynamic management view is used in SQL Server to provide information about each request that is executing within SQL Server. On the other hand, the sys.dm_pdw_exec_requests dynamic management view is used in Azure SQL Data Warehouse to provide similar information about each request executing within the data warehouse environment. Both views offer insights into the current status and details of queries running in their respective environments.

upvoted 3 times

...

azure_bimonster

1 year, 3 months ago

Selected Answer: A

A would be correct

upvoted 2 times

...

XiltroX

1 year, 4 months ago

Selected Answer: C

Answer is C https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-connections-transact-sql?view=sql-server-ver16

upvoted 1 times

...