Quiz
C192 / Data Warehousing
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 (43)
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
- Ddecentralized
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 is object oriented
- DData is 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
- Bmultidimensional
- 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
21Data cubes are created by extracting data from the operational database or from the data ____.
- Abase
- Bmanagement system
- Cprocessing system
- Dwarehouse
22The ability to capture the data ____ in memory provides faster response times, but it also makes the MDBMS more resource intensive than its relational counterpart.
- Abase
- Bcube
- Carray
- Dcache
23Multidimensional data analysis is also affected by how the database system handles ____.
- Amain memory
- Bhypercubes
- Cwarehouses
- Dsparsity
24____ is a measurement of the density of the data held in the data cube.
- ACompactness
- BConcentration
- CMass
- DSparsity
25____ are numeric measurements or values that represent a specific business aspect or activity.
- ATables
- BSchemas
- CFacts
- DAttributes
26____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.
- APartitioning
- BReplication
- CAggregation
- DDenormalizing
27____ makes a copy of a table and places it in a different location, to improve access time.
- APeriodicity
- BAggregation
- CPartitioning
- DReplication
28____ provides information about the timespan of the data stored in the table.
- APeriodicity
- BPartitioning
- CReplication
- DAggregation
29During the data ____ phase of data mining, the main data sets to be used by the data mining operation are identified and cleansed of any data impurities.
- Aanalysis
- Bpreparation
- Cclassification
- Dacquisition
30During the data ____ phase of data mining, common characteristics or patterns are identified.
- Aanalysis
- Bpreparation
- Cextraction
- Dacquisition
31During the ____ phase of data mining, the data mining tool selects the appropriate modeling algorithms.
- Aanalysis and classification
- Bpreparation
- Cprognosis
- Dknowledge acquisition
32During the ____ phase of data mining, the data mining findings are used to predict future behavior and forecast business outcomes.
- Aanalysis and classification
- Bpreparation
- Cprognosis
- Dknowledge acquisition
33The ____ schema creates the near equivalent of a multidimensional database schema from the existing relational database.
- Astar
- Bsquare
- COLAP
- DROLAP
34Which of the following is NOT a basic component of a star schema?
- AAttribute hierarchy
- BFact
- CDomain
- DDimension
35Using multidimensional jargon, the ability to focus on slices of the cube to perform a more detailed analysis is known as ____.
- Astar cuts
- Bslice and dice
- Cmicroscoping
- DTPL processing
36Given the importance and universality of this dimension from a data analysis perspective, many vendors have added automatic ____ dimension management features to their data warehousing products.
- Aspace
- Btime
- Clocation
- Dproduct
37Which of the following is NOT a technique used to optimize data warehouse design?
- ANormalization of dimensional tables
- BMultiple fact tables representing different aggregation levels
- CTable partitioning and replication
- DNormalization of fact tables
38During the ____ phase of data warehouse implementation, the designer must identify and interview key users, define main subjects, and identify operational data models among other tasks.
- Ainitial data gathering
- Bdesign and mapping
- Cloading and testing
- Drollout and feedback
39During the ____ phase of data warehouse implementation, tasks include system maintenance and system expansion.
- Ainitial data gathering
- Bdesign and mapping
- Cloading and testing
- Drollout and feedback
40In contrast to the traditional DSS tools, data mining is ____.
- Aproactive
- Bprotective
- Cautomatic
- Dcostly
41Decision ____ is a methodology designed to extract information from data and to use such information as a basis for decision making.
- Amanagement
- Bsupport
- Cmining
- Danalysis
42The DSS database is called the ____.
- AOLAP
- Bdata store
- CDBMS
- DRDSS
43In which DSS architectural style does the data store contain lightly aggregated data in an RDBMS?
- ATraditional mainframe based OLTP
- BMIS with 3GL
- CFirst-generation departmental DSS
- DSecond-generation data warehouse using MDBMS
Information
- Description
- College C192 Databases Quiz on C192 / Data Warehousing, created by Craig Willey on 29/06/2020.
- Author
- Craig Willey
- Language
- English
- Views
- 7
- Tags
- Rating
- No ratings yet Rate this quiz