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

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 1 question 23 discussion

Actual exam question from Microsoft's PL-300
Question #: 23
Topic #: 1
[All PL-300 Questions]

DRAG DROP
-

You use Power Query Editor to preview the data shown in the following exhibit.



You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Show Suggested Answer Hide Answer
Suggested Answer:
by MarcoW91PL at April 4, 2023, 12:57 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
RazaTheLegend
Highly Voted 2 years, 2 months ago
Order is correct, we need to correct the errors first. Thus we select the column and then replace errors then change the data type.
upvoted 62 times
Arnav123
6 months ago
yes I agree because we change the data type before replacing the errors, it may result in producing an error.
upvoted 3 times
...
Asaase
6 months, 3 weeks ago
I disagree. This is better...... Select Discount > Set Discount type to Decimal > Replace errors with 0.05 Reason: practically, errors could have arisen because of wrong data type. It is best to correct the data type first (some errors may actually go away). Then you replace the remaining errors with 0.05. If you replace errors first, you totally miss out on potential corrections with the data type change
upvoted 5 times
BIFakeGuru
6 months ago
Changing the data type at the end is important because if you attempt to change the data type before addressing errors, Power Query might throw an error for the entire column.
upvoted 2 times
...
...
waxlyrical
11 months ago
I disagree with the order; we should change data type before replacing errors. Errors may arise from changing the data type and if this is done last the errors will remain on load.
upvoted 6 times
...
...
ET_phone_home_son
Highly Voted 1 year, 11 months ago
Select Discount > Replace errors with 0.05 > Set Discount type to Decimal
upvoted 19 times
...
BP215
Most Recent 1 month, 4 weeks ago
I disagree with the order; we first change the data type and then replace the error.
upvoted 1 times
...
Jasmine121
4 months, 1 week ago
I will go for 1 5 3, which are Select > Replace Error > set to Decimal
upvoted 1 times
...
rcaliandro
10 months, 2 weeks ago
First of all: Select discount column, Then: Replace errors to replace each error value with 0.05 Finally: For the discount column change data type to decimal number
upvoted 2 times
...
Kiran37
11 months, 1 week ago
correct answer
upvoted 1 times
...
shazzzy
1 year, 1 month ago
Change data type last because if the error is relating to the column not being convertable to decimal then that action will fail. If you replace to 0.05 first you are guaranteed it is convertable to decimal.
upvoted 2 times
...
AliD84
1 year, 2 months ago
Correct answer is: Select Discount > Replace errors with 0.05 > Set Discount type to Decimal This sequence does not work in P-BI: Select Discount > Set Discount type to Decimal > Replace errors with 0.05
upvoted 2 times
...
Detviler
1 year, 6 months ago
This was so logical. No argument for this one.
upvoted 3 times
...
Pratham8285
1 year, 9 months ago
Is it incorrect if I set the Discount type to Decimal before replacing the errors?
upvoted 5 times
...
Igetmyrole
1 year, 9 months ago
The correct three consecutive actions are: Action 1: Select the discount column. This is the column we need to transform. Action 3: From the discount column, change data type to decimal Number. This step is necessary to work with numeric values. Action 5: Select replace error to replace each error value with 0.05. This will address the requirement of replacing error values with the desired discount value. Action 2: select the price column. Selecting the price column is not relevant to the requirement of cleaning and transforming the discount column. Action 4: From the discount column, change data type to whole number. Changing the data type of the discount column to a whole number is not appropriate since the discount values are decimal numbers, and you want to replace errors with 0.05, which is not a whole number.
upvoted 2 times
XAPT_Kft
1 year, 6 months ago
This order is correct: - Select the discount column - Change data type to decimal - Select Replace Errors TESTED
upvoted 5 times
...
RicoPallazzo7
1 year, 9 months ago
are you sure about the order? I mean, if i modify the type after the replacement, isn't the same? Or even better, because you're not causing other problems of types before the casting
upvoted 1 times
...
...
inejo
2 years ago
De acuerdo con la respuesta
upvoted 2 times
...
newusername
2 years, 1 month ago
Why do we need to change the datatype?
upvoted 3 times
LouStar2
2 years ago
its currently stored as text its a decimal value so store it as a decimal
upvoted 1 times
...
nick0651
1 year, 8 months ago
yes , it is required to change the datatype of the column
upvoted 1 times
...
...
alojt
2 years, 2 months ago
Yes please. It would be great if someone explain the 5 & 3 answer order. Assuming the answers are 1-5 top to bottom. Could/Should the answer be 3 & 5 instead?
upvoted 1 times
alojt
2 years, 2 months ago
Oh no, I get it now. Of course, you want to get rid of the errors first. :)
upvoted 2 times
...
Igetmyrole
1 year, 9 months ago
The correct three consecutive actions are: Action 1: Select the discount column. This is the column we need to transform. Action 3: From the discount column, change data type to decimal Number. This step is necessary to work with numeric values. Action 5: Select replace error to replace each error value with 0.05. This will address the requirement of replacing error values with the desired discount value. Action 2: select the price column. Selecting the price column is not relevant to the requirement of cleaning and transforming the discount column. Action 4: From the discount column, change data type to whole number. Changing the data type of the discount column to a whole number is not appropriate since the discount values are decimal numbers, and you want to replace errors with 0.05, which is not a whole number.
upvoted 1 times
...
...
abhishek15695121
2 years, 2 months ago
given answers are correct
upvoted 1 times
...
MarcoW91PL
2 years, 2 months ago
Correct
upvoted 1 times
...
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