Question 1

Figuer: (Oracle)
CREATE DIMENSION StoreDim
LEVEL StoreID IS Store. StoreID
LEVEL City IS Store. StoreCity
LEVEL State IS Store. StoreState
LEVEL Zap IS Store.StoreZip
LEVEL Nation IS Store. StoreNation
LEVEL DivID IS Division. DivID
HIERARCHY CityRollup (
StoreID CHILD OF
City CHILD OF
State CHILD OF
Nation )
HIERARCHY ZipRollup
StoreID CHILD OF
Zip CHILD OF
State CHILD OF
Nation )
HIERARCHY DivisionRollup (
StoreID CHILD OF
DivID
JOIN KEY Store.DivID REFERENCES DivID )
ATTRIBUTE DivID DETERMINES Division. DivName
ATTRIBUTE DivID DETERMINES Division. DivManager; 
-The dimension StoreDim contains how many hierarchies?

Accepted Answer

The dimension StoreDim contains three hierarchies: CityRollup, ZipRollup, and DivisionRollup, as explicitly defined in the given code.

Question 2

An organization that does not want to take the time to develop an EDM sometimes uses a(n)_________________ architecture for data warehousing by modeling one entity at a time and storing them in separate data marts.

Accepted Answer

The answer of An organization that does not want to...

Question 3

Figure:
Table1
$$\begin{array} { | l | l | l | } 
\hline \text { Bank product } & \text { Location } & \text { Number-of-customers } \
\hline \text { Checking } & \text { USA } & 1,000,000 \
\hline \text { Checking } & \text { Europe } & 500,000 \
\hline \text { Checking } & \text { SE Asia } & 1,100,000 \
\hline \text { Checking } & \text { India } & 300,000 \
\hline \text { Savings } & \text { USA } & 700,000 \
\hline \text { Savings } & \text { Europe } & 400,000 \
\hline \text { Savings } & \text { SE Asia } & 900,000 \
\hline \text { Savings } & \text { India } & 800,000 \
\hline \text { Mutual funds } & \text { USA } & 300,000 \
\hline \text { Mutual funds } & \text { Europe } & \
\hline \text { Mutual funds } & \text { SE Asia } & 300,000 \
\hline \text { Mutual funds } & \text { India } & 80,000 \
\hline
\end{array}$$
Table2
$$\begin{array} { | l | l | l | l | } 
\hline \text { Location } & \text { Checking } & \text { Savings } & \text { Mutual Funds } \
\hline \text { USA } & 1,000,000 & 700,000 & 300,000 \
\hline \text { Europe } & 500,000 & 400,000 & 200,000 \
\hline \text { SE Asia } & 1,100,000 & 900,000 & 300,000 \
\hline \text { India } & & & \
\hline
\end{array}$$
The numeric values in Table2 indicate the number of customers.
-We want to add the following capabilities to Table2: show the data for 3 age groups (20-39,40-60,over 60),3 revenue groups (less than $10,000,$10,000-$30,000,over $30,000)and add a new type of account: Money market.The Types of account are either government-insured (checking,savings)or non-government-insured (Money Market,Mutual Funds).This latest requirement creates:

Accepted Answer

