Microsoft
70-448 · Question #22
You create a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server 2008. You create the dimensions as shown in the following table. The CustKey attribute is used as a column in a…
The correct answer is B. Set the reference dimension to DimGeography by using a referenced dimension attribute as GeoKey. See the full explanation below for the reasoning.
Question
You create a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server 2008. You create the dimensions as shown in the following table. The CustKey attribute is used as a column in a table named FactSales. You need to create a referenced dimension that allows you to browse the measures of the FactSales table by using the DimGeography dimension. What should you do?
Options
- ASet the reference dimension to DimGeography by using a referenced dimension attribute as GeoKey
- BSet the reference dimension to DimGeography by using a referenced dimension attribute as GeoKey
- CSet the reference dimension to DimCustomer by using a referenced dimension attribute as CustKey
- DSet the reference dimension to DimCustomer by using a referenced dimension attribute as GeoKey
How the community answered
(39 responses)- A10% (4)
- B79% (31)
- C8% (3)
- D3% (1)
Community Discussion
No community discussion yet for this question.