Microsoft Exam Questions

You need to design a solution that gives the application access to the product data with the least a

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 ofdevelopment effort. What should you do?

A.
Use sp_addlinkedserver to add a linked server to access the MDS database tables directly.

B.
Create an OLE DB connection string that sets the Provider property to MDS.

C.
Use transactional replication for data synchronization.

D.
Create a Subscription View in MDS.