Simulado Tribunal de Justiça do Estado de Santa Catarina - TJ/SC | Analista de Sistemas | 2020 | Questão 172

Tecnologia da Informação / Banco de Dados / 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