Exam 9: Data Warehouse Implementation and Use

If applicable,the archived data from operational sources is loaded in the data warehouse during the:

The process of deciding what to extract during the extraction process begins after the requirements and modeling stages are completed.

GENERICDATA Observe the tables GENERICDIMENSION and GENERICFACT: GENERICDIMENSION AA BB CC DD EE FF AA1 BB1 CC1 DD1 EE1 FF1 AA2 BB2 CC1 DD2 EE2 FF1 AA3 BB3 CC2 DD3 EE1 FF1 AA4 BB4 CC2 DD4 EE2 FF1 AA5 BB5 CC2 DD5 EE3 FF1 GENERICFACT AA \ldots Number AA1 \ldots 100 AA1 \ldots 100 AA2 \ldots 200 AA2 \ldots 200 AA3 \ldots 300 AA3 \ldots 300 AA4 \ldots 400 AA4 \ldots 400 AA5 \ldots 100 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 CC1 CC2 EE1 200 600 EE2 400 800 EE3 0 100 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. $E E 1$ 1 200 2 600 EE2 1 400 2 800 EE3 CC1 0 CC2 100

The multidimensional database cube always has three dimensions.

Which of the following is NOT true? Front-end (BI)applications are used to retrieve the data from:

The data in fact tables is always located faster in relational implementations than in the multidimensional implementations.

What is the multidimensional database model?

What is an executive dashboard?

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 SSN Name Gemder CustBirthYear 111-11-1111 Ned Male 1980 222-22-2222 Nelly Female 1990 333-33-3333 Anna Female 1989 444-44-4444 Ned Male 1970 \\ A-MAX CUSTOMER TABLE GSN Nane Sex YearOfBirth 111-11-1111 Ned M 1980 222-22-2212 Nelly F 1990 333-33-3333 Anna F 1989 555-55-5555 Anna F 1970 \\ AM CUSTOMER ZIPCODE INFO SSN ZipCode 111-11-1111 60611 222-22-2122 60655 333-33-3333 60601 444-44-4444 60611 555-55-5555 60655 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 female customer?

The process of transformation cannot involve standardizing different versions of the same data present in different data sources.

The set of processes that is used to populate the data warehouse tables with the appropriate relevant data retrieved from the operational databases is known as:

The purpose of the drill down operation is to make the granularity of the data in the query result finer.

GENERICDATA Observe the tables GENERICDIMENSION and GENERICFACT: GENERICDIMENSION AA BB CC DD EE FF AA1 BB1 CC1 DD1 EE1 FF1 AA2 BB2 CC1 DD2 EE2 FF1 AA3 BB3 CC2 DD3 EE1 FF1 AA4 BB4 CC2 DD4 EE2 FF1 AA5 BB5 CC2 DD5 EE3 FF1 GENERICFACT AA \ldots Number AA1 \ldots 100 AA1 \ldots 100 AA2 \ldots 200 AA2 \ldots 200 AA3 \ldots 300 AA3 \ldots 300 AA4 \ldots 400 AA4 \ldots 400 AA5 \ldots 100 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 CC1 CC2 EE1 200 600 EE2 400 800 EE3 0 100 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. CC1 CC2 DD1 DD2 DD3 DD4 DD5 EE1 200 0 600 0 0 EE2 0 400 0 800 0 EE3 0 0 0 0 100

GENERICDATA Observe the tables GENERICDIMENSION and GENERICFACT: GENERICDIMENSION AA BB CC DD EE FF AA1 BB1 CC1 DD1 EE1 FF1 AA2 BB2 CC1 DD2 EE2 FF1 AA3 BB3 CC2 DD3 EE1 FF1 AA4 BB4 CC2 DD4 EE2 FF1 AA5 BB5 CC2 DD5 EE3 FF1 GENERICFACT AA \ldots Number AA1 \ldots 100 AA1 \ldots 100 AA2 \ldots 200 AA2 \ldots 200 AA3 \ldots 300 AA3 \ldots 300 AA4 \ldots 400 AA4 \ldots 400 AA5 \ldots 100 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 CC1 CC2 EE1 200 600 EE2 400 800 EE3 0 100 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. CC1 CC2 EE1 200 600 EE2 400 800

Illustrate a typical HOLAP architecture.

OLAP tools are:

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 ABC Retailer dimension PRODUCT)can drill up from ProductID to ProductCategoryID.

What is a first load?

OLAP/BI tools can be used for:

OLAP/BI tools are designed for the analysis of dimensionally modeled data.