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 warehouse.You connect to the data warehouse.You need to ensure that the user can access the highest resource class.Which statement should you execute?
You have a Microsoft Azure Data Factory pipeline that has an activity.You need to change the timeout to three hours.Which section of the pipeline's JSON document should you modify?
DRAG DROP -You need to create a dataset in Microsoft Azure Data Factory that meets the following requirements:✑ Receives data from Azure Data Factory✑ Uses Azure Blob storage✑ Writes 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. 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:
DRAG DROP -You have an Apache Hive database in a Microsoft Azure HDInsight cluster.You create an Azure Data Factory named DF1.You need to transform the data in the Hive database and to output the data to Azure Blob storage.Which three cmdlets should you run in sequence? To answer, move the appropriate cmdlets from the list of cmdlets to the answer area and arrange them in the correct order.Select and Place:
HOTSPOT -You are creating a series of activities for a Microsoft Azure Data Factory. The first activity will cope an input dataset named Dataset1 to an output dataset namedDataset2. The second activity will cope a dataset named Dataset3 to an output dataset named Dataset4.Dataset1 is located in Azure Table Storage. Dataset2 is located in Azure Blob storage. Dataset3 is located in an Azure Data Lake store. Dataset4 is located in anAzure SQL data warehouse.You need to configure the inputs for the second activity. The solution must ensure that Dataset3 is copied after dataset2 is created.How should you complete the JSON code for the second activity? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
Note: This question is part of series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You are troubleshooting a slice in Microsoft Azure Data Factory for a dataset that has been in a waiting state for the last three days. The dataset should have been ready two days ago.The dataset is being produced outside the scope of Azure Data Factory. The dataset is defined by using the following JSON code.You need to modify the JSON code to ensure that the dataset is marked as ready whenever there is data in the data store.Solution: You add conditions to the policy.Does this meet the goal?
