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.)

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:



Leave a Reply 4

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


jgf

jgf

DQS_MAIN
dqs_kb_administrator

…Terminate an activity or perform administrative duties…

name

name

dqs_kb_administrator???
really???

Min

Min

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

henrov

henrov

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