Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam PL-300 Topic 15 Question 30 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 30
Topic #: 15
[All PL-300 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

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
Freida
1 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
...
Dyan
6 days ago
Exactly! Why make things complicated when you can just use a Top N filter?
upvoted 0 times
...
Princess
19 days ago
B) Configure the Sales Profit measure to use the RANKX function.
upvoted 0 times
...
Zachary
19 days ago
Option A is definitely the way to go. Keep it simple and efficient!
upvoted 0 times
...
Lynsey
21 days ago
A) Add a Top N filter to the visual.
upvoted 0 times
...
Denae
22 days ago
A) Add a Top N filter to the visual.
upvoted 0 times
...
...
Jerry
2 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
2 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 days ago
User3: Option A might be simpler, but option C seems more effective.
upvoted 0 times
...
Lonna
11 days ago
User2: I agree, it gives us more control over the data.
upvoted 0 times
...
Nikita
21 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
1 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
2 months ago
A) Add a Top N filter to the visual.
upvoted 0 times
...
...
Sabra
3 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
Harrison
27 days ago
User4: Option A it is then, let's go with that.
upvoted 0 times
...
Lea
2 months ago
User3: I agree, it's a simple and effective way to show only the top cities.
upvoted 0 times
...
Kenda
2 months ago
User2: Yeah, adding a Top N filter seems like the easiest solution.
upvoted 0 times
...
Kallie
2 months ago
User1: I think option A is the most straightforward way to get the top 10 cities.
upvoted 0 times
...
...
Jutta
3 months ago
I disagree, I think we should add a calculated column to the table that uses the TOPN function.
upvoted 0 times
...
Winfred
3 months ago
I agree with Ling, adding a Top N filter would be the best option.
upvoted 0 times
...
Ling
3 months ago
I think we should add a Top N filter to the visual.
upvoted 0 times
...

Save Cancel