Home » Microsoft » 70-767 » What should you recommend?
You manage Master Data Services (MDS). You plan to create entities and attributes and load them with the data. You also plan to match data before loading it into Data Quality Services (DQS).
You need to recommend a solution to perform the actions.
What should you recommend?
A. MDS Add-in for Microsoft Excel
B. MDS Configuration Manager
C. Data Quality Matching
D. MDS repository
Correct Answer: A
Explanation/Reference:
In the Master Data Services Add-in for Excel, matching functionality is provided by Data Quality Services (DQS). This functionality must be enabled to be used.
1. To enable Data Quality Services integration 2. Open Master Data Services Configuration Manager.
3. In the left pane, click Web Configuration.
4. On the Web Configuration page, select the website and web application.
5. In the Enable DQS Integration section, click Enable integration with Data Quality Services.
6. On the confirmation dialog box, click OK.
References: https://docs.microsoft.com/en-us/sql/master-data-services/install-windows/enable-data-quality-services-integration-with-master-data-services
