HOTSPOT You have a Microsoft Azure Data Lake Analytics service. You have a tab-delimited file named UserActivity.tsv that contains logs of user sessions. The file does not have a header row. You need to create a table and to load…
DRAG DROP You have a Microsoft Azure Stream Analytics solution that captures website visits and user interactions on the website You have the sample input data described in the following table. You have the sample output described in the following…
Drag Drop You have IoT devices that produce the following output. You need to use Microsoft Azure Stream Analytics to convert the output into the tabular format described in the following table. How should you complete the Stream Analytics query?…
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,…
DRAG DROP You plan to develop a solution for real-time sentiment analysis of Twitter data. You need to create a Microsoft Azure Stream Analytics job query to count the number of tweets during a period. Which Window function should you…
DRAG DROP Note: This question is part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of…
HOTSPOT Note: This question is part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the…
You manage an on-premises data warehouse that uses Microsoft SQL Server The data warehouse contains 100 TB of data. The data is partitioned by month. One TB of data is added to the data warehouse each month, You create a…
You have an on-premises data warehouse that uses Microsoft SQL Server 2016. All the data in the data warehouse comes from text files stored in Azure Blob storage. The text files are imported into the data warehouse by using SQL…
You plan to deploy a Microsoft Azure virtual machine that will a host data warehouse. The data warehouse will contain a 10 TB database You need to provide the fastest read and writes times for the database. Which disk configuration…