Microsoft Exam PL-300 Topic 2 Question 61 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 61
Topic #: 2

[All PL-300 Questions]

What should you do to address the existing environment data concerns?

Aa calculated column that uses the following formula: ABS(Sales[sales_amount])

Ba measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])

Ca measure that uses the following formula: SUM(Sales[sales_amount])

Da calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))

Show Suggested Answer

Suggested Answer: B

by Oliva at Jan 12, 2025, 05:20 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

24 hours ago

Option D is the correct answer. It addresses the existing environment data concerns by handling blank values and returning 0 instead.

upvoted 0 times

...

4 days ago

But option D) only handles blank values, whereas option A) covers all scenarios.

upvoted 0 times

...

5 days ago

I disagree, I believe option D) with IF function is the best approach.

upvoted 0 times

...

9 days ago

I think we should use option A) a calculated column with ABS function.

upvoted 0 times

...