Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.You are implementing the data load process for a data warehouse.The data warehouse uses daily partitions to store data added or modified during the last 60 days. Older data is stored in monthly partitions.You need to ensure that the ETL process can modify the partition scheme during the data load process.Which component should you use to load the data to the data warehouse?
You are building a server to host a data warehouse.The planned disk activity for the data warehouse is five percent write activity and 95 percent read activity.You need to recommend a storage solution for the data files of the data warehouse. The solution must meet the following requirements:✑ Ensure that the data warehouse is available if two disks fail.✑ Minimize hardware costs.Which RAID configuration should you recommend?
You have a data warehouse named DW1.In DW1, you plan to create a table named Table1 that will be partitioned by hour. Table1 will contain the last three hours of data.You plan to implement a sliding window process for inserting data into Table1.You need to recommend the minimum number of partitions that must be included in Table1 to support the planned implementation. The solution must minimize the number of transaction log records created during the insert process.How many partitions should you recommend?
DRAG DROP -You need to recommend a storage solution for a data warehouse that minimizes load times. The solution must provide availability if a hard disk fails.Which RAID configuration should you recommend for each type of database file? To answer, drag the appropriate RAID configurations to the correct database file types. Each RAID configuration 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:
You plan to deploy several Microsoft SQL Server Integration Services (SSIS) packages to a highly available SQL Server instance. The instance is configured to use an AlwaysOn availability group that has two replicas.You need to identify which deployment method must be used to ensure that the packages are always accessible from all the nodes in the availability group.Which deployment method should you use for the packages?
Note: This question is part of a 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 have a Microsoft Azure SQL Data Warehouse instance that must be available six months a day for reporting.You need to pause the compute resources when the instance is not being used.Solution: You use SQL Server Configuration Manager.Does the solution meet the goal?
