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

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Willow

7 days ago

The question is a real brain-teaser, but I have to say, option D is the way to go. It's the most comprehensive solution.

upvoted 0 times

Richelle

2 days ago

User 1

upvoted 0 times

...

Melinda

22 days ago

D is the winner! Gotta love that IF(ISBLANK()) function. It's like a magic wand for dealing with those pesky blank cells.

upvoted 0 times

Lauran

3 days ago

User 1: D is the winner! Gotta love that IF(ISBLANK()) function.

upvoted 0 times

...

Glendora

29 days ago

The question is a bit tricky, but I think D is the best solution. It's important to have a robust formula that can handle any data issues.

upvoted 0 times

Noah

5 days ago

I think D is the safest choice as well.

upvoted 0 times

...

Alyce

11 days ago

I agree, D seems like the most reliable option.

upvoted 0 times

...

Joanne

1 months ago

I agree with Vanna. Option D is the way to go. Handling blank values is crucial in this scenario.

upvoted 0 times

...

Vanna

1 months 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

Clarence

4 days ago

Yes, option D will ensure that blank values are handled properly.

upvoted 0 times

...

Eura

6 days ago

So we should go with option D to address the data concerns.

upvoted 0 times

...

Agustin

17 days ago

I agree, option D handles blank values effectively.

upvoted 0 times

...

Tasia

19 days ago

I think option D is the best choice.

upvoted 0 times

...

Trevor

1 months ago

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

upvoted 0 times

...

Blossom

1 months ago

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

upvoted 0 times

...

Trevor

1 months ago

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

upvoted 0 times

...