Quiz
C192 Data WareHousing 1-20
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (20)
1What are the high-level components that compose a DSS?
- AData store, data extraction, and data filtering
- BEnd user query tool and end user presentation tool
- CData store, data extraction and data filtering, end user query tool and end user presentation
tool - DData store, and end user query tool and end user presentation tool
2The components of a data warehouse are ____.
- Aintegrated
- Bvolatile
- Cobject-oriented
- Ddecentrialized
3Which of the following is a rule that defines the data warehouse?
- AEnvironments are integrated
- BData warehouse contains historical data over a long time horizon
- CData are object-oriented
- DData are subject-oriented
4Which of the following is a characteristic of an OLAP?
- AUses single dimensional data analysis techniques
- BProvides introductory database support and complex end user interfaces
- CProvides introductory end-user interfaces
- DSupports client/server architecture
5The DSS tools that use multidimensional data analysis techniques are known as online ____ processing.
- Aanalysis
- Banalytical
- Cstatistical
- Dcomputational
6A complete data warehouse ____ includes support for a DSS data store, a data extraction and integration filter, and a specialized presentation interface.
- Adatabase
- Bcycle
- Cfile
- Darchitecture
7____ data must conform to uniform structures and formats to avoid data conflicts.
- AData mart
- BDatabase
- CData warehouse
- DData analysis
8Multidimensional data analysis refers to the processing of data such that data are viewed as part of the ____ structure.
- Asemidimensional
- Bmulti-dimensional
- Cone-dimensional
- Dtwo-dimensional
9Many of the OLAP interface features are "borrowed" from previous generations of data ____ tools.
- Amodule
- Bprocessing
- Cfiltering
- Danalysis
10Client/server ____ provides a framework within which new systems can be designed, developed, and implemented.
- Ainterface
- Barchitecture
- Cprocessing
- Dsupport
11When the OLAP GUI runs on the client workstations, and the OLAP engine runs on a shared computer, the ____ is more practical than running both on the same computer.
- Ainterface
- Bprocessing
- Carchitecture
- Dsupport
12The end user GUI might be a custom-made program or a plug-in module that is integrated with Lotus 123, Microsoft Excel, or other third party data ____ and query tools.
- Aanalysis
- Bbase
- Cprocessing
- Dintegration
13Multidimensional data analysis requires some type of multidimensional data representation, which is normally provided by the ____ engine.
- AVLDB
- BRDBMS
- COLAP
- DROLAP
14The data warehouse and OLAP are two interrelated and complementary ____.
- Aenvironments
- Bprograms
- Csystems
- Dwarehouses
15To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end user ____.
- Aworkstations
- Bqueries
- Cschemas
- Dservers
16MOLAP extends OLAP functionality to multidimensional ____ management systems.
- Aonline
- Bdatabase
- Cprocessing
- Ddata
17MOLAP's premise is that ____ databases are best suited to manage, store, and analyze multidimensional data.
- Amultidimensional
- Bone-dimensional
- Ctwo-dimensional
- Drelational
18Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a(n) ____.
- Aanalytical cube
- Bhypercube
- Cdata cube
- Dsparse cube
19The location of each data value in the data cube is a function of the x, y, and z axes in a ____ space.
- Aone-dimensional
- Btwo-dimensional
- Cthree-dimensional
- Dmultidimensional
20Data cubes can grow to n-number of dimensions, thus becoming ____.
- Amemory cubes
- Bdimensional cubes
- Chypercubes
- Dstar data cubes
Information
- Description
- Quiz on C192 Data WareHousing 1-20, created by Brandon Gagon on 30/11/2020.
- Author
- Brandon Gagon
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz