DA0-002 Visualization and Reporting Practice Test 3 — 15 Questions

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

DATEADD. DATEADD is correct because it is a time intelligence function that shifts a date range by a specified interval, so DATEADD('Date'[Date], -1, YEAR) returns the same period one year earlier, enabling prior-year sales comparisons. SAMEPERIODLASTYEAR is also correct because it is a dedicated time intelligence function that returns a table of dates shifted exactly one year back from the current filter context, which is ideal for calculating previous-year sales. TOTALYTD is not appropriate here because it computes a year-to-date accumulation for the current period rather than retrieving the prior year's values. FILTER is a generic iterator/table filter function and does not itself perform any year-over-year time shift. PREVIOUSYEAR is not among the marked correct answers and, while it returns the entire previous year, it is not one of the two functions designated as correct in this question.

Answer

TOTALYTD

Answer

FILTER

Answer

PREVIOUSYEAR

Question 2

A data analyst is creating a dashboard in Tableau to show monthly sales trends. The data source includes daily sales figures. The analyst needs to calculate the cumulative sales for each month and compare it to the same period last year. Which Tableau feature should be used for the year-over-year comparison?

Accepted Answer

Table calculations. Table calculations in Tableau operate on the data currently visible in the view and can compute values such as running totals (cumulative sales) and year-over-year comparisons using functions like LOOKUP(), WINDOW_SUM(), or the built-in 'Year over Year Growth' quick table calculation. Because the analyst needs a cumulative monthly figure compared to the prior year's same period, this is a positional/relative computation across the table's addressing and partitioning dimensions — exactly what table calculations are designed for. They are computed client-side after the query returns, so they can reference values in other rows of the result set, which calculated fields and LOD expressions cannot do directly.

Answer

Calculated fields

Answer

Level of Detail (LOD) expressions

Answer

Parameters

Question 3

A data analyst is building a report in Power BI and needs to create a measure that calculates the total sales for the current year, but only for products that have at least one sale in the previous year. Which DAX function combination is most appropriate?

Accepted Answer

CALCULATE with FILTER and SAMEPERIODLASTYEAR. Using CALCULATE with a FILTER that checks for sales in the previous year via SAMEPERIODLASTYEAR or a similar time intelligence filter achieves this dynamic filtering.

Answer

RELATED to pull product data

Answer

TOTALYTD with a filter on Date table

Answer

SUMX with a FILTER on Sales table

Question 4

A data analyst is designing a dashboard for a sales team. Which TWO of the following are key performance indicators (KPIs) rather than operational metrics?

Accepted Answer

Customer retention rate. Customer retention rate (B) is a key performance indicator (KPI) because it measures the long-term health of customer relationships and directly reflects strategic business goals, such as loyalty and recurring revenue. It is a high-level metric that tracks performance against strategic objectives, unlike operational metrics which focus on day-to-day activities.

Answer

Number of emails sent to prospects

Answer

Number of sales calls made per day

Answer

Average time to close a deal

Question 5

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?

Accepted Answer

Clear labels and titles. Option B (Clear labels and titles) is correct because executives need to immediately understand what each chart and axis represents without guessing, which reduces cognitive load and speeds up trend identification. Option C (Visual hierarchy) is correct because arranging elements by importance (e.g., KPIs at the top, supporting details below) guides the viewer's eye to the most critical trends first. Option D (Consistent color coding) is correct because using the same color for the same category or metric across all views prevents misinterpretation and lets executives compare trends reliably. Option A (Maximize data-ink ratio) is not among the marked correct answers here, and Option E (Include as many interactive filters as possible) is wrong because excessive filters clutter the dashboard and overwhelm non-technical executive users rather than helping them quickly spot trends.

Answer

Maximize data-ink ratio

Answer

Include as many interactive filters as possible

Question 6

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?

Accepted Answer

Scatter plot. A scatter plot (B) is correct because it plots two continuous variables against each other, so wait times in minutes can be shown on one axis versus time of day on the other, revealing correlations, clusters, and outliers across departments. A heat map (D) is correct because it uses color intensity to encode a numeric measure such as average wait time, with departments and time-of-day buckets as the two categorical axes, making patterns and hotspots easy to spot. A box plot (E) is correct because it summarizes the distribution of the continuous wait-time variable per department, showing median, quartiles, and outliers for comparing departments side by side. A funnel chart (A) is not appropriate because it represents sequential stages of a process with progressively decreasing values, which does not match wait times across independent departments. A histogram (C) is not among the marked answers because, while it can show the distribution of wait times, it does not inherently incorporate the department or time-of-day dimensions needed for this multi-variable exploration.

