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_kb_editor
0
0
Right. https://msdn.microsoft.com/en-us/hh213045.aspx
0
0
No, it’s operator. The question requires the user must NOT be able to create or change a knowledge base, with the kb_editor can do. So the correct answer is dql_kb_operator.
1
0
dqs_kb_editor
0
0
My Apologies :: correct answer is dqs_administrator
The DQS Administrator (dqs_administrator role) can do everything in the scope of the product. The administrator can edit and execute a project, create and edit a knowledge base, terminate an activity, stop a process within an activity, and can change the configuration and Reference Data Services settings. The DQS Administrator cannot, however, install the server or add new users. The database administrator must do that.
The DQS KB Editor (dqs_kb_editor role) can perform all of the DQS activities, except for administration. The KB Editor can edit and execute a project, and create and edit a knowledge base. They can see the activity monitoring data, but cannot terminate or stop an activity or perform administrative duties.
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.
0
0
DID YOU READ WHAT YOU POSTED?>>>>>>>?!!!
1
0
The question says the user can NOT perform: Knowledge management, knowledge base or admin.
It is dqs_kb_operator
0
0
Spot on. It’s dqs_kb_operator
0
0
dqs_kb_operator
0
0
dqs_kb_operator is correct
0
0
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
Follow the request that user should only open or read permission instead of modify or admin
->dqs_kb_operator
0
0
The Solution given is correct.
0
0