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

Question 1

A data analyst needs to display the distribution of customer ages in a dataset containing 10,000 records. Which TWO chart types are appropriate? (Choose two.)

Accepted Answer

Box plot. Histograms show distribution of a continuous variable, and box plots show distribution with quartiles and outliers. Pie charts and bar charts are not for distribution.

Answer

Pie chart

Answer

Bar chart

Answer

Line chart

Question 2

A business analyst is asked to distinguish between KPIs and metrics for a new dashboard. According to CompTIA Data+, which TWO statements correctly differentiate KPIs from metrics? (Choose two.)

Accepted Answer

KPIs are directly tied to strategic business objectives. KPIs are tied to strategic objectives and are often leading or lagging indicators. Metrics are operational measurements that may support KPIs but are not necessarily strategic.

Answer

KPIs and metrics are interchangeable terms

Answer

Metrics are always more important than KPIs

Answer

KPIs are always lagging indicators

Question 3

A retail company generates a daily PDF report showing the previous day's sales by region and product category. The report is automatically emailed to store managers at 6:00 AM. Which type of report is this?

Accepted Answer

Scheduled report. Scheduled reports are automated and delivered on a regular cadence. This daily sales report is scheduled and automatically delivered.

Answer

Self-service report

Answer

Ad hoc report

Answer

Operational report

Question 4

A data analyst needs to communicate the findings of a marketing campaign analysis to the Vice President of Marketing. The VP typically only reads the first paragraph and wants the key takeaway immediately. Which format should the analyst use?

Accepted Answer

An executive summary. An executive summary provides a concise overview with headline numbers and key insights, suitable for busy executives.

Answer

A raw data extract

Answer

A detailed technical report

Answer

A data dictionary

Question 5

A data analyst discovers that the sales data for the current quarter shows a 15% increase in revenue. However, the analyst notes that the data does not include returns from the last week due to a system lag. How should the analyst communicate this uncertainty?

Accepted Answer

Include a caveat that returns from the last week are missing and revenue may be overstated.. When data has limitations, it's important to disclose them, such as missing returns, to avoid misleading conclusions.

Answer

Delay the report until returns are processed.

Answer

Report the 15% increase as final, because the returns are insignificant.

Answer

State that the revenue increase is exactly 15% and provide a confidence interval.

Question 6

An organization wants to ensure that all reports use the same definitions for metrics like 'Active Customer' to avoid confusion. Which data governance element should be implemented?

Accepted Answer

Data dictionary. A data dictionary provides consistent definitions, calculation methods, sources, and update frequencies for metrics.

Answer

Row-level security

Answer

Single version of truth

Answer

Data lineage

Question 7

A manager in operations needs a real-time dashboard showing production line status, including machine uptime and error counts. Which type of report is most appropriate?

Accepted Answer

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

Answer

Analytical report

Answer

Ad hoc report

Answer

Scheduled report

Question 8

A data analyst is creating a report on customer satisfaction scores. The analyst wants to ensure that regional managers can only see data for their own region. Which security measure should be applied?

Accepted Answer

Row-level security. Row-level security restricts data visibility so that users see only the rows relevant to them, such as their region.

Answer

Data encryption

Answer

Single version of truth

Answer

Data masking

Question 9

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. Self-service reporting allows business users to create their own reports and visualizations using BI tools without technical skills.

Answer

Operational report

Answer

Scheduled report

Answer

Ad hoc report

Question 10

A financial analyst is preparing a report that must comply with the Sarbanes-Oxley (SOX) Act. What is the most critical requirement for this report?

Accepted Answer

Audit trail. SOX requires audit trails to ensure the integrity and traceability of financial data for compliance.

Answer

Row-level security

Answer

Data anonymization

Answer

Data dictionary

Question 11

A data analyst receives a request from a sales manager for a one-time report on Q4 performance by product line. The report is not expected to be repeated. Which type of report should the analyst create?

Accepted Answer

Ad hoc report. An ad hoc report is created for a specific, one-time request, as opposed to scheduled or recurring reports.

Answer

Scheduled report

Answer

Operational report

Answer

Self-service report

Question 12

An organization is implementing a centralized reporting layer to replace multiple departmental spreadsheets. Which governance principle does this support?

Accepted Answer

Single version of truth. A single version of truth ensures that all users access the same consistent data, eliminating discrepancies from siloed spreadsheets.

Answer

Data dictionary

Answer

Data lineage

Answer

Row-level security

Question 13

An analyst is presenting a recommendation to increase marketing spend. Which statement best follows the data-driven recommendation structure (evidence → insight → recommendation → expected impact)?

Accepted Answer

Based on a 5% lift in sales from previous campaigns, we recommend a 10% increase in marketing spend, expecting a 7% revenue growth.. The correct structure provides evidence, insight derived from it, a recommendation, and the expected impact.

Answer

A 10% increase in marketing spend is recommended because we have budget.

Answer

The data shows sales are up, so we should spend more on marketing.

Answer

We should increase marketing spend by 10% because it might boost sales.

Question 14

A data analyst is building a report that includes customer names and addresses. To comply with GDPR, what must the analyst do before publishing the report?

Accepted Answer

Anonymize the PII data. GDPR requires that personally identifiable information (PII) be anonymized to prevent individual identification in reports.

Answer

Add a data dictionary

Answer

Increase data freshness

Answer

Apply row-level security

Question 15

A data analyst is creating a weekly KPI email for executives. Which TWO attributes are most important for this type of report?

Accepted Answer

Providing an executive summary with key metrics. Scheduled reports for executives should be concise and automated, with clear headline metrics and context.

Answer

Allowing interactive drill-down

Answer

Including raw data tables

Answer

Including real-time data