nerdexam
Microsoft

70-463 · Question #38

You manage a SQL Server Master Data Services (MDS) environment. A new application requires access to the product data that is available in the MDS repository. You need to design a solution that…

The correct answer is A. Create a Subscription View in MDS. You create a subscription view to export Master Data Services data to a subscribing system such You use the subscribing system to view the data in the Master Data Services database. master-data-services?view=sql-server-2017

Build data quality solutions

Question

You manage a SQL Server Master Data Services (MDS) environment. A new application requires access to the product data that is available in the MDS repository. You need to design a solution that gives the application access to the product data with the least amount of development effort. What should you do?

Options

  • ACreate a Subscription View in MDS.
  • BAccess the product entity tables in the MDS database directly.
  • CUse SQL Server Integration Services (SSIS) to extract the data and put it in a staging
  • DUse change data capture on the product entity tables.

How the community answered

(22 responses)
  • A
    91% (20)
  • C
    5% (1)
  • D
    5% (1)

Explanation

You create a subscription view to export Master Data Services data to a subscribing system such You use the subscribing system to view the data in the Master Data Services database. master-data-services?view=sql-server-2017

Topics

#Master Data Services#Subscription View#data access#MDS integration

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice