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
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