距離 Microsoft Engineering Data with Microsoft Cloud Services 考試的日子越來越近，卻總覺得複習進度追不上計畫？Fast2test 的 070-776 題庫收錄 92 道練習題，幫助你把有限的備考時間用在真正會出題的重點上。

Microsoft 070-776 考試概覽:

Microsoft 070-776 考試大綱主題:

Microsoft Engineering Data with Microsoft Cloud Services 考生最常問的問題

最新的 Microsoft Azure SQL Data Warehous 070-776 免費考試真題：

問題 #1

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?

A. a policy assignment that uses the Allowed locations policy definition
B. a policy assignment that uses the Allowed resource types policy definition
C. a Native Active Directory app registration
D. a Web app/API Active Directory app registration

問題 #2

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.

問題 #3

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 have a table named Table1 that contains 3 billion rows. Table1 contains data from the last 36 months.
At the end of every month, the oldest month of data is removed based on a column named DateTime.
You need to minimize how long it takes to remove the oldest month of data.
Solution: You implement a columnstore index on the DateTime column.
Does this meet the goal?

A. No
B. Yes

問題 #4

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

問題 #5

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 request logs to an event hub.
C. Send the audit logs to Log Analytics.
D. Stream the audit logs to an event hub.

問題與答案：