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 two streaming inputs, 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
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-inputsThe proposed solution to use Azure Stream Analytics to process the Customers and LocationIncomes files in Azure Blob storage does meet the goal of looking up a median income based on the customer's location and outputting the data to Azure SQL Database and Azure Data Lake Storage Gen2.
The solution involves creating a Stream Analytics job with two streaming inputs - Customers and LocationIncomes files stored in Azure Blob storage. The job will use a query to join the two streams based on the location field in the Customers file and the location field in the LocationIncomes file. The output from the query will be sent to two destinations - Azure SQL Database for immediate use and Azure Data Lake Storage Gen2 for long-term retention.
This solution allows for real-time processing of the data as it is being streamed from the input files, ensuring that the data is always up-to-date. It also allows for storing the data in both a relational database and a data lake for different use cases, providing flexibility in how the data can be accessed and analyzed.
Overall, this solution meets the requirements stated in the question and is a valid approach for using Azure Stream Analytics to process and analyze data from Azure Blob storage. Therefore, the answer is A. Yes.