Exam 8: Data Warehouse and Data Mart Modeling

The ________ slowly changing dimension approach involves creating a previous and current column in the dimension table for each column where changes are anticipated.

(Multiple Choice)

4.7/5

(40)

Question 61

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 patient,such an aggregated table would have ________ records in the fact table.

(Multiple Choice)

4.8/5

(27)

Question 62

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 SPAEMPLOYEE in the CUSTOM SPA star schema has ________ records.

(Multiple Choice)

4.7/5

(37)

Question 63

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 VISITPROCEDURE in the CUSTOM SPA star schema has ________ records.

(Multiple Choice)

4.9/5

(37)

Question 64

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 PRESCRIPTION in the STATEWIDE HEALTH star schema has ________ records.

(Multiple Choice)

4.8/5

(43)

Question 65

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

(True/False)

4.9/5

(31)

Question 66

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 detailed fact table in the CUSTOM SPA star schema has ________ records.

(Multiple Choice)

4.8/5

(36)

Question 67

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

(True/False)

4.8/5

(33)

Question 68

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 value Mani from the CUSTOM SPA DAILY VISITS DATABASE appears altogether ________ time(s)in CUSTOM SPA star schema.

(Multiple Choice)

4.8/5

(28)

Question 69

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

(True/False)

4.9/5

(40)

Question 70

When a data warehouse is normalized,its dependent data marts also must be normalized.

(True/False)

4.9/5

(31)

Question 71

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 value Daisy from the CUSTOM SPA DAILY VISITS DATABASE appears altogether ________ time(s)in CUSTOM SPA star schema.

(Multiple Choice)

4.8/5

(37)

Question 72

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

(True/False)

4.9/5

(39)

Question 73

What is a surrogate key?

(Essay)

5.0/5

(27)

Question 74

Typically,in a star schema all ________ are given a simple,non-composite system-generated key,also called a surrogate key.

(Multiple Choice)

5.0/5

(37)

Question 75

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

(True/False)

4.8/5

(35)

Question 76

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

(True/False)

4.7/5

(41)

Question 77

Transaction time is typically included as a column in the fact table.

(True/False)

4.7/5

(31)

Question 78

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

(True/False)

4.8/5

(28)

Question 79

Independent data marts approach can be used for designing an enterprise-wide analytical data warehouse.

(True/False)

4.9/5

(35)

Question 80

Showing 61 - 80 of 100

The ________ slowly changing dimension approach involves creating a previous and current column in the dimension table for each column where changes are anticipated.

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

When a data warehouse is normalized,its dependent data marts also must be normalized.

What is a surrogate key?

Typically,in a star schema all ________ are given a simple,non-composite system-generated key,also called a surrogate key.

Transaction time is typically included as a column in the fact table.

Independent data marts approach can be used for designing an enterprise-wide analytical data warehouse.

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