IT認証試験問題集
毎月、ITshikenは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / 70-776 問題集  / 70-776 問題練習

Microsoft 70-776 問題練習

Perform Big Data Engineering on Microsoft Cloud Services (beta) 試験

最新更新時間: 2021/01/12,合計56問。

2021新年のギフト:70-776 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、70-776 問題集を使用してください。

 / 4

Question No : 1
You manage an on-premises data warehouse that uses Microsoft SQL Server. The data warehouse contains 100 TB of data. The data is partitioned by month. One TB of data is added to the data warehouse each month.
You create a Microsoft Azure SQL data warehouse and copy the on- premises data to the data warehouse.
You need to implement a process to replicate the on-premises data warehouse to the Azure SQL data warehouse. The solution must Support daily incremental updates and must provide error handling.
What should you use?

正解:

Question No : 2
You have an on-premises data warehouse that uses Microsoft SQL Server 2016. All the data in the data warehouse comes from text files stored in Azure Blob storage. The text files are imported into the data warehouse by using SQL Server Integration Services (SSIS). The text files are not transformed.
You need to migrate the data to an Azure SQL data warehouse in the least amount of time possible.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

正解:

Question No : 3
You plan to deploy a Microsoft Azure virtual machine that will a host data warehouse. The data warehouse will contain a10-TB database.
You need to provide the fastest read and writes times for the database.
Which disk configuration should you use?

正解:

Question No : 4
You have a Microsoft Azure SQL data warehouse named DW1. Data is loaded to DW1 once daily at 01:00.
A user accidentally deletes data from a fact table in DW1 at 09:00.
You need to recover the lost data. The solution must prevent the need to change any connection strings and must minimize downtime.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the area and arrange them in the correct order.

Untitled

正解:

Question No : 5
You are monitoring a Microsoft Azure SQL data warehouse.
You need to get the following information:
*The top 10 longest running queries
*The distributed query plan for a specific query
Which dynamic management view should you use for each piece of information? To answer, drag the appropriate dynamic management view to the correct piece of information. Each dynamic management view 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.

Untitled

正解:

Question No : 6
You have a Microsoft Azure SQL data warehouse.
Users discover that reports running in the data warehouse take longer than expected to complete.
You need to review the duration of the queries and which users are running the queries currently.
Which dynamic management view should you review for each requirement? To answer, drag the appropriate dynamic management view to the correct requirements. Each dynamic management view 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.

Untitled

正解:

Question No : 7
You have an on-premises deployment of Active Directory named contoso.com.
You plan to deploy a Microsoft Azure SQL data warehouse.
You need to ensure that the data warehouse can be accessed by contoso.com users.
Which two components should you deploy? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

正解:

Question No : 8
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.

Untitled

正解:

Question No : 9
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?

正解:

Question No : 10
You have a Microsoft Azure SQL data warehouse named DW1 that is used only from Monday to Friday.
You need to minimize Data Warehouse Unit (DWU) usage during the weekend.
What should you do?

正解:

Question No : 11
The following materials are read as the reference.

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 tin* available* < ompute nodes.
What should you do?

正解:

Question No : 12
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.

正解:

Question No : 13
You have a Microsoft Azure SQL data warehouse that has a fact table named FactOrder. FactOrder contains three columns named Customer Id. Order Id, and Order DateKey. FactOrder is hash distributed on Customerld. Order Id is the unique identifier for FactOrder. FactOrder contains 3 million rows.
Orders are distributed evenly among different customers from a table named dimCustomers that contains 2 million rows.
You often run queries that join FactOrder and dimCustomers by selecting and groupinq by the OrderDateKey column.
You add 7 million rows to FactOrder. Most of the new records have a more recent OrderDateKey value than the previous records.
You need to reduce the execution time of queries that group on Order DateKey and that join dimCustomers and FactOrder.
What should you do?

正解:

Question No : 14
You have a Microsoft Azure Data Lake Analytics service.
You need to provide a user with the ability to monitor Data Lake Analytics jobs. The solution must minimize the number of permissions assigned to the user.
Which role should you assign to the user?

正解:

Question No : 15
HOTSPOT
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.



正解:

 / 4