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 B. Run the DQSInstaller.exe command.. Installing SQL Server Data Quality Services places the DQS binaries on disk, but does not create or configure the required DQS databases. Running DQSInstaller.exe (located in the SQL Server Binn folder) is the mandatory post-installation step that creates and initializes the thre

Build data quality solutions

Question

Options

AInstall the Analysis Services OLE DB Provider.
BRun the DQSInstaller.exe command.
CRun the Configuration component in the Data Quality Client.
DMake the data available for DQS operations.

How the community answered

(58 responses)

A
3% (2)
B
93% (54)
C
2% (1)
D
2% (1)

Explanation

Installing SQL Server Data Quality Services places the DQS binaries on disk, but does not create or configure the required DQS databases. Running DQSInstaller.exe (located in the SQL Server Binn folder) is the mandatory post-installation step that creates and initializes the three DQS databases: DQS_MAIN (knowledge bases and operational data), DQS_PROJECTS (data quality projects), and DQS_STAGING_DATA (staging area). Until DQSInstaller.exe is run, the Data Quality Client cannot connect to Data Quality Server and no DQS operations can be performed. Installing the Analysis Services OLE DB Provider is unrelated to DQS setup.

Topics

#DQSInstaller.exe#DQS post-installation#Data Quality Server#DQS configuration

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice