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

Questions 11–15

1. 11application · medium

   An e-commerce company generates a daily sales report from its transactional database and a weekly summary report from its data warehouse. The daily report shows $10,000 in sales for Monday, but the weekly report shows only $9,500 for that same day. What is the MOST appropriate action to resolve this discrepancy?

   • AUpdate the weekly report to match the daily report
   • BCheck if the weekly report includes all transactions from Monday or if some were excluded due to time zone or cutoff times
   • CAssume the daily report is correct because it is more detailed
   • DIgnore the discrepancy because it is only one day
   Reveal Solution Discussion Select an answer first
2. 12expert · hard

   A data team has implemented an automated validation tool that checks for data quality issues in a nightly batch process. The tool generates a report of all issues found, but the team is overwhelmed by the volume of issues and does not have time to review them all. What is the BEST way to prioritize which issues to investigate?

   • AFocus on issues that affect key metrics used in executive reports
   • BInvestigate all issues in the order they appear in the report
   • CRandomly select a sample of issues to investigate
   • DIgnore issues that have been present for more than a week
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   What is the primary benefit of performing data validation on a report before distribution?

   • AIt automatically corrects all data entry errors in the source system.
   • BIt reduces the file size of the report.
   • CIt increases the confidence stakeholders have in the report's findings.
   • DIt eliminates the need for any further data analysis.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   What is the first step in resolving a discrepancy found during report validation?

   • ADelete the discrepant data from the report.
   • BIgnore the discrepancy if it is small.
   • CInvestigate the root cause of the discrepancy.
   • DImmediately correct the data in the report.
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   A data analyst has created a validation process for a monthly report. The process is documented in a shared document, but a new analyst on the team is unsure how to handle a specific validation step. The documentation is unclear about the expected outcome of that step. What is the BEST way to improve the documentation?

   • AAdd a detailed example of the step with sample data and expected results
   • BRemove the step from the documentation because it is unclear
   • CCreate a separate document with only the unclear steps
   • DAsk the new analyst to figure it out on their own
   Reveal Solution Discussion Select an answer first