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 *


Youcef

Youcef

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.

DQS KB Editor is the right answer for the second box

Youcef

Youcef

Sorry …. the right answer is 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.

Milen

Milen

No, operator.

“….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”

AlexanderS

AlexanderS

Milen is right!