IAProvatec | A Maneira Inteligente de Estudar

#2344783

Banco de Dados: OLAP (On-line Analytical Processing)

2017 FCC TRT - 24ª REGIÃO (MS)

Analista Judiciário Tecnologia da Informação

Consider the following descriptions of the OLAP operations in multidimensional data:

− The slice operation ..I.. one particular dimension from a given cube and provides a new sub-cube.

− Drill-down can be performed by ..II.. a concept hierarchy for a dimension.

− Roll-up can be performed by ...III... a concept hierarchy for a dimension.

− The pivot operation is also known as rotation. It ...IV... the data axes in view in order to provide an alternative presentation of data.

The correct words to fill in the gaps I, II, III and IV are, respectively,

A selects, stepping down, climbing up and rotates.

B select, fall down, scale up and rotate.

C selects, climbing up, stepping down and rotates.

D select, climbing, stepping and rotate.

E select, pull up, climbing down and rotates.

FCC - 2017 - TRT - 24ª REGIÃO (MS) - Analista Judiciário - Tecnologia da Informação