Microsoft
70-448 · Question #21
70-448 Question #21: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #21. The question stem and answer options stay visible for context.
Question
You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a dimension named Customer. The Customer dimension has the attributes named Country and State. The Country attribute has the following components: - The KeyColumn property is set to the country code. - The NameColumn property is set to the country name. You create an attribute relation between the Country attribute and the State attribute. You need to ensure that the state names are sorted first by the country name and then by the state name. What should you do?
Options
- ASet the OrderBy property to Name and the OrderByAttribute property to Country for the State attribute.
- BSet the OrderBy property to AttributeName and the OrderByAttribute property to Country for the State attribute.
- CSet the OrderBy property to Name for the Country attribute.
- DSet the OrderBy property to Name for the Country attribute.
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.