PrepAway - Latest Free Exam Questions & Answers

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

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?

PrepAway - Latest Free Exam Questions & Answers

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.

5 Comments on “You need to design a solution that gives the application access to the product data with the least amount ofde


Leave a Reply