You have a Microsoft SQL Server Analysis Services (SSAS) instance that is configured to use multidimensional mode. You create the following cube:
Users need to be able to analyze sales by color.
You need to create a dimension that contains all of the colors for products sold by the company.Which relationship type should you use between the InternetSales table and the new dimension? for the dimension is joined directly to the fact table.
A.
no relationship
B.
regular
C.
fact
D.
referenced
E.
many-to-many
F.
data mining
Explanation:
A regular dimension relationship between a cube dimension and a measure group exists when the key column
References: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models-olap-logical-cubeobjects/dimension-relationships