WorksheetsISST303 | Quiz 3
Total questions: 10
Worksheet time: 3mins
A Data Warehouse primarily supports:
Transactional operations
Analytical processing and decision-making
File storage
Email communications
What does a Data Mart represent?
A subset of a Data Warehouse focused on specific business functions
A raw data staging area
A set of transaction logs
A spreadsheet backup
ETL stands for:
Extract, Transform, Load
Execute, Transfer, Link
Extract, Transfer, Launch
Evaluate, Translate, Load
Which architecture integrates multiple independent data marts using middleware?
Federated Warehouse
Data Mart Bus Architecture
Centralized Warehouse
Hub-and-Spoke
What is the main cause of inconsistent reports when multiple departments maintain separate data marts?
Lack of centralized data integration
Excessive normalization
Overuse of staging areas
Data compression errors
In a Hub-and-Spoke architecture, which statement justifies its use?
It allows scalable and maintainable customization for business units
It removes the need for ETL tools
It relies only on real-time data
It duplicates all data sources
Which step of the ETL process ensures that data values meet quality and consistency standards?
Extraction
Transformation
Loading
Backup
When ETL fails to remove duplicate sales data, what happens to Business Intelligence reports?
Reports become inaccurate and inflated
Reports show accurate results
Reports display no data
Reports show only current year data
Which Kimball Lifecycle phase ensures the system evolves with business changes?
Growth and Maintenance
Extraction
Loading
Integration
A bank wants a single source of truth for decision-making data. Which architecture should it choose?
Centralized Data Warehouse
Independent Data Marts
Operational Database
File-based Storage
