Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
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?
A. no relationship
B. regular
C. fact
D. referenced
E. many-to-many
F. data mining
I do not agree with the Answer.
I would go for “Referenced”. You can even refer to the previous question explanation.
A color dimension could not have a regular relationship to the InternetSales table as InternetSales.ColorKey does not exist…?
If the colors table was included in the products dimension then yes it would be a regular relationship, but that is not what the question says.