WorksheetsAEIC 420 Topic 1: Business Drivers - Quiz
Total questions: 20
Worksheet time: 10mins
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
What business challenge led to the development of data warehouses by the year 2000?
Limited storage capacity
High costs of computing
Poor system integration and data inconsistency
Lack of trained personnel
How did normalization differ from denormalization in database design?
Normalization increased data redundancy while denormalization reduced it
Normalization divides data into multiple tables while denormalization combines data
Normalization was faster while denormalization was slower
Normalization uses SQL while denormalization uses NoSQL
What fundamental shift in data management occurred with the transition from magnetic tapes to disk storage?
Increased storage capacity
Lower costs
Direct access to data
Better security
Why was Facebook's adoption of NoSQL databases in 2008 significant?
It demonstrated the limitations of traditional databases
It showed the need for handling unstructured information at scale
It proved that NoSQL was faster than SQL
It reduced operating costs
Which statement best describes the relationship between business intelligence and data warehousing?
They are completely independent systems
Data warehousing emerged as a response to business intelligence needs
Business intelligence replaced data warehousing
They compete with each other
What key limitation did punch cards address in early data processing?
The need for portable data storage
The requirement for structured data organization
The demand for fast processing
The necessity for wireless data transmission
How did the rise of commercial online applications in the late 1960s impact business operations?
It eliminated the need for human workers
It increased the importance of data accuracy and accessibility
It reduced the need for data storage
It simplified database management
What fundamental problem did data warehouses solve that personal computers couldn't?
Processing speed
Data storage capacity
Enterprise-wide data integration
User interface design
The transition from centralized IT to personal computing and back to integrated data warehouses illustrates what principle?
Technology always becomes more complex
Business needs drive technological evolution
Smaller solutions are always better
Centralization is always more efficient
Why was the development of relational databases in the 1980s significant?
They were more user-friendly and introduced SQL
They eliminated the need for data warehouses
They could store more data than previous systems
They were less expensive to maintain
