Question 1

What takes place during the transformation part of ETL?

Accepted Answer

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

Question 2

Which of the following processes is typically the most time- and resource-consuming?

Accepted Answer

A) Creating the data warehouse tables using the DBMS functionalities 
B) Creating the OLAP query 
C) Creating the ETL infrastructure 
D) Creating the data warehouse model

Question 3

The word online in the term OLAP refers to the use of the Internet or other networks.

Accepted Answer

A) True 
 B)False

Question 4

GENERIC RETAILER
Observe the ER diagram for the Generic Retailer:
  Assume that the dimension PRODUCT containing the following columns:
ProductKey (surrogate key)
ProductID
ProductDescription
ProductBrandID
ProductBrandName
ProductCategoryID
ProductCategoryName
is created for the Generic Retailer.This dimension will be used for the following questions citing Generic Retailer PRODUCT dimension.
-A user using an OLAP query (based on the dimensionally modeled data set that contains the Generic Retailer dimension PRODUCT)can drill up from ProductBrandID to ProductCategoryID.

Accepted Answer

A) True 
 B)False

Question 5

Data cleansing is a part of:

Accepted Answer

A) OLAP 
B) Extraction 
C) Transformation 
D) Load

Question 6

What is a data warehouse alpha release?

Accepted Answer

The answer of What is a data warehouse alpha release?...

Question 7

Updating,querying,and presenting data from databases for operational purposes is known as:

Accepted Answer

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

Question 8

Developing front-end applications includes creating a set of predeveloped queries and interfaces to those queries.

Accepted Answer

A) True 
 B)False

Question 9

What takes place during the extraction part of ETL?

Accepted Answer

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

Question 10

GENERIC RETAILER
Observe the ER diagram for the Generic Retailer:
  Assume that the dimension PRODUCT containing the following columns:
ProductKey (surrogate key)
ProductID
ProductDescription
ProductBrandID
ProductBrandName
ProductCategoryID
ProductCategoryName
is created for the Generic Retailer.This dimension will be used for the following questions citing Generic Retailer PRODUCT dimension.
-A user using an OLAP query (based on the dimensionally modeled data set that contains the Generic Retailer dimension PRODUCT)can drill down from ProductBrandID to ProductCategoryID.

Accepted Answer

A) True 
 B)False

Question 11

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 data in the three source tables,how many records in the dimension CUSTOMER in the populated star schema for ALSETMAX COMPANY represent a customer named Ned?

Accepted Answer

A) 1 
B) 2 
C) 3 
D) 4

Question 12

Creating a data warehouse involves using the functionalities of database management software to implement the data warehouse model as a collection of physically created and mutually connected database tables.

Accepted Answer

A) True 
 B)False

Question 13

GENERIC RETAILER
Observe the ER diagram for the Generic Retailer:
  Assume that the dimension PRODUCT containing the following columns:
ProductKey (surrogate key)
ProductID
ProductDescription
ProductBrandID
ProductBrandName
ProductCategoryID
ProductCategoryName
is created for the Generic Retailer.This dimension will be used for the following questions citing Generic Retailer PRODUCT dimension.
-A user using an OLAP query (based on the dimensionally modeled data set that contains the Generic Retailer dimension PRODUCT)can drill down from ProductBrandID to ProductID.

Accepted Answer

A) True 
 B)False

Question 14

What is a data warehouse production release?

Accepted Answer

The answer of What is a data warehouse production release?...

Question 15

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 data in the three source tables,how many records will the dimension CUSTOMER in the populated star schema for ALSETMAX COMPANY have?

Accepted Answer

A) 4 
B) 5 
C) 8 
D) 13

Question 16

What is a refresh load?

Accepted Answer

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

Question 17

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} { l l l c } 
& E E 1 & E E 2 & E E 3 \
C C 1 & 200 & 400 & 0 \
C C 2 & 600 & 800 & 100
\end{array}$$

Accepted Answer

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

Question 18

The ETL infrastructure is essentially predetermined by the results of the requirements collection and data warehouse modeling processes that specify:

Accepted Answer

A) The OLAP/BI tools 
B) The alpha release 
C) The sources and the target 
D) The refresh cycle

Question 19

What is a data warehouse beta release?

Accepted Answer

The answer of What is a data warehouse beta release?...

Question 20

Illustrate a typical ROLAP architecture.

Accepted Answer

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

Exam 9: Data Warehouse Implementation and Use

What takes place during the transformation part of ETL?

Which of the following processes is typically the most time- and resource-consuming?

The word online in the term OLAP refers to the use of the Internet or other networks.

Data cleansing is a part of:

What is a data warehouse alpha release?

Updating,querying,and presenting data from databases for operational purposes is known as:

Developing front-end applications includes creating a set of predeveloped queries and interfaces to those queries.

What takes place during the extraction part of ETL?

Creating a data warehouse involves using the functionalities of database management software to implement the data warehouse model as a collection of physically created and mutually connected database tables.

What is a data warehouse production release?

What is a refresh load?

The ETL infrastructure is essentially predetermined by the results of the requirements collection and data warehouse modeling processes that specify:

What is a data warehouse beta release?

Illustrate a typical ROLAP architecture.