Exam PL-300 Topic 2 Question 51 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 51
Topic #: 2
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.

Suggested Answer:


1 - Select the discount column.
2 - Select Replace Errors to replace each error valure with 0.05.
3 - For the disocunt column, change Data Type to Decimal Number.

by Angelo at May 12, 2024, 11:59 PM

Limited Time Offer

15%

Off

Get Premium PL-300 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
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.
0
0
0
10