Exam 70-768 All Questions

View all questions & answers for the 70-768 exam

Exam 70-768 topic 1 question 14 discussion

Actual exam question from Microsoft's 70-768

Question #: 14
Topic #: 1

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

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 Lex_P at April 6, 2020, 1:45 p.m.

Comments

Submit Cancel

Kartheek285

Highly Voted 4 years, 9 months ago

Since the cube already created and to view sales by color. We can't directly join Fact and Color dim because there is no relation between them. Even if we create a new regular dimension. The cube needs modification, we have to add Color Key in Fact. So, as per my understanding, the answer is referenced.

upvoted 6 times

...

DudeHere

Most Recent 4 years, 5 months ago

Referenced. One can clearly see there is no key.... in InternetSales that one could create a regular relationship with.

upvoted 1 times

...

othman_ee

4 years, 6 months ago

Going with D

upvoted 1 times

...

clement_

4 years, 7 months ago

In this situation if I am asked to let users "analyze sales by color." I would definitely go for a dimension based on the Colors dimension table, linked to the InternetSales with the Referenced relationship. No questions asked. My answer is D then, instead of B (which is in my opinion the answer to the previous question).

upvoted 1 times

...

panal

4 years, 7 months ago

I think the correct Answer is D

upvoted 1 times

...

Cococo

4 years, 8 months ago

Well, they are not asking you to assess the approach, the question is about "dimension that contains all of the colours", so it should be a dimension with all colours, not with the references to them. This dimension might be linked with the Products and Colours dimensions but we don't care. New Dimension should have colours and FK InternetSaleID. Yes, that is stupid because they already have the Products and Colors dimensions :) I think it is a regular dimension with the simple join.

upvoted 1 times

TintinDoan

4 years, 8 months ago

Because we have to create a dimension that contains all of the colours of products -> firstly create a named query table (including information of colors and productions) into design view -> using it for a regular dimension.

upvoted 1 times

...

bjamsh

5 years, 1 month ago

that would be the answer to the previous question. this one asks you "You need to create a dimension that contains all of the colors for products sold by the company" meaning the Dim has to be created with those columns which results in a regular dimension.

upvoted 3 times

Jrestrepo

5 years ago

Both questions are asking to create a new dim. and for both questions you can create the new dims with a regular relationship, but you would have to move the "Color name" to the product dim. Also the answer to both questions could also be "Referenced" if you use the current dims as given in the question, meaning go via the "Product" dim to get to the "Color Name" in the "Color" dim.

upvoted 6 times

...

Lex_P

5 years, 2 months ago

Shouldn't this be referenced? Color is one table further than Products...

upvoted 4 times

...