Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 2 question 27 discussion

Actual exam question from Microsoft's DP-200

Question #: 27
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, two queries, and four outputs.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️
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 Yan2x at July 14, 2020, 9:46 p.m.

Comments

Submit Cancel

BungyTex

Highly Voted 4 years, 11 months ago

It would meet the goal, but why would you even create 2 queries? You can get there with just 1 query and two outputs.

upvoted 11 times

H_S

4 years, 5 months ago

no you can''t, you have 2 "INTO"

upvoted 1 times

...

cadio30

Most Recent 4 years, 3 months ago

NO is the answer Reference: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-stream-analytics-query-patterns#query-example-send-data-to-multiple-outputs

upvoted 1 times

cadio30

4 years, 2 months ago

Here is the scenario, there is a file that contains two dataset in-store and online customer and it requires to load it into Azure SQL and Data Lake. In coding perspective each query is equivalent to ONE select into which results to two queries to load the requirement. However, if we are going to combine the in-store and online customers then it is only ONE query. Since it was not stated here to unify the datasets then it is best to assume that they will be loaded into two tables. In azure SQL it will be loaded to two tables then in Azure Datalake there will be also two placeholder. Therefore, there are 2 queries and 4 outputs in total.

upvoted 2 times

...

azure_emumba

4 years, 3 months ago

"NO". we can handle two inputs i.e two SELECT statements in one query. so no need of two queries. https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-use-reference-data#joining-multiple-reference-datasets-in-a-job

upvoted 1 times

...

maynard13x8

4 years, 7 months ago

I think the problem is that its a bit confusing what is "one query". Is it all you can do into query editor or is each time you use separated "select - into - from" ? If its the second one, so you need to create 2 queries, each one with different "INTO output"

upvoted 1 times

mohowzeh

4 years, 7 months ago

Good point about "what is a query"... Two SELECT clauses are needed if there are two INTO statements, as per this link: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-stream-analytics-query-patterns: (quote from above link) "Multiple SELECT statements can be used to output data to different output sinks. For example, one SELECT can output a threshold-based alert while another one can output events to blob storage."

upvoted 1 times

...

dumpsm42

4 years, 7 months ago

hi to all, for it's false just because we have 1 query and not 2 queries; the query already joins the main data with the reference data so it's one query the rest is OK https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-troubleshoot-query regards

upvoted 3 times

H_S

4 years, 5 months ago

it's one query, with 2 outputs and not 4 ?

upvoted 1 times

...

syu31svc

4 years, 8 months ago

Hmm...so long as it meets the goal the answer then the answer is yes then. Yes the suggested solution does kind of "overdo" it but no harm in it I suppose. Just my own thoughts about it so I will go with Yes in this case.

upvoted 3 times

...

hart232

4 years, 10 months ago

There is only one requirement in teh question "You need to use an address to look up a median income based on location". 1 Query and 2 outputs makes sense. Not sure why we need the second query for? anyone?

upvoted 2 times

...

Varma_Saraswathula

4 years, 10 months ago

The online customers will provide a mailing address. 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 Does this mean that we need to have 2 diferent queries to get this, if there are 2 queries then 4 outputs

upvoted 1 times

...

dcpavelescu

4 years, 11 months ago

Not clear why 4 outputs are required, as long as no specific requirement to provide separate outputs per customer type (in-store and online customers) 2 query, 2 outputs shall be the right answer accordingly also to: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-stream-analytics-query-patterns Anyone, is an option with 2 queries and 2 outputs in the exam?

upvoted 3 times

...

Yan2x

5 years ago

There are only two queries, why need for four outputs? I think the answer should be No.

upvoted 1 times

nivas143srinivas

5 years ago

The query output need to be stored in two places: SQL DW and Data lake both. So it's 2x2

upvoted 6 times

...