nerdexam
Exams70-467Questions#49
Microsoft

70-467 · Question #49

70-467 Question #49: Real Exam Question with Answer & Explanation

The correct answer is C: Set the Usage property to Parent.. From scenario: The Sales measure group is based on the FactSales table. The Sales Plan measure group is based on the FactSalesPlan table. The Sales Plan measure group has been configured with a multidimensional OLAP (MOLAP) writeback partition. Both measure groups use MOLAP parti

Question

You need to configure the Scenario attribute to ensure that business users appropriately query the Sales Plan measure. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

Options

  • ASet the AttributeHierarchyVisible property to False.
  • BSet the IsAggregatable property to False.
  • CSet the Usage property to Parent.
  • Dset the DefaultMember property to the Forecast member.
  • ESet the AttributeHierarchyEnabled property to False.
  • FSet the RootMemberIf property to ParentIsMissing.

Explanation

  • From scenario: The Sales measure group is based on the FactSales table. The Sales Plan measure group is based on the FactSalesPlan table. The Sales Plan measure group has been configured with a multidimensional OLAP (MOLAP) writeback partition. Both measure groups use MOLAP partitions, and aggregation designs are assigned to all partitions.

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice