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

View Answer

Answer: B

Explanation:

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