A data analyst at an e-commerce company is tasked with creating a quarterly revenue report. They notice that the revenue figures pulled from the sales team's CRM are 5% higher than the figures recorded in the finance team's accounting software. This discrepancy has caused confusion in previous leadership meetings. Which of the following would be the most effective solution to ensure data consistency and reliability for future reporting?
Establish a single source of truth (SSoT) by designating one of the systems as the authoritative source for revenue data.
Increase the refresh interval of the data integration jobs between the two systems.
Implement role-based access control (RBAC) to restrict who can view the revenue reports.
Create a detailed data dictionary to document the fields in both the CRM and the accounting software.
The correct answer is to establish a single source of truth (SSoT). A SSoT is a central, authoritative data repository that an entire organization can use for a specific data element, eliminating discrepancies between different systems. In this scenario, designating either the CRM or the accounting software (or a new, consolidated data warehouse) as the definitive source for revenue figures would resolve the conflict.
Increasing the data refresh interval would only update the conflicting numbers more frequently; it would not resolve the underlying discrepancy.
Creating a data dictionary is a useful documentation practice that describes data and its attributes, but it does not enforce consistency or resolve conflicts between data sources.
Role-based access control is a security measure that restricts data access based on a user's role within the organization. It is unrelated to solving issues of data accuracy or consistency between different systems.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What does a 'Single Source of Truth' (SSoT) mean in data management?
Open an interactive chat with Bash
How can a company decide which system to designate as the SSoT?
Open an interactive chat with Bash
What steps are involved in implementing a Single Source of Truth?
Open an interactive chat with Bash
CompTIA Data+ DA0-002 (V2)
Data Governance
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .