Implementing a SQL Data Warehouse — Question 16

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are the administrator of a Microsoft SQL Server Master Data Services (MDS) instance. The instance contains a model named Geography and a model named Customer. The Geography model contains an entity named CountryRegion.
You need to ensure that the CountryRegion entity members are available in the customer model.
Solution: Create a CountryRegion entity in the Customer model. In the Geography model, create a subscription view and load data to the entity-based staging table that contains the CountryRegion entity.
Does this meet the goal?

Answer options

Correct answer: B

Explanation

The proposed solution does not meet the goal because simply creating a CountryRegion entity in the Customer model does not automatically link or provide access to the members from the Geography model. A more effective approach would involve proper integration or referencing mechanisms between the two models to ensure data availability.