Caboodle Data Model Study Set UPDATED
ACTUAL Questions and CORRECT
Answers
Caboodle - CORRECT ANSWER - A data warehouse, designed to store Epic and non-
Epic data. 2-4
ETL process for Caboodle - CORRECT ANSWER - Caboodle receives data from Clarity
(Epic Data) and from other databases (non-Epic data). 2-5
SSIS Package - CORRECT ANSWER - SQL Server Integration Services are the
mechanisms used to move data during the Caboodle ETL process. 2-5
Schema - CORRECT ANSWER - A collection of database objects. 2-6
dbo schema - CORRECT ANSWER - Data source for SlicerDicer. 2-6
FullAccess schema - CORRECT ANSWER - contains everything for report writers from
the dbo schema and more. 2-6
Why use Caboodle over Clarity? - CORRECT ANSWER - Caboodle stores Epic and Non-
Epic Data, hyperspace integration, simplified report writing, enforced naming conventions. 2-8,
2-9, 2-10
Caboodle table naming conventions - CORRECT ANSWER - Dim for dimensions, Fact
for facts, Bridge for bridges, DataMart for data marts, AtributeValueDim for EAV tables,
<suffix>X for custom tables. 2-10
Surrogate Key - CORRECT ANSWER - ‐ Any key column where the column's value does
not exist in the source database and is created during the ETL process. In Caboodle all columns
, that end in ‐Key are surrogate keys. This is necessary because Caboodle contains both Epic and
non‐Epic data. 2-10
Lookup Column - CORRECT ANSWER - A column in one table whose value identifies at
least one row in another table. Most tables in Caboodle have at least one lookup column. Lookup
columns in Caboodle will always end in ‐Key and the Cogito Dictionary will tell report writers
what DMC the lookup column references. 2-10
Star Schema - CORRECT ANSWER - refers to the way that reports centered around fact
tables appear in a join diagram. 2-11
True or False: A column can either be a primary key or a surrogate key, but not both - CORRECT
ANSWER - False. A column can be both a primary key (the column(s) used to uniquely
identify a row) and a surrogate key (a key created during ETL that does not exist in the source
database). In Caboodle, primary key columns are also surrogate keys. 2-15
What is the relationship between SlicerDicer and Caboodle? - CORRECT ANSWER -
SlicerDicer is Epic's self‐service reporting tool in Hyperspace that dynamically queries Caboodle
data. 2-15
Explain the relationship between the dbo and FullAccess schemas. - CORRECT
ANSWER - The Cogito Dictionary reflects the dbo schema. The FullAccess schema
contains almost everything in the dbo schema (minus a few metadata columns) plus additional
columns in some tables. Since FullAccess has more data, report writers should use it when
writing queries. However, report writers should also be familiar with dbo due to its relationship
with the Cogito Dictionary. 2-15
True or False: Naming conventions are enforced in Caboodle. - CORRECT ANSWER -
True. Naming conventions, such as Fact, are enforced in Caboodle. Study Checklist The Basics
Of Caboodle. 2-15
Staging Database - CORRECT ANSWER - Data first moves from its source into the
staging database to be transformed, checked for data integrity issues, and cleaned to resolve
those issues. 2-5
ACTUAL Questions and CORRECT
Answers
Caboodle - CORRECT ANSWER - A data warehouse, designed to store Epic and non-
Epic data. 2-4
ETL process for Caboodle - CORRECT ANSWER - Caboodle receives data from Clarity
(Epic Data) and from other databases (non-Epic data). 2-5
SSIS Package - CORRECT ANSWER - SQL Server Integration Services are the
mechanisms used to move data during the Caboodle ETL process. 2-5
Schema - CORRECT ANSWER - A collection of database objects. 2-6
dbo schema - CORRECT ANSWER - Data source for SlicerDicer. 2-6
FullAccess schema - CORRECT ANSWER - contains everything for report writers from
the dbo schema and more. 2-6
Why use Caboodle over Clarity? - CORRECT ANSWER - Caboodle stores Epic and Non-
Epic Data, hyperspace integration, simplified report writing, enforced naming conventions. 2-8,
2-9, 2-10
Caboodle table naming conventions - CORRECT ANSWER - Dim for dimensions, Fact
for facts, Bridge for bridges, DataMart for data marts, AtributeValueDim for EAV tables,
<suffix>X for custom tables. 2-10
Surrogate Key - CORRECT ANSWER - ‐ Any key column where the column's value does
not exist in the source database and is created during the ETL process. In Caboodle all columns
, that end in ‐Key are surrogate keys. This is necessary because Caboodle contains both Epic and
non‐Epic data. 2-10
Lookup Column - CORRECT ANSWER - A column in one table whose value identifies at
least one row in another table. Most tables in Caboodle have at least one lookup column. Lookup
columns in Caboodle will always end in ‐Key and the Cogito Dictionary will tell report writers
what DMC the lookup column references. 2-10
Star Schema - CORRECT ANSWER - refers to the way that reports centered around fact
tables appear in a join diagram. 2-11
True or False: A column can either be a primary key or a surrogate key, but not both - CORRECT
ANSWER - False. A column can be both a primary key (the column(s) used to uniquely
identify a row) and a surrogate key (a key created during ETL that does not exist in the source
database). In Caboodle, primary key columns are also surrogate keys. 2-15
What is the relationship between SlicerDicer and Caboodle? - CORRECT ANSWER -
SlicerDicer is Epic's self‐service reporting tool in Hyperspace that dynamically queries Caboodle
data. 2-15
Explain the relationship between the dbo and FullAccess schemas. - CORRECT
ANSWER - The Cogito Dictionary reflects the dbo schema. The FullAccess schema
contains almost everything in the dbo schema (minus a few metadata columns) plus additional
columns in some tables. Since FullAccess has more data, report writers should use it when
writing queries. However, report writers should also be familiar with dbo due to its relationship
with the Cogito Dictionary. 2-15
True or False: Naming conventions are enforced in Caboodle. - CORRECT ANSWER -
True. Naming conventions, such as Fact, are enforced in Caboodle. Study Checklist The Basics
Of Caboodle. 2-15
Staging Database - CORRECT ANSWER - Data first moves from its source into the
staging database to be transformed, checked for data integrity issues, and cleaned to resolve
those issues. 2-5
