Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 2 question 26 discussion

Actual exam question from Microsoft's DP-203

Question #: 26
Topic #: 2

HOTSPOT -
You have an Azure SQL database named Database1 and two Azure event hubs named HubA and HubB. The data consumed from each source is shown in the following table.

You need to implement Azure Stream Analytics to calculate the average fare per mile by driver.
How should you configure the Stream Analytics input for each source? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

HubA: Stream -

HubB: Stream -

Database1: Reference -
Reference data (also known as a lookup table) is a finite data set that is static or slowly changing in nature, used to perform a lookup or to augment your data streams. For example, in an IoT scenario, you could store metadata about sensors (which don't change often) in reference data and join it with real time IoT data streams. Azure Stream Analytics loads reference data in memory to achieve low latency stream processing
Reference:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-use-reference-data

by Sunnyb at June 4, 2021, 4:04 p.m.

Comments

Submit Cancel

Sunnyb

Highly Voted 3 years, 6 months ago

Answer is correct

upvoted 42 times

...

Jaws1990

Highly Voted 2 years, 11 months ago

Crap question. With that data, how are you supposed to link the stream data with the reference data.

upvoted 16 times

...

KarlGardnerDataEngineering

Most Recent 6 months, 3 weeks ago

Why are some of these questions very simple and others are insanely hard?

upvoted 6 times

...

kkk5566

1 year, 3 months ago

correct

upvoted 1 times

...

mafragias

1 year, 8 months ago

Stream, STream, Reference

upvoted 3 times

...

zorko10

2 years, 1 month ago

Correct Data stream input : is an unbounded sequence of events over time. Reference Data input : Reference data is either completely static or changes slowly https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-add-inputs

upvoted 6 times

...

Deeksha1234

2 years, 4 months ago

correct

upvoted 2 times

...

wolf74

2 years, 5 months ago

why hubA, that contains driver's name, should be processed as stream?? it's a dimension type and should be processed as reference in my opinion

upvoted 3 times

dmitriypo

2 years, 1 month ago

HubA doesn't contain driver's name. It is Database1 that contains driver's name.

upvoted 4 times

...

gssd4scoder

3 years, 1 month ago

Correct: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-add-inputs

upvoted 2 times

...

GameLift

3 years, 3 months ago

I doubt if these questions are really what they asking in the real exam.

upvoted 4 times

[Removed]

3 years, 2 months ago

it could be real, he is asking if you can realize the main difference between the real-time data vs the reference data and so you can choose the best service for each one

upvoted 5 times

...

Vanq69

1 year, 2 months ago

I mean they can't just ask hard questions where you need 5min to think about, no one would pass that. Also they want the certificate to be worth something but also have many people passing the exam and go for Azure instead of AWS, GCP.

upvoted 1 times

...

[Removed]

3 years, 2 months ago

I have tried some pretty easy question like this one before in prev exams

upvoted 3 times

...