Microsoft PL-300 Exam - 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

Julieta

5 months ago

Not sure if a calculated column is necessary for this.

upvoted 0 times

...

Kaitlyn

5 months ago

Definitely going with option A, it’s the simplest.

upvoted 0 times

...

Marsha

5 months ago

Surprised there’s no option to just sort and limit directly!

upvoted 0 times

...

Quentin

5 months ago

I think RANKX is a better option for this.

upvoted 0 times

...

Malcom

5 months ago

Just add a Top N filter to show the top 10 cities!

upvoted 0 times

...

Hassie

6 months ago

Option D seems a bit complicated. I remember we discussed calculated columns, but returning 'Not in Top 10' feels unnecessary for this task.

upvoted 0 times

...

Kristal

6 months ago

I practiced a similar question where we had to filter top values, and I feel like option C could be the way to go with TOPN.

upvoted 0 times

...

Terrilyn

6 months ago

I'm not so sure about B, but I remember RANKX being useful for ranking values. Maybe it could work here?

upvoted 0 times

...

Iola

6 months ago

I think option A sounds right since we learned about using filters to limit data in visuals.

upvoted 0 times

...

Beata

6 months ago

The last choice with the calculated column that checks for the top 10 cities is interesting. That could be a clever way to handle this, but I'll need to think it through carefully.

upvoted 0 times

...

Carla

6 months ago

The TOPN function looks promising, but adding a calculated column seems like an extra step. I'll have to weigh the pros and cons of that option.

upvoted 0 times

...

Youlanda

6 months ago

Hmm, I'm a bit unsure about the RANKX function. I'll need to double-check the syntax and how it works before deciding if that's the best approach.

upvoted 0 times

...

Ailene

6 months ago

I think the Top N filter is the way to go here. It's a straightforward solution that should get the job done quickly.

upvoted 0 times

...

Jolanda

6 months ago

Hmm, this looks tricky. I'll need to make sure I configure the OSPF process correctly on both routers, and get the interface settings right. I better review the OSPF configuration steps carefully.

upvoted 0 times

...

Antione

6 months ago

Recalled AY 08-09 slabs and that 80C deductions reduce gross income.

upvoted 0 times

...

Buddy

6 months ago

Okay, let's see. Creating a custom search and selecting it in each section seems like a good approach, but I'm not sure if that's the most efficient way to do it. I'll have to think about the other options.

upvoted 0 times

...

India

11 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

Merilyn

9 months ago

D) Add 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.

upvoted 0 times

...

Freida

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

...

Dyan

10 months ago

Exactly! Why make things complicated when you can just use a Top N filter?

upvoted 0 times

...

Princess

10 months ago

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

upvoted 0 times

...

Zachary

10 months ago

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

upvoted 0 times

...

Lynsey

10 months ago

A) Add a Top N filter to the visual.

upvoted 0 times

...

Denae

10 months ago

A) Add a Top N filter to the visual.

upvoted 0 times

...

Jerry

11 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

11 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

10 months ago

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

upvoted 0 times

...

Lonna

10 months ago

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

upvoted 0 times

...

Nikita

10 months ago

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

upvoted 0 times

...

Trina

12 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

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

11 months ago

A) Add a Top N filter to the visual.

upvoted 0 times

...

Sabra

12 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