ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-767 All Questions

View all questions & answers for the 70-767 exam
Go to Exam

Exam 70-767 topic 1 question 39 discussion

Actual exam question from Microsoft's 70-767
Question #: 39
Topic #: 1
[All 70-767 Questions]

HOTSPOT -
You have a series of analytic data models and reports that provide insights into the participation rates for sports at different schools. Users enter information about sports and participants into a client application. The application stores this transactional data in a Microsoft SQL Server database. A SQL Server Integration
Services (SSIS) package loads the data into the models.
When users enter data, they do not consistently apply the correct names for the sports. The following table shows examples of the data entry issues.


You need to create a new knowledge base to improve the quality of the sport name data.
How should you configure the knowledge base? To answer, select the appropriate options in the dialog box in the answer area.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Spot 1: Create Knowledge base from: None
Select None if you do not want to base the new knowledge base on an existing knowledge base or data file.
by mohroshdy at Feb. 12, 2020, 12:33 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
mohroshdy
Highly Voted 5 years, 2 months ago
The second selection is Domain Management
upvoted 17 times
...
sissi1130
Most Recent 4 years, 4 months ago
Select Domain Management to create the knowledge base and enter the screens that you use to modify the domains in the knowledge base. Select Knowledge Discovery to create the knowledge base and enter the wizard that you use to analyze a data sample and populate the domains of the knowledge base with the results. Select Matching Policy to create a matching policy and add it to the knowledge base. https://docs.microsoft.com/en-us/sql/data-quality-services/create-a-knowledge-base?view=sql-server-ver15
upvoted 1 times
...
DudeHere
4 years, 5 months ago
After reviewing my cbt nuggets lab, I'm going with NONE and Knowledge Discovery. Domain Management takes place AFTER creating your Knowledge Base
upvoted 1 times
Lukis92
4 years, 5 months ago
Not exactly. You need to add a mapping between the source fields and domains during creating new "Knowledge Discovery". So, you have to create all needed domains at first in "Domain Management" and add rules or just add domains without rules in "Knowledge Discovery". Anyway, I choose Domain Management as the first step to create Knowledge Base.
upvoted 1 times
...
...
DudeHere
4 years, 6 months ago
None - The scenarios does not specify an existing Knowledge Base or DQS File. Domain Management - A Knowledge base consists of domains. Each domain represents the data in a data field. Each value in a data field or domain is known as a domain value. DQS provides the ability to validate, cleanse, match and deduplicate values from any dataset against domain values in the DQS Knowledge base. P 209 in "Implementing a SQL Data Warehouse.
upvoted 1 times
...
kimalto452
4 years, 6 months ago
Some simple explanation of the last 3?
upvoted 1 times
...
Slava_bcd81
4 years, 6 months ago
the second is Knowledge Discovery (see - https://docs.microsoft.com/en-us/sql/data-quality-services/dqs-knowledge-bases-and-domains?view=sql-server-ver15)
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago