Managerial and strategic databases are typically derived as subsets, summaries, or aggregates from which data source?

Managerial and strategic databases are typically derived as subsets, summaries, or aggregates from which data source?

• A. Operational databases
• B. Desktop spreadsheets
• C. Cloud storage volumes
• D. External public datasets

Answer: (A)

The main idea is that managerial and strategic databases come from the organization’s day-to-day transactional systems. These operational databases capture current, detailed business activity and are designed for fast updates. To support higher-level decision making, data from these systems is extracted, cleaned, and consolidated into data warehouses or data marts, where it’s stored as subsets, summaries, or aggregates tailored for analysis and reporting. This setup makes it easier to track performance over time and across functions without repeatedly querying the operational systems. Desktop spreadsheets are typically standalone and limited in scope, cloud storage volumes are not structured for integrated analytics, and external public datasets, while useful for benchmarking, aren’t the internal source of the organization’s managerial or strategic insights.

The main idea is that managerial and strategic databases come from the organization’s day-to-day transactional systems. These operational databases capture current, detailed business activity and are designed for fast updates. To support higher-level decision making, data from these systems is extracted, cleaned, and consolidated into data warehouses or data marts, where it’s stored as subsets, summaries, or aggregates tailored for analysis and reporting. This setup makes it easier to track performance over time and across functions without repeatedly querying the operational systems. Desktop spreadsheets are typically standalone and limited in scope, cloud storage volumes are not structured for integrated analytics, and external public datasets, while useful for benchmarking, aren’t the internal source of the organization’s managerial or strategic insights.