Caboodle Data Model Fundamentals
exam 2024 with 100% correct answers
A DMC consists of - correct answer the table, the packages used to populate the table, and underlying
metadata tables that assist Caboodle Administrators with the ETL process
Data warehouse - correct answer a relational database, made up of tables and columns, that can be
queried using SQL
Chronicles - correct answer Epic's production database. End users enter data into Chronicles through
their daily activities
Clarity - correct 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 - correct answer the database used by Caboodle report writers to create reports
SQL Server Integration Services (SSIS) packages - correct answer the mechanism used to move data
during the Caboodle ETL process
dbo schema - correct answer data source for SlicerDicer. The Caboodle Dictionary and the Caboodle
portion of the Cogito Data Dictionary reflect the contents of this
FullAccess schema - correct answer contains everything for report writers from the dbo schema and
more
FilteredAccess schema - correct 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 - correct answer Epic's self-service reporting tool. It dynamically queries Caboodle data
based on selected criteria, slices, and measures
Dimensional data models - correct answer Maximize user understanding and ease of retrieval
•Updates typically occur in batch mode
•Normalization offers little advantage
•Massive indexes are sustainable
Surrogate Key - correct 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 - correct answer A column in one table whose value identifies at least one row in
another table
Dimension tables - correct answer contain one row for each entity within the set
Fact tables - correct answer one row for each occurrence of some significant, measurable event
Bridge tables - correct answer used in Caboodle to model many-to-many relationships
DataMarts - correct answer used in Caboodle to report on data points from several DMCs in one place
Entity-Attribute-Value (EAV) dimension tables - correct answer contain information about values of
additional attributes in Caboodle
star schema - correct answer refers to the way that reports centered around fact tables appear in a join
diagram
You are writing a report in Caboodle about surgeries. A colleague on the OpTime team tells you that the
patient is stored in I ORC 50. What is the best way to determine which Caboodle table and column
extracts this data? - correct answer Search the Cogito Dictionary for "ORC 50". To limit the search
results to ONLY Caboodle, search "CB: ORC 50".
exam 2024 with 100% correct answers
A DMC consists of - correct answer the table, the packages used to populate the table, and underlying
metadata tables that assist Caboodle Administrators with the ETL process
Data warehouse - correct answer a relational database, made up of tables and columns, that can be
queried using SQL
Chronicles - correct answer Epic's production database. End users enter data into Chronicles through
their daily activities
Clarity - correct 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 - correct answer the database used by Caboodle report writers to create reports
SQL Server Integration Services (SSIS) packages - correct answer the mechanism used to move data
during the Caboodle ETL process
dbo schema - correct answer data source for SlicerDicer. The Caboodle Dictionary and the Caboodle
portion of the Cogito Data Dictionary reflect the contents of this
FullAccess schema - correct answer contains everything for report writers from the dbo schema and
more
FilteredAccess schema - correct 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 - correct answer Epic's self-service reporting tool. It dynamically queries Caboodle data
based on selected criteria, slices, and measures
Dimensional data models - correct answer Maximize user understanding and ease of retrieval
•Updates typically occur in batch mode
•Normalization offers little advantage
•Massive indexes are sustainable
Surrogate Key - correct 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 - correct answer A column in one table whose value identifies at least one row in
another table
Dimension tables - correct answer contain one row for each entity within the set
Fact tables - correct answer one row for each occurrence of some significant, measurable event
Bridge tables - correct answer used in Caboodle to model many-to-many relationships
DataMarts - correct answer used in Caboodle to report on data points from several DMCs in one place
Entity-Attribute-Value (EAV) dimension tables - correct answer contain information about values of
additional attributes in Caboodle
star schema - correct answer refers to the way that reports centered around fact tables appear in a join
diagram
You are writing a report in Caboodle about surgeries. A colleague on the OpTime team tells you that the
patient is stored in I ORC 50. What is the best way to determine which Caboodle table and column
extracts this data? - correct answer Search the Cogito Dictionary for "ORC 50". To limit the search
results to ONLY Caboodle, search "CB: ORC 50".
