DRAG DROP
Your company is evaluating the data cleansing capabilities of SQL Server Data Quality
Services (DQS).
A stand-alone server will be used to host DQS, as well as all related services necessary to
run this service.
You need to install the DQS components on the server by using the minimum amount of
steps possible. You also need to grant permissions to a login named DataStewards to
enable DataStewards to edit and execute DQS projects.
Which four actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Answer: See the explanation.
Explanation:
Box 1:Box 2:
Box 3:
Box 4:
Note:
Step 1 -2:
* SQL Server Data Quality Services (DQS) is a new feature in SQL Server 2012 that
contains the following two components: Data Quality Server and Data Quality Client.* You have to use the SQL Server 2012 Setup to install DQS components. When you run the
SQL Server Setup, you have to go through a series of installation wizard pages to select
appropriate options based on your requirements.
/ Feature Selection
Data Quality Services under Database Engine Services to install the Data Quality Server.
Data Quality Client to install Data Quality Client.
Step 3-4:
* The Data Quality Services (DQS) security infrastructure is based upon the SQL Server
security infrastructure. A database administrator grants a user a set of permissions by
associating the user with a DQS role. Doing so determines the DQS resources that the user
has access to and the functional activities that the user is allowed to perform.
* There are four roles for DQS. One is the database administrator (DBA) who deals primarily
with product installation, database maintenance, and user management. This role primarily
uses the SQL Server Management Studio, rather than within the Data Quality Client
application. Their server role is sysadmin.
The three other roles are information workers, data stewards who use the product directly by
working in the Data Quality Client application. These roles include the following:
/ The DQS Administrator (dqs_administrator role) can do everything in the scope of the
product.
/ The DQS KB Editor (dqs_kb_editor role) can perform all of the DQS activities, except for
administration.
/ The DQS KB Operator (dqs_kb_operator role) can edit and execute a project. They cannot
perform any kind of knowledge management; they cannot create or change a knowledge
base. They can see the activity monitoring data, but cannot terminate an activity or perform
administrative duties.
Box1 and Box2 must be reversed.
You can’t run DQS Installer without DQS and Database Engine Service
https://msdn.microsoft.com/en-us/library/hh231682.aspx
And in box4 is dqs_kb_operator (read the notes)
Answer is right. You have to get DQSInstaller.exe from MSSQL2012 installation. So to install DQS,BOX1,Box2,Box3 and DQS_kb_Operator
last step should be DQS_kb_Operator
Yes dqs_kb_operator is right and box 1 and box 2 must be exchange.
Correct Answer should be Box2, Box1, Box3, dqs_kb_operator
For the following reasons:
1.) Running DQSInstaller.exe is a Post-Installation task
2.) DataStewards are only allowed to edit and execute projects(kb_operator role) if you assign them kb_editor role in addition to editing and executing projects they will also be able to create and edit a knowledge base which is more than what the question required.
checkout these links;
https://msdn.microsoft.com/en-us/library/gg492277(v=sql.110).aspx
https://msdn.microsoft.com/en-us/library/hh213045(v=sql.110).aspx
yes correct!
dqs_kb_operator
DQS installation is a three-part process:
1-Pre-Installation Tasks : Verify system requirements before you install DQS.
2-Data Quality Services Installation Tasks : Install DQS by using SQL Server Setup.
3-Post-Installation Tasks : Perform these tasks after finishing with the SQL Server Setup to finish installing DQS.