DP-200 Exam QuestionsBrowse all questions from this exam
Go to Exam

DP-200 Exam - Question 84

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?

Show Answer
Correct Answer: A

The solution involves utilizing Azure Stream Analytics with one streaming input for the real-time customer data, one reference input for the median income data that changes rarely, a single query that joins streamed data with the reference data based on location, and two outputs, one to Azure SQL Database for immediate use and one to Azure Data Lake Storage Gen2 for long-term retention. This approach aligns with Azure Stream Analytics' capabilities to handle multiple outputs within a single query using multiple INTO clauses. Therefore, the solution meets the requirements and is correctly implemented.

Discussion

6 comments
Sign in to comment
Uday0809
Nov 12, 2020

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

dumpsm42
Dec 12, 2020

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

dumpsm42
Dec 12, 2020

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

HeleneB
Jul 18, 2020

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.

singhadi003
Jul 21, 2020

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."

Pairon
Apr 13, 2021

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.

BungyTex
Sep 3, 2020

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.

sandGrain
Sep 30, 2020

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

jumby
Nov 23, 2020

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.

mohowzeh
Dec 22, 2020

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.

mohowzeh
Dec 22, 2020

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.

jumby
Nov 23, 2020

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.

mohowzeh
Dec 22, 2020

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.

mohowzeh
Dec 22, 2020

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.

mohowzeh
Dec 22, 2020

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.

Akva
Oct 29, 2020

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

victor90
Nov 28, 2021

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