Microsoft Engineering Data with Microsoft Cloud Services - 70-776 Exam Practice Test

You plan to use Microsoft Azure Event Hubs to ingest sensor data. You plan to use Azure Stream Analytics to analyze the data in real time and to send the output directly to Azure Data Lake Store.
You need to write events to the Data Lake Store in batches.
What should you use?

You plan to use U-SQL to run federated queries to join data from a Microsoft Azure SQL data warehouse, an Azure SQL database, and a Microsoft SQL Server database on an Azure virtual machine.
You need to ensure that you can use a U-SQL query that joins all three data sources. The solution must ensure that the three data sources appear as tables in U-SQL without having to move the data from external sources.
Which three statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

You have the following process:
* A CSV file is ingested by Microsoft Azure Stream Analytics.
* Scoring is performed by Azure Machine Learning.
* Stream Analytics returns sentiment scoring through a web service endpoint.
* Stream Analytics creates an output blob.
You need to view the output of the scoring operation and to evaluate the throughput to the Machine Learning models.
Which monitoring data should you evaluate from the Azure portal?

You have a Microsoft Azure Data Lake Store and an Azure Active Directory tenant.
You are developing an application that will access the Data Lake Store by using end-user credentials.
You need to ensure that the application uses end-user authentication to access the Data Lake Store.
What should you create?

You plan to deploy a Microsoft Azure Stream Analytics job to filter multiple input streams from IoT devices that have a total data flow of 30 MB/s.
You need to calculate how many streaming units you require for the job. The solution must prevent lag.
What is the minimum number of streaming units required?

You have sensor devices that report data to Microsoft Azure Stream Analytics. Each sensor reports data several times per second.
You need to create a live dashboard in Microsoft Power BI that shows the performance of the sensor devices.
The solution must minimize lag when visualizing the data.
Which function should you use for the time-series data element?

You are building a data pipeline that uses Microsoft Azure Stream Analytics.
Alerts are generated when the aggregate of data streaming in from devices during a minute-long window matches the values in a rule.
You need to retrieve the following information:
*The event ID
*The device ID
*The application ID that runs the service
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

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 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_workers shows a significant variation in the number of rows being moved among the distributions for the same table for the same query.
You need to ensure that the load is distributed evenly across the compute nodes.
Solution: You add a nonclustered columnstore index.
Does this meet the goal?

You have a Microsoft Azure SQL data warehouse. The following statements are used to define file formats in the data warehouse.

You have an external PolyBase table named file_factPowerMeasurement that uses the FileFormat_ORC file format.
You need to change file_ factPowerMeasurement to use the FileFormat_PARQUET file format.
Which two statements should you execute? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

You use Microsoft Visual Studio to develop custom solutions for customers who use Microsoft Azure Data Lake Analytics.
You install the Data Lake Tools for Visual Studio.
You need to identify which tasks can be performed from Visual Studio and which tasks can be performed from the Azure portal.
What should you identify for each task? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.