The answer of  Figure:
Table1
\[\begin{array} { | l | l...

Question 4

Figure:
Table1
$$\begin{array} { | l | l | l | } 
\hline \text { Bank product } & \text { Location } & \text { Number-of-customers } \
\hline \text { Checking } & \text { USA } & 1,000,000 \
\hline \text { Checking } & \text { Europe } & 500,000 \
\hline \text { Checking } & \text { SE Asia } & 1,100,000 \
\hline \text { Checking } & \text { India } & 300,000 \
\hline \text { Savings } & \text { USA } & 700,000 \
\hline \text { Savings } & \text { Europe } & 400,000 \
\hline \text { Savings } & \text { SE Asia } & 900,000 \
\hline \text { Savings } & \text { India } & 800,000 \
\hline \text { Mutual funds } & \text { USA } & 300,000 \
\hline \text { Mutual funds } & \text { Europe } & \
\hline \text { Mutual funds } & \text { SE Asia } & 300,000 \
\hline \text { Mutual funds } & \text { India } & 80,000 \
\hline
\end{array}$$
Table2
$$\begin{array} { | l | l | l | l | } 
\hline \text { Location } & \text { Checking } & \text { Savings } & \text { Mutual Funds } \
\hline \text { USA } & 1,000,000 & 700,000 & 300,000 \
\hline \text { Europe } & 500,000 & 400,000 & 200,000 \
\hline \text { SE Asia } & 1,100,000 & 900,000 & 300,000 \
\hline \text { India } & & & \
\hline
\end{array}$$
The numeric values in Table2 indicate the number of customers.
-We have added the following capability to Table2: showing the data for 3 age groups (20-39,40-60,over 60)as a third dimension.Showing the data for age group 40-60 is called:

Accepted Answer

Adding a specific age group (40-60) as a dimension and focusing on it is called slicing the data. This is because it involves selecting a subset of the data based on specific criteria, similar to slicing a portion from the whole.

Question 5

______________ is the process of discovering implicit data patterns in the data of a data warehouse,and using those patterns for business advantage.

Accepted Answer

The answer of ______________ is the process of discovering implicit...

Question 6

Figuer: (Oracle)
CREATE DIMENSION StoreDim
LEVEL StoreID IS Store. StoreID
LEVEL City IS Store. StoreCity
LEVEL State IS Store. StoreState
LEVEL Zap IS Store.StoreZip
LEVEL Nation IS Store. StoreNation
LEVEL DivID IS Division. DivID
HIERARCHY CityRollup (
StoreID CHILD OF
City CHILD OF
State CHILD OF
Nation )
HIERARCHY ZipRollup
StoreID CHILD OF
Zip CHILD OF
State CHILD OF
Nation )
HIERARCHY DivisionRollup (
StoreID CHILD OF
DivID
JOIN KEY Store.DivID REFERENCES DivID )
ATTRIBUTE DivID DETERMINES Division. DivName
ATTRIBUTE DivID DETERMINES Division. DivManager; 
-The dimension StoreDim contains how many levels?

Accepted Answer

The dimension StoreDim contains 6 levels: StoreID, City, State, Zip, Nation, and DivID.

Question 7

In maintaining a data warehouse,which of the following is not a task in the preparation phase:

Accepted Answer

Merging is typically part of the integration phase, not the preparation phase, which includes extraction, transportation, and cleaning.

Question 8

A subset of a data warehouse,typically at a department level,that acts as an interface between the end users and the corporate data warehouse is called a(n)___________________.

Accepted Answer

The answer of A subset of a data warehouse,typically at...

Question 9

Figure:
Table1
$$\begin{array} { | l | l | l | } 
\hline \text { Bank product } & \text { Location } & \text { Number-of-customers } \
\hline \text { Checking } & \text { USA } & 1,000,000 \
\hline \text { Checking } & \text { Europe } & 500,000 \
\hline \text { Checking } & \text { SE Asia } & 1,100,000 \
\hline \text { Checking } & \text { India } & 300,000 \
\hline \text { Savings } & \text { USA } & 700,000 \
\hline \text { Savings } & \text { Europe } & 400,000 \
\hline \text { Savings } & \text { SE Asia } & 900,000 \
\hline \text { Savings } & \text { India } & 800,000 \
\hline \text { Mutual funds } & \text { USA } & 300,000 \
\hline \text { Mutual funds } & \text { Europe } & \
\hline \text { Mutual funds } & \text { SE Asia } & 300,000 \
\hline \text { Mutual funds } & \text { India } & 80,000 \
\hline
\end{array}$$
Table2
$$\begin{array} { | l | l | l | l | } 
\hline \text { Location } & \text { Checking } & \text { Savings } & \text { Mutual Funds } \
\hline \text { USA } & 1,000,000 & 700,000 & 300,000 \
\hline \text { Europe } & 500,000 & 400,000 & 200,000 \
\hline \text { SE Asia } & 1,100,000 & 900,000 & 300,000 \
\hline \text { India } & & & \
\hline
\end{array}$$
The numeric values in Table2 indicate the number of customers.
-In Table2,we show the "location" as columns and the "type of account" as rows.This is called:

Accepted Answer

The transformation from Table 1 to Table 2, where the orientation of data is changed by swapping rows and columns, is known as a pivot operation.

Question 10

A(n)_______________________ is a conceptual data model of a data warehouse which defines the structure of the data warehouse and the metadata to access the operational databases and external data sources.

Accepted Answer

The answer of A(n)_______________________ is a conceptual data model of...

Question 11

Figure:
Table1
$$\begin{array} { | l | l | l | } 
\hline \text { Bank product } & \text { Location } & \text { Number-of-customers } \
\hline \text { Checking } & \text { USA } & 1,000,000 \
\hline \text { Checking } & \text { Europe } & 500,000 \
\hline \text { Checking } & \text { SE Asia } & 1,100,000 \
\hline \text { Checking } & \text { India } & 300,000 \
\hline \text { Savings } & \text { USA } & 700,000 \
\hline \text { Savings } & \text { Europe } & 400,000 \
\hline \text { Savings } & \text { SE Asia } & 900,000 \
\hline \text { Savings } & \text { India } & 800,000 \
\hline \text { Mutual funds } & \text { USA } & 300,000 \
\hline \text { Mutual funds } & \text { Europe } & \
\hline \text { Mutual funds } & \text { SE Asia } & 300,000 \
\hline \text { Mutual funds } & \text { India } & 80,000 \
\hline
\end{array}$$
Table2
$$\begin{array} { | l | l | l | l | } 
\hline \text { Location } & \text { Checking } & \text { Savings } & \text { Mutual Funds } \
\hline \text { USA } & 1,000,000 & 700,000 & 300,000 \
\hline \text { Europe } & 500,000 & 400,000 & 200,000 \
\hline \text { SE Asia } & 1,100,000 & 900,000 & 300,000 \
\hline \text { India } & & & \
\hline
\end{array}$$
The numeric values in Table2 indicate the number of customers.
-We have added the following capability to Table2: showing the data for 3 age groups (20-39,40-60,over 60)as a third dimension.Showing the data for age groups 20-39 and 40-60 is called:

Accepted Answer

Dice is the operation that selects specific rows and columns from a data cube, often based on specific dimensions or criteria, such as age groups in this case.

Question 12

In a(n)______________ data warehouse architecture,operational data are transformed and loaded into the data warehouse,which is accessed directly by the user departments.

Accepted Answer

The answer of In a(n)______________ data warehouse architecture,operational data are...

Question 13

Which of the following statements is not true about populating a data warehouse:

Accepted Answer

Populating a data warehouse is not a matter of simply copying data from various sources. It involves several steps such as extracting, transforming, and loading data from various sources while ensuring the quality and accuracy of the data.

Question 14

Figuer: (Oracle)
CREATE DIMENSION StoreDim
LEVEL StoreID IS Store. StoreID
LEVEL City IS Store. StoreCity
LEVEL State IS Store. StoreState
LEVEL Zap IS Store.StoreZip
LEVEL Nation IS Store. StoreNation
LEVEL DivID IS Division. DivID
HIERARCHY CityRollup (
StoreID CHILD OF
City CHILD OF
State CHILD OF
Nation )
HIERARCHY ZipRollup
StoreID CHILD OF
Zip CHILD OF
State CHILD OF
Nation )
HIERARCHY DivisionRollup (
StoreID CHILD OF
DivID
JOIN KEY Store.DivID REFERENCES DivID )
ATTRIBUTE DivID DETERMINES Division. DivName
ATTRIBUTE DivID DETERMINES Division. DivManager; 
-The dimension StoreDim gets data from how many tables?

