CDW110V CABOODLE DATA MODEL
FUNDAMENTALS TESTED QUESTIONS
2026 GRADED A+
>> EpicUUID
Answer: Unique identifier for Epic data models.
>> Caboodle
Answer: Data warehouse for Epic and non-Epic data.
>> Referential Integrity
Answer: Ensures lookup columns have valid values.
>> Change Tracking
Answer: Method for tracking changes in data.
>> Durable Key
Answer: Key used for snapshot change tracking.
>> ETL Process
Answer: Extract, Transform, Load data management process.
>> Data Mart
Answer: Subset of a data warehouse for specific analysis.
>> Bridge Tables
Answer: Tables that connect facts and dimensions.
, >> Dimensional Data Model
Answer: Data model optimized for reporting and analysis.
>> Primary Key
Answer: Column uniquely identifying a row in a table.
>> Surrogate Key
Answer: Key created by ETL, not in source database.
>> Lookup Columns
Answer: Columns that reference rows in another table.
>> Schemas
Answer: Organizational structure for database objects.
>> SlicerDicer
Answer: Tool for querying and analyzing Caboodle data.
>> Clarity
Answer: Epic's relational database for clinical data.
>> Chronicles
Answer: Epic's hierarchical database for patient records.
>> SQL Studio
Answer: Environment for writing and executing SQL queries.
>> Data Dictionary
Answer: Reference for data elements and their definitions.
FUNDAMENTALS TESTED QUESTIONS
2026 GRADED A+
>> EpicUUID
Answer: Unique identifier for Epic data models.
>> Caboodle
Answer: Data warehouse for Epic and non-Epic data.
>> Referential Integrity
Answer: Ensures lookup columns have valid values.
>> Change Tracking
Answer: Method for tracking changes in data.
>> Durable Key
Answer: Key used for snapshot change tracking.
>> ETL Process
Answer: Extract, Transform, Load data management process.
>> Data Mart
Answer: Subset of a data warehouse for specific analysis.
>> Bridge Tables
Answer: Tables that connect facts and dimensions.
, >> Dimensional Data Model
Answer: Data model optimized for reporting and analysis.
>> Primary Key
Answer: Column uniquely identifying a row in a table.
>> Surrogate Key
Answer: Key created by ETL, not in source database.
>> Lookup Columns
Answer: Columns that reference rows in another table.
>> Schemas
Answer: Organizational structure for database objects.
>> SlicerDicer
Answer: Tool for querying and analyzing Caboodle data.
>> Clarity
Answer: Epic's relational database for clinical data.
>> Chronicles
Answer: Epic's hierarchical database for patient records.
>> SQL Studio
Answer: Environment for writing and executing SQL queries.
>> Data Dictionary
Answer: Reference for data elements and their definitions.
