Certified Data Management Professional – Fundamentals (CDMP) — Question 53

One of the key differences between operational systems and data warehouses is:

Answer options

• A. Operational systems focus on business processes; data warehouses focus on business strategies
• B. Operational systems focus on historical data; data warehouses contain current data
• C. Operational systems are available 24x7; data warehouses are available during business hours
• D. Operational systems focus on data quality; data warehouses focus on data security
• E. Operational systems focus on current data; data warehouses contain historical data

Correct answer: E

Explanation

The correct answer, E, accurately states that operational systems are designed to handle current data necessary for day-to-day operations, while data warehouses are structured to store historical data for analysis and reporting. The other options mischaracterize the roles and focuses of operational systems and data warehouses, leading to incorrect comparisons.