Microsoft DP-700 Exam - Topic 2 Question 7 Discussion

Actual exam question for Microsoft's DP-700 exam

Question #: 7
Topic #: 2

[All DP-700 Questions]

You have an Azure event hub. Each event contains the following fields:

BikepointID

Street

Neighbourhood

Latitude

Longitude

No_Bikes

No_Empty_Docks

You need to ingest the events. The solution must only retain events that have a Neighbourhood value of Chelsea, and then store the retained events in a Fabric lakehouse.

What should you use?

Aa KQL queryset

Ban eventstream

Ca streaming dataset

DApache Spark Structured Streaming

Show Suggested Answer

Suggested Answer: D

To compute the standard deviation of the temperature from the thermal sensor data, you would use the Aggregate transform operator in Eventstream1. The Aggregate operator allows you to apply functions like sum, average, count, and statistical functions like standard deviation across a group of rows or events. This operator is ideal for operations that require summarizing or computing statistics over a dataset, such as calculating the standard deviation.

by Monte at Jan 23, 2025, 02:18 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Helene

5 months ago

No way, D is definitely the way to go!

upvoted 0 times

...

Aileen

5 months ago

I’m surprised they want to filter by Neighbourhood like that.

upvoted 0 times

...

Shalon

5 months ago

Wait, why not just use a streaming dataset?

upvoted 0 times

...

Kenda

5 months ago

A KQL queryset would work too, right?

upvoted 0 times

...

Annice

6 months ago

I think D is the best choice for this.

upvoted 0 times

...

Isadora

6 months ago

I feel like the eventstream option might not be enough for the filtering requirement. Spark seems more appropriate for this scenario.

upvoted 0 times

...

Muriel

6 months ago

I practiced a similar question where we had to filter events, and I think a streaming dataset could be the right choice, but I’m not confident.

upvoted 0 times

...

Sage

6 months ago

I'm not entirely sure, but I remember something about KQL being useful for querying data. Would that work here?

upvoted 0 times

...

Lindsey

6 months ago

I think we might need to use Apache Spark Structured Streaming for this, since it can handle real-time data and filtering.

upvoted 0 times

...

Lai

6 months ago

This seems pretty straightforward to me. I'd just use a KQL queryset to filter the events with a Neighbourhood value of Chelsea, and then store the results in the Fabric lakehouse. KQL is a powerful query language for working with Azure data sources, so I think that would be the most efficient approach here.

upvoted 0 times

...

Blondell

6 months ago

Okay, I've got a strategy for this. I'd use Apache Spark Structured Streaming to ingest the events from the Azure event hub. That way, I can apply the Neighbourhood filter in real-time as the data is coming in, and then write the filtered events directly to the Fabric lakehouse. Spark Streaming should give me the performance and scalability I need for this kind of streaming data processing.

upvoted 0 times

...

Jannette

6 months ago

Hmm, I'm a bit unsure about this one. I'm not super familiar with Azure event hubs and Fabric lakehouses. I think I'd need to do some more research on the specific technologies involved before deciding on the best approach. Maybe I'll try to find some examples online to get a better understanding.

upvoted 0 times

...

Cecil

7 months ago

This looks like a classic data ingestion and filtering problem. I'd start by using a streaming dataset to ingest the events from the Azure event hub, and then apply a filter to only retain the events with a Neighbourhood value of Chelsea before storing them in the Fabric lakehouse.

upvoted 0 times

...

Glenn

12 months ago

Haha, I bet the answer is just to use a KQL queryset and then manually filter out the events. That's probably the most 'Azure' solution, right?

upvoted 0 times

Beata

10 months ago

User 4: Just filter out the events with Neighbourhood value of Chelsea.

upvoted 0 times

...

Robt

10 months ago

User 3: It's definitely the most Azure way to do it.

upvoted 0 times

...

Hildred

10 months ago

User 2: Yeah, that sounds like the right choice.

upvoted 0 times

...

Kristofer

11 months ago

User 1: I think the answer is to use a KQL queryset.

upvoted 0 times

...

Rikki

11 months ago

Hayley: Yeah, it's a more efficient way to handle the data ingestion process.

upvoted 0 times

...

Hayley

11 months ago

User 2: That's correct. Using KQL will make it easier to retain only the events you need for the Fabric lakehouse.

upvoted 0 times

...

Kiley

11 months ago

User 1: Actually, the best option is to use a KQL queryset to filter out the events with Neighbourhood value of Chelsea.

upvoted 0 times

...

Lillian

12 months ago

I'm leaning towards option C, a streaming dataset. That seems like it would be a good fit for this use case, and it might be a bit simpler to set up than the Spark solution.

upvoted 0 times

...

Dick

1 year ago

Hmm, I'm not sure about that. Wouldn't an eventstream be a more straightforward solution? It's designed for ingesting and processing streaming data like this.

upvoted 0 times

Rhea

11 months ago

I agree, using a KQL queryset would allow us to easily retain events with a Neighbourhood value of Chelsea before storing them in a Fabric lakehouse.

upvoted 0 times

...

Theola

12 months ago

I think a KQL queryset would be more appropriate for filtering events based on specific criteria like Neighbourhood.

upvoted 0 times

...

Gracia

1 year ago

I think option D, Apache Spark Structured Streaming, is the way to go. It can handle the streaming data and filter out the events based on the Neighbourhood value.

upvoted 0 times