Microsoft Exam 70-768 Topic 10 Question 2 Discussion

Actual exam question for Microsoft's 70-768 exam

Question #: 2
Topic #: 10

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?

Ano relationship

Bregular

Cfact

Dreferenced

Emany-to-many

Fdata mining

Show Suggested Answer

Suggested Answer: B

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

by Carissa at May 09, 2022, 09:14 AM

Limited Time Offer

25%

Off

Get Premium 70-768 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!