DBMS-Data Warehousing and Data Mining
DBMS-Data Warehousing and Data Mining
21. Which of the following is an advantage of data warehousing ?
- Better enterprise intelligence.
- Business recengineering.
- Cost-Effective decision-making.
- All of these.
23. Which of the following technological advances in data modelling, databases and application development methods resulted into paradigm shift from informaion system (IS) approach to business-driven warehouse implementations ?
- Data modelling
- Databases
- Application development methods,
- All of these
24. Data acquisition component of data warehouse is responsible for
- collection of data from legacy systems.
- convert legacy data into usable form for the users.
- importing and exporting data from legacy system.
- All of these.
25. Data access component of data warehouse is responsible for
- providing the end-users with access to the stored warehouse information through the use of specialised end-user tools.
- Collecting the data from legacy system and convert them into usable form for the users.
- holding a vast amount of information froma wide variety of sources.
- None of these
26. Data acquisition component of data warehouse is responsible for
- Providing the end-users with access tot he stored warehouse information through the use of specidalised end-user tools.
- collecting the data from legacy system and convert them into usable form for the users.
- holding a vast amount of information from a wide variety of sources.
- None of these
27. Data Storage component of data warehouse is responsible for
- providing the end-users with access to the stored warehouse information through the use of specidalised end-user tools.
- collecting the data from legacy system and convert them into usable form for the users.
- holding a vast amount of information from a wide variety of sources.
- None of these.
28. The data warehouse structure is based on
- a relational database management system sever that functions as the central repository for informational data.
- a network database system
- Both (a) and (b)
- None of these
29. In the data warehouse structure.
- operational data processing is completely separate from data warehouse processing.
- opeational data and processing is part of data warehouse processing.
- Both (a) and (b)
- None of these