Microsoft
70-448 · Question #267
You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as shown in the following exhibit. (Click the Exhibit button.) You need to ensure that the Amount measure can be…
The correct answer is C. Create a many-to-many relationship between DimCustomer and FactTransaction. See the full explanation below for the reasoning.
Question
You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as shown in the following exhibit. (Click the Exhibit button.) You need to ensure that the Amount measure can be aggregated for the DimCustomer dimension. What should you do?
Exhibit
Options
- ACreate a regular relationship between DimCustomer and FactTransaction.
- BCreate a referenced relationship between DimCustomer and FactCustomerAccount.
- CCreate a many-to-many relationship between DimCustomer and FactTransaction.
- DCreate a many-to-many relationship between DimCustomer and FactCustomerAccount.
How the community answered
(26 responses)- A19% (5)
- B8% (2)
- C69% (18)
- D4% (1)
Community Discussion
No community discussion yet for this question.