Question 1

What is represented by each row in a transaction-level detailed fact table?

Accepted Answer

In a transaction-level detailed fact table,each row represents a particular transaction.

Question 2

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

Accepted Answer

A) 0 (the dimension DOCTOR does not exist) 
B) 3 
C) 4 
D) 5 
A) 0 (the dimension DOCTOR does not exist) 
B) 3 
C) 4 
D) 5 B

Question 3

A dimensional model cannot be based on a single source.

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 250lb 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 
A) 1 
B) 2 
C) 3 
D) 5

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

What is the difference between detailed fact tables and aggregated fact tables?

Accepted Answer

In detailed fact tables,each r

Question 9

List the two questions that have to be answered for every dimension under consideration during the dimensional modeling process.

Accepted Answer

Question 1: Can the dimension

Question 10

A dimensional model can contain more than one fact table.

Accepted Answer

A) True 
 B)False

Question 11

What is represented by each row in a line-item detailed fact table?

Accepted Answer

In a line-item detai

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) 0 
B) 5 
C) 9 
D) 82 
A) 0 
B) 5 
C) 9 
D) 82

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) 0 (the dimension PATRON does not exist) 
B) 4 
C) 5 
D) 8 
A) 0 (the dimension PATRON does not exist) 
B) 4 
C) 5 
D) 8

Question 16

Due to multiple subjects of analysis sharing dimensions,the following occurs:

Accepted Answer

A) A star schema is composed strictly of fact tables 
B) A dimensional model contains more than one fact table 
C) Some dimensions are eliminated 
D) All dimensions are reduced 
A) A star schema is composed strictly of fact tables 
B) A dimensional model contains more than one fact table 
C) Some dimensions are eliminated 
D) All dimensions are reduced

Question 17

Normalized data warehouse approach results in multiple unrelated ETL infrastructures.

Accepted Answer

A) True 
 B)False

Question 18

What type of columns does a fact table contain?

Accepted Answer

A fact table contains fact-mea

Question 19

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

Accepted Answer

A) True 
 B)False

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

Accepted Answer

A) 0 (the dimension CALENDAR does not exist) 
B) 1 
C) 2 
D) 5 
A) 0 (the dimension CALENDAR does not exist) 
B) 1 
C) 2 
D) 5

What is represented by each row in a transaction-level detailed fact table?

A dimensional model cannot be based on a single source.

What is the difference between detailed fact tables and aggregated fact tables?

List the two questions that have to be answered for every dimension under consideration during the dimensional modeling process.

A dimensional model can contain more than one fact table.

What is represented by each row in a line-item detailed fact table?

Due to multiple subjects of analysis sharing dimensions,the following occurs:

Normalized data warehouse approach results in multiple unrelated ETL infrastructures.

What type of columns does a fact table contain?

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

Exam 8: Data Warehouse and Data Mart Modeling

What is represented by each row in a transaction-level detailed fact table?

A dimensional model cannot be based on a single source.

What is the difference between detailed fact tables and aggregated fact tables?

List the two questions that have to be answered for every dimension under consideration during the dimensional modeling process.

A dimensional model can contain more than one fact table.

What is represented by each row in a line-item detailed fact table?

Due to multiple subjects of analysis sharing dimensions,the following occurs:

Normalized data warehouse approach results in multiple unrelated ETL infrastructures.

What type of columns does a fact table contain?

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