Question 1

The following questions citing STATEWIDE HEALTH assume that a single-source star schema is created. The  purpose of this star schema is to analyze quantities of prescribed medications by all dimensions provided by its source: the STATEWIDE HEALTH PRESCRIPTIONS DATABASE shown below. In this database, each prescription is prescribed for one patient by one doctor, and it contains one medication.

STATEWIDE HEALTH PRESCRIPTIONS  DATABASE

-Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS database,if we created an aggregated fact table that contains data about daily prescribed quantities of each medication per each doctor,such an aggregated table would have ________ records in the fact table.

Accepted Answer

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

Question 2

What are conformed dimensions?

Accepted Answer

The answer of What are conformed dimensions?...

Question 3

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created. The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS  DATABASE, shown below. In this database, each visit includes one patron, one spa employee, and one or more procedures. The price for each procedure varies from visit to visit.

CUSTOM SPA DAILY VISITS DATABASE

-The CUSTOM SPA star schema contains the dimension VISIT.

Accepted Answer

A) True 
 B)False

Question 4

Observe the REAL ESTATE PROPERTY DIMENSION:

This dimension will be used for the following questions citing REAL ESTATE PROPERTY DIMENSION.

-Show how Type 3 approach would implement the following change: the size of property whose ID is 111 is increased to 7000 sq ft on 1/1/2013.Assume that the dimension was originally created and populated with all brand-new properties on 1/1/2000,and add appropriate timestamps.

Accepted Answer

The answer of Observe the REAL ESTATE PROPERTY DIMENSION:

This dimension...

Question 5

What is a snowflake model?

Accepted Answer

The answer of What is a snowflake model?...

Question 6

All sources for a dimensional model must be operational data sources from the company that is building the dimensional model.

Accepted Answer

A) True 
 B)False

Question 7

The following questions citing STATEWIDE HEALTH assume that a single-source star schema is created. The  purpose of this star schema is to analyze quantities of prescribed medications by all dimensions provided by its source: the STATEWIDE HEALTH PRESCRIPTIONS DATABASE shown below. In this database, each prescription is prescribed for one patient by one doctor, and it contains one medication.

STATEWIDE HEALTH PRESCRIPTIONS  DATABASE

-The value 10 from the STATEWIDE HEALTH PRESCRIPTIONS database appears all together ________ time(s)in the populated tables of the STATEWIDE HEALTH star schema.

Accepted Answer

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

Question 8

Dimensionally modeled data warehouse approach results in multiple unrelated ETL infrastructures.

Accepted Answer

A) True 
 B)False

Question 9

In a typical,properly designed star schema,the number of records (rows)in any of the dimension tables is:

Accepted Answer

A) Larger than in the fact table 
B) Same as in the fact table 
C) Smaller than in the fact table 
D) No typical rule-there is an even number of dimension tables with larger,smaller and same number of records as in the fact table

Question 10

What does granularity of a fact table describe?

Accepted Answer

The answer of What does granularity of a fact table...

Question 11

What are the two options for designing analytical databases in organizations where the organizational,political,or budgetary structure of the organization forces parts of the organization to undertake isolated initiatives?

Accepted Answer

The answer of What are the two options for designing...

Question 12

Observe the REAL ESTATE PROPERTY DIMENSION:

This dimension will be used for the following questions citing REAL ESTATE PROPERTY DIMENSION.

-Show how the Type 2 approach would implement the following change: the size of property whose ID is 111 is increased to 7000 sq ft (do not add timestamps).

Accepted Answer

The answer of Observe the REAL ESTATE PROPERTY DIMENSION:

This dimension...

Question 13

What is a constellation of stars?

Accepted Answer

The answer of What is a constellation of stars?...

Question 14

The following questions citing STATEWIDE HEALTH assume that a single-source star schema is created. The  purpose of this star schema is to analyze quantities of prescribed medications by all dimensions provided by its source: the STATEWIDE HEALTH PRESCRIPTIONS DATABASE shown below. In this database, each prescription is prescribed for one patient by one doctor, and it contains one medication.

STATEWIDE HEALTH PRESCRIPTIONS  DATABASE

-The value 2mg from the STATEWIDE HEALTH PRESCRIPTIONS database appears all together ________ time(s)in the populated tables of the STATEWIDE HEALTH star schema.

Accepted Answer

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

Question 15

The following questions citing STATEWIDE HEALTH assume that a single-source star schema is created. The  purpose of this star schema is to analyze quantities of prescribed medications by all dimensions provided by its source: the STATEWIDE HEALTH PRESCRIPTIONS DATABASE shown below. In this database, each prescription is prescribed for one patient by one doctor, and it contains one medication.

STATEWIDE HEALTH PRESCRIPTIONS  DATABASE

-Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE,the dimension MEDICATION in the STATEWIDE HEALTH star schema has ________ records.

Accepted Answer

A) 0 (the dimension MEDICATION does not exist) 
B) 2 
C) 3 
D) 5

Question 16

Dimensionally modeled data warehouse approach can be used for designing an enterprise-wide analytical data warehouse.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following allows reusing (instead of duplication)of dimensions?

Accepted Answer

A) Time column 
B) Snowflaking 
C) Galaxy of stars 
D) Degenerate dimension

Question 18

Aggregated fact tables have a finer level of granularity than detailed tables.

Accepted Answer

A) True 
 B)False

Question 19

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created. The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS  DATABASE, shown below. In this database, each visit includes one patron, one spa employee, and one or more procedures. The price for each procedure varies from visit to visit.

CUSTOM SPA DAILY VISITS DATABASE

-The fact table in the CUSTOM SPA star schema is a ________ fact table.

Accepted Answer

A) constellation 
B) degenerate 
C) transaction-level detailed 
D) line-item detailed

Question 20

The following questions citing STATEWIDE HEALTH assume that a single-source star schema is created. The  purpose of this star schema is to analyze quantities of prescribed medications by all dimensions provided by its source: the STATEWIDE HEALTH PRESCRIPTIONS DATABASE shown below. In this database, each prescription is prescribed for one patient by one doctor, and it contains one medication.

STATEWIDE HEALTH PRESCRIPTIONS  DATABASE

-Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS database,if we created an aggregated fact table that contains data about daily prescribed quantities of each medication per each doctor,such an aggregated table would be connected to ________ dimensions.

Accepted Answer

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

Exam 8: Data Warehouse and Data Mart Modeling

What are conformed dimensions?

What is a snowflake model?

All sources for a dimensional model must be operational data sources from the company that is building the dimensional model.

Dimensionally modeled data warehouse approach results in multiple unrelated ETL infrastructures.

In a typical,properly designed star schema,the number of records (rows) in any of the dimension tables is:

What does granularity of a fact table describe?

What are the two options for designing analytical databases in organizations where the organizational,political,or budgetary structure of the organization forces parts of the organization to undertake isolated initiatives?

Observe the REAL ESTATE PROPERTY DIMENSION: This dimension will be used for the following questions citing REAL ESTATE PROPERTY DIMENSION. -Show how the Type 2 approach would implement the following change: the size of property whose ID is 111 is increased to 7000 sq ft (do not add timestamps).

What is a constellation of stars?

Dimensionally modeled data warehouse approach can be used for designing an enterprise-wide analytical data warehouse.

Which of the following allows reusing (instead of duplication) of dimensions?

Aggregated fact tables have a finer level of granularity than detailed tables.