Caboodle Data Model Study Set Exam
Questions and Answers8
Caboodle - ANSWERS-A data warehouse, designed to store Epic and non-Epic data. 2-4
ETL process for Caboodle - ANSWERS-Caboodle receives data from Clarity (Epic Data) and from
other databases (non-Epic data). 2-5
SSIS Package - ANSWERS-SQL Server Integration Services are the mechanisms used to move
data during the Caboodle ETL process. 2-5
Schema - ANSWERS-A collection of database objects. 2-6
dbo schema - ANSWERS-Data source for SlicerDicer. 2-6
FullAccess schema - ANSWERS-contains everything for report writers from the dbo schema and
more. 2-6
Why use Caboodle over Clarity? - ANSWERS-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 - ANSWERS-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 - ANSWERS-‐ 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 - ANSWERS-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 - ANSWERS-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 - ANSWERS-
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? - ANSWERS-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. - ANSWERS-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. - ANSWERS-True. Naming
conventions, such as Fact, are enforced in Caboodle. Study Checklist The Basics Of Caboodle. 2-
15
Staging Database - ANSWERS-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
Questions and Answers8
Caboodle - ANSWERS-A data warehouse, designed to store Epic and non-Epic data. 2-4
ETL process for Caboodle - ANSWERS-Caboodle receives data from Clarity (Epic Data) and from
other databases (non-Epic data). 2-5
SSIS Package - ANSWERS-SQL Server Integration Services are the mechanisms used to move
data during the Caboodle ETL process. 2-5
Schema - ANSWERS-A collection of database objects. 2-6
dbo schema - ANSWERS-Data source for SlicerDicer. 2-6
FullAccess schema - ANSWERS-contains everything for report writers from the dbo schema and
more. 2-6
Why use Caboodle over Clarity? - ANSWERS-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 - ANSWERS-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 - ANSWERS-‐ 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 - ANSWERS-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 - ANSWERS-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 - ANSWERS-
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? - ANSWERS-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. - ANSWERS-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. - ANSWERS-True. Naming
conventions, such as Fact, are enforced in Caboodle. Study Checklist The Basics Of Caboodle. 2-
15
Staging Database - ANSWERS-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
