PrepAway - Latest Free Exam Questions & Answers

Which relationship type should you choose?

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube. A dimension named
Category is based on the DimCategory table.
A subset of the data source view is shown in the following graphic.

You need to relate the Category dimension to the Sales measure group.
Which relationship type should you choose?
To answer, select the appropriate option from the drop-down list in the dialog box.

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:

Note:
Referenced Relationship
Link a dimension to a fact table indirectly through a dimension that is linked directly through
a primary key–foreign key relationship.


Leave a Reply