DRAG DROP
You are the administrator for a Data Quality Server. You are adding a user who must have
permission to:
Edit and execute a project
View the activity monitoring data
This user must not be able to:
Perform any kind of knowledge management
Create or change a knowledge base
Terminate an activity or perform administrative duties
You need to develop a Transact-SQL (T-SQL) script to meet these requirements.
What should you do? (To answer, drag the appropriate code segment or segments to the
correct location or locations in the answer area.)
Answer: 
DQS_MAIN
dqs_kb_administrator
…Terminate an activity or perform administrative duties…
0
0
dqs_kb_administrator???
really???
0
0
Nope. its right. dqs_kb_operator role
Question stated that
Permission to: –
Edit and execute a project – YES for DQS KB Operator
View the activity monitoring data – YES for DQS KB Operator
This user must not be able to: –
Perform any kind of knowledge management – NO for DQS KB Operator
Create or change a knowledge base – NO for DQS KB Operator
Terminate an activity or perform administrative duties – NO for DQS KB Operator
https://technet.microsoft.com/en-us/library/hh213045(v=sql.110).aspx
1
0
-DQS_MAIN
-dqs_kb_operator
This user must not be able to:
(…)
Terminate an activity or perform administrative duties
I think JGF overlooked the part where it says ‘ must NOT be able to-
0
0