What should you recommend?

A database has tables named Table1, Table2, and Table3.
Table1 has a foreign key relationship with Table2.
Table2 has a foreign key relationship with Table3.
Table1 does not have a direct relationship with Table3.
You need to recommend an appropriate dimension usage relationship.
What should you recommend?
A. many-to-one relationship
B. referenced relationship
C. regular dimension relationship
D. fact relationship

Correct Answer: B
Explanation/Reference:
A reference dimension relationship between a cube dimension and a measure group exists when the key column for the dimension is joined indirectly to the fact table through a key in another dimension table, as shown in the following illustration.

Incorrect Answers:
C: A regular dimension relationship between a cube dimension and a measure group exists when the key column for the dimension is joined directly to the fact table.
References: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models-olap-logical-cube-objects/dimension-relationships