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 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 Management Studio and Distributed Reply Client
B.
Data Quality Client and SQL Server Data Tools
C.
Data Quality Client and Distributed Replay Client
D.
SQL Server Management Studio and Master Data Services
A
What do have to do with Distributed Replay Service/Client?It’s to assess the impact of changes and upgrades by replaying workload activity against a test environment based on a replay trace captured from the current production SQL Server environment.
I would choose D but nothing to do with MDS too. For cleaning data, it need Data Quality Client. 🙁
463 question
A checked
B
Data Quality Client is used for data cleansing.
SSDT has a T-SQL editor to execute ad hoc queries
Yep, B is the correct, at least from what is explained in the 70-462 book by Microsoft.