Microsoft Exam PL-300 Topic 15 Question 30 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 30
Topic #: 15

You have the dataset shown in the following exhibit.

You need to ensure that the visual shows only the 10 cities that have the highest sales profit.

What should you do?

AAdd a Top N filter to the visual.

BConfigure the Sales Profit measure to use the RANKX function.

CAdd a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.

DAdd a calculated column to the table that returns the city name if the city is in the top 10, otherwise the
calculated column will return 'Not in Top 10'. In the visual, replace Sales Profit with the calculated column.

Show Suggested Answer

Suggested Answer: A

by Joesph at Aug 28, 2023, 08:35 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

India

1 months ago

Option A all the way, baby! Keep it simple, stupid. Why complicate things when you can just slap on a Top N filter and call it a day? I'm all about efficiency, not complexity.

upvoted 0 times

Princess

12 days ago

B) Configure the Sales Profit measure to use the RANKX function.

upvoted 0 times

...

Zachary

12 days ago

Option A is definitely the way to go. Keep it simple and efficient!

upvoted 0 times

...

Lynsey

14 days ago

A) Add a Top N filter to the visual.

upvoted 0 times

...

Denae

15 days ago

A) Add a Top N filter to the visual.

upvoted 0 times

...

Jerry

1 months ago

Option D is an interesting approach, but I'm not sure if it's necessary to create a calculated column just to display the top 10 cities. Seems a bit excessive.

upvoted 0 times

...

Kathrine

1 months ago

Option C with the TOPN function seems like a good way to get the top 10 cities. It gives us more control over the data, but it might be a bit more complex than option A.

upvoted 0 times

Elbert

3 days ago

User3: Option A might be simpler, but option C seems more effective.

upvoted 0 times

...

Lonna

4 days ago

User2: I agree, it gives us more control over the data.

upvoted 0 times

...

Nikita

14 days ago

User1: I think option C with the TOPN function is a good choice.

upvoted 0 times

...

Trina

2 months ago

Option B with the RANKX function sounds interesting, but I'm not sure if it's the best approach for this scenario. Might be overkill for just displaying the top 10 cities.

upvoted 0 times

Dalene

27 days ago

C) Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.

upvoted 0 times

...

Albina

1 months ago

A) Add a Top N filter to the visual.

upvoted 0 times

...

Sabra

2 months ago

I think option A is the most straightforward way to get the top 10 cities. It's a simple filter that will do the job without any additional calculations.

upvoted 0 times