CABOODLE DATA MODEL STUDY SET
EXAM QUESTIONS AND ANSWERS
2025
, Caboodle - ANSWERA data warehouse, designed to store Epic and non-Epic data. 2-4
ETL process for Caboodle - ANSWERCaboodle receives data from Clarity (Epic Data)
and from other databases (non-Epic data). 2-5
SSIS Package - ANSWERSQL Server Integration Services are the mechanisms used to
move data during the Caboodle ETL process. 2-5
Schema - ANSWERA collection of database objects. 2-6
dbo schema - ANSWERData source for SlicerDicer. 2-6
FullAccess schema - ANSWERcontains everything for report writers from the dbo
schema and more. 2-6
Why use Caboodle over Clarity? - ANSWERCaboodle stores Epic and Non-Epic Data,
hyperspace integration, simplified report writing, enforced naming conventions. 2-8, 2-9,
2-10
Caboodle table naming conventions - ANSWERDim 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 - 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 - ANSWERA 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 - ANSWERrefers 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 -
ANSWERFalse. 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
EXAM QUESTIONS AND ANSWERS
2025
, Caboodle - ANSWERA data warehouse, designed to store Epic and non-Epic data. 2-4
ETL process for Caboodle - ANSWERCaboodle receives data from Clarity (Epic Data)
and from other databases (non-Epic data). 2-5
SSIS Package - ANSWERSQL Server Integration Services are the mechanisms used to
move data during the Caboodle ETL process. 2-5
Schema - ANSWERA collection of database objects. 2-6
dbo schema - ANSWERData source for SlicerDicer. 2-6
FullAccess schema - ANSWERcontains everything for report writers from the dbo
schema and more. 2-6
Why use Caboodle over Clarity? - ANSWERCaboodle stores Epic and Non-Epic Data,
hyperspace integration, simplified report writing, enforced naming conventions. 2-8, 2-9,
2-10
Caboodle table naming conventions - ANSWERDim 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 - 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 - ANSWERA 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 - ANSWERrefers 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 -
ANSWERFalse. 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
