You are creating a SQL Server Master Data Services (MDS) model. This model is used to store a master list of
products. An attribute must be added to the Productentity to define the sales manager responsible foreach
product. You need to create an attribute in the Product entity that prevents users from entering invalid sales
manager values. Which type of attribute should you create?
A.
Derived
B.
Domain-based
C.
User-defined
D.
Parent
E.
Explicit
F.
Recursive
Explanation:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/bb190163.aspx
http://msdn.microsoft.com/en-us/library/ee633737.aspx
http://msdn.microsoft.com/en-us/library/ee633759.aspx
http://msdn.microsoft.com/en-us/library/ee633745.aspx
http://msdn.microsoft.com/en-us/library/ee633724.aspx
http://msdn.microsoft.com/en-us/library/ee633733.aspx
http://msdn.microsoft.com/en-us/library/ff487058.aspx
B.
Domain-based