Answer

Funnel chart

Answer

Histogram

Question 7

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?

Accepted Answer

Histogram. 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.

Answer

Scatter plot

Answer

Bar chart

Answer

Box plot

Question 8

A data analyst is building a dashboard in Tableau and wants to allow users to select a specific product category and have all charts on the dashboard filter to that category. Which Tableau feature should be used?

Accepted Answer

Dashboard action. Dashboard actions in Tableau allow one worksheet to act as a filter or highlight source for other worksheets on the same dashboard. By configuring a filter action driven by a category selector (e.g., a sheet or parameter-driven control), selecting a product category filters all charts on the dashboard. This is the native Tableau feature designed for cross-sheet interactivity on a dashboard.

Answer

Calculated field

Answer

LOD expression

Answer

Parameter

Question 9

A marketing analyst wants to visualize the conversion funnel from website visitors to paying customers. Which TWO chart types are suitable for showing this pipeline? (Choose two.)

Accepted Answer

Funnel chart. The funnel chart (C) is purpose-built for visualizing a sequential pipeline where a starting population progressively narrows through stages, so it directly represents visitors → leads → paying customers with decreasing widths per stage. The waterfall chart (D) is also suitable because it shows how an initial value is incrementally reduced or transformed by successive stages, letting you display the drop-off at each conversion step and the final paying-customer count. A scatter plot (A) only shows correlation between two numeric variables and cannot encode ordered pipeline stages. A pie chart (B) shows parts of a single whole at one point in time, not a multi-stage conversion flow. A bar chart (E) compares discrete categories but does not inherently convey the sequential narrowing of a funnel.

Answer

Scatter plot

Answer

Pie chart

Answer

Bar chart

Question 10

An analyst is creating a Tableau dashboard for a logistics company. They need to allow users to filter data by region and time period, and also want to show a tooltip with detailed shipment information. Which THREE Tableau features should be used? (Choose three.)

Accepted Answer

Tooltips. Option A (Tooltips) is correct because Tableau tooltips let the analyst display detailed shipment information when a user hovers over a mark, satisfying the requirement to show shipment details on demand. Option C (Parameters) is correct because parameters are user-controlled values that can be referenced by calculated fields or filters, enabling flexible selection of region and time period without editing the workbook. Option E (Dashboard actions) is correct because actions such as filter actions let selections on one worksheet dynamically filter other worksheets in the dashboard, which is the standard way to drive region and time-period filtering across a dashboard. Option B (Marks) is not correct because marks are the visual representations of data (bars, lines, shapes) rather than a filtering or tooltip mechanism. Option D (Calculated fields) is not correct because calculated fields create new data values through expressions, not the interactive filtering and detail-display features requested here.

Answer

Marks

Answer

Calculated fields

Question 11

A business user wants to explore sales data by creating custom charts and tables without writing SQL queries. Which type of report capability should the BI team provide?

Accepted Answer

Self-service report. A self-service report empowers business users to build their own charts and tables through a drag-and-drop interface without writing SQL, which is exactly what the user requested. Self-service BI tools (like Power BI, Tableau, or Looker) expose semantic models that abstract the database so users can explore data independently.

Answer

Operational report

Answer

Scheduled report

Answer

Ad hoc report

Question 12

A data analyst is reviewing the quality of a sales report before publishing. Which THREE elements should the analyst include to ensure report quality?

Accepted Answer

Data freshness timestamp. Report quality includes documenting when data was last updated, any limitations or assumptions, and the source of the data to ensure transparency and reliability.

Answer

Row-level security settings

Answer

Methodology notes

Question 13

An operations manager needs to monitor manufacturing line status every 15 minutes to identify bottlenecks. Which type of report should be used?

Accepted Answer

Operational report. Operational reports provide real-time or near-real-time data for monitoring ongoing operations.

Answer

Ad hoc report

Answer

Analytical report

Answer

Scheduled report

Question 14

A business user wants to explore sales data without relying on the data team. Which report type empowers the user to create their own analysis?

Accepted Answer

Self-service report. A self-service report is designed to let business users independently explore data, build their own visualizations, and answer their own questions without depending on the data team. This directly matches the requirement of empowering a business user to create their own analysis.

Answer

Ad hoc report

Answer

Operational report

Answer

Scheduled report

Question 15

A data analyst notices that two departments report different revenue totals for the same period. Which data governance issue is most likely?

Accepted Answer

Single version of truth. Lack of a single version of truth means data sources are not reconciled, leading to discrepancies.

Answer

Data dictionary

Answer

Data lineage

Answer

Row-level security