Information Systems and Technology Flashcards

Which database model uses tables with rows and columns and supports SQL queries?

Answer: Relational model

The relational model organizes data into tables (relations) and uses SQL as its standard query language.

What is the primary purpose of an Enterprise Content Management (ECM) system?

Answer: Capturing, storing, and delivering content throughout its lifecycle

ECM systems manage the full lifecycle of unstructured content including capture, storage, retrieval, and disposition.

In information architecture, what does a taxonomy primarily provide?

Answer: A hierarchical classification system for organizing information

A taxonomy is a hierarchical classification structure that organizes information into categories and subcategories for easier retrieval.

Which of the following best describes a data warehouse?

Answer: A subject-oriented, integrated repository designed for analytical reporting

A data warehouse is a subject-oriented, integrated, time-variant, nonvolatile collection of data supporting management decisions.

What is the function of metadata in an information management system?

Answer: To provide data about data, enabling discovery and context

Metadata describes the characteristics, context, and content of data, making information easier to find, understand, and manage.

Which technology allows multiple virtual servers to run on a single physical machine?

Answer: Virtualization

Virtualization software creates virtual machines that share physical hardware resources, enabling multiple isolated server environments on one host.

In a master data management (MDM) strategy, what problem does MDM primarily solve?

Answer: Inconsistent or duplicate core business data across systems

MDM creates a single authoritative source for critical business entities like customers, products, and suppliers, eliminating data inconsistencies across systems.