CIP Information Systems and Technology 3 — Questions and Answers
Question 1: What does CRUD stand for in the context of database operations?
- Create, Read, Update, Delete (Correct answer)
- Compile, Run, Undo, Deploy
- Copy, Retrieve, Upload, Distribute
- Cache, Replicate, Update, Deduplicate
Correct answer: Create, Read, Update, Delete
CRUD represents the four basic operations performed on persistent data: Create, Read, Update, and Delete.
Question 2: Which type of cloud deployment model gives an organization exclusive use of computing resources not shared with others?
- Public cloud
- Hybrid cloud
- Private cloud (Correct answer)
- Community cloud
Correct answer: Private cloud
A private cloud is dedicated to a single organization, offering greater control and security than public cloud environments.
Question 3: What is the role of an API (Application Programming Interface) in information systems?
- To physically connect servers in a data center
- To define how software components communicate and exchange data (Correct answer)
- To compress database tables for faster access
- To generate compliance audit reports automatically
Correct answer: To define how software components communicate and exchange data
An API specifies how software components interact, enabling different systems to exchange data and functionality in a standardized way.
Question 4: In information security, what does the CIA triad stand for?
- Control, Integrity, Access
- Confidentiality, Integrity, Availability (Correct answer)
- Classification, Indexing, Archiving
- Compliance, Investigation, Audit
Correct answer: Confidentiality, Integrity, Availability
The CIA triad — Confidentiality, Integrity, and Availability — forms the core model for information security policy.
Question 5: Which concept describes converting physical records into digital format to enable electronic processing?
- Data normalization
- Digitization (Correct answer)
- Data migration
- Schema mapping
Correct answer: Digitization
Digitization is the process of converting analog or physical content into a digital format for storage, retrieval, and processing.
Question 6: What is the primary advantage of a NoSQL database over a traditional relational database?
- Stricter enforcement of ACID transactions
- Greater flexibility for storing unstructured or rapidly changing data at scale (Correct answer)
- Built-in support for SQL syntax
- Lower storage costs per gigabyte
Correct answer: Greater flexibility for storing unstructured or rapidly changing data at scale
NoSQL databases offer schema flexibility and horizontal scalability, making them well-suited for large volumes of varied, unstructured data.
Question 7: What is business intelligence (BI) primarily used for in an organization?
- Automating software development pipelines
- Transforming raw data into actionable insights for decision-making (Correct answer)
- Managing employee access credentials
- Routing internet traffic across the enterprise network
Correct answer: Transforming raw data into actionable insights for decision-making
Business intelligence tools analyze historical and current data to help organizations make informed strategic and operational decisions.
CIP Information Systems and Technology 3
What does CRUD stand for in the context of database operations?