Exam DP-700 topic 3 question 12 discussion

Actual exam question from Microsoft's DP-700

Question #: 12
Topic #: 3

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?

A. the Microsoft Fabric Capacity Metrics app
B. views from the queryinsights schema
C. Query activity
D. the sys.dm_exec_requests dynamic management view

Show Suggested Answer

Suggested Answer: B 🗳️

by zxc01 at April 10, 2025, 4:49 a.m.

Comments

Submit Cancel

PBridge

Highly Voted 1 month, 1 week ago

Selected Answer: B

B. views from the queryinsights schema Option Why it’s not correct A. Microsoft Fabric Capacity Metrics app High-level view of capacity usage, not query-level detail. C. Query activity Surface-level monitoring, doesn't include query text or usernames. D. sys.dm_exec_requests Only shows currently executing queries, not queries from the last 60 minutes.

upvoted 5 times

...

smanzana

Most Recent 2 weeks, 3 days ago

Selected Answer: B

B is correct

upvoted 1 times

...

DarioReymago

3 weeks, 6 days ago

Selected Answer: B

queryinsights.exec_requests_history

upvoted 2 times

...

Biju1

2 months, 3 weeks ago

Selected Answer: B

B is the answer SELECT * FROM queryinsights.exec_requests_history WHERE start_time >= DATEADD(MINUTE, -30, GETUTCDATE()) AND login_name = USER_NAME();

upvoted 2 times

...

Biju1

2 months, 3 weeks ago

Selected Answer: C

SELECT * FROM queryinsights.exec_requests_history WHERE start_time >= DATEADD(MINUTE, -30, GETUTCDATE()) AND login_name = USER_NAME();

upvoted 1 times

...

zxc01

2 months, 3 weeks ago

Selected Answer: B

I think both [queryinsights].[exec_requests_history] and Query activity can match "username of the users that submitted the queries and the query statements". However, query activity just can set filter on "last 24 hours", "last 7 days" and "last 30 days", the question need filter it with last 60 minutes. [queryinsights].[exec_requests_history] is easy to set filter with where condition on submit time column.

upvoted 2 times

...