Administering Microsoft SQL Server 2012/2014 Databases — Question 44

You install a Microsoft SQL Server 2012 instance.
The instance will store data extracted from two databases running on Windows Azure SQL Database.
You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the database.
You need to ensure that the data steward is given the correct client tools to perform these tasks.
Which set of tools should you install?

Answer options

• A. SQL Server Management Studio and Distributed Replay Client
• B. Master Data Services and Data Quality Client
• C. Data Quality Client and Distributed Replay Client
• D. Data Quality Client and SQL Server Management Studio

Correct answer: B

Explanation

The correct answer is B because Master Data Services and Data Quality Client are specifically designed for managing and ensuring the quality of data. The other options do not provide the necessary tools focused on data quality management and cleansing, making them unsuitable for the data steward's tasks.