Data Visualization, DP-900, Microsoft Certification, Power BI

Practice Questions: Identify appropriate visualizations for data (DP-900 Exam Prep)

Practice Questions

Question 1

Which visualization is BEST for showing sales trends over the past 12 months?

A. Pie chart
B. Scatter chart
C. Line chart
D. Gauge chart

✅ Answer: C

Explanation:
Line charts are ideal for displaying trends over time.

Question 2

Which visualization is MOST appropriate for comparing revenue across different product categories?

A. Map
B. Bar chart
C. Card
D. Gauge chart

✅ Answer: B

Explanation:
Bar charts are commonly used for comparing values across categories.

Question 3

Which visualization is BEST suited for displaying a single metric such as total profit?

A. Matrix
B. Pie chart
C. Card
D. Scatter chart

✅ Answer: C

Explanation:
Cards are used to display a single important value or KPI.

Question 4

Which visualization would be MOST useful for displaying sales performance by country?

A. Map
B. Gauge chart
C. Pie chart
D. Card

✅ Answer: A

Explanation:
Maps are designed for visualizing geographic or location-based data.

Question 5

Which visualization is BEST for showing the relationship between advertising spend and sales revenue?

A. Line chart
B. Scatter chart
C. Pie chart
D. Matrix

✅ Answer: B

Explanation:
Scatter charts help identify relationships and correlations between numeric variables.

Question 6

A report needs to show how each region contributes to total company sales. Which visualization is MOST appropriate?

A. Gauge chart
B. Pie chart
C. Table
D. Scatter chart

✅ Answer: B

Explanation:
Pie charts are commonly used to show proportions or percentages of a whole.

Question 7

Which Power BI visualization is MOST appropriate for displaying detailed transactional records?

A. Table
B. Card
C. Gauge chart
D. Pie chart

✅ Answer: A

Explanation:
Tables display detailed row-level data effectively.

Question 8

Which visualization is BEST for monitoring progress toward a sales target?

A. Scatter chart
B. Matrix
C. Gauge chart
D. Pie chart

✅ Answer: C

Explanation:
Gauge charts show progress toward a goal or threshold.

Question 9

Which Power BI feature allows users to interactively filter report visuals?

A. Relationships
B. Measures
C. Slicers
D. Cards

✅ Answer: C

Explanation:
Slicers provide interactive filtering capabilities in reports.

Question 10

Which visualization is MOST appropriate for summarized cross-tab reporting with grouped data?

A. Matrix
B. Card
C. Pie chart
D. Gauge chart

✅ Answer: A

Explanation:
Matrices are useful for grouped summaries and pivot-style analysis.

✅ Quick Exam Takeaways

✔ Visualization selection matters

✔ Common visualizations:

  • Line chart → trends over time
  • Bar/Column chart → comparisons
  • Pie/Donut chart → proportions
  • Scatter chart → relationships/correlation
  • Map → geographic data
  • Card → single metric
  • Gauge → progress toward target
  • Table → detailed records
  • Matrix → grouped summaries

✔ Interactive feature:

  • Slicers → filtering

✔ Exam tips:
👉 Trend over time = line chart
👉 Category comparison = bar chart
👉 Relationship between values = scatter chart
👉 Single KPI = card
👉 Geographic data = map

Go to the DP-900 Exam Prep Hub main page.

Leave a comment