Microsoft
70-779 · Question #46
You have the data model shown in the exhibit. You need to create a hierarchy from DimProductSubcategory[ProduaSubcategoryName]andDimProduct[ProductName]. What should you do before you create the…
The correct answer is A. To DimProduct, add a calculated column named ProductSubcategoryName that uses the. See the full explanation below for the reasoning.
Question
You have the data model shown in the exhibit. You need to create a hierarchy from DimProductSubcategory[ProduaSubcategoryName]andDimProduct[ProductName]. What should you do before you create the hierarchy?
Exhibit
Options
- ATo DimProduct, add a calculated column named ProductSubcategoryName that uses the
- BTo DimProductSubcategory, add a calculated column named ProductName that uses the
- CCreate a relationship between the tables. To DimProduct, add a calculated column named
- DCreate a relationship between the tables. To DimProductSuhcategory, add a calculated column
How the community answered
(25 responses)- A80% (20)
- B4% (1)
- C12% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.