Accepted Answer

The dimension StoreDim gets data from two tables: "Store" and "Division", as indicated by the references to Store.* and Division.* fields in the dimension definition.

Question 15

The ATTRIBUTE clause:

Accepted Answer

The ATTRIBUTE clause in a dimensional table's CREATE TABLE statement specifies a constraint of the dimension and defines a functional dependency between a dimension level and a non-source column. Therefore, both options A and B are correct.

Question 16

Figure:
Table1
$$\begin{array} { | l | l | l | } 
\hline \text { Bank product } & \text { Location } & \text { Number-of-customers } \
\hline \text { Checking } & \text { USA } & 1,000,000 \
\hline \text { Checking } & \text { Europe } & 500,000 \
\hline \text { Checking } & \text { SE Asia } & 1,100,000 \
\hline \text { Checking } & \text { India } & 300,000 \
\hline \text { Savings } & \text { USA } & 700,000 \
\hline \text { Savings } & \text { Europe } & 400,000 \
\hline \text { Savings } & \text { SE Asia } & 900,000 \
\hline \text { Savings } & \text { India } & 800,000 \
\hline \text { Mutual funds } & \text { USA } & 300,000 \
\hline \text { Mutual funds } & \text { Europe } & \
\hline \text { Mutual funds } & \text { SE Asia } & 300,000 \
\hline \text { Mutual funds } & \text { India } & 80,000 \
\hline
\end{array}$$
Table2
$$\begin{array} { | l | l | l | l | } 
\hline \text { Location } & \text { Checking } & \text { Savings } & \text { Mutual Funds } \
\hline \text { USA } & 1,000,000 & 700,000 & 300,000 \
\hline \text { Europe } & 500,000 & 400,000 & 200,000 \
\hline \text { SE Asia } & 1,100,000 & 900,000 & 300,000 \
\hline \text { India } & & & \
\hline
\end{array}$$
The numeric values in Table2 indicate the number of customers.
-We add the following two dimensions to Table2: age groups (20-39,40-60,over 60)and revenue groups (less than $10,000,$10,000-$30,000,over $30,000).The star schema consists of the following number of tables:

