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.
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.