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

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.

This question makes no sense: it will be 51 values appearing in the visual table for the unique values PLUS the number of distinct values (it could be 1 value or more... so at least we will get 52 values) We have non-null values but if we have null values they will be added also because we are using YES for "is-nullable", so i think the question is not well formed. (try a column from 1 to 51(distinct values) and continue till 75 as u wish and then create a visualization table) and obviously when summarized the rows will be reduced to one.

Tried in power bi. when created a table visual with UnitsInStock column(only this column, without ProductID column etc / also without summarization) The number of rows equal the number of distinct values. Since we don't have distinct value here, the answer of first box really depends on how we define [unique]....if unique here = distinct, then 51. if there is ProductID in the table visual then 75.

Domanda nell'esame di oggi