Microsoft
70-448 · Question #273
70-448 Question #273: Real Exam Question with Answer & Explanation
The correct answer is A. Set the source attribute to Customer and the related attribute to City.. See the full explanation below for the reasoning.
Question
You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a dimension named DimCustomer that contains the following three attributes: - Customer - City - Country The Customer attribute is the key. The DimCustomer dimension is related to a measure group named Sales that has the Granularity property set to City. You need to ensure that you can retrieve measure values based on the City and Country attributes. What should you do?
Options
- ASet the source attribute to Customer and the related attribute to City.
- BSet the source attribute to City and the related attribute to Customer.
- CSet the source attribute to Customer and the related attribute to City.
- DSet the source attribute to City and the related attribute to Customer.
Community Discussion
No community discussion yet for this question.