Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 11 question 2 discussion

Actual exam question from Microsoft's PL-300
Question #: 2
Topic #: 11
[All PL-300 Questions]

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.
Which type of visualization should you create?

  • A. pie chart
  • B. scatterplot
  • C. bar chart
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Namenick10
Highly Voted 2 years, 1 month ago
C. bar chart
upvoted 34 times
...
Sucheta_SM
Highly Voted 2 years, 1 month ago
Pie chart because from 100% what % is late orders. Please feel free to correct me.
upvoted 21 times
Fer079
2 years, 1 month ago
The report must show "The percentage of orders that were shipped late by country and shipping region", so I think that the Bar chart fits better
upvoted 39 times
BabaJee
1 year, 10 months ago
The bar chart makes more sense due to the complexity of two added factors ie. country and shipping region. Otherwise you will have to create two Pie Charts
upvoted 10 times
...
...
sa56
1 year, 6 months ago
A. Pie chart. A pie chart is an effective way to show the percentage of a whole, in this case, the percentage of late orders. The pie chart will display the percentage of late orders by country and shipping region. It is an excellent way to show a summary of the data and quickly identify areas that need attention. However, if you also want to compare the percentage of late orders between different countries or regions, a bar chart might be more appropriate.
upvoted 3 times
AfuIRa
6 months, 3 weeks ago
https://theconversation.com/heres-why-you-should-almost-never-use-a-pie-chart-for-your-data-214576
upvoted 3 times
...
...
...
Smitpowerbi
Most Recent 5 months, 2 weeks ago
C. bar chart
upvoted 1 times
...
MoneyStacking
6 months ago
Selected Answer: C
Passed with 917/1000 Question and answers were exactly the same but different order with the options!
upvoted 4 times
...
IVO999
6 months, 3 weeks ago
Selected Answer: C
Bar chart, more detailed visualization
upvoted 1 times
...
JohnChung
9 months ago
Selected Answer: A
I think we can use a pie chart, which is an effective way to show percentages. The case study requires a visual to show the percentage of orders shipped late for a selected month or quarter. This can be achieved by making a pie chart with interaction setting as filter
upvoted 3 times
...
kimii1993
11 months, 2 weeks ago
Selected Answer: C
This was on the exam today. Passed with 917/1000
upvoted 6 times
iamak96
9 months, 3 weeks ago
what are the sources u took to prepare for the exam?
upvoted 1 times
9f73003
6 months, 2 weeks ago
Are you really going to check back on this question for this individual's answer??
upvoted 1 times
...
...
...
jl234
1 year ago
Selected Answer: C
The answer should be Bar chart. By using Pie chart, one can not include too much information in it. But refer to the question, "The On-Time Shipping report will show the following metrics for a selected shipping month or quarter: The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter". We can't put all these into a pie chart.
upvoted 3 times
...
WRTopics
1 year ago
A. Pie Chart
upvoted 1 times
...
JJMC5544
1 year, 3 months ago
Selected Answer: C
Pie chart could help, but question says "a visualisation". Regions, countries and percentages would be complex to show in a pie chart, would need multiple pie charts. But questions says "a visual". So if we use a stacked column chart: - Each column represents a country, - And the stacked segments represent different shipping regions. - The height of each segment represents the percentage of late shipments.
upvoted 10 times
...
halofrosty
1 year, 4 months ago
Selected Answer: C
As of submitting this comment most voted answer is A. However we need to refer not only to the question itself but the case study, where it states the requirement for showing the data by country and shipping region dimensions, hence pie chart is not meeting the 'full' requirement.
upvoted 4 times
...
VNAS06
1 year, 5 months ago
I believe the answer will be Bar chart. As mentioned, - "The On-Time Shipping report will show the following metrics for a selected shipping month or quarter: The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter Northwind Traders defines late orders as those shipped after the required shipping date. The warehouse shipping department must be notified if the percentage of late orders within the current month exceeds 5%. The reports must show historical data for the current calendar year and the last three calendar years." I think Pie Chart would not fit. Please let me know, if I'm wrong.
upvoted 3 times
...
Mcisneros
1 year, 5 months ago
I initially chose pie chart. I think that it does work, but I think the reason C is the correct answer is because pie charts excel at summarizing a value column by one single dimension. The requirements need the value summarized by country and shipping region which would look messy as a pie chart but discernable in a bar chart.
upvoted 1 times
...
UlyUkr
1 year, 5 months ago
There is no definite answer here, Microsoft is always confusing. Not sure sometimes if they are testing the knowledge of Power BI, because all they do is trick you. Real customer would never give such puzzled requirements. Based on the question itself, I would show a Pie Chart to show the % of Late orders out of all orders. But based on the requirements in the report, I would show a 100% Stacked bar chart by Country and shipping region.
upvoted 8 times
...
Outsider
1 year, 5 months ago
The case is complex, because the question ask for "a" visualization. So, just one visualization should shown all the information asked? "The On-Time Shipping report will show the following metrics for a selected shipping month or quarter: The percentage of orders that were shipped late by country and shipping region". Pie chat is the best, but that will need at least 2 visualizations. we have Time Month and Quarter and 2 DIM. Putting all in just 1 visualization, the bar chart will solve the problem. So, C
upvoted 2 times
...
Shalaleh
1 year, 6 months ago
Selected Answer: A
A pie chart is a type of visualization that is often used to display data as a percentage or a proportion of a whole. In this case, the On-Time Shipping report is showing the percentage of orders that were shipped late. The pie chart would be an ideal choice because it allows us to see the relative size of each category (i.e., country and shipping region) as a slice of the whole pie.
upvoted 1 times
...
SanaCanada
1 year, 6 months ago
Selected Answer: C
Becuase The On-Time Shipping report will show the following metrics for a selected shipping month or quarter there is two axis, so Pie Chart could be fit there
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...