Online Access Free 070-776 Exam Questions

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.

Correct Answer:

Explanation

You are implementing a solution by using Microsoft Azure Data Lake Analytics.
You have a dataset that contains data-related to website visits.
You need to combine overlapping visits into a single entry based on the timestamp of the visits.
Which type of U-SQL interface should you use?

• A.IProcessor
• B.IReducer
• C.Aggregate
• D.IExtractor

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.

• A.DROP EXTERNAL TABLE
• B.CREATE EXTERNAL TABLE
• C.ALTER EXTERNAL DATA SOURCE
• D.CREATE EXTERNAL TABLE AS SELECT
• E.ALTER TABLE

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.

Correct Answer:

Explanation

References:
https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-monitor-manage-pipelines?view=powerbiap

You have a Microsoft Azure SQL data warehouse.
You need to configure Data Warehouse Units (DWUs) to ensure that you have six compute nodes. The solution must minimize costs.
Which value should set for the DWUs?

• A.DW400
• B.DW200
• C.DW600
• D.DW1000