Implementing Azure Stream Analytics for Real-Time Data Processing
Question
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?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B.B
We need one reference data input for LocationIncomes, which rarely changes.
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-inputsYes, the solution meets the goal.
The solution involves using Azure Stream Analytics to read data from an Azure Blob storage file named Customers. The Customers file contains in-store and online customer details, including the mailing address for online customers. The solution also involves reading data from another Azure Blob storage file named LocationIncomes, which contains median incomes based on location. The file rarely changes.
The solution then uses an address to look up a median income based on location. The lookup is performed by using a Stream Analytics query, which joins the Customers file with the LocationIncomes file on the basis of the address field. The query then outputs the data to two destinations: Azure SQL Database for immediate use and Azure Data Lake Storage Gen2 for long-term retention.
In summary, the solution meets the goal of using Azure Stream Analytics to look up median incomes based on location and output the results to both Azure SQL Database and Azure Data Lake Storage Gen2.
