C192 DML Architecture Part2

1. 1The components of a data warehouse are ____.

   1. Aintegrated
   2. Bvolatile
   3. Cobject-oriented
   4. Ddecentrialized
2. 2Which of the following is a rule that defines the data warehouse?

   1. Aenvironments are integrated
   2. BData warehouse contains historical data over a long time horizon
   3. Cdata are object-oriented
   4. Ddata are subject-oriented
3. 3Which of the following is a characteristic of an OLAP?

   1. AUses single dimensional data analysis techniques
   2. BProvides introductory database support and complex end user interfaces
   3. CProvides introductory end-user interfaces
   4. DSupports client/server architecture
4. 4____ data must conform to uniform structures and formats to avoid data conflicts.

   1. Adata mart
   2. Bdatabase
   3. Cdata warehouse
   4. Ddata analysis
5. 5Multidimensional data analysis refers to the processing of data such that data are viewed as part of the ____ structure.

   1. Asemidimensional
   2. Bmultidimensional
   3. Cone-dimensional
   4. Dtwo-dimensional
6. 6MOLAP extends OLAP functionality to multidimensional ____ management systems.

   1. Aonline
   2. Bdatabase
   3. Cprocessing
   4. Ddata
7. 7MOLAP's premise is that ____ databases are best suited to manage, store, and analyze multidimensional data.

   1. Amultidimensional
   2. Bone-dimensional
   3. Ctwo-dimensional
   4. Drelational
8. 8The ____ hierarchy provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.

   1. Arelational
   2. Bdimensional
   3. Cmultidimensional
   4. Dattribute
9. 9During the data ____ phase of data mining, common characteristics or patterns are identified.

   1. Aanalysis
   2. Bpreparation
   3. Cextraction
   4. Dacquisition
10. 10During the ____ phase of data mining, the data-mining findings are used to predict future behavior and forecast business outcomes.

    1. Aanalysis and classification
    2. Bpreparation
    3. Cprognosis
    4. Dknowledge acquisition

Description

Quiz on C192 DML Architecture Part2, created by Brandon Gagon on 28/11/2020.

Author

Brandon Gagon

Language

English

Views

0

Rating

No ratings yet

Rate this quiz

Rate this quiz

More on Data Warehouse Architecture