Quiz
C192 / Data Warehousing
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do 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
Informações
- Descrição
- College C192 Databases Quiz sobre C192 / Data Warehousing, criado por Craig Willey em 29-06-2020.
- Autor
- Craig Willey
- Idioma
- English
- Visualizações
- 7
- Etiquetas
- Avaliação
- Ainda sem avaliações Avalie este quiz