70-463 · Question #35
You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS). You need to complete the post-installation configuration. What should you do?
The correct answer is A. Run the DQSInstaller.exe command.. After installing the DQS server component, you must run DQSInstaller.exe to complete post-installation setup by creating the required DQS databases and configuring the server.
Question
You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS). You need to complete the post-installation configuration. What should you do?
Options
- ARun the DQSInstaller.exe command.
- BInstall the data providers that are used for data refresh.
- CInstall ADOMD.NET.
- DRun the dbimpexp.exe command.
How the community answered
(35 responses)- A94% (33)
- B3% (1)
- D3% (1)
Why each option
After installing the DQS server component, you must run DQSInstaller.exe to complete post-installation setup by creating the required DQS databases and configuring the server.
DQSInstaller.exe is the mandatory post-installation tool that creates the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases and configures the SQL Server instance to support Data Quality Services. Without running this executable, the Data Quality Server is not functional. It must be run from the command line with administrative privileges after the SQL Server DQS feature is installed.
Installing data providers for data refresh is a prerequisite step for SQL Server Analysis Services tabular models, not a DQS post-installation requirement.
ADOMD.NET is a client library used to connect to Analysis Services, not a component required for DQS post-installation configuration.
dbimpexp.exe is a SQL Server Master Data Services utility used for importing and exporting model data, not related to DQS installation.
Concept tested: DQS post-installation configuration using DQSInstaller.exe
Source: https://learn.microsoft.com/en-us/sql/data-quality-services/install-data-quality-services
Topics
Community Discussion
No community discussion yet for this question.