Data Warehouse
| Description: Data Warehouse | |
| Number of Questions: 16 | |
| Created by: Sangita Pandit | |
| Tags: Data Warehouse Databases |
Which of the following is a collection of corporate information derived from the operational systems and some external data sources?
Which of the following criteria for data warehouse requires incemental loading of new data on a periodic basis within narrow time window?
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?
_____________ is a workgroup or departmental warehouse, which is small in size.
Which of the following data is typically stored in a format that makes analysis much easier?
In ____________ category, data are not updated or changed in any way once they enter the data warehouse, but are only loaded and accessed.
Which of the following requirements of the database server must be good enough to support the user's performance expectation during analysis?
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.
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?
___________ technique places orders into groups with similar characteristics.
Which of the following techniques involves mapping a set of input values to a single output value?
Which of the following tools acts a cheat sheet for the business user?
In a data warehouse team, which of the following must know how to phrase the questions for determining the end users' needs?
_____________ must be available all the time so that; when things go wrong, he is around to respond immediately.
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?
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?