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

Question 1

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. GDPR requires anonymization of PII, ensuring aggregate data does not allow re-identification, and respecting data retention policies.

Answer

Retain data indefinitely for analysis

Answer

Include customer names for context

Question 2

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. Confidence intervals and caveats help stakeholders understand data limitations.

Answer

Executive summary

Answer

Data dictionary definitions

Answer

Detailed row-level data

Question 3

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. The report is automatically delivered on a regular schedule, which defines a scheduled report.

Answer

Ad hoc report

Answer

Self-service report

Answer

Operational report

Question 4

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. A one-time, custom query for a specific purpose is an ad hoc report.

Answer

Scheduled report

Answer

Self-service report

Answer

Analytical report

Question 5

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 6

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%.". Confidence intervals are standard for communicating uncertainty around a point estimate.

Answer

"The satisfaction rate might be lower or higher."

Answer

"75% of customers are satisfied."

Answer

"The margin of error is 3%."

Question 7

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 8

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 9

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.

Question 10

A data analyst is building a self-service reporting environment. Which of the following is the primary benefit of this approach?

Accepted Answer

It reduces the number of ad hoc report requests to the analytics team.. Self-service BI empowers business users to create their own reports, reducing ad hoc requests to the analytics team.

Answer

It ensures all reports use the same data source.

Answer

It automatically generates executive summaries.

Answer

It improves data security by limiting access.

Question 11

Which report type is best suited for monitoring the real-time status of manufacturing equipment on the factory floor?

Accepted Answer

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

Answer

Scheduled report

Answer

Self-service report

Answer

Analytical report

Question 12

A data analyst is creating a report that includes customer names and addresses. To comply with privacy regulations, which TWO actions should the analyst take?

Accepted Answer

Use aggregated data instead of individual records.. Anonymizing PII (e.g., removing or masking names/addresses) and aggregating data prevent individual identification, which is required for GDPR compliance.

Answer

Include customer names for context.

Answer

Share the raw data with all stakeholders.

Answer

Encrypt the report but keep names visible.

Question 13

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

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

Accepted Answer

Row-level security. Row-level security restricts access to specific rows (regions), and a data dictionary ensures consistent metric definitions across regions.

Answer

Single version of truth

Answer

Data retention

Answer

Data lineage

Question 14

A data analyst is documenting a report for external stakeholders. Which THREE elements should be included to ensure report quality and transparency?

Accepted Answer

Data freshness (e.g., last updated timestamp). Data freshness, methodology notes, and limitations/assumptions help users assess the reliability and context of the report.

Answer

Employee names who created the report

Answer

Row-level security settings

Question 15

An analyst is creating an executive summary for a quarterly business review. Which THREE components are essential for an effective executive summary?

Accepted Answer

Actionable recommendations. An executive summary should start with a headline number, provide context, and include actionable recommendations.

Answer

Detailed data tables

Answer

SQL queries used to extract data