You have a Microsoft Azure SQL data warehouse to which 1,000 Data Warehouse Units (DWUs) are allocated.You plan to load 10 million rows of data to the data warehouse.You need to load the data in the least amount of time possible. The solution must ensure that queries against the new data execute as quickly as possible.What should you use to optimize the data load?
HOTSPOT -You need to create a Microsoft Azure SQL data warehouse named dw1 that supports up to 10 TB of data.How should you complete the statement? 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 stored in geo-redundant storage.You experience a regional outage.You plan to recover the database to a new region.You need to get a list of the backup files that can be restored to the new region.Which cmdlet should you run?
You manage an on-premises data warehouse that uses Microsoft SQL Server. The data warehouse contains 100 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 a process to replicate the on-premises data warehouse to the Azure SQL data warehouse. The solution must support daily incremental updates and must provide error handling.What should you use?
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?
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?
