Validate Reporting Accuracy DA0-001 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   What is the purpose of performing data consistency checks across multiple reports?

   • ATo ensure that the same data is represented uniformly in all reports.
   • BTo make all reports use the same color scheme.
   • CTo reduce the number of reports generated.
   • DTo combine all reports into a single document.
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A data analyst is validating a customer satisfaction report. The report shows an average satisfaction score of 4.8 out of 5. The analyst notices that the underlying dataset contains only responses from customers who made a purchase in the last 30 days. What validation technique should the analyst use to ensure the report is accurate?

   • ACheck the data source for completeness and representativeness of the target population
   • BRecompute the average using a different formula
   • CCompare the average to industry benchmarks
   • DRemove any outliers from the dataset
   Reveal Solution Discussion Select an answer first
4. 18expert · hard

   A data analyst is validating a report that combines data from two different sources: a CRM system and a billing system. The report shows 1,000 customers, but the CRM has 1,050 and the billing system has 980. The analyst needs to determine the correct number of customers for the report. What is the BEST approach?

   • AInvestigate the definitions of 'customer' in each system and reconcile the lists
   • BUse the billing system number because it represents actual paying customers
   • CAverage the two numbers to get 1,015
   • DUse the CRM number because it is the system of record for customer data
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A retail company's monthly sales report shows total revenue of $1,250,000. The finance team independently calculates the same total from the general ledger and gets $1,250,000. However, the report also shows a 12% month-over-month growth, while the finance team's calculation indicates only 8% growth. Which data validation technique would BEST identify the source of this discrepancy?

   • AVerify that the report was generated using the latest version of the reporting software
   • BRecompute the growth percentage using the previous month's revenue from the same report
   • CCheck that the report's date range matches the previous month's report
   • DCompare the revenue figure and growth percentage against the finance team's source data
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A company's quarterly financial report shows a total expense of $500,000. The accounting system shows $520,000 for the same period. After investigation, the analyst finds that the report excluded $20,000 in consulting fees because they were coded to a different cost center. What is the BEST way to resolve this discrepancy?

   • ALeave the report as-is because the consulting fees belong to a different cost center
   • BChange the accounting system to match the report
   • CAdd a footnote to the report explaining the exclusion
   • DUpdate the report to include the consulting fees and document the correction
   Reveal Solution Discussion Select an answer first