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 12

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


Ankit

Ankit

dqs_kb_editor

Ankit

Ankit

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.

Islam

Islam

DID YOU READ WHAT YOU POSTED?>>>>>>>?!!!

et

et

The question says the user can NOT perform: Knowledge management, knowledge base or admin.
It is dqs_kb_operator

SQLdba

SQLdba

Spot on. It’s dqs_kb_operator

Ritesh

Ritesh

dqs_kb_operator

sqlninja

sqlninja

dqs_kb_operator is correct

Jeff_Yen

Jeff_Yen

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

Islam

Islam

The Solution given is correct.