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?…
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…
You have a Microsoft Azure Data Factory that recently ran several activities in parallel. You receive alerts indicating that there are insufficient resources. From the Activity Windows list in the Monitoring and Management app, you discover the statuses described in…
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? A. From the Azure CLI, run…
You need to define an input dataset for a Microsoft Azure Data Factory pipeline. Which properties should you include when you define the dataset? A. name, type, typeProperties, and availability B. name, typeProperties, structure, and availability C. name, policy, structure,…
You have an on-premises Microsoft SQL Server instance. You plan to copy a table from the instance to a Microsoft Azure Storage account. You need to ensure that you can copy the table by using Azure Data Factory. Which service…
You have a Microsoft Azure SQL data warehouse. You have an Azure Data Lake Store that contains data from ORC, RC, Parquet, and delimited text files. You need to load the data to the data warehouse in the least amount…
You have a fact table named PowerUsage that has 10 billion rows. PowerUsage contains data about customer power usage during the last 12 months. The usage data is collected every minute. PowerUsage contains the columns configured as shown in the…
You have a Microsoft Azure SQL data warehouse You need to configure Data Warehouse Units (DWUs) to ensure that you have six compute nodes. The solution must minimize costs. Which value should set for the DWUs? A. DW200 B. DW400…
You have an extract, transformation, and load (ETL) process for a Microsoft Azure SQL data warehouse. You run the following statements to create the logon and user for an account that will run the nightly data load for the data…