ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam
Go to Exam

Exam DP-600 topic 1 question 46 discussion

Actual exam question from Microsoft's DP-600
Question #: 46
Topic #: 1
[All DP-600 Questions]

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 Hide Answer
Suggested Answer: A 🗳️
by Momoanwar at Feb. 18, 2024, 1:32 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Sanji931
Highly Voted 1 year, 2 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, 2 months ago
Yeah they finally got rid of the PDW bit.
upvoted 2 times
a_51
1 year, 1 month 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 4 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
5 months, 2 weeks ago
Selected Answer: A
sys.dm_exec_requests
upvoted 1 times
...
Pegooli
9 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
6 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
11 months, 3 weeks 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
11 months, 3 weeks 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
12 months 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 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 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, 1 month ago
Selected Answer: A
A would be correct
upvoted 2 times
...
XiltroX
1 year, 2 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago