Which set of tools should you install?

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?

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



Leave a Reply 6

Your email address will not be published. Required fields are marked *


JackD

JackD

Wrong set of Options.
Option should include Data Quality client and SSMS

Donk

Donk

Answer should be B
Data Quality Client – to do the data cleansing
SSDT – to enable ad-hoc queries

Henry Figgins

Henry Figgins

JackD is right, I saw the correct option elsewhere. ssdt is for the development of di tools in visual studio. It doesn’t run any ad hoc queries

kmr

kmr

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?

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: A