GENERIC RETAILER
Observe the ER diagram for the Generic Retailer:
Assume that the dimension PRODUCT containing the following columns:
ProductKey (surrogate key)
ProductID
ProductDescription
ProductBrandID
ProductBrandName
ProductCategoryID
ProductCategoryName
is created for the Generic Retailer.This dimension will be used for the following questions citing Generic Retailer PRODUCT dimension.
-A user using an OLAP query (based on the dimensionally modeled data set that contains the ABC Retailer dimension PRODUCT)can drill up from ProductID to ProductCategoryID.

Question

GENERIC RETAILER
Observe the ER diagram for the Generic Retailer:
  Assume that the dimension PRODUCT containing the following columns:
ProductKey (surrogate key)
ProductID
ProductDescription
ProductBrandID
ProductBrandName
ProductCategoryID
ProductCategoryName
is created for the Generic Retailer.This dimension will be used for the following questions citing Generic Retailer PRODUCT dimension.
-A user using an OLAP query (based on the dimensionally modeled data set that contains the ABC Retailer dimension PRODUCT)can drill up from ProductID to ProductCategoryID.

Quizplus · Accepted Answer

The PRODUCT dimension contains ProductID and ProductCategoryID, allowing the user to drill up from ProductID to ProductCategoryID. Therefore, the statement is true.

GENERIC RETAILER Observe the ER Diagram for the Generic Retailer