Questions
Which of the following is a collection of corporate information derived from the operational systems and some external data sources?
- Data warehouse
- Data mart
- Data mining
- Data base
Which of the following criteria for data warehouse requires incemental loading of new data on a periodic basis within narrow time window?
- Load processing
- Query performance
- Load performance
- Data quality management
Which category of data warehouse contains a place for storing data, that are 5 to 10 years old, to be used for comparisons, trends and forecasting?
- Subject-oriented
- Time variant
- Non-volatile
- None of these
_____________ is a workgroup or departmental warehouse, which is small in size.
- Data mining
- Data warehouse
- Data mart
- None of these
Which of the following data is typically stored in a format that makes analysis much easier?
- Operational data
- Informational data
- Technical data
- None of these
In ____________ category, data are not updated or changed in any way once they enter the data warehouse, but are only loaded and accessed.
- non-volatile
- subject-oriented
- time variant
- none of these
Which of the following requirements of the database server must be good enough to support the user's performance expectation during analysis?
- Performance
- Capacity
- Scalability
- Open interface
The _____________ of the server must be such that the server can handle the requirements of an ever-growing amount of data in the data warehouse.
- capacity
- performance
- scalability
- none of these
Which of the following tools, used to analyse the data, allows automation of the analysis of data to find patterns or rules that can be used to tailor business operations?
- Decision support system
- Data mining tool
- Executive information system
- None of these
___________ technique places orders into groups with similar characteristics.
- Sequential pattern
- Clustering
- Prediction
- None of these
Which of the following techniques involves mapping a set of input values to a single output value?
- Association
- Sequential pattern
- Clustering
- Prediction
Which of the following tools acts a cheat sheet for the business user?
- Scope for success
- Quick reference guide
- Business conceptual design
- Training
In a data warehouse team, which of the following must know how to phrase the questions for determining the end users' needs?
- Data warehouse architect
- Database administrator
- System administrator
- Data provision specialist
_____________ must be available all the time so that; when things go wrong, he is around to respond immediately.
- System administrator
- Data migration specialist
- Database adminstrator
- None of these
Which of the following key organizational components must have a respected voice within the organization and the ability and authority to lead the project and make decisions?
- Senior level business sponsor
- A steering committee
- A user group
- None of these
In which of the following criteria are many steps taken to load new or updated data into the data warehouse including data conversion, filtering, reformatting, integrity checks, physical storage, indexing and metadata updates?
- Sequential pattern
- Load processing
- Time variant
- None of these