AEIC 420 Topic 1: Business Drivers - Quiz

Why did businesses start developing data warehouses in the 1990s?

• To reduce storage costs

• To integrate fragmented data for strategic decision-making

• To replace personal computers

• To compete with NoSQL databases

Which statement best describes the key difference between a database and a data warehouse?

• Databases are larger than data warehouses

• Databases use SQL while data warehouses use NoSQL

• Databases are designed to record data, while data warehouses are designed to analyze data

• Data warehouses can only store historical data

Which technological advancement in the 1960s represented a significant improvement over punch cards by allowing direct access to data?

• Magnetic tape storage

• Disk storage

• Personal computers

• 4GL technology

How did introducing personal computers in the workplace initially impact corporate IT structure?

• It led to the strengthening of centralized IT departments

• It suggested centralized IT departments might become unnecessary

• It increased the need for punch card systems

• It eliminated the need for data storage

What unexpected challenge did end users discover when given more control over their data through 4GL and personal computers?

• The systems were too complicated to use

• The hardware was unreliable

• Data could be incorrect, incomplete, or outdated

• The software was too expensive

During the 1990s, what was the main factor that influenced changes in data warehouse development?

• The need for better gaming computers

• The rise of social media platforms

• Increased competition due to globalization and networking

• The decline of mainframe computers

Which characteristic best distinguishes OLAP from OLTP?

• OLAP is a newer technology

• OLAP is designed for analytical processing while OLTP is for transactional processing

• OLAP can only handle small datasets

• OLTP is more expensive to implement

Why did organizations transition to NoSQL databases?

• They were cheaper than traditional databases

• They could handle unstructured data more flexibly

• They were faster than SQL databases

• They required less storage space

What was the primary function of IBM's Information Management System (IMS) when it was introduced?

• To process payroll

• To manage storage on disk

• To create punch cards

• To run personal computers

The evolution of data storage from punch cards to modern systems demonstrates what key business principle?

• The increasing need for data security

• The growing importance of data integration and accessibility

• The declining cost of storage

• The preference for simple solutions