PrepAway - Latest Free Exam Questions & Answers

You need to create a referenced dimension that allows you to browse the measures of the FactSales table by usi

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Set the reference dimension to DimGeography by using a referenced dimension attribute
as GeoKey and an intermediate dimension attribute as CustKey.

B.
Set the reference dimension to DimGeography by using a referenced dimension attribute
as GeoKey and an intermediate dimension attribute as GeoKey.

C.
Set the reference dimension to DimCustomer by using a referenced dimension attribute
as CustKey and an intermediate dimension attribute as GeoKey.

D.
Set the reference dimension to DimCustomer by using a referenced dimension attribute
as GeoKey and an intermediate dimension attribute as GeoKey.


Leave a Reply