Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 2 question 26 discussion

Actual exam question from Microsoft's DP-200

Question #: 26
Topic #: 2

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are developing a solution that will use Azure Stream Analytics. The solution will accept an Azure Blob storage file named Customers. The file will contain both in-store and online customer details. The online customers will provide a mailing address.
You have a file in Blob storage named LocationIncomes that contains median incomes based on location. The file rarely changes.
You need to use an address to look up a median income based on location. You must output the data to Azure SQL Database for immediate use and to Azure
Data Lake Storage Gen2 for long-term retention.
Solution: You implement a Stream Analytics job that has one streaming input, one reference input, one query, and two outputs.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
We need one reference data input for LocationIncomes, which rarely changes.
We need two queries, on for in-store customers, and one for online customers.
For each query two outputs is needed.
Note: Stream Analytics also supports input known as reference data. Reference data is either completely static or changes slowly.
References:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-add-inputs#stream-and-reference-inputs https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-outputs

by HeleneB at July 18, 2020, 2:43 p.m.

Comments

Submit Cancel

Uday0809

Highly Voted 4 years, 6 months ago

This is the correct answer --> "You implement a Stream Analytics job that has one streaming input, one reference input, one query, and two outputs."

upvoted 21 times

...

dumpsm42

Highly Voted 4 years, 5 months ago

hi to all, it's correct: A https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-add-inputs in one query we can join reference data two outputs because of two different database systems regards

upvoted 6 times

dumpsm42

4 years, 5 months ago

https://docs.microsoft.com/en-us/stream-analytics-query/reference-data-join-azure-stream-analytics

upvoted 2 times

...

Akva

Most Recent 4 years, 7 months ago

We don't need streaming input, hence answer - no

upvoted 2 times

victor90

3 years, 6 months ago

No, Stream analytics jobs must have at least one stream input. https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-add-inputs#data-stream-input

upvoted 1 times

...

BungyTex

4 years, 9 months ago

According to the documentation you can have two output types in a query. "You can use a single output per job, or multiple outputs per streaming job (if you need them) by adding multiple INTO clauses to the query." I think the answer is A.

upvoted 2 times

sandGrain

4 years, 8 months ago

I agree with BungyTex ... you only need one query with 2 output types .. i have done it in practice ... so can validate it works ...

upvoted 1 times

jumby

4 years, 6 months ago

To back BungyTex and sandGrain, here' the doc: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-outputs#:~:text=An%20Azure%20Stream%20Analytics%20job,%2C%20query%2C%20and%20an%20output.&text=When%20you%20design%20your%20Stream,INTO%20clauses%20to%20the%20query.

upvoted 1 times

mohowzeh

4 years, 5 months ago

Hi Jumby, in the link you provide, the text says that there can be multiple INTO statements in the "query". However, in the following link, it can be seen that two INTO statements require two SELECT statements: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-stream-analytics-query-patterns#query-example-send-data-to-multiple-outputs It seems that different authors at Microsoft disagree on exactly what a query is. If one query is equal to one SELECT statement, as most SQL literature defines it, then then two INTO statements would mean two queries. The author of the article on Streaming Analytics uses a different definition of "query". IMHO he should have said "job" instead of "query". All very confusing, I'd say, particularly since an exam question rests entirely of which version of the definition one uses.

upvoted 1 times

...

mohowzeh

4 years, 5 months ago

In your quote "multiple outputs per streaming job", the key word "job" seems different to me from a "query". The test question refers to number of queries, not the number of jobs. If one query is equal to one SELECT statement, then one job can have multiple queries.

upvoted 1 times

...

singhadi003

4 years, 10 months ago

We need to two query to load in different targets as stated in question: "You must output the data to Azure SQL Database for immediate use and to Azure Data Lake Storage Gen2 for long-term retention."

upvoted 3 times

Pairon

4 years, 1 month ago

Yeah but that means you save the SAME result (only one query) in two services because of different purposes. So I think that one query is enough.

upvoted 1 times

...

HeleneB

4 years, 10 months ago

I don't see why you couldn't use one query since both sources are in the one customer file. It doesn't say you need two sets of queries for each source in the scenario. I disagree.

upvoted 3 times

...