You create a materialized reference dimension between a dimension named Regions and a
measure group named Orders.
You use a table named Customers as a bridge as shown in the exhibit. (Click the Exhibit button.)
You need to ensure that data is updated to reflect any changes in the relationship. The
solution must NOT require that the entire cube be reprocessed.
What should you reprocess?
A.
The Sales partition
B.
The Regions dimension
C.
The Customers dimension
D.
The Orders partition
The correct answer is D.
Materialized reference relationships are resolved during partition processing and not
dimension processing.
D is right
D
http://sqlblog.com/blogs/alberto_ferrari/archive/2009/02/25/ssas-reference-materialized-dimension-might-produce-incorrect-results.aspx