nerdexam
Microsoft

70-463 · Question #58

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 D. Create a Subscription View in MDS. MDS Subscription Views are the built-in mechanism for exposing MDS repository data to external applications with minimal development effort.

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

  • AUse sp_addlinkedserver to add a linked server to access the MDS database tables directly.
  • BCreate an OLE DB connection string that sets the Provider property to MDS.
  • CUse transactional replication for data synchronization.
  • DCreate a Subscription View in MDS.

How the community answered

(12 responses)
  • C
    8% (1)
  • D
    92% (11)

Why each option

MDS Subscription Views are the built-in mechanism for exposing MDS repository data to external applications with minimal development effort.

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

Accessing internal MDS database tables directly via a linked server is unsupported and requires deep knowledge of the undocumented internal schema, resulting in more development effort and fragility.

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

There is no OLE DB provider with a 'MDS' Provider property value - this is not a valid or supported connection method for MDS data.

CUse transactional replication for data synchronization.

Transactional replication involves configuring a publisher, distributor, and subscriber with ongoing synchronization maintenance, which is significantly more development and administrative effort than creating a Subscription View.

DCreate a Subscription View in MDS.Correct

A Subscription View is created directly within the MDS web application and generates a SQL Server view over the MDS repository, exposing member and attribute data in a flat, queryable format. An external application can then query this view using standard SQL or any data access technology, requiring no custom schema mapping or replication setup, which minimizes development effort.

Concept tested: Exporting MDS data using Subscription Views

Source: https://learn.microsoft.com/en-us/sql/master-data-services/overview-exporting-data-master-data-services

Topics

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

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-463 Practice