nerdexam
Microsoft

70-463 · Question #57

You are installing SQL Server Data Quality Services (DQS). You need to give specific users access to the Data Quality Server. Which SQL Server application should you use?

The correct answer is C. SQL Server Management Studio. After installing DQS, SQL Server Management Studio is the correct tool to manage user access by assigning users to the appropriate DQS database roles.

Build data quality solutions

Question

You are installing SQL Server Data Quality Services (DQS). You need to give specific users access to the Data Quality Server. Which SQL Server application should you use?

Options

  • ASQL Server Configuration Manager
  • BSQL Server Data Tools
  • CSQL Server Management Studio
  • DData Quality Client

How the community answered

(43 responses)
  • A
    2% (1)
  • B
    5% (2)
  • C
    93% (40)

Why each option

After installing DQS, SQL Server Management Studio is the correct tool to manage user access by assigning users to the appropriate DQS database roles.

ASQL Server Configuration Manager

SQL Server Configuration Manager manages SQL Server services, network protocols, and aliases - it has no functionality for managing database user access or role membership.

BSQL Server Data Tools

SQL Server Data Tools (SSDT) is a development IDE for building database, SSIS, SSRS, and SSAS projects, not a tool for administering server-level security or user permissions.

CSQL Server Management StudioCorrect

SQL Server Management Studio (SSMS) is used to manage SQL Server security and role membership. To grant DQS access, an administrator uses SSMS to add users to the dqs_administrator, dqs_kb_editor, or dqs_kb_operator roles in the DQS_MAIN database, which controls what each user can do on the Data Quality Server.

DData Quality Client

Data Quality Client is the end-user application for performing DQS operations such as knowledge base management and running data quality projects, not for administering server-level user access.

Concept tested: Managing DQS user security with SSMS

Source: https://learn.microsoft.com/en-us/sql/data-quality-services/administer-dqs-user-security

Topics

#DQS installation#user access#Data Quality Server#SQL Server Management Studio

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice