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?
Click on the arrows to vote for the correct answer
A. B.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.
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-outputsYes, the proposed solution meets the goal.
The solution proposes to use Azure Stream Analytics to read an input file from Azure Blob storage named Customers, which contains in-store and online customer details, including a mailing address for online customers. The solution also proposes to use a reference input file named LocationIncomes that contains median incomes based on location. The reference input rarely changes.
The solution suggests that the Stream Analytics job will have one streaming input, which is the Customers file, and one reference input, which is the LocationIncomes file. The reference input will be used to look up a median income based on location.
The solution proposes to implement one query to process the data from the streaming input and reference input. The query will use the address information in the streaming input to look up the median income based on location in the reference input.
Finally, the solution proposes to output the processed data to two destinations. The first destination is Azure SQL Database, where the data will be immediately available for use. The second destination is Azure Data Lake Storage Gen2, where the data will be stored for long-term retention.
Therefore, this solution meets the goal of using an address to look up a median income based on location and outputting the data to Azure SQL Database for immediate use and to Azure Data Lake Storage Gen2 for long-term retention.