You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008.
To meet the business development’a SQL Server 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?
A.
A many-to-many relationship should be created between FactTransaction and DimCustomer. Besides, FactCustomerAccount should be set as an intermediate measure group.
B.
A many-to-many relationship should be created between FactCustomerAccount and DimCustomer. Besides, FactTransaction should be set as an intermediate measure group
C.
A regular relationship should be created between FactCustomerAccount and DimCustomer. Besides, FactTransaction should be set as an intermediate measure group
D.
A regular relationship should be created between FactTransaction and DimCustomer
E.
A referenced relationship should be created between FactCustomerAccount and DimCustomer. Besides, DimAccount should be set as an intermediate dimension.