P3 Misses 175-200

QUESTION 175 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?

QUESTION 176 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?

QUESTION 177 You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Windows Azure SQL Database. The package has been deployed to a production server that runs Windows Server 2008 R2 and SQL Server 2012. The package fails when executed on the production server. You need to ensure that the package can load the Excel workbook data without errors. You need to use the least amount of administrative effort to achieve this goal. What should you do?

QUESTION 186 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?

QUESTION 189 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?

QUESTION 190 You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database to a server that runs SQL Server 2012. The connection will be used by data flow tasks in multiple SSIS packages. The address of the target Windows Azure SQL Database will be provided by a project parameter. You need to create a solution to meet the requirements by using the least amount of administrative effort. What should you do?

QUESTION 191 A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database. To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP website instead of from a weekly flat file. The public website hosts a comma separated values (CSV) file that contains one row per currency. You need to download the CSV file to the environment. What should you use to retrieve the document from the website?

QUESTION 194 You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database into a SQL Server database. The SSIS package has the following requirements:  Every night, a very large amount of data is imported into the staging database.  Package processing time must be minimized.  The package must run on its own dedicated server when it is deployed to production.  Transaction log activity when data is imported must be minimized. You need to design the package to meet the requirements. Which destination component should you use?