Microsoft DP-700 Exam - Topic 3 Question 19 Discussion

Actual exam question for Microsoft's DP-700 exam

Question #: 19
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?

Athe Microsoft Fabric Capacity Metrics app

Bviews from the queryinsights schema

CQuery activity

Dthe sys.dm_exec_requests dynamic management view

Show Suggested Answer

Suggested Answer: B

by Tresa at Aug 02, 2025, 02:46 AM

Limited Time Offer

25%

Off

Get Premium DP-700 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jonell

2 months ago

D could work, but it won't give you usernames, just the requests.

upvoted 0 times

...

Miss

3 months ago

Wait, can we really get all that info from B? Sounds too good to be true!

upvoted 0 times

...

Hildred

3 months ago

I think it's definitely B, the queryinsights schema has all the details we need.

upvoted 0 times

...

Lashon

3 months ago

I agree with B too, it’s the best way to get user info and queries.

upvoted 0 times

...

Mitsue

3 months ago

A is useful for metrics, but not for isolating queries like we need.

upvoted 0 times

...

Haydee

3 months ago

I feel like Query activity could be the right choice since it usually tracks user queries, but I need to double-check that.

upvoted 0 times

...

Myra

4 months ago

The Microsoft Fabric Capacity Metrics app sounds familiar, but I don't think it provides detailed query information like usernames.

upvoted 0 times

...

Myra

4 months ago

I remember practicing with the sys.dm_exec_requests view, but I don't recall if it shows the query statements we need.

upvoted 0 times

...

Evette

4 months ago

I think we might need to look at the queryinsights schema for that, but I'm not entirely sure if it includes usernames.

upvoted 0 times

...

Ricki

4 months ago

This seems straightforward enough. I'm going to go with the "views from the queryinsights schema" option. That sounds like it will provide the details I need to isolate the queries from the last 60 minutes.

upvoted 0 times

...

Mozell

4 months ago

I'm a bit confused by the different options here. I'm not familiar with some of these tools and features, so I'll need to do a bit of research to figure out which one is the most appropriate for this scenario.

upvoted 0 times

...

Charisse

5 months ago

Ah, I think I've got it! The "Query activity" option sounds like it's going to give me the exact information I need - the username and the query statements. I'm going to go with that one.

upvoted 0 times

...

Buffy

5 months ago

Okay, let's see here. I'm pretty sure the answer has something to do with monitoring or logging the query activity, but I'm not sure which of these options is the best approach.

upvoted 0 times

...

Helene

5 months ago

Hmm, this looks like a tricky one. I'll need to think carefully about the different options and which one would be the most efficient way to isolate the queries from the last 60 minutes.

upvoted 0 times

...