Practice Flashcards

A retail company wants to integrate its inventory, sales, and HR data into a single system. Which type of system best fits this need?

Answer: Enterprise Resource Planning (ERP)

ERP systems integrate core business processes—including inventory, sales, and HR—into one unified platform.

Which data characteristic ensures that information is accessible to authorized users whenever they need it?

Answer: Availability

Availability means authorized users can access information and systems when required, a core pillar of the CIA triad.

A hospital uses software that monitors patient vitals in real time and alerts nurses to anomalies. This is an example of which system type?

Answer: Process Control System

Process control systems monitor and manage physical or operational processes in real time using sensor data.

In the context of database design, what does 'normalization' primarily achieve?

Answer: Eliminates data redundancy and improves data integrity

Normalization organizes database tables to reduce redundancy and prevent update anomalies, improving overall integrity.

Which business intelligence concept refers to drilling down from a summary-level view to progressively more detailed data?

Answer: OLAP drill-down

OLAP drill-down allows analysts to navigate from higher-level summaries (e.g., annual totals) into granular transaction-level data.

A company's CIO wants a real-time dashboard showing KPIs across all departments. Which system is most appropriate?

Answer: Executive Information System (EIS)

An EIS (also called ESS) is designed to give executives summarized, real-time KPI views drawn from multiple organizational systems.

What is the primary purpose of a data warehouse in an organization?

Answer: To store and analyze large volumes of historical data for decision-making

A data warehouse consolidates historical data from multiple sources to support analysis, reporting, and strategic decision-making.