You install a Microsoft SQL Server instance.
The instance will store data extracted from two databases running on Microsoft Azure SQL Database.
You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the data.
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?
A. SQL Server DATA Tools and Distributed Replay Client
B. Data Quality Client and SQL Server DATA Tools
C. Master Data Services and SQL Server Data Tools
D. Data Quality Client and Distributed Replay Client
Correct Answer: B
Explanation/Reference:
Explanation:
Data Quality Client is a standalone application that enables you to perform knowledge management, data quality projects, and administration in one user interface.
The application is designed for both data stewards and DQS administrators. It is a stand-alone executable file that performs knowledge discovery, domain management, matching policy creation, data cleansing, matching, profiling, monitoring, and server administration.
SQL Server Data Tools is a modern development tool that you can download for free to build SQL Server relational databases, Azure SQL databases, Integration
Services packages, Analysis Services data models, and Reporting Services reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.
Incorrect Answers:
A, D: The SQL Server Distributed Replay feature helps you assess the impact of future SQL Server upgrades. You can also use it to help assess the impact of hardware and operating system upgrades, and SQL Server tuning.
C: Master Data Services enables you to manage a master set of your organization’s data. You can organize the data into models, create rules for updating the data, and control who updates the data.
References:
https://technet.microsoft.com/en-us/library/ff877917(v=sql.110).aspx
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
