nerdexam
Microsoft

70-463 · Question #39

You are installing SQL Server Data Quality Services (DQS). You need to give users belonging to a specific Active Directory group access to the Data Quality Server. Which SQL Server application…

The correct answer is D. SQL Server Management Studio with administrative credentials. DQS user access is managed through SQL Server logins, which are created and managed using SQL Server Management Studio with administrative credentials.

Build data quality solutions

Question

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

Options

  • AData Quality Client with administrative credentials
  • BSQL Server Configuration Manager with local administrative credentials
  • CSQL Server Data Tools with local administrative permissions
  • DSQL Server Management Studio with administrative credentials

How the community answered

(35 responses)
  • A
    3% (1)
  • C
    6% (2)
  • D
    91% (32)

Why each option

DQS user access is managed through SQL Server logins, which are created and managed using SQL Server Management Studio with administrative credentials.

AData Quality Client with administrative credentials

The Data Quality Client application is used for data quality operations such as cleansing and knowledge base management, not for managing SQL Server logins or role memberships.

BSQL Server Configuration Manager with local administrative credentials

SQL Server Configuration Manager is used to manage SQL Server services, network protocols, and connectivity settings, not user logins or database permissions.

CSQL Server Data Tools with local administrative permissions

SQL Server Data Tools is an IDE for developing SSIS, SSAS, and SSRS projects and does not provide functionality for managing server-level logins or DQS role assignments.

DSQL Server Management Studio with administrative credentialsCorrect

DQS security relies on SQL Server roles in the DQS_MAIN database, specifically dqs_administrator, dqs_kb_editor, and dqs_kb_operator. To grant an Active Directory group access to the Data Quality Server, you use SQL Server Management Studio to create a new SQL Server login for the AD group and then map it to the appropriate DQS database role. Administrative credentials are required because login creation is a server-level operation.

Concept tested: Granting Active Directory group access to DQS via SSMS

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

Topics

#DQS security#Active Directory groups#SQL Server Management Studio#permissions

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-463 Practice