exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 3 question 12 discussion

Actual exam question from Microsoft's DP-700
Question #: 12
Topic #: 3
[All DP-700 Questions]

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 Hide Answer
Suggested Answer: B 🗳️

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
Biju1
2 weeks, 6 days 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 1 times
...
Biju1
2 weeks, 6 days 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
3 weeks, 2 days 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 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago