You use Microsoft Azure Stream Analytics to analyze website visit logs in real time.You have a table named Locations that has a column containing IP addresses and a column containing country names.You need to look up the country name of a specific IP address.Which query element should you use?
You plan to capture the output from a group of 500 IoT devices that produce approximately 10 GB of data per hour by using Microsoft Azure Stream Analytics. The data will be retained for one year.Once the data is processed, it will be stored in Azure, and then analyzed by using an Azure HDInsight cluster.You need to select where to store the output data from Stream Analytics. The solution must minimize costs.What should you select?
DRAG DROP -You use Microsoft Azure Stream Analytics to analyze data from an Azure event hub in real time and send the output to a table named Table1 in an Azure SQL database. Table1 has three columns named Date, EventID, and User.You need to prevent duplicate data from being stored in the database.How should you complete the command? To answer, drag the appropriate values to the correct targets. Each value may be used once more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.Select and Place:
You have a Microsoft Azure SQL data warehouse that contains information about community events.An Azure Data Factory job writes an updated CSV file in Azure Blob storage to Community/{date}/event.csv daily.You plan to consume a Twitter feed by using Azure Stream Analytics and to correlate the feed to the community events.You plan to use Stream Analytics to retrieve the latest community events data and to correlate the data to the Twitter feed data.You need to ensure that when updates to the community events data is written to the CSV files, the Stream Analytics job can access the latest community events data.What should you configure?
You are developing an application that uses Microsoft Azure Stream Analytics.You have data structures that are defined dynamically.You want to enable consistency between the logical methods used by stream processing and batch processing.You need to ensure that the data can be integrated by using consistent data points.What should you use to process the data?
Note: This question is part of 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 monitoring user queries to a Microsoft Azure SQL data warehouse that has six compute nodes.You discover that compute node utilization is uneven. The rows_processed column from sys.dm_pdw_dms_workers shows a significant variation in the number of rows being moved among the distributions. The variation occurs for the same table, using the same query.You need to ensure that the load is distributed evenly across the compute nodes.Solution: You add a clustered columnstore index.Does this meet the goal?
