Online Access Free 070-776 Practice Test

You need to define an input dataset for a Microsoft Azure Data Factory pipeline.
Which properties should you include when you define the dataset?

• A.name, policy, structure, and external
• B.name, type, policy, and structure
• C.name, typeProperties, structure, and availability
• D.name, type, typeProperties, and availability

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 should you use?

• A.RAID 5 volumes
• B.stripped volumes
• C.storage pools with striped disks
• D.spanned volumes
• E.storage pools with mirrored disks

You have a Microsoft Azure Data Lake Analytics service.
You plan to configure diagnostic logging.
You need to use Microsoft Operations Management Suite (OMS) to monitor the IP addresses that are used to access the Data Lake Store.
What should you do?

• A.Send the request logs to Log Analytics.
• B.Stream the audit logs to an event hub.
• C.Send the audit logs to Log Analytics.
• D.Stream the request logs to an event hub.

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.

Correct Answer:

Explanation

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.ALTER TABLE
• B.CREATE EXTERNAL TABLE AS SELECT
• C.CREATE EXTERNAL TABLE
• D.ALTER EXTERNAL DATA SOURCE
• E.DROP EXTERNAL TABLE