Caboodle Data Model Study Set
Questions and Answers 100% Pass
Caboodle - ✔✔A data warehouse, designed to store Epic and non-Epic data. 2-4
ETL process for Caboodle - ✔✔Caboodle receives data from Clarity (Epic Data) and
from other databases (non-Epic data). 2-5
SSIS Package - ✔✔SQL Server Integration Services are the mechanisms used to move
data during the Caboodle ETL process. 2-5
Schema - ✔✔A collection of database objects. 2-6
dbo schema - ✔✔Data source for SlicerDicer. 2-6
FullAccess schema - ✔✔contains everything for report writers from the dbo schema and
more. 2-6
Why use Caboodle over Clarity? - ✔✔Caboodle stores Epic and Non-Epic Data,
hyperspace integration, simplified report writing, enforced naming conventions. 2-8, 2-
9, 2-10
Katelyn Whitman, All Rights Reserved © 2025 1
, Caboodle table naming conventions - ✔✔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 - ✔✔‐ 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 - ✔✔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 - ✔✔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 -
✔✔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? - ✔✔SlicerDicer is Epic's
self‐service reporting tool in Hyperspace that dynamically queries Caboodle data. 2-15
Katelyn Whitman, All Rights Reserved © 2025 2
Questions and Answers 100% Pass
Caboodle - ✔✔A data warehouse, designed to store Epic and non-Epic data. 2-4
ETL process for Caboodle - ✔✔Caboodle receives data from Clarity (Epic Data) and
from other databases (non-Epic data). 2-5
SSIS Package - ✔✔SQL Server Integration Services are the mechanisms used to move
data during the Caboodle ETL process. 2-5
Schema - ✔✔A collection of database objects. 2-6
dbo schema - ✔✔Data source for SlicerDicer. 2-6
FullAccess schema - ✔✔contains everything for report writers from the dbo schema and
more. 2-6
Why use Caboodle over Clarity? - ✔✔Caboodle stores Epic and Non-Epic Data,
hyperspace integration, simplified report writing, enforced naming conventions. 2-8, 2-
9, 2-10
Katelyn Whitman, All Rights Reserved © 2025 1
, Caboodle table naming conventions - ✔✔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 - ✔✔‐ 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 - ✔✔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 - ✔✔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 -
✔✔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? - ✔✔SlicerDicer is Epic's
self‐service reporting tool in Hyperspace that dynamically queries Caboodle data. 2-15
Katelyn Whitman, All Rights Reserved © 2025 2
