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.)
You need to develop a Transact-SQL (T-SQL) script to meet these requirements
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.)
DQS_MAIN
dqs_kb_administrator
…Terminate an activity or perform administrative duties…
dqs_kb_administrator???
really???
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
-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-