Caboodle Data Model Fundamentals
Exam Questions and Answers 100%
Pass
A DMC consists of - ✔✔the table, the packages used to populate the table, and
underlying metadata tables that assist Caboodle Administrators with the ETL process
Data warehouse - ✔✔a relational database, made up of tables and columns, that can be
queried using SQL
Chronicles - ✔✔Epic's production database. End users enter data into Chronicles
through their daily activities
Clarity - ✔✔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 - ✔✔the database used by Caboodle report writers to create reports
SQL Server Integration Services (SSIS) packages - ✔✔the mechanism used to move data
during the Caboodle ETL process
Katelyn Whitman, All Rights Reserved © 2025 1
, dbo schema - ✔✔data source for SlicerDicer. The Caboodle Dictionary and the
Caboodle portion of the Cogito Data Dictionary reflect the contents of this
FullAccess schema - ✔✔contains everything for report writers from the dbo schema and
more
FilteredAccess schema - ✔✔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 - ✔✔Epic's self-service reporting tool. It dynamically queries Caboodle data
based on selected criteria, slices, and measures
Dimensional data models - ✔✔Maximize user understanding and ease of retrieval
•Updates typically occur in batch mode
•Normalization offers little advantage
•Massive indexes are sustainable
Surrogate Key - ✔✔Any key column where the column's value does not exist in the
source database and is created during the ETL process
Lookup Column - ✔✔A column in one table whose value identifies at least one row in
another table
Dimension tables - ✔✔contain one row for each entity within the set
Katelyn Whitman, All Rights Reserved © 2025 2
Exam Questions and Answers 100%
Pass
A DMC consists of - ✔✔the table, the packages used to populate the table, and
underlying metadata tables that assist Caboodle Administrators with the ETL process
Data warehouse - ✔✔a relational database, made up of tables and columns, that can be
queried using SQL
Chronicles - ✔✔Epic's production database. End users enter data into Chronicles
through their daily activities
Clarity - ✔✔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 - ✔✔the database used by Caboodle report writers to create reports
SQL Server Integration Services (SSIS) packages - ✔✔the mechanism used to move data
during the Caboodle ETL process
Katelyn Whitman, All Rights Reserved © 2025 1
, dbo schema - ✔✔data source for SlicerDicer. The Caboodle Dictionary and the
Caboodle portion of the Cogito Data Dictionary reflect the contents of this
FullAccess schema - ✔✔contains everything for report writers from the dbo schema and
more
FilteredAccess schema - ✔✔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 - ✔✔Epic's self-service reporting tool. It dynamically queries Caboodle data
based on selected criteria, slices, and measures
Dimensional data models - ✔✔Maximize user understanding and ease of retrieval
•Updates typically occur in batch mode
•Normalization offers little advantage
•Massive indexes are sustainable
Surrogate Key - ✔✔Any key column where the column's value does not exist in the
source database and is created during the ETL process
Lookup Column - ✔✔A column in one table whose value identifies at least one row in
another table
Dimension tables - ✔✔contain one row for each entity within the set
Katelyn Whitman, All Rights Reserved © 2025 2
