age 1 of 54
EPIC Caboodle Data Model Fundamentals
CERTIFICATION TEST STUDY GUIDE 2025/2026
QUESTIONS BANK AND VERIFIED CORRECT
SOLUTIONS WITH RATIONALES || 100%
GUARANTEED PASS <RECENT VERSION>
A DMC consists of ......ANSWER........the table, the packages used
to populate the table, and underlying metadata tables that
assist Caboodle Administrators with the ETL process
Data warehouse ......ANSWER........a relational database, made
up of tables and columns, that can be queried using SQL
Chronicles ......ANSWER........Epic's production database. End
users enter data into Chronicles through their daily activities
,age 2 of 54
Clarity ......ANSWER........extracts data from the Chronicles
database through a standard ETL process. After transformation,
the data is stored in a relational database on a separate server
Caboodle ......ANSWER........the database used by Caboodle
report writers to create reports
SQL Server Integration Services (SSIS) packages
......ANSWER........the mechanism used to move data during the
Caboodle ETL process
dbo schema ......ANSWER........data source for SlicerDicer. The
Caboodle Dictionary and the Caboodle portion of the Cogito
Data Dictionary reflect the contents of this
FullAccess schema ......ANSWER........contains everything for
report writers from the dbo schema and more
,age 3 of 54
FilteredAccess schema ......ANSWER........similar to the FullAccess
schema except report writers who only have access to the
FilteredAccess schema will have their results filtered based on
their user security
SlicerDicer ......ANSWER........Epic's self-service reporting tool. It
dynamically queries Caboodle data based on selected criteria,
slices, and measures
Dimensional data models ......ANSWER........Maximize user
understanding and ease of retrieval
•Updates typically occur in batch mode
•Normalization offers little advantage
•Massive indexes are sustainable
, age 4 of 54
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
Lookup Column ......ANSWER........A column in one table whose
value identifies at least one row in another table
Dimension tables ......ANSWER........contain one row for each
entity within the set
Fact tables ......ANSWER........one row for each occurrence of
some significant, measurable event
Bridge tables ......ANSWER........used in Caboodle to model
many-to-many relationships
DataMarts ......ANSWER........used in Caboodle to report on data
points from several DMCs in one place
EPIC Caboodle Data Model Fundamentals
CERTIFICATION TEST STUDY GUIDE 2025/2026
QUESTIONS BANK AND VERIFIED CORRECT
SOLUTIONS WITH RATIONALES || 100%
GUARANTEED PASS <RECENT VERSION>
A DMC consists of ......ANSWER........the table, the packages used
to populate the table, and underlying metadata tables that
assist Caboodle Administrators with the ETL process
Data warehouse ......ANSWER........a relational database, made
up of tables and columns, that can be queried using SQL
Chronicles ......ANSWER........Epic's production database. End
users enter data into Chronicles through their daily activities
,age 2 of 54
Clarity ......ANSWER........extracts data from the Chronicles
database through a standard ETL process. After transformation,
the data is stored in a relational database on a separate server
Caboodle ......ANSWER........the database used by Caboodle
report writers to create reports
SQL Server Integration Services (SSIS) packages
......ANSWER........the mechanism used to move data during the
Caboodle ETL process
dbo schema ......ANSWER........data source for SlicerDicer. The
Caboodle Dictionary and the Caboodle portion of the Cogito
Data Dictionary reflect the contents of this
FullAccess schema ......ANSWER........contains everything for
report writers from the dbo schema and more
,age 3 of 54
FilteredAccess schema ......ANSWER........similar to the FullAccess
schema except report writers who only have access to the
FilteredAccess schema will have their results filtered based on
their user security
SlicerDicer ......ANSWER........Epic's self-service reporting tool. It
dynamically queries Caboodle data based on selected criteria,
slices, and measures
Dimensional data models ......ANSWER........Maximize user
understanding and ease of retrieval
•Updates typically occur in batch mode
•Normalization offers little advantage
•Massive indexes are sustainable
, age 4 of 54
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
Lookup Column ......ANSWER........A column in one table whose
value identifies at least one row in another table
Dimension tables ......ANSWER........contain one row for each
entity within the set
Fact tables ......ANSWER........one row for each occurrence of
some significant, measurable event
Bridge tables ......ANSWER........used in Caboodle to model
many-to-many relationships
DataMarts ......ANSWER........used in Caboodle to report on data
points from several DMCs in one place
