Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 3 question 24 discussion

Actual exam question from Microsoft's DA-100

Question #: 24
Topic #: 3

HOTSPOT -
You have the Power BI data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Analyze the Data

by Maue at April 30, 2021, 6:05 p.m.

Comments

Submit Cancel

Aj123456

Highly Voted 4 years, 1 month ago

TESTED d and d

upvoted 85 times

memo43

4 years, 1 month ago

why the first one is d? SUM is logical???

upvoted 3 times

Massy

4 years, 1 month ago

it's not logical but it what Power Bi authomatically do

upvoted 3 times

Andy7622

4 years ago

I tested integer IDs the default is 'don't summarize' and it gave a list of values.

upvoted 5 times

Massimo70

4 years ago

if in your model the ID are text , that's right. But if they are Numeric then Sum happens

upvoted 4 times

...

flynt

3 years, 6 months ago

Auto-Sum is turned off on PF and FK

upvoted 2 times

...

memo43

4 years, 1 month ago

it should be b-d

upvoted 30 times

...

ihustle

3 years, 7 months ago

You are right.

upvoted 1 times

...

TalkingData

3 years, 8 months ago

Sorry, bit I think you're wrong. The first answer is (c) List Distinct StoreID Values. There is no default summarization on the StoreID field in Sales as shown in the model diagram (the sigma symbol isn't present). Also, as this is a key field, there is no default summarization. I agree that (d) is correct for the second part of the question - there is a bi-directional filter present on the relationship between Sales and Customers.

upvoted 42 times

Davico93

2 years, 11 months ago

try it in Power BI, and no neccessarily appear the sigma symbol

upvoted 1 times

Davico93

2 years, 11 months ago

but you right, StoreID is a FK, so PK and FK have no default summarization

upvoted 1 times

...

Load full discussion...

...

Iroshan4

Highly Voted 4 years, 1 month ago

D and D. Because Store ID is formatted as a whole number and and default summarization is Sum. And filter propagates only to the customer table. Other connections comes towards the store table.

upvoted 40 times

Bhavya_G

3 years, 4 months ago

first is not D. I wont sum the values as summerize option is disabled in the properties. That is why we are not seeing sigma symbol next to store ID.

upvoted 3 times

...

ricknash

4 years, 1 month ago

towards *sales table

upvoted 1 times

...

presidentjoe2

4 years ago

Wouldn't there be a sigma symbol next to Store ID in the model view if the default summarization was set to sum? It looks like it's set to don't summarize which means the table will display a list of distinct Store ID values.

upvoted 29 times

andimohr

3 years, 11 months ago

Extremely good point!!!!!!!! Thanks for that hint. I was just angry that they didn´t show the advanced options for Store ID - but yes - if you switch the advanced option "summarize by" to none the sigma symbol vanishes. The anwer is definitely "list of all the StorID values for the upper box.

upvoted 3 times

andimohr

3 years, 11 months ago

Sorry, not quite - it only eliminates that "sum of the store ID values" is the solution. I think, indeed, a list of distinct Store ID values will be displayed. But i only tested it with non-numeric sample data - and am not sure.

upvoted 8 times

RowSwanson

3 years, 6 months ago

I tested it w/ a whole number field, it's list of distinct StoreID values

upvoted 8 times

Angell

2 years, 12 months ago

I just tried with a test dataset I have which for this case is productID. Its data type is whole number and when explained in a table visualization it shows a list of distinct values. I tried both the table and matrix visuals. The only way it sums is when chosen on the field options or when explained on the matrix visual as values.

upvoted 1 times

...

vishalbhise

Most Recent 9 months, 3 weeks ago

For the second,Everyone is saying bidirectional filter hence it will filter customers also Sales also filters product table check the cross filter direction is from sales to product. So the answer should be all related tables of sales

upvoted 1 times

...

Maniula

1 year, 10 months ago

C & D There are duplicates of StoreID in Sales, table visual will only show distinct ID's.

upvoted 1 times

...

gtc108

2 years, 9 months ago

Tested and confirmed: C and D. By default, when the Whole number is selected as the datatype, Power BI will Summarize the values. To get it to the screen shot though you'll need to click on the 'Advanced' option which is not displayed and select 'None' under Summarized By. Once you change the Summarized by to 'None' and use the field in the table visual, it will show distinct values.

upvoted 6 times

...

The_General92

2 years, 9 months ago

Stop making people confused, the true answers are C and B. To make sure just make the same model on your power BI desktop and add the field to a table visual. YOU WILL SEE WITH YOUR OWN EYES THAT THERE IS A LIST OF THE DISTINCT StoreID values AND THE FILTER TAKES VALUES ONLY FROM THE Sales table ONLY. Good luck and sorry for screaming at you, reading the comments below how people are so sure of their answers and they are wrong made me mad.

upvoted 6 times

VeroF

2 years, 8 months ago

C and B are the correct answer. Tested

upvoted 2 times

...

rainbowyu

2 years, 10 months ago

Tested, it is C and D

upvoted 2 times

...

QWERTYman

2 years, 10 months ago

Correct answer is C and D

upvoted 5 times

...

Mazarakis

2 years, 11 months ago

correct answers: C & D.

upvoted 6 times

...

Davico93

2 years, 11 months ago

Testes it's C and D, the first is not D because Power BI recognize that ID as a foreign key, so by default it's "don't summarize"

upvoted 1 times

...

Franz58

3 years ago

C (no sum symbol on storeID) and D (bidirectional relationship)

upvoted 2 times

...

claudeaboki

3 years ago

tested. List of the distinct StoreID values, only the Store table

upvoted 1 times

claudeaboki

3 years ago

keyboard error, only Sales table

upvoted 1 times

claudeaboki

3 years ago

Tested. the final answer is List of the distinct StoreID values, the sales table and the customer table.

upvoted 2 times

...

BLUE_BUBBLES

3 years ago

For the 2nd part, why not all the tables related to Sales tables. Sales table slices other 2 tables so when you change the store ID to 1, it should alter the other tables right?

upvoted 2 times

...

Gunel_Huseynova

3 years, 1 month ago

When you create a table visual it will present the list of stores :) therefore the answer is correct, please upvote to make the correct answer appear on top

upvoted 3 times

...