Question 1

Illustrate a typical MOLAP architecture.

Accepted Answer

Multidimensional Online Analytical Proce

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 
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

In a multidimensional cube,every record

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 
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 
A) ETL 
B) OLAP 
C) OLTP 
D) Micro batches

Question 8

What takes place during the load part of ETL?

Accepted Answer

Load refers to the process of

Question 9

What is a refresh cycle?

Accepted Answer

Refresh cycle is the

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 
A) Slice and dice 
B) Pivot 
C) Drill-up 
D) Drill-down

Illustrate a typical MOLAP architecture.

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

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

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

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).

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

What takes place during the load part of ETL?

What is a refresh cycle?

Introduction

Database Requirements and ER Modeling

Relational Database Modeling

Update Operations, update Anomalies, and Normalization

SQL

Database Implementation and Use

Data Warehousing Concepts

Data Warehouse and Data Mart Modeling

Overview of Dbms Functionalities and Database Administration

Filters

Exam 9: Data Warehouse Implementation and Use

Illustrate a typical MOLAP architecture.

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

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

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

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).

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

What takes place during the load part of ETL?

What is a refresh cycle?

Introduction

Database Requirements and ER Modeling

Relational Database Modeling

Update Operations, update Anomalies, and Normalization

SQL

Database Implementation and Use

Data Warehousing Concepts

Data Warehouse and Data Mart Modeling

Overview of Dbms Functionalities and Database Administration

Filters