Accepted Answer

The star schema will consist of 5 tables: 1 fact table (Table2 with the number of customers) and 4 dimension tables (Location, Bank Product, Age Groups, Revenue Groups).

Question 17

A(n)____________________ is a just-in-time data mart usually built from one operational database in response to a major event.

Accepted Answer

The answer of A(n)____________________ is a just-in-time data mart usually...

Question 18

A(n)___________________ is a multidimensional format sometimes known as a hypercube,because conceptually it could have an infinite number of dimensions.

Accepted Answer

The answer of A(n)___________________ is a multidimensional format sometimes known...

Question 19

Figuer: (Oracle)
CREATE DIMENSION StoreDim
LEVEL StoreID IS Store. StoreID
LEVEL City IS Store. StoreCity
LEVEL State IS Store. StoreState
LEVEL Zap IS Store.StoreZip
LEVEL Nation IS Store. StoreNation
LEVEL DivID IS Division. DivID
HIERARCHY CityRollup (
StoreID CHILD OF
City CHILD OF
State CHILD OF
Nation )
HIERARCHY ZipRollup
StoreID CHILD OF
Zip CHILD OF
State CHILD OF
Nation )
HIERARCHY DivisionRollup (
StoreID CHILD OF
DivID
JOIN KEY Store.DivID REFERENCES DivID )
ATTRIBUTE DivID DETERMINES Division. DivName
ATTRIBUTE DivID DETERMINES Division. DivManager; 
-The dimension StoreDim gets data from how many columns of the source table Store?

Accepted Answer

The dimension StoreDim gets data from 5 columns of the source table Store: StoreID, StoreCity, StoreState, StoreZip, and StoreNation.

Question 20

A central repository for summarized and integrated data from operational databases and external sources,used to support decision making is a(n)___________________.

Accepted Answer

The answer of A central repository for summarized and integrated...

Quiz 16: Data Warehouse Technology and Management