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

Question 1

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?

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

Accepted Answer

Include a caveat that returns from the last week are missing and revenue may be overstated.. The analyst must be transparent about the data's limitations. Since the missing returns could reduce the reported revenue increase, the correct action is to explicitly state that returns from the last week are not included and that the 15% figure may be overstated. This maintains data integrity and allows stakeholders to make informed decisions.

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 2

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 is a centralized repository that documents the names, definitions, data types, and business rules for data elements such as 'Active Customer.' By defining the metric once and publishing it, all reports and analysts reference the same meaning, eliminating ambiguity. This directly addresses the requirement for consistent metric definitions across the organization.

Answer

Row-level security

Answer

Single version of truth

Answer

Data lineage

Question 3

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. An operational report is designed to support day-to-day monitoring of ongoing business processes, providing near real-time visibility into metrics like machine uptime and error counts. It is the correct choice for a production line dashboard that operations managers check continuously. Operational reports focus on current status rather than historical trends or deep analysis.

Answer

Analytical report

Answer

Ad hoc report

Answer

Scheduled report

Question 4

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 (RLS) filters query results at the row level based on the identity of the user running the report, so each regional manager automatically sees only the rows belonging to their region. This is the standard mechanism in BI platforms (e.g., Power BI, Tableau, Salesforce) for enforcing per-user data segmentation without duplicating reports. Encryption, masking, and single-version-of-truth do not restrict which rows a user can retrieve.

Answer

Data encryption

Answer

Single version of truth

Answer

Data masking

Question 5

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 6

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 a one-time, on-demand report created for a specific question and not scheduled or reused. The scenario explicitly states the report is not expected to be repeated, which is the defining characteristic of ad hoc reporting. Scheduled, operational, and self-service reports all imply recurring or ongoing use.

Answer

Scheduled report

Answer

Operational report

Answer

Self-service report

Question 7

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 8

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 9

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 10

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

Question 11

A data analyst frequently receives ad hoc requests for the same type of analysis. Which TWO approaches could reduce the number of ad hoc requests?

Accepted Answer

Create a scheduled report that covers the common analysis. Option B is correct because a scheduled report that covers the common analysis proactively delivers the recurring results the analyst keeps being asked for, eliminating the need for users to submit one-off requests each time. Option E is correct because a self-service BI tool lets business users build and run their own reports against governed data, shifting routine ad hoc demand away from the analyst. Option A is not correct because increasing data freshness to real-time addresses latency, not the volume of repetitive requests. Option C is not correct because adding security controls does not reduce how often users ask for the same analysis. Option D is not correct because ignoring requests is unprofessional and does nothing to eliminate the underlying recurring demand.

Answer

Increase data freshness to real-time

Answer

Add more security to the data

Answer

Ignore the requests until they become urgent

Question 12

A data analyst creates a weekly KPI dashboard for executives. The analyst notes that the data is updated as of the previous day. Which report quality element should be included?

Accepted Answer

Data freshness timestamp. When a dashboard shows data as of the previous day, the report must communicate that staleness to executives. A data freshness timestamp explicitly states when the underlying data was last refreshed, so consumers know the currency of the metrics. This is a core report quality element for trust and decision-making.

Answer

Data dictionary

Answer

Data lineage

Answer

Row-level security

Question 13

A business analyst needs to explain to a sales director that the reported revenue has a 95% confidence interval of ±2%. Which concept is being communicated?

Accepted Answer

Uncertainty communication. Confidence intervals quantify the uncertainty around a metric, conveying that the true value may vary.

Answer

Data governance

Answer

Single version of truth

Answer

Data lineage

Question 14

A healthcare analyst is creating a report on patient outcomes. To comply with privacy regulations, which action should be taken before publishing?

Accepted Answer

Anonymize personally identifiable information. Anonymizing PII protects patient identities and ensures compliance with privacy laws like HIPAA.

Answer

Include patient names for context

Answer

Provide raw data to all stakeholders

Answer

Aggregate data without anonymization

Question 15

A sales VP wants a quick summary of last month's revenue change and key drivers. Which report section is most relevant?

Accepted Answer

Executive summary. Executive summaries provide high-level numbers and context for quick decision-making.

Answer

Data dictionary

Answer

Methodology notes

Answer

Row-level data