Microsoft
70-463 · Question #57
70-463 Question #57: Real Exam Question with Answer & Explanation
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.
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
Explanation
After installing DQS, SQL Server Management Studio is the correct tool to manage user access by assigning users to the appropriate DQS database roles.
Common mistakes.
- A. SQL Server Configuration Manager manages SQL Server services, network protocols, and aliases - it has no functionality for managing database user access or role membership.
- B. 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.
- D. 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
Reference. https://learn.microsoft.com/en-us/sql/data-quality-services/administer-dqs-user-security
Community Discussion
No community discussion yet for this question.