Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-700 Exam - Topic 3 Question 19 Discussion

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?
B) views from the queryinsights schema
A) the Microsoft Fabric Capacity Metrics app
C) Query activity
D) the sys.dm_exec_requests dynamic management view

Microsoft DP-700 Exam - Topic 3 Question 19 Discussion

Actual exam question for Microsoft's DP-700 exam
Question #: 19
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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Jonell
9 months ago
D could work, but it won't give you usernames, just the requests.
upvoted 0 times
...
Miss
9 months ago
Wait, can we really get all that info from B? Sounds too good to be true!
upvoted 0 times
...
Hildred
9 months ago
I think it's definitely B, the queryinsights schema has all the details we need.
upvoted 0 times
...
Lashon
10 months ago
I agree with B too, it’s the best way to get user info and queries.
upvoted 0 times
...
Mitsue
10 months ago
A is useful for metrics, but not for isolating queries like we need.
upvoted 0 times
...
Haydee
10 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
10 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
11 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
11 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
11 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
11 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
11 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
11 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
12 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
...
Kayleigh
12 months ago
I believe Query activity might also be a good option to isolate the queries.
upvoted 0 times
...
Frank
1 year ago
Hold up, what about that sys.dm_exec_requests dynamic management view? That could be a real game-changer, you know?
upvoted 0 times
...
Viva
1 year ago
Hmm, I'm leaning towards Option B. Those views from the queryinsights schema sound like they could do the trick.
upvoted 0 times
Tesha
12 months ago
User2: Yeah, those views from the queryinsights schema seem promising.
upvoted 0 times
...
Charlene
12 months ago
User1: I think Option B is the way to go.
upvoted 0 times
...
...
Kaitlyn
1 year ago
I agree with Carole, views from the queryinsights schema would give us the necessary information.
upvoted 0 times
...
Carole
1 year ago
I think we should use views from the queryinsights schema.
upvoted 0 times
...
Julieta
1 year ago
Option C definitely seems like the way to go here. It's all about that query activity, baby!
upvoted 0 times
Timothy
1 year ago
User3: I agree, let's go with Query activity.
upvoted 0 times
...
Shawnna
1 year ago
User2: Yeah, that sounds like the best option.
upvoted 0 times
...
Catalina
1 year ago
User1: I think we should use Query activity.
upvoted 0 times
...
...

Save Cancel