Microsoft
70-466 · Question #82
70-466 Question #82: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #82. The question stem and answer options stay visible for context.
Build a tabular data model
Question
You need to create the hierarchy in the AdhocReports project. What should you do?
Options
- AMulti-select all of the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
- BUse the RELATED() function to consolidate the columns in the DimSalesTerritory table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
- CUse the RELATEDTABLE() function to consolidate the tables, multi-select the columns in the hierarchy, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
- DUse the RELATED() function to consolidate the columns in the DimEmployee table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 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.
Topics
#tabular hierarchy#RELATED function#DAX#dimension columns