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:

Redeem Provision

A clause in a financial contract allowing the holder to exchange a particular financial instrument under specified conditions, often before maturity.

Investment-Grade Bonds

Bonds that are rated by credit rating agencies as having a lower risk of default, making them a safer investment.

Speculative Bonds

Speculative bonds are high-risk, high-reward investment securities that have a lower credit rating and offer higher yields to compensate for their increased risk.

Fourth Market

Direct trading of stocks and securities among investors or institutions without the use of a broker or public exchange.