Questões de Banco de Dados (TI) — TRE-PR / Diversas

Questão 1TRE-PR·Diversas·2017Banco de Dados (TI)

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

Aunidimensional structures, named cubes or datamarts that contain all data in the database.Bbidimensional structures, named facts, that contains information about all data from data source.Cmultidimensional structures that contain a specific piece of data from the database.Dheterogeneous structures, named blocks, that contains the main information of the piece of data you want to store.Emultidimensional structures, named tuples that are composed by a star table and many different dimensions.