DP-200 Exam QuestionsBrowse all questions from this exam

DP-200 Exam - Question 83


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 query, and two outputs.

Does this meet the goal?

Show Answer
Correct Answer: B

To use Azure Stream Analytics correctly in this scenario, you need both a streaming input and a reference data input because LocationIncomes changes rarely. Reference data in Stream Analytics is used for data that is static or changes infrequently, allowing you to merge it with the streaming data. The proposed solution mentions only one streaming input and does not include a reference input for LocationIncomes. Therefore, it does not meet the goal of accurately looking up median income based on location and outputting the data correctly.

Discussion

1 comment
Sign in to comment
tuchoOption: B
Apr 10, 2021

Correct answer is B) , "add reference input" is missing. https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-use-reference-data