You are the data steward for a Business Intelligence project.You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been created to support this project.You need to produce the CSV file with the least amount of development effort.What should you do?
You manage a SQL Server Master Data Services (MDS) environment.A new application requires access to the product data that is available in the MDS repository.You need to design a solution that gives the application access to the product data with the least amount of development effort.What should you do?
You are installing SQL Server Data Quality Services (DQS).You need to give users belonging to a specific Active Directory group access to the Data Quality Server.Which SQL Server application should you use?
You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base.In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Team Type, does not yet have a domain.You need to complete the mapping of the Team Type column.What should you do?
You are maintaining a Data Quality Services (DQS) environment. The production server failed and a new server has been set up. The DQS databases are restored to a new server. All the appropriate permissions are granted.DQS users are experiencing issues connecting to the new Data Quality Server.You need to enable users to connect to the new server.Which Surface Area Configuration property should you enable?
You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence DevelopmentStudio (BIDS).The package includes custom scripts that must be upgraded.You need to upgrade the package to SQL Server 2012.Which tool should you use?
