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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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. […]

Read More

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 […]

Read More

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. […]

Read More