Microsoft-Implementing a Data Warehouse with Microsoft SQL Server 2012 Set 3

You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages. All packages in the project must connect to the same database. The server name for the database must be set by using a parameter named ServerParam when any package in the project is executed. You need to develop this project with the least amount of development effort. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages. All packages in the project must connect to the same database. The server name for the database must be set by using a parameter named ParamConnection when any package in the project is executed. You need to develop this project with the least amount of development effort. What should you do? (Each answer presents a part of the solution. Choose all that apply.)

You are deploying a new SQL Server Integration Services (SSIS) package to five servers. The package must meet the following requirements: .NET Common Language Runtime (CLR) integration in SQL Server must not be enabled. The Connection Managers used in the package must be configurable without editing and redeploying the package. The deployment procedure must be automated as much as possible. Performance must be maximized. You need to set up a deployment strategy that meets the requirements. What should you do?

You develop a SQL Server Integration Services (SSIS) package that imports Windows Azure SQL Database data into a data warehouse every night. The Windows Azure SQL Database data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large. If no acceptable match is found, the Fuzzy Lookup transformation passes a null value. The current setting for the Fuzzy Lookup similarity threshold is 0.50. Many values are incorrectly matched. You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance. What should you do?

You are preparing to install SQL Server 2012 Master Data Services (MDS). You need to ensure that the database requirements are met. What should you install?

You are installing the Data Quality Server component of Data Quality Services. You need to provision the hardware and install the software for the server that runs the Data Quality Server. You must ensure that the minimum Data Quality Server prerequisites are met. What should you do?

You are the administrator of a Data Quality Server. The server hosting the Data Quality Server had a hardware failure. You need to restore the Data Quality Server to another server. You have a recent backup of all the required databases. Which two actions should you perform? Each correct answer presents part of the solution.

You are designing an extract, transform and load (ETL) solution that loads data into dimension tables. The ETL process involves many transformation steps. You need to ensure that the design can provide: Auditing information for compliance and business user acceptance Tracking and unique identification of records for troubleshooting and error correction What should you do?

To support the implementation of new reports, Active Directory data will be downloaded to a SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package. The following requirements must be met: All the user information for a given Active Directory group must be downloaded to a SQL Server table. The download process must traverse the Active Directory hierarchy recursively. You need to configure the package to meet the requirements by using the least development effort. What should you use?

You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of the data. You need to use DQS profiling to obtain the required statistics. Which DQS activity should you use?