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 (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Namenick10
Highly Voted 2 years, 5 months ago
C. bar chart
upvoted 35 times
...
Sucheta_SM
Highly Voted 2 years, 4 months ago
Pie chart because from 100% what % is late orders. Please feel free to correct me.
upvoted 23 times
Fer079
2 years, 4 months 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 41 times
BabaJee
2 years, 1 month 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 12 times
...
...
sa56
1 year, 10 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
10 months, 2 weeks ago
https://theconversation.com/heres-why-you-should-almost-never-use-a-pie-chart-for-your-data-214576
upvoted 3 times
...
...
...
Layla0322
Most Recent 1 month, 2 weeks ago
Selected Answer: C
The C. Bar Chart is the best choice for this visualization because: It can handle multiple dimensions (e.g., country and shipping region) simultaneously. It clearly represents the percentage of late orders for each dimension. It avoids the clutter and limitations of pie charts, which are unsuitable for multidimensional data.
upvoted 1 times
...
jaume
2 months, 3 weeks ago
Selected Answer: C
Pie chart would visualize % break down for total 100% of late orders but not % of late orders out of total orders. Scatterplot could visualize late orders by country and shipping region and set bubble size related to the % of late orders over total orders but would be not the most effective visual. Bar chart is best way amongst suggested options to represent the % of late orders and would also mak easier to compare % values between different customers, regions, shipment regions....
upvoted 1 times
...
Smitpowerbi
9 months, 1 week ago
C. bar chart
upvoted 2 times
...
MoneyStacking
9 months, 3 weeks 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
10 months, 2 weeks ago
Selected Answer: C
Bar chart, more detailed visualization
upvoted 1 times
...
JohnChung
1 year 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
1 year, 3 months ago
Selected Answer: C
This was on the exam today. Passed with 917/1000
upvoted 7 times
iamak96
1 year, 1 month ago
what are the sources u took to prepare for the exam?
upvoted 1 times
9f73003
10 months ago
Are you really going to check back on this question for this individual's answer??
upvoted 1 times
...
...
...
jl234
1 year, 4 months 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, 4 months ago
A. Pie Chart
upvoted 1 times
...
JJMC5544
1 year, 7 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 11 times
...
halofrosty
1 year, 7 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, 8 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, 9 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, 9 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, 9 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
...
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago