Microsoft Engineering Data with Microsoft Cloud Services - 70-776 Exam Practice Test
You plan to implement a Microsoft Azure Stream Analytics job to track the data from IoT devices. You will have the following two jobs:
- Job1 will contain a query that has one non-partitioned step.
- Job2 will contain a query that has two steps. One of the steps is partitioned.
What is the maximum number of streaming units that will be consumed per job? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
- Job1 will contain a query that has one non-partitioned step.
- Job2 will contain a query that has two steps. One of the steps is partitioned.
What is the maximum number of streaming units that will be consumed per job? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
References:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-scale-jobs
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-streaming-unit-consumption
You have a Microsoft Azure SQL data warehouse that has 10 compute nodes.
You need to export 10 TB of data from a data warehouse table to several new flat files in Azure Blob storage.
The solution must maximize the use of the available compute nodes.
What should you do?
You need to export 10 TB of data from a data warehouse table to several new flat files in Azure Blob storage.
The solution must maximize the use of the available compute nodes.
What should you do?
Correct Answer: A
Vote an answer
You are using a Microsoft Azure Stream Analytics query language.
You are outputting data from an input click stream.
You need to ensure that when you consecutively receive two rows from the same IP address within one minute, only the first row is outputted.
Which functions should you use in the WHERE statement?
You are outputting data from an input click stream.
You need to ensure that when you consecutively receive two rows from the same IP address within one minute, only the first row is outputted.
Which functions should you use in the WHERE statement?
Correct Answer: A
Vote an answer
You need to load data from Microsoft Azure Data Lake Store to Azure SQL Data Warehouse by using Transact-SQL.
In which sequence should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
In which sequence should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Correct Answer:
Explanation
You have a Microsoft Azure Data Factory version 2 (V2) service.
You need to deploy a linked service to an existing database in Azure SQL Data Warehouse.
How should you complete the JSON snippet? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to deploy a linked service to an existing database in Azure SQL Data Warehouse.
How should you complete the JSON snippet? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
You have a Microsoft Azure Stream Analytics job.
You are debugging event information manually.
You need to view the event data that is being collected.
Which monitoring data should you view for the Stream Analytics job?
You are debugging event information manually.
You need to view the event data that is being collected.
Which monitoring data should you view for the Stream Analytics job?
Correct Answer: A
Vote an answer
You need to use the Cognition.Vision.FaceDetector() function in U-SQL to analyze images.
Which attribute can you detect by using the function?
Which attribute can you detect by using the function?
Correct Answer: C
Vote an answer
You plan to create for an alert for a Microsoft Azure Data Factory pipeline.
You need to configure the alert to trigger when the total number of failed runs exceeds five within a three-hour period.
How should you configure the window size and the threshold in the JSON file? 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.
You need to configure the alert to trigger when the total number of failed runs exceeds five within a three-hour period.
How should you configure the window size and the threshold in the JSON file? 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.
Correct Answer:
Explanation
References:
https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-monitor-manage-pipelines?view=powerbiap
You have a file in a Microsoft Azure Data Lake Store that contains sales data. The file contains sales amounts by salesperson, by city, and by state.
You need to use U-SQL to calculate the percentage of sales that each city has for its respective state.
Which code should you use?
You need to use U-SQL to calculate the percentage of sales that each city has for its respective state.
Which code should you use?
Correct Answer: B
Vote an answer
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? 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.
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? 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.
Correct Answer:
