70-448 · Question #142
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named…
The correct answer is A. A many-to-many relationship should be created between FactTransaction and DimCustomer. See the full explanation below for the reasoning.
Question
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server 2008. 2008 Analysis Services (SSAS) solution is created. You also create a dimension named DimCustomer. Following is the cube structure: (Click the Exhibit button.) Now you get an order from your company CIO, according to his requirement, you should make sure that you can aggregate the Amount measure for the DimCustomer dimension. What action should you perform to achieve that goal?
Exhibit
Options
- AA many-to-many relationship should be created between FactTransaction and DimCustomer.
- BA many-to-many relationship should be created between FactCustomerAccount and DimCustomer.
- CA regular relationship should be created between FactCustomerAccount and DimCustomer.
- DA regular relationship should be created between FactTransaction and DimCustomer
- EA referenced relationship should be created between FactCustomerAccount and DimCustomer.
How the community answered
(24 responses)- A75% (18)
- B13% (3)
- D4% (1)
- E8% (2)
Community Discussion
No community discussion yet for this question.