Administering a SQL Database Infrastructure — Question 121

You install a Microsoft SQL Server 2016 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, as Master Data Services and Data Quality Client are specifically designed for data management and quality tasks, which are essential for data cleansing. Options A, C, and D do not provide the necessary tools for effective data stewardship, as they lack the Master Data Services component that is critical for managing and maintaining data integrity.