1
CDW110 EXAM LATEST 2024/2025 WITH ACTUAL
QUESTIONS AND CORRECT VERIFIED
ANSWERS/ALREADY GRADED A+
•
What is Caboodle? - (answers)A data warehouse, designed to store Epic and non-Epic data in a
unified data model for efficient reporting
Caboodle staging database - (answers)Data is transformed, checked for referential integrity, and
cleaned
Caboodle reporting database - (answers)Comes from the staging database and is used by caboodle
report writers to write reports
SSIS Packages - (answers)SQL Server Integration Services. The mechanism used to move data during
the caboodle ETL process
True or false: your organization can create custom SSIS packages to extract Clarity data or additional
data sets - (answers)True
Schema - (answers)A collection of database objects
dbo schema - (answers)Stores reporting data and acts as the data source for SlicerDicer
FullAccess Schema - (answers)Everything for report writers from the dbo schema and more
FilteredAccess Schema - (answers)Similar to FullAccess, but results are filtered based on user
security
Which schema should be the default schema for reporting? - (answers)FullAccess
How to see what schema is being used for reports? - (answers)SELECT SCHEMA_NAME()
, 2
Which Cogito tools query from Caboodle? - (answers)Mainly SlicerDicer, but also certain custom
Radar metrics and Workbench templates
True or false: all tables and columns in Caboodle are written in PascalCase - (answers)True
True or false: all key columns in Caboodle are surrogate keys - (answers)True
Surrogate key - (answers)The column's value does not exist in the source database and is created
during the ETL process. This is necessary because Caboodle contains both Epic and non-Epic data
Lookup column - (answers)A column in one table whose value identifies at least one row in another
table. Most tables in Caboodle have at least one
Compared to Fact tables, Dimension tables usually contain.. - (answers)More data and fewer lookup
columns
True or false: lookup columns end in -Key - (answers)True
Where to look for identifying information for validation in Caboodle? - (answers)EpicId or EpicCsn
columns
DMC - (answers)Data Model Component. Consists of the table, the packages used to populate the
table, and underlying metadata tables that assist with ETL
Dimension tables - (answers)One row for each entity within the set. Examples are ProviderDim,
PatientDim
Fact tables - (answers)One row for each occurrence of some significant, measurable event. Examples
are MedicationOrderFact and EncounterFact
Bridge tables - (answers)For many to many relationships
DataMart - (answers)Report on data points from several DMCs in one place
CDW110 EXAM LATEST 2024/2025 WITH ACTUAL
QUESTIONS AND CORRECT VERIFIED
ANSWERS/ALREADY GRADED A+
•
What is Caboodle? - (answers)A data warehouse, designed to store Epic and non-Epic data in a
unified data model for efficient reporting
Caboodle staging database - (answers)Data is transformed, checked for referential integrity, and
cleaned
Caboodle reporting database - (answers)Comes from the staging database and is used by caboodle
report writers to write reports
SSIS Packages - (answers)SQL Server Integration Services. The mechanism used to move data during
the caboodle ETL process
True or false: your organization can create custom SSIS packages to extract Clarity data or additional
data sets - (answers)True
Schema - (answers)A collection of database objects
dbo schema - (answers)Stores reporting data and acts as the data source for SlicerDicer
FullAccess Schema - (answers)Everything for report writers from the dbo schema and more
FilteredAccess Schema - (answers)Similar to FullAccess, but results are filtered based on user
security
Which schema should be the default schema for reporting? - (answers)FullAccess
How to see what schema is being used for reports? - (answers)SELECT SCHEMA_NAME()
, 2
Which Cogito tools query from Caboodle? - (answers)Mainly SlicerDicer, but also certain custom
Radar metrics and Workbench templates
True or false: all tables and columns in Caboodle are written in PascalCase - (answers)True
True or false: all key columns in Caboodle are surrogate keys - (answers)True
Surrogate key - (answers)The column's value does not exist in the source database and is created
during the ETL process. This is necessary because Caboodle contains both Epic and non-Epic data
Lookup column - (answers)A column in one table whose value identifies at least one row in another
table. Most tables in Caboodle have at least one
Compared to Fact tables, Dimension tables usually contain.. - (answers)More data and fewer lookup
columns
True or false: lookup columns end in -Key - (answers)True
Where to look for identifying information for validation in Caboodle? - (answers)EpicId or EpicCsn
columns
DMC - (answers)Data Model Component. Consists of the table, the packages used to populate the
table, and underlying metadata tables that assist with ETL
Dimension tables - (answers)One row for each entity within the set. Examples are ProviderDim,
PatientDim
Fact tables - (answers)One row for each occurrence of some significant, measurable event. Examples
are MedicationOrderFact and EncounterFact
Bridge tables - (answers)For many to many relationships
DataMart - (answers)Report on data points from several DMCs in one place
