nerdexam
Microsoft

70-779 · Question #46

70-779 Question #46: Real Exam Question with Answer & Explanation

Sign in or unlock 70-779 to reveal the answer and full explanation for question #46. The question stem and answer options stay visible for context.

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

70-779 question #46 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

Unlock 70-779 to see the answer

You've previewed enough free 70-779 questions. Unlock 70-779 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-779 Practice