DA0-001 Visualizing Data Practice Test 4 — 15 Questions

Question 1

The exhibit shows a SQL query result intended for a bar chart of revenue by region. However, the chart shows only the top 10 regions, but the query returns all regions. What is the most likely cause?

Accepted Answer

The visualization tool has a default limit on the number of categories displayed. The query has no LIMIT clause, so it returns all rows. The chart tool must have a built-in limit. Option A is correct because the data is not truncated, but the visualization tool may be set to show only top 10. Options B, C, and D are incorrect because the query is correct and order is applied.

Answer

The GROUP BY clause is incorrect

Answer

The query is missing a WHERE clause

Answer

The ORDER BY clause is ignored in the chart

Question 2

The exhibit shows a JSON configuration for a line chart that displays average response time over time. However, the chart shows jagged lines with many spikes. Which configuration change would smooth the visualization?

Accepted Answer

Change "interpolation" to "monotone". Setting interpolation to 'monotone' or 'smooth' can reduce jaggedness. The aggregation is already applied in the query, so changing it to 'average' in the widget would double-aggregate. Changing chart type or data source is not necessary.

Answer

Change "aggregation" to "average"

Answer

Change the query to include a moving average

Answer

Change chartType to "bar"

Question 3

The exhibit shows log entries. A data analyst wants to visualize the frequency of each error type over time. Which chart type is most appropriate?

Accepted Answer

Time series line chart. A time series line chart counts events per time interval, best for showing frequency over time. Bar chart of counts is static. Pie of error types ignores time. Scatter plot not suitable.

Answer

Bar chart of error types

Answer

Scatter plot of timestamp vs error code

Answer

Pie chart of error types

Question 4

A company wants to show the number of products sold across different categories: Electronics, Clothing, Home Goods, and Books. Which chart type is most appropriate?

Accepted Answer

Bar chart. Bar chart is ideal for comparing categorical data across distinct groups.

Answer

Scatter plot

Answer

Line chart

Answer

Pie chart

Question 5

A data analyst is designing a dashboard for executives. Which best practice should be followed?

Accepted Answer

Minimize clutter and use clear visual hierarchy. Reducing clutter helps viewers focus on key insights without distraction.

Answer

Use 3D effects to make charts more engaging

Answer

Include every data point in the dashboard

Answer

Use rainbow color palette to highlight all data points

Question 6

A heat map of store sales by region shows very low correlation between advertising spend and revenue, but a scatter plot of the same data shows a strong positive relationship. What is the most likely cause?

Accepted Answer

Data was aggregated incorrectly in the heat map. Heat maps often aggregate data into bins (e.g., averages), which can mask the underlying relationship.

Answer

The heat map used an incorrect color scale

Answer

Outliers were removed only for the scatter plot

Answer

The chart types are inherently incompatible

Question 7

A retail analyst wants to visualize monthly sales over the past year to identify seasonal patterns. Which chart type is best?

Accepted Answer

Line chart. A line chart is best for visualizing monthly sales over time because it explicitly shows trends and seasonal patterns across a continuous time axis. The sequential ordering of months allows the line to connect data points, making it easy to identify peaks, troughs, and recurring cycles. This aligns with the DA0-001 objective of selecting appropriate visualizations for time-series data.

Answer

Pie chart

Answer

Histogram

Answer

Box plot

Question 8

A data analyst needs to compare the salary distribution across five departments. Which visualization is most appropriate?

Accepted Answer

Side-by-side box plot. A side-by-side box plot (option B) is the most appropriate visualization for comparing salary distributions across multiple departments because it displays the median, quartiles, and potential outliers for each group simultaneously. This allows the analyst to assess central tendency, spread, and skewness across all five departments in a single, compact chart.

Answer

Line chart

Answer

Scatter plot

Answer

Stacked bar chart

Question 9

A sales dashboard shows a map with many overlapping markers in the same city, making it hard to read. What is the best improvement?

Accepted Answer

Aggregate the data by region and use a choropleth map. Option B is correct because aggregating sales data by region and using a choropleth map eliminates visual clutter from overlapping markers by shading entire geographic areas based on a metric (e.g., total sales). This approach leverages spatial aggregation to provide a clear, high-level view of regional performance, which is the best practice when individual point markers become unreadable due to density.

Answer

Add tooltips to show details on hover

Answer

Use a bubble chart instead of a map

Answer

Use different marker colors for each store

Question 10

A marketing team wants to explore the relationship between advertising spend (in dollars) and resulting revenue. Which chart type is most suitable?

Accepted Answer

Scatter plot. Scatter plots reveal correlation and distribution of two continuous variables.

Answer

Line chart

Answer

Table

Answer

Pie chart

Question 11

An executive dashboard needs to display key performance indicators (KPIs) such as sales growth and customer satisfaction. Which design principle is most important?

Accepted Answer

Consistent color encoding for similar metrics. Consistent color coding helps viewers quickly associate colors with metrics across multiple charts.

Answer

Use gauges for each KPI

Answer

Include all raw data in the dashboard

Answer

Animate charts to draw attention

Question 12

A time series dataset has several missing months of data. Which chart type will present the most honest picture of the trend?

Accepted Answer

Line chart with gaps for missing months. Line charts with gaps explicitly show missing periods, avoiding false continuity.

Answer

Area chart with interpolation

Answer

Bar chart with zero values for missing months

Answer

Scatter plot with connected lines

Question 13

Which TWO chart types are best suited for visualizing the distribution of a single continuous variable? (Select two.)

Accepted Answer

Box plot. Histogram shows frequency bins; box plot shows quartiles and outliers.

Answer

Scatter plot

Answer

Line chart

Answer

Pie chart

Question 14

Which THREE are considered best practices in dashboard design? (Select three.)

Accepted Answer

Using heat maps to visualize correlation. Option A is correct because heat maps effectively visualize correlation by using color intensity to represent the strength of relationships between two variables, making patterns and outliers immediately apparent. This aligns with best practices for dashboard design, which prioritize clarity and rapid insight over decorative elements.

Answer

Using 3D charts to add depth

Answer

Including every data point in the dashboard

Question 15

Which TWO color choices are appropriate for a categorical data visualization? (Select two.)

Accepted Answer

Distinct hues. Distinct hues (A) are appropriate for categorical data because they use different colors to represent distinct categories without implying any order or magnitude. This aligns with best practices in data visualization where categorical variables require qualitative color schemes that maximize perceptual separation between groups.

Answer

Sequential color scheme

Answer

Monochrome

Answer

Rainbow gradient

DA0-001 Visualizing Data Practice Test 4 — 15 Questions

Exhibit

DA0-001 Visualizing Data Practice Test 4 — 15 Questions

Exhibit