Which design should you choose?

You design a SQL Server 2008 Analysis Services (SSAS) solution. The data source view has tables as shown in the exhibit. (Click the Exhibit button.)

The FactInternetSales measure will be queried frequently based on the city and country of the customer.
You need to design a cube that will provide optimal performance for queries.
Which design should you choose?

You design a SQL Server 2008 Analysis Services (SSAS) solution. The data source view has tables as shown in the exhibit. (Click the Exhibit button.)

The FactInternetSales measure will be queried frequently based on the city and country of the customer.
You need to design a cube that will provide optimal performance for queries.
Which design should you choose?

A.
Create two dimensions named Customer and Geography from the DimCustomer table and the DimGeography table, respectively.
Create a materialized reference relationship between the Geography dimension and the FactInternetSales measure by using the Customer dimension as an intermediate dimension.

B.
Create two dimensions named Customer and Geography from the DimCustomer table and the DimGeography table, respectively.
Create an unmaterialized reference relationship between the Geography dimension and the FactInternetSales measure by using the Customer dimension as an intermediate dimension.

C.
Create a dimension named Customer by joining the DimGeography and DimCustomer tables.
Add an attribute relationship from CustomerKey to City and from City to Country.
Create a regular relationship in the cube between the Customer dimension and the FactInternetSales measure.

D.
Create a dimension named Customer by joining the DimGeography and DimCustomer tables.
Add an attribute relationship from CustomerKey to City and from CustomerKey to Country.
Create a regular relationship in the cube between the Customer dimension and the FactInternetSales measure.

Explanation:
Tip: “design a cube … optimal performance” = “a dimension … City to Country”



Leave a Reply 1

Your email address will not be published. Required fields are marked *


For the Unseasoned

For the Unseasoned

First of all, allow my family recognize a person¡¯s command during this matter. Even though this is certainly brand new , nevertheless soon after registering your site, this intellect has exploded extensively. Allow all of us to take hold of one¡¯s rss to help keep in touch with at all probable messages Sincere understand but will pass it on to help admirers and my private are living members