nerdexam
Microsoft

70-463 · Question #59

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 C. Run the Data Quality Server Installer. After installing the DQS binaries via SQL Server setup, you must run DQSInstaller.exe to complete post-installation configuration and initialize the required DQS databases.

Build data quality solutions

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

  • AInstall the Analysis Services OLE DB Provider.
  • BMake the data available for DQS operations.
  • CRun the Data Quality Server Installer.
  • DInstall ADOMD.NET.

How the community answered

(23 responses)
  • A
    4% (1)
  • C
    91% (21)
  • D
    4% (1)

Why each option

After installing the DQS binaries via SQL Server setup, you must run DQSInstaller.exe to complete post-installation configuration and initialize the required DQS databases.

AInstall the Analysis Services OLE DB Provider.

The Analysis Services OLE DB Provider is a connectivity component for SSAS and is not required for DQS post-installation configuration.

BMake the data available for DQS operations.

Making data available for DQS operations is an ongoing operational task performed after the server is fully installed and configured, not a post-installation step.

CRun the Data Quality Server Installer.Correct

Running the Data Quality Server Installer (DQSInstaller.exe) is the mandatory post-installation step that creates and initializes the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases on the SQL Server instance. Without executing this installer, the DQS server is non-functional even though the binaries are present.

DInstall ADOMD.NET.

ADOMD.NET is a managed client library for connecting to Analysis Services and has no role in DQS server setup.

Concept tested: DQS Data Quality Server post-installation configuration

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

Topics

#DQS installation#Data Quality Server#post-installation configuration#DQS setup

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-463 Practice