070-776 무료 덤프문제 온라인 액세스
| 시험코드: | 070-776 |
| 시험이름: | Engineering Data with Microsoft Cloud Services |
| 인증사: | Microsoft |
| 무료 덤프 문항수: | 92 |
| 업로드 날짜: | 2025-08-30 |
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?
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?
You have a Microsoft Azure SQL data warehouse.
You plan to reference data from Azure Blob storage. The data is stored in the GZIP compressed format. The blob storage requires authentication.
You create a master key for the data warehouse and a database schema.
You need to reference the data without importing the data to the data warehouse.
Which four 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.
You plan to use Microsoft Azure Data factory to copy data daily from an Azure SQL data warehouse to an Azure Data Lake Store.
You need to define a linked service for the Data Lake Store. The solution must prevent the access token from expiring.
Which type of authentication should you use?
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?