38 of 113 questions · Page 2/2 · Dap Visualising Data topic · Answers revealed
Which TWO of the following are leading indicators that can help predict future performance?
Increased traffic may lead to more sales.
Why this answer
Leading indicators predict future outcomes; website traffic and number of qualified leads are forward-looking.
A data analyst is creating a dashboard in Looker Studio for an e-commerce company. They want to display the average order value by product category, and also allow users to filter by date range. Which combination of elements should be used?
Product category is a dimension, average order value is a metric, and date range control allows filtering.
Why this answer
In Looker Studio, dimensions are fields like product category, metrics are aggregations like average order value, and date range controls provide filtering.
A data analyst in a healthcare organization needs to visualize patient wait times across different departments. The data includes department names (categorical), wait times in minutes (continuous), and time of day. Which THREE chart types could be effectively used to explore this data?
Can show relationship between time of day and wait time.
Why this answer
Box plots show distribution and outliers; scatter plots can show wait time vs. time of day; heat maps can show average wait time by department and time period. Histograms show distribution of a single variable, funnel charts are for pipelines.
A data analyst is building a Power BI report to track KPIs for a retail chain. Which TWO of the following are considered leading indicators? (Choose two.)
High satisfaction often leads to repeat purchases and referrals.
Why this answer
Leading indicators predict future performance. Number of website visits and customer satisfaction score can foreshadow future sales, whereas total sales and profit margin are lagging indicators. Employee count is operational but not typically leading.
A data analyst is creating a dashboard in Tableau to monitor sales performance. The dashboard will be used by executives to quickly identify trends. Which THREE design principles should the analyst apply?
Makes the dashboard easy to understand at a glance.
Why this answer
Visual hierarchy ensures key metrics stand out; consistent color coding aids interpretation; clear labels prevent confusion. Data-ink ratio is important but not as critical for executive dashboards as clarity; including many interactive filters may clutter.
Which chart type is best for showing the number of website visitors at each stage of a conversion funnel, from initial visit to purchase?
Correct. Funnel charts are ideal for conversion funnels.
Why this answer
A funnel chart is specifically designed to visualize the progressive reduction in volume across stages of a linear process, such as a conversion funnel. It clearly shows the number of visitors at each stage (e.g., initial visit, product view, add to cart, purchase) and the drop-off between them, making it the optimal choice for this scenario.
Exam trap
The trap here is that candidates often confuse a funnel chart with a waterfall chart because both show sequential steps, but a waterfall chart is for cumulative changes (additions/subtractions), not for displaying the count at each stage of a funnel.
How to eliminate wrong answers
Option A is wrong because a stacked bar chart is used to compare parts of a whole across categories, not to show the sequential reduction in a funnel; it would obscure the drop-off between stages. Option B is wrong because a treemap displays hierarchical data as nested rectangles based on proportion, which is not suitable for a linear, sequential process like a conversion funnel. Option D is wrong because a waterfall chart is designed to show the cumulative effect of sequential positive and negative values (e.g., financial statements), not the simple count of visitors at each stage of a funnel.
A data analyst is creating a presentation for executives to explain why customer churn has increased over the last quarter. The analyst wants to present the story in a compelling way. Which narrative structure is most appropriate?
This structure effectively sets the context, presents the problem, and offers a solution.
Why this answer
The Situation-Complication-Resolution structure is ideal for executive presentations because it first establishes the context (situation), then introduces the problem (complication—increased churn), and finally proposes a solution (resolution). This narrative arc aligns with how executives process strategic issues, making the data story compelling and actionable. In contrast, other structures are better suited for technical reports or hypothesis testing, not high-level storytelling.
Exam trap
The CompTIA Data+ exam often tests the distinction between narrative structures for different audiences; the trap here is that candidates mistake 'Background, Analysis, Recommendation' (a common technical report format) as appropriate for executives, when in fact it lacks the persuasive arc needed for strategic decision-making.
How to eliminate wrong answers
Option A is wrong because 'Problem, Hypothesis, Test' is a scientific method structure used for experimental validation, not for presenting a business narrative to executives. Option B is wrong because 'Background, Analysis, Recommendation' is a linear report format that lacks the dramatic tension needed to engage an executive audience on a problem like churn. Option D is wrong because 'Data, Visualization, Conclusion' is a data-centric sequence that prioritizes outputs over storytelling, failing to frame the business impact and resolution in a compelling way.
A data analyst wants to compare the sales revenue of five different product categories for the current month. Which chart type is most suitable for this comparison?
Bar charts compare categories easily.
Why this answer
A bar chart is ideal for comparing discrete categories across a single metric like sales revenue.
An analyst needs to create a report in Power BI that shows year-to-date sales compared to the same period last year, with the ability to drill down from year to quarter. Which DAX function combination is most appropriate for the year-to-date calculation?
These time intelligence functions compute YTD and compare to the same period last year.
Why this answer
TOTALYTD calculates year-to-date values, and SAMEPERIODLASTYEAR shifts the comparison to the prior year. Together they allow YTD vs prior YTD comparison.
A data analyst is building a dashboard for executives and wants to ensure the most important metric, total revenue, is immediately visible. Which design principle should the analyst apply?
Correct. Visual hierarchy guides the viewer's eye to the most important metric first.
Why this answer
Visual hierarchy means arranging elements so that the most important information is most prominent, often by placing it in the top-left or center and making it larger.
A data analyst wants to show the relationship between advertising spend and sales revenue for 50 stores. Which chart type is most appropriate?
Scatter plots show the relationship between two continuous variables.
Why this answer
A scatter plot is the most appropriate chart for showing the relationship between two continuous variables—advertising spend and sales revenue—across 50 stores. Each point on the plot represents one store, allowing the analyst to visually assess correlation, trends, or outliers. This aligns with the DA0-001 objective of selecting visualizations that best represent bivariate relationships.
Exam trap
The trap here is that candidates often confuse a line chart (which connects points in sequence) with a scatter plot (which treats points as independent observations), leading them to incorrectly choose a line chart when no temporal or ordered dimension exists.
How to eliminate wrong answers
Option A is wrong because a line chart is typically used to display trends over time or ordered categories, not to show the relationship between two independent continuous variables like advertising spend and sales revenue. Option C is wrong because a bar chart compares discrete categories or groups, not the correlation between two continuous metrics across 50 individual stores. Option D is wrong because a pie chart shows proportions of a whole for categorical data, which is irrelevant for analyzing the relationship between two numerical variables.
An analyst is choosing a chart to show the correlation between two continuous variables. Which TWO chart types could be used? (Select two.)
Bubble charts are scatter plots with a third variable; they also show correlation.
Why this answer
A bubble chart is an extension of a scatter plot that can show the correlation between two continuous variables on the x- and y-axes, while a third variable is represented by the size of the bubbles. For the specific purpose of showing correlation between exactly two continuous variables, the bubble chart is valid because the bubble size is optional and does not interfere with the primary x-y relationship. This makes it a correct choice for visualizing the relationship between two continuous variables.
Exam trap
A common misconception in data visualization is that a histogram can show relationships between two variables, but it only displays the frequency distribution of a single continuous variable. For the Data+ exam, remember that scatter plots and bubble charts are appropriate for showing correlation between two continuous variables.
In Looker Studio, what is the difference between dimensions and metrics?
This matches Looker Studio terminology.
Why this answer
In Looker Studio, dimensions are fields that contain categorical data (e.g., text, dates, or geographic names) used to group and segment data, while metrics are numerical fields (e.g., counts, sums, averages) that can be aggregated. Option D is correct because this distinction is fundamental to how Looker Studio processes and visualizes data: dimensions define the rows or categories in a chart, and metrics provide the quantitative values to be measured.
Exam trap
The trap here is that candidates often confuse the general data types (numeric vs. string) with the semantic roles in Looker Studio, leading them to choose option C, but the exam expects you to know that dimensions are always used for grouping (categorical) and metrics for aggregation (numerical) in the context of this tool.
How to eliminate wrong answers
Option A is wrong because it reverses the roles: dimensions are used for grouping and segmenting data, not aggregation, while metrics are the fields that are aggregated (e.g., SUM, COUNT, AVG). Option B is wrong because it incorrectly states that dimensions are numerical and metrics are categorical; in reality, dimensions are typically categorical (text, date, boolean) and metrics are numerical. Option C is wrong because while both can technically be categorical or numerical in raw data, Looker Studio enforces a strict semantic distinction: dimensions are treated as grouping keys (categorical) and metrics as aggregatable values (numerical), and mixing them leads to incorrect chart behavior.
A sales manager wants to see the conversion rates at each stage of the sales pipeline, from initial contact to closed deal. Which chart type is most appropriate?
Funnel charts visualize pipeline stages and conversion.
Why this answer
A funnel chart is designed to show progressive reductions as stages narrow.
A sales analyst wants to show total sales by product category, with each category's contribution to the total. Which chart type is best?
Stacked bars show total and composition.
Why this answer
A stacked bar chart shows both the total and the part-to-whole breakdown by category.
A data analyst needs to show the relationship between advertising spend (in dollars) and the number of website visits. Both variables are continuous. Which chart type is most suitable?
Scatter plots show the relationship between two continuous variables and can reveal correlation patterns.
Why this answer
Scatter plots are ideal for visualizing the correlation between two continuous variables.
A sales analyst is building a Power BI report to analyze quarterly performance. Which THREE are appropriate uses of DAX or Power Query? (Select three.)
Power Query is ideal for data cleaning and transformation.
Why this answer
Option B is correct because Power Query is specifically designed for data transformation and cleaning tasks, such as removing duplicate rows from a data source, before the data is loaded into the data model. This is a standard ETL operation that Power Query handles efficiently using its 'Remove Duplicates' feature, which is not a DAX function.
Exam trap
Cisco often tests the distinction between data transformation tools (Power Query) and data analysis functions (DAX), leading candidates to mistakenly think that DAX functions like SUMX can perform data cleaning tasks, when in fact they are for analytical calculations within the data model.
Which TWO chart types are appropriate for visualizing the distribution of a continuous variable? (Select two.)
Box plots show quartiles, median, and outliers.
Why this answer
A box plot (B) is appropriate for visualizing the distribution of a continuous variable because it displays the median, quartiles, and potential outliers, providing a five-number summary of the data. A histogram (D) is also appropriate as it groups continuous data into bins and shows the frequency distribution, revealing the shape, central tendency, and spread of the variable.
Exam trap
The trap here is that candidates often confuse a bar chart with a histogram, thinking both can show distribution, but a bar chart is for categorical data while a histogram is specifically for continuous data with no gaps between bars.
A data analyst is designing a dashboard and wants to maximize the data-ink ratio. Which action aligns with this principle?
Removing unnecessary gridlines reduces non-data ink and improves the data-ink ratio.
Why this answer
Data-ink ratio focuses on removing non-data ink (chartjunk) and emphasizing data. Using minimal gridlines reduces non-data ink.
A data analyst is presenting a story about declining sales. The narrative arc should include which three elements in order?
This is the standard narrative arc.
Why this answer
Option B is correct because a compelling data story about declining sales follows the classic narrative arc: Situation (establish context, e.g., 'Sales were steady in Q1'), Complication (introduce the conflict, e.g., 'Then a 20% drop occurred in Q2'), and Resolution (present the insight or action, e.g., 'We identified the cause and implemented a new pricing strategy'). This order mirrors the 'Situation-Complication-Resolution' framework used in data storytelling to guide the audience logically from context to problem to solution.
Exam trap
The trap here is that candidates often confuse the narrative order with a simple 'problem-solution' structure, mistakenly placing Complication first (Option D) or skipping the Situation entirely, but the exam requires the full Situation → Complication → Resolution sequence to ensure a complete and logical data story.
How to eliminate wrong answers
Option A is wrong because starting with Resolution (the solution) before establishing the Situation or Complication confuses the audience; they need context first to understand why the resolution matters. Option C is wrong because placing Resolution before Complication skips the core conflict that drives the narrative, making the story feel incomplete and the resolution unsupported. Option D is wrong because beginning with Complication without first setting the Situation leaves the audience without necessary background, making the problem seem arbitrary or disconnected from the data.
A data analyst is creating a dashboard and wants to maximize the data-ink ratio. Which action supports this principle?
This removes redundant ink and focuses on data.
Why this answer
Removing unnecessary gridlines and decorative elements reduces non-data ink, thereby increasing the data-ink ratio. The data-ink ratio is the proportion of ink used to display data versus total ink used in the chart.
A data analyst wants to show the monthly sales trend for the past two years with an emphasis on cumulative growth. Which chart type is most appropriate?
Area charts highlight cumulative totals over time.
Why this answer
An area chart is the most appropriate choice because it combines a line chart's ability to show trends over time with a filled area beneath the line, which visually emphasizes cumulative growth. For monthly sales data over two years, the area fill makes it easy to see both the month-over-month trend and the total accumulated sales volume, which is exactly what the data analyst needs.
Exam trap
The trap here is that candidates often choose a line chart (Option D) because it shows trends, but they overlook that the area chart is specifically designed to emphasize cumulative growth through its filled region, which is the key requirement in the question.
How to eliminate wrong answers
Option A is wrong because a scatter plot is used to show the relationship between two numerical variables (e.g., correlation), not to display a single time series trend or cumulative growth. Option B is wrong because a bar chart is best for comparing discrete categories or individual values, but it does not inherently emphasize cumulative growth or continuous trend over time. Option D is wrong because while a line chart effectively shows trends over time, it lacks the filled area that visually emphasizes cumulative growth; the area chart is specifically designed to highlight the magnitude of change and accumulation.
A data analyst is preparing a presentation for the executive team to explain why quarterly revenue fell short of targets. They want to use storytelling with data. Which THREE elements should be included in the narrative arc? (Choose three.)
Correct. The resolution provides the path forward.
Why this answer
Situation sets context, complication introduces the problem, and resolution provides the solution. Data details are not part of the high-level narrative arc.
A data analyst wants to visualize the distribution of employee salaries across departments and identify any outliers. Which chart type would best show quartiles, median, and potential outliers?
Box plots show five-number summary and outliers.
Why this answer
A box plot displays the median, quartiles (Q1 and Q3), and outliers, making it ideal for identifying outliers in distribution.
An analyst creates a scatter plot with three variables: X, Y, and a third variable represented by the size of the markers. This chart is called a:
Bubble charts are scatter plots with a third dimension represented by bubble size.
Why this answer
A bubble chart is a variation of a scatter plot where a third numeric variable is encoded by the size (area) of the markers. This allows the visualization of three dimensions of data simultaneously on a two-dimensional plane, making it the correct choice for the described chart.
Exam trap
The trap here is that candidates confuse a bubble chart with a heat map because both can represent three variables, but the heat map uses color gradients on a grid, not marker size on a scatter plot.
How to eliminate wrong answers
Option A is wrong because a heat map uses color intensity to represent the magnitude of a third variable across two categorical axes, not marker size. Option B is wrong because a treemap uses nested rectangles (tiles) to display hierarchical data, with area encoding a quantitative value, and does not use X/Y coordinates or marker sizes. Option D is wrong because a waterfall chart shows cumulative effects of sequential positive or negative values, typically in a financial context, and does not involve scatter plot markers or a third variable encoded by size.
A data analyst needs to display the distribution of customer ages in a dataset. The ages range from 18 to 85, and the analyst wants to see the shape of the distribution and identify any outliers. Which chart type should be used?
Histograms show the distribution shape of continuous data.
Why this answer
A histogram shows the distribution of a continuous variable, while a box plot shows quartiles and outliers. The question asks for distribution shape, so histogram is more appropriate.
A dashboard designer is creating a KPI dashboard for executives. Which of the following is a leading indicator?
Leads are a leading indicator of future sales.
Why this answer
Number of qualified leads is a leading indicator as it predicts future sales, while revenue and customer churn are lagging indicators.
A data analyst wants to compare the revenue across five different product categories. Which chart type is best suited?
Bar charts are best for comparing categories.
Why this answer
Bar charts are ideal for comparing categories because they display discrete values side by side.
A data analyst is using Power BI to create a report that shows sales by region. The data includes duplicate rows for some transactions due to a data entry error. The analyst needs to count only unique transactions. Which DAX function should be used to create a measure for unique count?
DISTINCTCOUNT counts distinct values in a column, ignoring duplicates.
Why this answer
DISTINCTCOUNT is the DAX function specifically for counting unique values in a column.
In Tableau, a data analyst creates a calculated field to compute the average sales per customer. The analyst wants this calculation to remain constant regardless of the level of detail in the view. Which Tableau feature should be used?
LOD expressions control granularity independent of the view.
Why this answer
Level of Detail (LOD) expressions allow calculations to be performed at a specific granularity independent of the view. FIXED LOD can compute average sales per customer and remain constant.
A data analyst is using Tableau to build a dashboard. Which THREE features are available in Tableau for creating interactive dashboards?
Actions enable interactivity like filtering or navigating between sheets.
Why this answer
Parameters, calculated fields, and dashboard actions are key Tableau features for interactivity. LOD expressions are also available but not required for interactivity per se. Power Query is a Power BI feature.
A data analyst is creating a report in Power BI and needs to calculate the total sales for the current year and the previous year. Which TWO DAX functions can be used to retrieve the previous year's sales?
Can shift dates by -1 year to get the previous year.
Why this answer
SAMEPERIODLASTYEAR and DATEADD (with -1 year) both can return dates from the previous year. PREVIOUSYEAR is invalid, TOTALYTD is for current year, and FILTER is not a time intelligence function.
A dashboard designer is creating a sales performance dashboard and wants to minimize non-data ink to improve clarity. Which action best follows the principle of maximizing the data-ink ratio?
Correct. Removing unnecessary gridlines reduces chartjunk and increases the proportion of ink used for data.
Why this answer
Option A is correct because it directly follows Tufte's data-ink ratio principle by removing non-data ink (gridlines that don't aid interpretation) while preserving the core data. This maximizes the proportion of ink devoted to actual sales metrics, improving clarity without sacrificing information.
Exam trap
The trap here is that candidates may confuse 'visually appealing' (options B, C, D) with effective data communication, not realizing that decorative elements reduce the data-ink ratio and can obscure insights in a professional dashboard.
How to eliminate wrong answers
Option B is wrong because a detailed company logo on every chart adds non-data ink that distracts from the sales performance data, violating the data-ink ratio principle. Option C is wrong because a background image introduces decorative non-data ink that reduces the clarity of the data visualization, contrary to the principle. Option D is wrong because 3-D effects on bars add chartjunk (non-data ink) that can distort perception of bar heights and make comparisons harder, directly opposing the goal of maximizing data-ink.
An analyst creates a dashboard with a large amount of decorative graphics and background images. According to CompTIA Data+, which design principle is being violated?
The data-ink ratio is reduced by unnecessary decorative elements.
Why this answer
The data-ink ratio, a concept from Edward Tufte, states that a visualization should maximize the proportion of ink used to represent actual data relative to total ink used. By adding excessive decorative graphics and background images, the analyst reduces this ratio, making the dashboard less efficient and potentially obscuring the data. CompTIA Data+ emphasizes minimizing non-data ink to improve clarity and insight extraction.
Exam trap
The trap here is that candidates confuse 'decorative graphics' with 'visual hierarchy' or 'color coding,' but CompTIA Data+ specifically tests the data-ink ratio as a principle for minimizing non-data elements to enhance readability.
How to eliminate wrong answers
Option A is wrong because visual hierarchy refers to the arrangement of elements to guide the viewer's eye by importance, which is not directly violated by decorative graphics; the issue is about ink efficiency, not order. Option C is wrong because appropriate precision concerns the level of detail in data values (e.g., rounding or decimal places), not the use of decorative elements. Option D is wrong because consistent color coding ensures that colors have the same meaning across the dashboard, which is unrelated to the overuse of non-data ink.
A business analyst needs to show the monthly sales trend for the past three years. Which chart type is most appropriate?
Line charts effectively show trends over time.
Why this answer
Line charts are ideal for displaying trends over time, making them suitable for showing monthly sales trends.
A business analyst wants to show the relationship between advertising spend (independent variable) and sales revenue (dependent variable) for 12 different regions. Each region will be represented by a point. Which chart type is most appropriate?
Correct. Scatter plots reveal correlation between two variables.
Why this answer
A scatter plot is the most appropriate chart type because it directly visualizes the relationship between two continuous variables—advertising spend (independent) and sales revenue (dependent)—by plotting each of the 12 regions as a point. This allows the analyst to assess correlation, trends, and outliers, which is the core purpose of scatter plots in data visualization.
Exam trap
The trap here is that candidates often confuse scatter plots with line charts, mistakenly thinking a line connecting points is needed to show a relationship, but the exam tests the understanding that scatter plots are the standard for bivariate continuous data without an inherent sequence.
How to eliminate wrong answers
Option A is wrong because a line chart is typically used to show trends over time or sequential data, not the relationship between two independent continuous variables across distinct regions. Option B is wrong because a bar chart compares categorical data or discrete values, not the continuous relationship between two numeric variables. Option D is wrong because a histogram displays the distribution of a single continuous variable by grouping data into bins, not the relationship between two variables.
A data analyst is designing a dashboard for executives. Which TWO practices improve dashboard effectiveness? (Select two.)
Clear labels are essential for understanding.
Why this answer
Clear labels and titles help interpretation; consistent color coding aids quick comprehension.
A data analyst needs to show the relationship between advertising spend (in dollars) and monthly sales revenue (in dollars) for the past 12 months. Which chart type is most appropriate?
Correct. Scatter plots display the relationship between two continuous variables.
Why this answer
A scatter plot is used to visualize the correlation between two continuous variables.
Ready to test yourself?
Try a timed practice session using only Dap Visualising Data questions.