Microsoft Implementing a SQL Data Warehouse

You have a Microsoft SQL Server Integration Services (SSIS) package that includes the control flow shown in the following diagram. You need to choose the enumerator for the Foreach Loop container. Which enumerator should you use?

You have a server that has Data Quality Services (DQS) installed. You create a matching policy that contains one matching rule. You need to configure the Similarity of Similar percentage that defines a match. Which similarity percentage will always generate a similarity score of 0?

You need to ensure that a downstream system can consume data in a Master Data Services (MDS) system. What should you configure?

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?

A database has tables named Table1, Table2, and Table3. Table1 has a foreign key relationship with Table2. Table2 has a foreign key relationship with Table3. Table1 does not have a direct relationship with Table3. You need to recommend an appropriate dimension usage relationship. What should you recommend?

You have a data warehouse named DW1 that contains 20 years of data. DW1 contains a very large fact table. New data is loaded to the fact table monthly. Many reports query DW1 for the past year of data. Users frequently report that the reports are slow. You need to modify the fact table to minimize the amount of time it takes to run the reports. The solution must ensure that other reports can continue to be generated from DW1. What should you do?

You are the administrator of a Microsoft SQL Server Master Data Services (MDS) model. The model was developed to provide consistent and validated snapshots of master data to the ETL processes by using subscription views. A new model version has been created. You need to ensure that the ETL processes retrieve the latest snapshot of master data. What should you do?

You are developing a Microsoft SQL Server Master Data Services (MDS) solution. The model contains an entity named Product. The Product entity has three user-defined attributes named Category, Subcategory, and Price, respectively. You need to ensure that combinations of values stored in the Category and Subcategory attributes are unique. What should you do?

You have a data warehouse that contains a fact table named Table1 and a Product table named Dim1. Dim1 is configured as shown in the following table. You are adding a second OLTP system to the data warehouse as a new fact table named Table2. The Product table of the OLTP system is configured as shown in the following table You need to modify Dim1 to ensure that the table can be used for both fact tables. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.