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?
Click on the arrows to vote for the correct answer
A. B.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.
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 solution described in the question meets the requirements.
The solution includes:
One streaming input: This refers to the Customers file in Azure Blob storage that contains both in-store and online customer details.
One reference input: This refers to the LocationIncomes file in Azure Blob storage that contains median incomes based on location. This input is referenced to look up the median income based on the mailing address of the online customers.
Two queries: The first query will join the streaming input with the reference input to look up the median income based on the mailing address. The second query will output the data to both Azure SQL Database for immediate use and to Azure Data Lake Storage Gen2 for long-term retention.
Four outputs: This refers to two outputs for each query. The first query will output the result to Azure SQL Database for immediate use and to Azure Data Lake Storage Gen2 for long-term retention. The second query will also output the result to Azure SQL Database for immediate use and to Azure Data Lake Storage Gen2 for long-term retention.
Therefore, this solution is a valid implementation of using Azure Stream Analytics to look up the median income based on location and outputting the data to both Azure SQL Database for immediate use and to Azure Data Lake Storage Gen2 for long-term retention.