70-463 · Question #40
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 D. Add a domain for the Team Type column. In DQS Knowledge Discovery, every source column must be mapped to a domain; when no domain exists for a column, you must add a new domain for that column.
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 Team Type, does not yet have a domain. You need to complete the mapping of the Team Type column. What should you do?
Options
- AAdd a column mapping for the Team Type column.
- BMap a composite domain to the source column.
- CCreate a composite domain that includes the Team Type column.
- DAdd a domain for the Team Type column.
How the community answered
(27 responses)- B4% (1)
- C4% (1)
- D93% (25)
Why each option
In DQS Knowledge Discovery, every source column must be mapped to a domain; when no domain exists for a column, you must add a new domain for that column.
Adding a column mapping alone is insufficient because a mapping requires a target domain; without creating a domain first, the mapping cannot be completed for Team Type.
Mapping a composite domain to a single source column is incorrect because composite domains are designed to span multiple related columns, not to handle a single unmapped column.
Creating a composite domain that includes Team Type would bundle it unnecessarily with other domains, adding unneeded complexity for what is a single-column mapping requirement.
In the DQS Knowledge Discovery mapping step, each source column must be associated with a domain that defines the data rules and values for that column. When a column like Team Type has no existing domain, you must add a new domain directly from the mapping configuration page. This creates a dedicated domain that the Knowledge Discovery process will then populate with discovered values.
Concept tested: DQS Knowledge Discovery mapping - adding a new domain
Source: https://learn.microsoft.com/en-us/sql/data-quality-services/perform-knowledge-discovery
Topics
Community Discussion
No community discussion yet for this question.