What should you do?

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?
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 MD
D . Use transactional replication for data synchronization.
E . Create a Subscription View in MD

View Answer

Answer: D