You have data in a Microsoft Excel worksheet as shown in the following table.
You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:
• If the discount column returns an error, a discount of 0.05 must be used.
• All the rows of data must be maintained.
• Administrative effort must be minimized.
What should you do in Power Query Editor?
To meet the requirements of the task—ensuring all rows are maintained, errors in the discount column are replaced with a discount of 0.05, and minimizing administrative effort—the most appropriate action in Power Query Editor is to use the 'Replace Errors' feature. This allows you to replace any errors in the specified column with a defined value easily and efficiently.
A. Select Replace Errors. is the correct answer. Because selecting "Replace Errors" allows you to replace any errors in the discount column with a specified value, which in the case is 0.05 as per the requirement. Option B is not necessary for this specific task. Option C would remove rows with errors entirely, which is not in line with the requirement to maintain all rows of data. Option D would keep rows with errors as they are, which is not what we want since we want to replace errors with a specific value.
THE ANSWERE IS A
A. Select Replace Errors - is correct. C&D will remove some rows Option B, "Edit the query in the Query Errors group", would technically also allow to achieve the required result. However, this would not be the optimal solution given the constraints provided in the scenario, which specifies that administrative effort must be minimized.
c'est correct mon reuf
The correct option to achieve the requirements is: A. Select Replace Errors. By selecting "Replace Errors" in Power Query Editor, you can specify a value (in this case, 0.05) to be used whenever an error is encountered in the specified column (discount column). This ensures that if the discount column returns an error, a discount of 0.05 will be used, while maintaining all rows of data and minimizing administrative effort.
Replace the errors, pretty straight forward
A - Select Replace Errors is correct
This was on the exam on 22/2/2024 (:
A for me
Replace Errors
Correct answer