Category «70-776»

Exam 70-776: Performing Big Data Engineering on Microsoft Cloud Services (beta)

You need to implement a process to replicate the on-premises data warehouse to the Azure SQL data warehouse.

You manage an on-premises data warehouse that uses Microsoft SQL Server. The data warehouse contains100 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 …

Which two actions should you perform?

You have an on-premises data warehouse that uses Microsoft SQL Server 2016. All the data in the datawarehouse comes from text files stored in Azure Blob storage. The text files are imported into the datawarehouse by using SQL Server Integration Services (SSIS). The text files are not transformed.You need to migrate the data to an …

Which dynamic management view should you review for each requirement?

DRAG DROPYou 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 appropriatedynamic management views …

You need to get the following information: – The top 10

DRAG DROPYou 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 queryWhich dynamic management view should you use for each piece of information? To answer, drag theappropriate dynamic management views to the correct pieces of information. Each …

Which three actions should you perform in sequence?

DRAG DROPYou have a Microsoft Azure SQL data warehouse named DW1. Data is located 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 andmust minimize downtime.Which three actions should …

Which disk configuration should you use?

You plan to deploy a Microsoft Azure virtual machine that will a host data warehouse. The data warehouse willcontain a 10-TB database.You need to provide the fastest read and writes times for the database.Which disk configuration should you use? A. storage pools with mirrored disks B. RAID 5 volumes C. spanned volumes D. stripped volumesE. …

Which two components should you deploy?

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. A. Azure AD …

What should you create?

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 Native Active Directory app registration B. …

You need to create a dataset in Microsoft Azure Data Factory that meets the following requirements:

DRAG DROPYou need to create a dataset in Microsoft Azure Data Factory that meets the following requirements:Receives data from Azure Data FactoryUses Azure Blob storageWrites data to a blob storage path based on the current year and monthHow should you complete the JSON code? To answer, drag the appropriate values to the correct targets. Eachvalue …