CIP Information Systems and Technology 2 — Questions and Answers
Question 1: Which database model uses tables with rows and columns and supports SQL queries?
- Hierarchical model
- Relational model (Correct answer)
- Network model
- Object-oriented model
Correct answer: Relational model
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?
- Managing employee performance reviews
- Capturing, storing, and delivering content throughout its lifecycle (Correct answer)
- Scheduling software deployments
- Monitoring network bandwidth usage
Correct answer: Capturing, storing, and delivering content throughout its lifecycle
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?
- A network security framework
- A hierarchical classification system for organizing information (Correct answer)
- A data backup strategy
- A software version control scheme
Correct 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.
Question 4: Which of the following best describes a data warehouse?
- A real-time transactional processing system
- A subject-oriented, integrated repository designed for analytical reporting (Correct answer)
- A cloud storage backup solution
- A network file sharing protocol
Correct 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.
Question 5: What is the function of metadata in an information management system?
- To encrypt data at rest
- To provide data about data, enabling discovery and context (Correct answer)
- To compress large files for storage
- To route network packets efficiently
Correct 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.
Question 6: Which technology allows multiple virtual servers to run on a single physical machine?
- RAID storage
- Virtualization (Correct answer)
- Load balancing
- Content delivery network
Correct answer: Virtualization
Virtualization software creates virtual machines that share physical hardware resources, enabling multiple isolated server environments on one host.
Question 7: In a master data management (MDM) strategy, what problem does MDM primarily solve?
- Slow network throughput
- Inconsistent or duplicate core business data across systems (Correct answer)
- Inadequate firewall rules
- Lack of software version control
Correct 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.
CIP Information Systems and Technology 2
Which database model uses tables with rows and columns and supports SQL queries?