Exam 8: Data Warehouse and Data Mart Modeling

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

(True/False)

4.7/5

(31)

Question 41

The dimensional schema is often referred to as the:

(Multiple Choice)

4.7/5

(33)

Question 42

Including a transaction identifier in the fact table is often referred to as:

(Multiple Choice)

4.8/5

(32)

Question 43

Dimensional modeling can be employed as a relational data modeling technique.

(True/False)

4.8/5

(25)

Question 44

Independent data marts approach results in multiple unrelated ETL infrastructures.

(True/False)

4.8/5

(36)

Question 45

STATEWIDE HEALTH 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 STATEWIDE HEALTH star schema contains the dimension PATIENT.

(True/False)

4.7/5

(42)

Question 46

In addition to giving each record of a dimension a new value that serves as a primary key within the dimensional model instead of the operational key value,surrogate key values contain additional information about each record in the dimension.

(True/False)

4.7/5

(27)

Question 47

STATEWIDE HEALTH 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 STATEWIDE HEALTH PRESCRIPTIONS database column MedicationDosage provides the data for the fact table in the STATEWIDE HEALTH star schema.

(True/False)

5.0/5

(43)

Question 48

The ________ slowly changing dimension approach creates a new additional dimension record using a new value for the surrogate key every time a value in a dimension record changes.

(Multiple Choice)

4.9/5

(31)

Question 49

The relational model is the only way through which dimensionally modeled databases can be implemented.

(True/False)

4.8/5

(35)

Question 50

The ER modeling and dimensional modeling methods cannot be combined and used within the same data warehousing project.

(True/False)

4.8/5

(28)

Question 51

STATEWIDE HEALTH 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 STATEWIDE HEALTH PRESCRIPTIONS database column PrescTimeOfDay provides the data for a dimension in the STATEWIDE HEALTH star schema.

(True/False)

4.8/5

(35)

Question 52

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 Family Medicine from the STATEWIDE HEALTH PRESCRIPTIONS database appears all together ________ time(s)in the populated tables of the STATEWIDE HEALTH star schema.

(Multiple Choice)

5.0/5

(29)

Question 53

What type of columns does a dimension table contain?

(Essay)

5.0/5

(36)

Question 54

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

(Essay)

4.8/5

(34)

Question 55

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 -Based on the data shown in the CUSTOM SPA DAILY VISITS DATABASE,the dimension CALENDAR in the CUSTOM SPA star schema has ________ record(s).

(Multiple Choice)

4.9/5

(20)

Question 56

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,such an aggregated table would be connected to ________ dimensions.

(Multiple Choice)

4.8/5

(35)

Question 57

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 PATIENT in the STATEWIDE HEALTH star schema has ________ record(s).

(Multiple Choice)

4.9/5

(39)

Question 58

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 DAILY VISITS DATABASE column VisitTimeOfDay provides the data for a dimension in the STATEWIDE HEALTH star schema.

(True/False)

4.8/5

(36)

Question 59

What is a slowly changing dimension?

(Essay)

4.8/5

(38)

Question 60

Showing 41 - 60 of 100

The dimensional schema is often referred to as the:

Including a transaction identifier in the fact table is often referred to as:

Dimensional modeling can be employed as a relational data modeling technique.

Independent data marts approach results in multiple unrelated ETL infrastructures.

In addition to giving each record of a dimension a new value that serves as a primary key within the dimensional model instead of the operational key value,surrogate key values contain additional information about each record in the dimension.

The ________ slowly changing dimension approach creates a new additional dimension record using a new value for the surrogate key every time a value in a dimension record changes.

The relational model is the only way through which dimensionally modeled databases can be implemented.

The ER modeling and dimensional modeling methods cannot be combined and used within the same data warehousing project.

What type of columns does a dimension table contain?

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

What is a slowly changing dimension?

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 Implementation and Use

Overview of Dbms Functionalities and Database Administration

Filters