CIP Information Systems and Technology 2

Question 1

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

Accepted Answer

Relational model

Answer

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

Question 2

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

Accepted Answer

Capturing, storing, and delivering content throughout its lifecycle

Answer

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

Question 3

In information architecture, what does a taxonomy primarily provide?

Accepted Answer

A hierarchical classification system for organizing information

Answer

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

Question 4

Which of the following best describes a data warehouse?

Accepted Answer

A subject-oriented, integrated repository designed for analytical reporting

Answer

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

Question 5

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

Accepted Answer

To provide data about data, enabling discovery and context

Answer

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

(CIP) Certified Information Professional Practice Test