PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. The data source for a cube has tables as shown in the following exhibit. (Click the Exhibit button.)

The cube contains the following objects:

A dimension named DimAccounts that uses a table named Accounts.
A dimension named DimCustomers that uses a table named Customers.
A measure group named Transactions that uses a fact table named Transactions.
A measure group named Customer Accounts that uses a fact table named CustomerAccounts.

You need to create a cube dimension to browse through the measures in the Transactions fact table by using the DimCustomers dimension.

What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Create a referenced relationship and set the intermediate dimension as DimAccounts.

B.
Create a referenced relationship and set the intermediate dimension as DimCustomers.

C.
Create a many-to-many relationship and set the intermediate measure group to Transactions.

D.
Create a many-to-many relationship and set the intermediate measure group to Customer Accounts.


Leave a Reply