Simulado Conselho Nacional do Ministério Público - CNMP | Analista do CNMP - Desenvolvimento de Sistemas | 2019 pre-edital | Questão 453

Tópicos Avançados / Arquitetura e análise de requisitos para sistemas analíticos, ferramentas ETL e OLAP; Arquitetura e aplicações de datawarehouse, ETL e Olap

A Data Warehouse supports Online Analytical Process − OLAP providing a flexible and analytical manner of storing data. In a
Data Warehouse, data are stored in

A ) unidimensional structures, named cubes or datamarts that contain all data in the database.

B ) bidimensional structures, named facts, that contains information about all data from data source.

C ) multidimensional structures that contain a specific piece of data from the database.

D ) heterogeneous structures, named blocks, that contains the main information of the piece of data you want to store.

E ) multidimensional structures, named tuples that are composed by a star table and many different dimensions.

Voltar à pagina de tópicos Próxima

Fonte: ANALISTA JUDICIáRIO - ANáLISE DE SISTEMAS / TRE/PR / 2017 / FCC