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
This is a mystery as well
ssms is good for adhoc querying
mds is good for marrying disparate data sources
dqs is good for data cleansing
and ssdt is good for developers making database applications in visual studio. It seems irrelevant to the day to day job of an ETL person.
D seems like the best answer if you can use mds for basic tranform. This seems more like a 463 question
Also, look at this!
http://www.aiotestking.com/microsoft/which-set-of-tools-should-you-install-3/
These answers were all wrong
A
I think so. but cannot find details
You install a Microsoft SQL Server 2012 instance. The instance will store data extracted from two
database running on windows Azure SQL Database.
You hire a data steward to perform interactive data cleaning 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.
Master Data Services and Data Quality Client
C.
Data Quality Client and Distributed Replay Client
D.
Data Quality Client and SQL Server Management Studio
D
You install a Microsoft SQL Server 2012 instance. The instance will store data extracted from two
database running on windows Azure SQL Database.
You hire a data steward to perform interactive data cleaning 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.
Master Data Services and Data Quality Client
C.
Data Quality Client and Distributed Replay Client
D.
Data Quality Client and SQL Server Management Studio