exam questions

Exam 70-463 All Questions

View all questions & answers for the 70-463 exam

Exam 70-463 topic 3 question 23 discussion

Actual exam question from Microsoft's 70-463
Question #: 23
Topic #: 3
[All 70-463 Questions]

DRAG DROP -
Your company is evaluating the data cleansing capabilities of SQL Server Data Quality Services (DQS).
A stand-alone server will be used to host DQS, as well as all related services necessary to run this service.
You need to install the DQS components on the server by using the minimum amount of steps possible. You also need to grant permissions to a login named
DataStewards to enable DataStewards to edit and execute DQS projects.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Note:
Step 1-2:
* SQL Server Data Quality Services (DQS) is a new feature in SQL Server 2012 that contains the following two components: Data Quality Server and Data Quality
Client.
* You have to use the SQL Server 2012 Setup to install DQS components. When you run the SQL Server Setup, you have to go through a series of installation wizard pages to select appropriate options based on your requirements.
/ Feature Selection
Data Quality Services under Database Engine Services to install the Data Quality Server.
Data Quality Client to install Data Quality Client.
Step 3-4:
* The Data Quality Services (DQS) security infrastructure is based upon the SQL Server security infrastructure. A database administrator grants a user a set of permissions by associating the user with a DQS role. Doing so determines the DQS resources that the user has access to and the functional activities that the user is allowed to perform.
* There are four roles for DQS. One is the database administrator (DBA) who deals primarily with product installation, database maintenance, and user management. This role primarily uses the SQL Server Management Studio, rather than within the Data Quality Client application. Their server role is sysadmin.
The three other roles are information workers, data stewards who use the product directly by working in the Data Quality Client application. These roles include the following:
✑ The DQS Administrator (dqs_administrator role) can do everything in the scope of the product.
✑ The DQS KB Editor (dqs_kb_editor role) can perform all of the DQS activities, except for administration.
✑ 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.
References: http://msdn.microsoft.com/en-gb/library/gg492277(v=sql.110).aspx

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Kasta
Highly Voted 5 years, 10 months ago
I think that box4 should be - dqs_kb_operator
upvoted 6 times
...
mickeygeorge
Most Recent 4 years, 10 months ago
I agree dqs_kb_operator can edit and execute projects.Thats all the question asks for so why put them in the dqs_kb_editor.You are giving them unecessary priviliges that are not asked for.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...