Caboodle Data Model Fundamentals
Exam Questions Complete Latest
2025/2026 with Correct Answers and
Rationales GRADED A+
Terms in this set (134) Original
EpicUUID Unique identifier for Epic data models.
Epic's data warehouse for analytics and
Caboodle
reporting.
Referential Integrity Ensures lookup columns have valid values.
Connects fact and dimension tables in
Bridge Tables
schemas.
,Change Tracking Method for tracking changes in data over time.
Durable Key Key used in snapshot change tracking.
Extract, Transform, Load; data integration
ETL Process
process.
Subsets of data warehouses for specific
Data Marts
business needs.
Data model optimized for reporting and
Dimensional Data Model
analysis.
Primary Key Column uniquely identifying a row in a table.
Surrogate Key Key created by ETL, not existing in source.
Lookup Columns Columns that reference rows in other tables.
, Data model with central fact table and
Star Schema
dimensions.
Tool for querying and analyzing Caboodle
SlicerDicer
data.
Reference for data elements and their
Data Dictionary
definitions.
Environment for writing and executing SQL
SQL Studio
queries.
Non-Epic Data Data not sourced from Epic systems.
Clarity Epic's relational database for reporting data.
Chronicles Epic's hierarchical database for clinical data.
Schemas Organizational structures for database tables.
Exam Questions Complete Latest
2025/2026 with Correct Answers and
Rationales GRADED A+
Terms in this set (134) Original
EpicUUID Unique identifier for Epic data models.
Epic's data warehouse for analytics and
Caboodle
reporting.
Referential Integrity Ensures lookup columns have valid values.
Connects fact and dimension tables in
Bridge Tables
schemas.
,Change Tracking Method for tracking changes in data over time.
Durable Key Key used in snapshot change tracking.
Extract, Transform, Load; data integration
ETL Process
process.
Subsets of data warehouses for specific
Data Marts
business needs.
Data model optimized for reporting and
Dimensional Data Model
analysis.
Primary Key Column uniquely identifying a row in a table.
Surrogate Key Key created by ETL, not existing in source.
Lookup Columns Columns that reference rows in other tables.
, Data model with central fact table and
Star Schema
dimensions.
Tool for querying and analyzing Caboodle
SlicerDicer
data.
Reference for data elements and their
Data Dictionary
definitions.
Environment for writing and executing SQL
SQL Studio
queries.
Non-Epic Data Data not sourced from Epic systems.
Clarity Epic's relational database for reporting data.
Chronicles Epic's hierarchical database for clinical data.
Schemas Organizational structures for database tables.
