An organization plans to receive an automated data feed into its enterprise data warehouse from a third-party service provider. Which of the following would be the
BEST way to prevent accepting bad data?
An organization plans to receive an automated data feed into its enterprise data warehouse from a third-party service provider. Which of the following would be the
BEST way to prevent accepting bad data?
To prevent accepting bad data when receiving an automated data feed from a third-party service provider, the best approach is to implement business rules to reject invalid data. These rules can automatically filter out data that does not meet the predefined criteria such as correct formats, value ranges, or required fields. This proactive measure ensures that only valid and accurate data enters the enterprise data warehouse, maintaining the overall integrity and quality of the data.
Clearly D
I'd vote for D
Implementing business rules aligns with CISA's proactive approach. These pre-defined rules can act as a filter, automatically rejecting data that doesn't meet specific criteria like data format, value ranges, or missing required fields. This significantly reduces the risk of bad data entering the system at the starting point. By proactively rejecting invalid data, the organization safeguards the integrity of its data warehouse from the beginning, ensuring the accuracy of future analysis and reporting.
D. Implement business rules to reject invalid data. The best way to prevent accepting bad data from an automated data feed into the enterprise data warehouse is to implement business rules to reject invalid data (Option D). By defining and implementing specific business rules that validate the data against predetermined criteria, the organization can ensure that only valid and accurate data is accepted into the data warehouse. This approach helps maintain data integrity and prevents the inclusion of erroneous or incomplete information.
D. Implement business rules to reject invalid data.