Exam PL-300 topic 2 question 24 discussion

If it's the only field in a table only unique values will be shown.

1 - 1 ROW 2 - increase

Tested in PBI with two simple columns product | unit A | 8 B | 8 C | 4 D | 1 Without summary - it shows 1,4,8 (3 records only) With summary - it shows 21 (1 record only) So without summary, it shows only distinct values; while summary shows aggregated (lesser records)

tested in power bi with a 2 column table with repeated values and blanks, it showed 1 row for each distinct value (not non null values), hence it is 51 + reduce

Tested in my own PBI report, table is returning ALL values in the column (75 non-null values will be listed there, any duplicated value would be listed also duplicated there). We should assume there are no null values in the column, as the table would ALSO REPORT that nulls (so answer, then, should be 75 rows + any additional null row). Is not clear "is nullable" is enabled ("yes") or disabled ("no") as it's like on the right side means it's disabled (in Version: 2.138.782.0 PBI desktop, this option is showing "Yes"/"No" for the selected value). Let's assume this screenshot stands for "Is nullable" being disabled, then all 75 non-null values are listed in the visual (if nullable values are not allowed, why to mention there are 75 non-nullable values, this is not testing knowledge but trying once and again to mislead you)

The data type is whole number therefore when you add only that field to the table, default summarization will occur - hence only 1 row showing total of all those UnitsInStock Changing the summarization setting is ambiguous since it can be changed to Average, Min, Max etc. I would guess you should say increase though

Correct

So, by default the table contains all the values for a specific field (75 in this case) when we select to don't summarize, then it will be reduced to the number of distinct values (51 in the example). So the given answer is correct

We assume that our column contains 75 non-null values ​​of which 51 are unique, so we have 63 distinct values ​​that will be visualized in the table, so I don't understand why your answers are 75 rows while in powerbi we don't see repeated values ​​in a table.

correct answer

The answer is correct. 75 rows / reduce. When added to a table it will show all the non-null values (75). When summarizing by each of those values, then it will only show each discrete value 1 time to show it's frequency of appearance (51 unique characters). 51 < 75 = reduce. Tested and agreed.

Summarize is set to: None, therefore all values will be shown.

The question was not well structured, obviously distinct values will be more than 51 (the unique values) since we have 75 non-null values. I happen when you try to theorize practical things.

The first question is very tricky. Assuming that the field accept null values and the question says "UnitsInStock has 75 non-null values, of which 51 are unique" should we assume that there is no null value therefor the answer is 75? But what if there is a null value then the answer is 76 that is one (1) null value plus seventy-five (75) non-null values. I tested this with a smaller set of data 14 Distinct (including 1 null value) and 10 unique. With no summarization, my table visual returned 14 rows (representing the distinct value that includes the null value). With summarization, my table visual returned 1 row. Because of that, I will just assume that there are no null values and select 75 for the first question and Decrease to the second question.

For the Guys and Girls, At this page, you will no longer find any free questions from Examtopics. However, if you're hesitant about purchasing Contributor Access, don't hesitate any longer; buy it. It costs only $50 and provides a significant boost to your CV and career. I recently passed with a score of 917 out of 1000. Save yourself time by learning and memorizing all these questions, as 85% of the 50 exam questions were identical to those provided here. Cheers and good luck!

The fact that the values are unique or not is not necessary here. If you are visualising the data for a month and plotting a table with unitstocks for each day, thinking that a record or a row will be removed just because two days in a month had same unitstocks is incorrect. Unless you are summarising(aggregating) records will not be removed on grounds that they do not have a unique value. answer would be 75, reduced.

So how should we answer in the exam if we face like this question where no answer is correct.