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 should you deploy?
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 the following table.Which activity cannot complete because of insufficient resources?
DRAG DROP -You have an on-premises Microsoft SQL Server instance named Instance1 that contains a database named DB1.You have a Data Management Gateway named Gateway1.You plan to create a linked service in Azure Data Factory for DB1.You need to connect to DB1 by using standard SQL Server Authentication. You must use a username of User1 and a password of P@$$w0rd89.How should you complete the JSON code? To answer, drag the appropriate values to the correct targets. Each value 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.Select and Place:
HOTSPOT -You are designing a fact table that has 100 million rows and 1,800 partitions. The partitions are defined based on a column named OrderDayKey. The fact table will contain:✑ Data from the last five years✑ A clustered columnstore index✑ A column named YearMonthKey that stores the year and the monthMultiple transformations will be performed on the fact table during the loading process. The fact table will be hash distributed on a column named OrderID.You plan to load the data to a staging table and to perform transformations on the staging table. You will then load the data from the staging table to the final fact table.You need to design a solution to load the data to the fact table. The solution must minimize how long it takes to perform the following tasks:✑ Load the staging table.✑ Transfer the data from the staging table to the fact table.✑ Remove data that is older than five years.✑ Query the data in the fact table.How should you configure the tables? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
You have a Microsoft Azure SQL data warehouse. You have an Azure Data Lake Store that contains from ORC, RC, Parquet, and delimited text files.You need to load the data to the 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.
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 the available compute nodes.What should you do?
