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

Descrição

Quiz sobre C192 DML Architecture Part2, criado por Brandon Gagon em 28-11-2020.

Autor

Brandon Gagon

Idioma

English

Visualizações

0

Avaliação

Ainda sem avaliações

Avalie este quiz

Avalie este quiz

Mais sobre Data Warehouse Architecture