Microsoft
70-448 · Question #181
70-448 Question #181: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #181. The question stem and answer options stay visible for context.
Question
You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. There are three characters in a dimensionality called DProducts below: - An attribute named Categories. - A key attribute named Products that has a relationship to the Categories attribute. - A hierarchy that has the Categories attributes on the first level and the Products attribute on the second level. When you browse through the dimension, it shows all the Products that do not have a relationship to the Categories attribute. The attribute is grouped under a Categories member named Unknown. You need to ensure that only those products that have a relationship to the Categories attribute are displayed. Which is the correct answer below?
Options
- AIn the hierarchy, you should change the HideMemberIf property of the Categories level to
- BIn the hierarchy, you should change the HideMemberIf property of the Products level to
- CYou should Change the UnKnownMember property of the DimProducts dimension to none.
- DYou should Change the UnKnownMember property of the DimProducts dimension to Hidden.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 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.