GENERICDATA
Observe the Tables GENERICDIMENSION and GENERICFACT:

GENERICDIMENSION

question 13

Multiple Choice

GENERICDATA
Observe the tables GENERICDIMENSION and GENERICFACT:

GENERICDIMENSION
$\begin{array} { l l l l l l } A A & B B & C C & D D & E E & F F \\ A A 1 & B B 1 & C C 1 & D D 1 & E E 1 & F F 1 \\ A A 2 & B B 2 & C C 1 & D D 2 & E E 2 & F F 1 \\ A A 3 & B B 3 & C C 2 & D D 3 & E E 1 & F F 1 \\ A A 4 & B B 4 & C C 2 & D D 4 & E E 2 & F F 1 \\ A A 5 & B B 5 & C C 2 & D D 5 & E E 3 & F F 1 \end{array}$
GENERICFACT
$\begin{array} { l c c } \text { AA } & \ldots & \text { Number } \\ \text { AA1 } & \ldots & 100 \\ \text { AA1 } & \ldots & 100 \\ A A 2 & \ldots & 200 \\ \text { AA2 } & \ldots & 200 \\ A A 3 & \ldots & 300 \\ A A 3 & \ldots & 300 \\ A A 4 & \ldots & 400 \\ A A 4 & \ldots & 400 \\ \text { AA5 } & \ldots & 100 \end{array}$ Assume the following two hierarchies exist in the table GENERICDIMENSION:
AA --> BB --> CC
AA --> DD --> EE --> FF
Assume the following result table was created using the OLAP/BI Tool:

GENERICOLAPRESULT1
$$\begin{array} { l r l } & C C 1 & C C 2 \\E E 1 & 200 & 600 \\E E 2 & 400 & 800 \\E E 3 & 0 & 100\end{array}$$
This scenario will be used for the following questions citing GENERICDATA.



-The result table below is the result of a ________ action on the GENERICOLAPRESULT1 result table.
$$\begin{array} { r r r r r r } && { C C 1 } && { C C 2 } \\& D D 1 & D D 2 & D D 3 & D D 4 & D D 5 \\E E 1 & 200 & 0 & 600 & 0 & 0 \\E E 2 & 0 & 400 & 0 & 800 & 0 \\E E 3 & 0 & 0 & 0 & 0 & 100\end{array}$$

• A)Slice and dice
• B)Pivot
• C)Drill-up
• D)Drill-down

---

Definitions:

Electronic Diary

A digital version of a personal journal or appointment book where users can record notes, events, and appointments electronically.

Secondary Data

Information that has been collected previously for some purpose other than the current research project, such as studies, reports, and surveys from external sources.

Primary Data

Data collected firsthand for a specific research purpose or project.

Observational Data

Information gathered by watching and recording actions or outcomes, without intervening or altering the situation.