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

Descripción

Test sobre C192 DML Architecture Part2, creado por Brandon Gagon el 28/11/2020.

Autor

Brandon Gagon

Idioma

English

Visitas

0

Valoración

Aún sin valoraciones

Valora este test

Valora este test

Más sobre Data Warehouse Architecture