Which relationship type should you use between the InternetSales table and the new dimension?

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 product and color.
You need to create the dimension.
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

microsoft-exams

One thought on “Which relationship type should you use between the InternetSales table and the new dimension?

  1. I do not agree with the solution.
    The question says ” You need to create the dimension. Which relationship type should you use between the InternetSales table and the new dimension?”
    I assume I am creating only one dimension. Based on two tables “Products” and “Colors”. For which the key attribute would definitely be the ProductKey and the relationship with the “InternetSales” fact table being “Regular”.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.