ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam
Go to Exam

Exam DA-100 topic 3 question 24 discussion

Actual exam question from Microsoft's DA-100
Question #: 24
Topic #: 3
[All DA-100 Questions]

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 Hide Answer
Suggested Answer:
Analyze the Data
by Maue at April 30, 2021, 6:05 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Aj123456
Highly Voted 4 years, 3 months ago
TESTED d and d
upvoted 85 times
memo43
4 years, 3 months ago
why the first one is d? SUM is logical???
upvoted 3 times
Massy
4 years, 2 months ago
it's not logical but it what Power Bi authomatically do
upvoted 3 times
Andy7622
4 years, 1 month ago
I tested integer IDs the default is 'don't summarize' and it gave a list of values.
upvoted 5 times
Massimo70
4 years, 1 month 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, 8 months ago
Auto-Sum is turned off on PF and FK
upvoted 2 times
...
...
memo43
4 years, 3 months ago
it should be b-d
upvoted 30 times
...
ihustle
3 years, 8 months ago
You are right.
upvoted 1 times
...
TalkingData
3 years, 9 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
3 years, 1 month ago
try it in Power BI, and no neccessarily appear the sigma symbol
upvoted 1 times
Davico93
3 years, 1 month 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, 3 months 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, 6 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, 2 months ago
towards *sales table
upvoted 1 times
...
presidentjoe2
4 years, 2 months 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
4 years, 1 month 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
4 years, 1 month 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, 8 months ago
I tested it w/ a whole number field, it's list of distinct StoreID values
upvoted 8 times
Angell
3 years, 1 month 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 11 months, 2 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
2 years ago
C & D There are duplicates of StoreID in Sales, table visual will only show distinct ID's.
upvoted 1 times
...
gtc108
2 years, 11 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, 11 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, 10 months ago
C and B are the correct answer. Tested
upvoted 2 times
...
...
rainbowyu
2 years, 11 months ago
Tested, it is C and D
upvoted 2 times
...
QWERTYman
3 years ago
Correct answer is C and D
upvoted 5 times
...
Mazarakis
3 years ago
correct answers: C & D.
upvoted 6 times
...
Davico93
3 years, 1 month 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, 1 month ago
C (no sum symbol on storeID) and D (bidirectional relationship)
upvoted 2 times
...
claudeaboki
3 years, 2 months ago
tested. List of the distinct StoreID values, only the Store table
upvoted 1 times
claudeaboki
3 years, 2 months ago
keyboard error, only Sales table
upvoted 1 times
claudeaboki
3 years, 2 months 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, 2 months 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, 3 months 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
...
HemantGorle
3 years, 4 months ago
I have tested it with dummy tables and answer is C and D. It displays list of distinct values if you drag a single column to the table.
upvoted 3 times
...
Fredone
3 years, 4 months ago
Tested C (only StoreID inside Sales Table) & D (bi-directional link)
upvoted 3 times
...
Lollipop14527
3 years, 4 months ago
I tested and it's C and A. Try to replicate the exact model shown.
upvoted 3 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel