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

Question 1

A financial analyst is creating a quarterly report compliant with SOX. Which requirement is most critical for the report's audit trail?

Accepted Answer

Audit trail of data changes. SOX compliance requires that financial reports be traceable and that any change to reported data be attributable to a specific user at a specific time. An audit trail of data changes (B) provides exactly this: a tamper-evident record of who changed what, when, and why, which is the core control auditors test for financial reporting integrity. Without it, the report cannot be defended as accurate or complete during an audit.

Answer

Row-level security

Answer

Data lineage

Answer

Data dictionary

Question 2

A marketing analyst needs to answer a one-time question about campaign performance for a specific week. Which report type is appropriate?

Accepted Answer

Ad hoc report. Ad hoc reports are designed for unique, on-demand queries.

Answer

Operational report

Answer

Self-service report

Answer

Scheduled report

Question 3

A data analyst is creating a self-service reporting environment. Which data governance practice ensures users see only data relevant to their department?

Accepted Answer

Row-level security. Row-level security (RLS) is a data governance practice that restricts data access at the row level based on user attributes such as department, role, or region. It ensures that users see only the data relevant to their department by dynamically filtering rows according to predefined policies. This is implemented in many BI and database platforms (e.g., Power BI, Tableau, Snowflake) and directly addresses the requirement of self-service reporting with department-specific data visibility.

Answer

Data lineage

Answer

Data dictionary

Answer

Single version of truth

Question 4

A company's sales report shows revenue of $1.2M, but the calculation method is unclear. What data governance artifact would clarify the definition?

Accepted Answer

Data dictionary. A data dictionary provides clear definitions, calculations, and sources for metrics.

Answer

Audit trail

Answer

Row-level security

Answer

Data lineage

Question 5

An analyst recommends a pricing change based on data showing price elasticity. The recommendation includes expected revenue impact. What is this an example of?

Accepted Answer

Data-driven recommendation. A data-driven recommendation is a decision or course of action grounded in analysis of data — here, price elasticity analysis — and it includes a quantified expected outcome such as revenue impact. The analyst is not merely presenting data; they are translating analysis into a recommended action with a projected business result. This is the defining characteristic of a data-driven recommendation.

Answer

Uncertainty communication

Answer

Self-service analysis

Answer

Executive summary

Question 6

A data analyst is designing a self-service reporting platform for business users. Which TWO practices will help ensure data consistency and trust? (Select TWO.)

Accepted Answer

Implement a single version of truth. Option A (Implement a single version of truth) is correct because consolidating reporting on one governed, authoritative dataset (e.g., a curated gold layer or semantic model) eliminates conflicting figures that arise when users pull from multiple duplicated sources, directly ensuring consistency and trust. Option E (Provide a data dictionary for all metrics) is correct because documenting each metric's exact definition, calculation, source column, and owner gives business users a shared, unambiguous meaning for every KPI, preventing misinterpretation and reinforcing confidence in the numbers. Options B, C, and D do not belong: letting users create their own data sources (B) proliferates ungoverned, inconsistent datasets; granting row-level security to all users (C) is an access-control measure that does not by itself guarantee metric consistency; and removing data lineage tracking (D) destroys the auditability and traceability that underpin trust in the data.

Answer

Allow users to create their own data sources

Answer

Grant row-level security to all users

Answer

Remove all data lineage tracking

Question 7

A data analyst is preparing a report on customer satisfaction scores. To comply with GDPR, which THREE actions must be taken? (Select THREE.)

Accepted Answer

Ensure aggregates do not identify individuals. Option B is correct because GDPR's data minimization and purpose-limitation principles require that aggregated statistics used for reporting must not allow re-identification of any individual, so ensuring aggregates do not identify individuals protects data subjects' privacy. Option D is correct because anonymizing personally identifiable information (PII) such as names, email addresses, and account numbers removes the personal data from scope of GDPR processing, satisfying the regulation's requirement to protect identifiable data. Option E is correct because GDPR Article 5(1)(e) mandates storage limitation, meaning the analyst must establish defined data retention periods for the report data rather than keeping it longer than necessary. Option A is incorrect because retaining data indefinitely violates the GDPR storage-limitation principle. Option C is incorrect because including customer names for context unnecessarily introduces identifiable personal data, contradicting data minimization and the anonymization requirement.

Answer

Retain data indefinitely for analysis

Answer

Include customer names for context

Question 8

A sales report shows a 10% increase in revenue, but the analyst knows the data has limitations. Which TWO elements should be included to communicate uncertainty? (Select TWO.)

Accepted Answer

Caveats about data completeness. Option B (Caveats about data completeness) is correct because explicitly stating known limitations, such as missing records, excluded regions, or incomplete reporting periods, directly communicates where the 10% revenue increase may be unreliable or biased. Option C (Confidence intervals around the revenue figure) is correct because a confidence interval quantifies the statistical uncertainty of the estimate, showing a plausible range (e.g., 10% ± 3%) rather than implying the point estimate is exact. Together, these elements address both qualitative and quantitative uncertainty, which is essential when the analyst knows the data has limitations. Option A (Executive summary) is a structural section that summarizes findings but does not itself convey uncertainty. Option D (Data dictionary definitions) documents field meanings and metadata, not the reliability of the result. Option E (Detailed row-level data) provides granular detail but does not communicate uncertainty about the aggregate revenue figure.

Answer

Executive summary

Answer

Data dictionary definitions

Answer

Detailed row-level data

Question 9

A sales manager receives a daily report at 8 AM via email showing yesterday's sales by region. This is an example of which report type?

Accepted Answer

Scheduled report. A scheduled report is generated automatically at a predefined time and delivered to recipients without manual intervention. The 8 AM daily email with yesterday's sales by region matches this pattern exactly — a recurring, time-triggered distribution. This is the defining characteristic of scheduled reporting in BI tools like Power BI, Tableau, or SSRS subscriptions.

Answer

Ad hoc report

Answer

Self-service report

Answer

Operational report

Question 10

A business analyst creates a one-time report to analyze customer churn for a special project. Which report type is being used?

Accepted Answer

Ad hoc report. An ad hoc report is a one-time, on-demand report created to answer a specific question or support a particular project, exactly as described. It is not scheduled, not part of a recurring cycle, and is typically built quickly by a user or analyst. The phrase 'one-time report for a special project' is the textbook definition of ad hoc reporting.

Answer

Scheduled report

Answer

Self-service report

Answer

Analytical report

Question 11

A data analyst is presenting a recommendation to reduce inventory costs. The evidence shows that overstocking occurs in 30% of warehouses. Which of the following best structures the recommendation?

Accepted Answer

"Overstocking occurs in 30% of warehouses. This indicates poor demand forecasting. We recommend implementing a just-in-time system to reduce inventory holding costs by 15%.". A proper data-driven recommendation follows the sequence: evidence → insight → recommendation → expected impact.

Answer

"Implement a just-in-time system."

Answer

"Our inventory costs are too high. We need to fix this."

Answer

"We should reduce inventory by 20%. This will save costs."

Question 12

When communicating uncertainty in a report, which of the following is the most appropriate way to convey the reliability of a survey result showing 75% customer satisfaction?

Accepted Answer

"We are 95% confident that the true satisfaction rate is between 72% and 78%.". A confidence interval communicates both the point estimate and the uncertainty around it. Stating '95% confident the true rate is between 72% and 78%' gives the reader the estimate (75%), the precision (the interval width), and the confidence level, which is the most complete and honest way to convey reliability. The other options either omit the uncertainty or state it incompletely.

Answer

"The satisfaction rate might be lower or higher."

Answer

"75% of customers are satisfied."

Answer

"The margin of error is 3%."

Question 13

A data analyst notices that the sales numbers in a report differ from the numbers in the finance department's spreadsheet. This discrepancy is most likely due to a lack of:

Accepted Answer

Single version of truth. A single version of truth means all departments use the same centralized data, avoiding inconsistencies.

Answer

Row-level security

Answer

Data lineage

Answer

Data dictionary

Question 14

A financial report must be retained for seven years to comply with regulatory requirements. This is an example of which data governance principle?

Accepted Answer

Data retention. Data retention policies specify how long data must be kept to meet legal or regulatory obligations.

Answer

Data freshness

Answer

Data lineage

Answer

Data dictionary

Question 15

A data analyst needs to design a report for two audiences: executives want a high-level trend, and operational managers need current inventory levels. Which approach best satisfies both?

Accepted Answer

Create two separate reports: an executive summary with trends and an operational dashboard with real-time inventory.. Providing a summary view for executives and a detailed view for operational managers addresses different needs.

Answer

Include all details in one report so everyone sees the same information.

Answer

Send only the operational dashboard and let executives derive trends.

Answer

Ask the stakeholders to agree on a single view.