Question 1

Illustrate a typical MOLAP architecture.

Accepted Answer

The answer of Illustrate a typical MOLAP architecture....

Question 2

The purpose of the drill up operation is to make the granularity of the data in the query result coarser.

Accepted Answer

A) True 
 B)False

Question 3

ALSETMAX COMPANY
Observe the three different tables that exist in the ALSETMAX COMPANY and contains the information about customers.Assume all the values in all tables are correct.All three tables will be used as the source tables for the dimension CUSTOMER in the ALSETMAX COMPANY dimensionally modeled data warehouse.
 ALSE TMAX CUSTOMERS
$\begin{array} { c l l c } \text { SSN } & \text { Name } & \text { Gemder } & \text { CustBirthYear } \ 111 - 11 - 1111 & \text { Ned } & \text { Male } & 1980 \ 222 - 22 - 2222 & \text { Nelly } & \text { Female } & 1990 \ 333 - 33 - 3333 & \text { Anna } & \text { Female } & 1989 \ 444-44 - 4444 & \text { Ned } & \text { Male } & 1970 \end{array}$\
A-MAX CUSTOMER TABLE
$\begin{array} { c c c c } \text { GSN } & \text { Nane } & \text { Sex } & \text { YearOfBirth } \ 111 - 11 - 1111 & \text { Ned } & \text { M } & 1980 \ 222 - 22 - 2212 & \text { Nelly } & F & 1990 \ 333 - 33 - 3333 & \text { Anna } & F & 1989 \ 555 - 55 - 5555 & \text { Anna } & F & 1970 \end{array}$\
AM CUSTOMER ZIPCODE INFO
$\begin{array} { c c } \text { SSN } & \text { ZipCode } \ 111 - 11 - 1111 & 60611 \ 222 - 22 - 2122 & 60655 \ 333 - 33 - 3333 & 60601 \ 444 - 44 - 4444 & 60611 \ 555 - 55 - 5555 & 60655 \end{array}$

This scenario will be used for the following questions citing ALSETMAX COMPANY.
-Based on the three source tables,how many columns will the dimension CUSTOMER in the populated star schema for ALSETMAX COMPANY have? (Assume that the dimension uses a surrogate key,but no time stamps or row indicators. )

Accepted Answer

A) 6 
B) 7 
C) 8 
D) 10

Question 4

Archived data from source systems is never present in the data warehouse.

Accepted Answer

A) True 
 B)False

Question 5

What enables direct lookup of values in the fact table in a multidimensional cube?

Accepted Answer

The answer of What enables direct lookup of values in...

Question 6

In the case of so-called active data warehouses,the loads occur in ________ that happen continuously,ensuring that the data in the data warehouse is updated close to real time (enabling analysis of the latest data).

Accepted Answer

A) Dimensional modeling actions 
B) OLAP actions 
C) OLTP actions 
D) Micro batches

Question 7

Querying and presenting data from data warehouses and/or data marts for analytical purposes is known as:

Accepted Answer

A) ETL 
B) OLAP 
C) OLTP 
D) Micro batches

Question 8

What takes place during the load part of ETL?

Accepted Answer

The answer of What takes place during the load part...

Question 9

What is a refresh cycle?

Accepted Answer

The answer of What is a refresh cycle?...

Question 10

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 } 
& \mathcal { C C 1 } & \mathcal { C C } 2 \
F F 1 & 600 & 1500
\end{array}$$

Accepted Answer

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

Exam 9: Data Warehouse Implementation and Use