Caboodle Data Model Study
Set Comprehensive Questions
(Frequently Tested) with
Verified Answers Graded A+
Caboodle - Answer: A data warehouse, designed to store Epic and non-Epic data. 2-4
ETL process for Caboodle - Answer: Caboodle receives data from Clarity (Epic Data) and from
other databases (non-Epic data). 2-5
SSIS Package - Answer: SQL Server Integration Services are the mechanisms used to move data
during the Caboodle ETL process. 2-5
Schema - Answer: A collection of database objects. 2-6
dbo schema - Answer: Data source for SlicerDicer. 2-6
FullAccess schema - Answer: contains everything for report writers from the dbo schema and
more. 2-6
Why use Caboodle over Clarity? - 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 - 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 - 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 - 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 - 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 - 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? - 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. - 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
Set Comprehensive Questions
(Frequently Tested) with
Verified Answers Graded A+
Caboodle - Answer: A data warehouse, designed to store Epic and non-Epic data. 2-4
ETL process for Caboodle - Answer: Caboodle receives data from Clarity (Epic Data) and from
other databases (non-Epic data). 2-5
SSIS Package - Answer: SQL Server Integration Services are the mechanisms used to move data
during the Caboodle ETL process. 2-5
Schema - Answer: A collection of database objects. 2-6
dbo schema - Answer: Data source for SlicerDicer. 2-6
FullAccess schema - Answer: contains everything for report writers from the dbo schema and
more. 2-6
Why use Caboodle over Clarity? - 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 - 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 - 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 - 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 - 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 - 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? - 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. - 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
