Data Warehousing and OLAP
Covers concepts related to data warehousing, OLAP operations, data mining, and data quality management in database systems
Questions
Which of the following characteristics of OLAP means that the system is targeted to deliver most responses to users within about five seconds, with the simplest analyses taking no more than one second and very few taking more than 20 seconds?
- Fast
- Analysis
- Shared
- Multidimensional
- None of these
____________ function is an operation against the set of records, which returns affinities or patterns that exists among the collection of items.
- Sequential pattern
- Clustering / segmentation
- Association
- EIther Sequential pattern or Clustering / segmentation
- None of these
Which of the following is referred to as the state of completeness, validity, consistency, timeliness and accuracy that makes data appropriate for a specific use?
- Data modelling
- Physical storage
- Data partitioning
- Data quality
- Data stripping
________ refers to the ability to look at the database from different view points.
- Consolidation
- Drill-Down
- Slicing and Dicing
- Either Consolidation or Drill-Down
- None of these
__________ is the operation of extracting data from a source system for further use in a data warehouse environment.
- Enrichment
- B-tree index
- Data loading
- Data segment compression
- Data extraction
_______________ task is the rearrangement and simplification of individual fields to make them more useful for the data warehouse environment.
- Splitting / Joining
- Enrichment
- Selection
- Data extraction
- Conversion
Which of the following tasks in data transformation includes a large variety of rudimentary conversions of single fields for two primary reasons - one to standardise among data extractions from disparate source systems, and the other to make the fields usable and understandable to the users?
- Selection
- Splitting / Joining
- Conversion
- Summarization
- Enrichment
Which of the following data warehouses is the integration of heterogeneous business intelligence systems set to provide analytical capabilities across different functions of an organisation?
- Real time data warehouse
- Federated data warehouse
- Distributed data warehouse
- Either Real time data warehouse or Distributed data warehouse
- None of these
____________ attempts to find patterns between events that occur in a progression over a period of time.
- Clustering
- Sequential discovery
- Classification
- EIther Clustering or Classification
- None of these
_________________ allows data to be modelled and viewed in multiple dimensions.
- Data cube
- Data loading
- Data transformation
- Data quality
- None of these