nerdexam
Microsoft

70-463 · Question #56

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base. In the mapping configuration, two of the three columns are…

The correct answer is C. Add a domain for the Group column. When a source column has no corresponding domain in the DQS knowledge base, the correct step is to add a new single domain for that column before the mapping can be completed.

Build data quality solutions

Question

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base. In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Group, does not yet have a domain. You need to complete the mapping of the Group column. What should you do?

Options

  • AMap a composite domain to the source column.
  • BCreate a composite domain that includes the Group column.
  • CAdd a domain for the Group column.
  • DAdd a column mapping for the Group column.

How the community answered

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

Why each option

When a source column has no corresponding domain in the DQS knowledge base, the correct step is to add a new single domain for that column before the mapping can be completed.

AMap a composite domain to the source column.

Mapping a composite domain to the source column is incorrect because a composite domain is designed to span multiple columns together, not to serve as the domain for a single unmapped column.

BCreate a composite domain that includes the Group column.

Creating a composite domain that includes the Group column would combine it with other columns into a multi-column domain, which is not the appropriate structure for mapping a single source column that simply lacks its own domain.

CAdd a domain for the Group column.Correct

In the DQS Knowledge Discovery mapping step, every source column must be linked to a domain in the knowledge base. Because the Group column does not yet have a domain, you must add a new domain for it directly from the mapping configuration screen. Once the domain is created, it can be selected as the mapping target for the Group column, completing the configuration.

DAdd a column mapping for the Group column.

Adding a column mapping entry without first creating the domain is not possible in DQS; a domain must exist before it can be selected as the mapping target for a column.

Concept tested: DQS Knowledge Discovery domain mapping for unmapped columns

Source: https://learn.microsoft.com/en-us/sql/data-quality-services/perform-knowledge-discovery

Topics

#DQS Knowledge Discovery#domain mapping#knowledge base#column mapping

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-463 Practice