CDW110 Exam Questions Fully Solved Latest Update 2025 Already Passed
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()
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
What does it mean when a DMC name ends with X.? - Answers It's custom made
What are some of the pros of Caboodle being a dimensional data model? - Answers Intuitive, quicker to
write a report, quicker run times due to fewer tables and joins
What is the downside of Caboodle being a dimensional data model? - Answers More complicated ETL
process to maintain
Star schema - Answers Fact table surrounded by and linked to dimensions
Where is the Caboodle data dictionary found? - Answers Analytics catalog
Data dictionary overview section - Answers Description, type of database object, granularity
Data dictionary column section - Answers Name, data type, availability in SlicerDicer, links to (lookup
columns), chronicles info, description
Data dictionary lineage section - Answers Available in expanded column. Contains chronicles INI nd item
numbers and how the item can be used in SlicerDicer sessions (FDS records)
Data dictionary ER diagram section - Answers Classic star schema for investigating joins. Only for Fact
and DataMart. Non join columns can also be listed by clicking the key to expand into full column list
Data dictionary dependencies section - Answers Indicates what database objects a table is dependent
on. Clarity or caboodle tables and columns
Data dictionary queries section - Answers Lists SSIS packages that populate the table and their queries
True or false: it is possible for more than one SSIS package and more than one data source to populate a
table in caboodle - Answers True
Change tracking - Answers A property of a table that informs us how Caboodle will be updated when
changes are made to the source databases
Change tracking types - Answers 1) None, 2) Snapshot Change Tracking
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()
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
What does it mean when a DMC name ends with X.? - Answers It's custom made
What are some of the pros of Caboodle being a dimensional data model? - Answers Intuitive, quicker to
write a report, quicker run times due to fewer tables and joins
What is the downside of Caboodle being a dimensional data model? - Answers More complicated ETL
process to maintain
Star schema - Answers Fact table surrounded by and linked to dimensions
Where is the Caboodle data dictionary found? - Answers Analytics catalog
Data dictionary overview section - Answers Description, type of database object, granularity
Data dictionary column section - Answers Name, data type, availability in SlicerDicer, links to (lookup
columns), chronicles info, description
Data dictionary lineage section - Answers Available in expanded column. Contains chronicles INI nd item
numbers and how the item can be used in SlicerDicer sessions (FDS records)
Data dictionary ER diagram section - Answers Classic star schema for investigating joins. Only for Fact
and DataMart. Non join columns can also be listed by clicking the key to expand into full column list
Data dictionary dependencies section - Answers Indicates what database objects a table is dependent
on. Clarity or caboodle tables and columns
Data dictionary queries section - Answers Lists SSIS packages that populate the table and their queries
True or false: it is possible for more than one SSIS package and more than one data source to populate a
table in caboodle - Answers True
Change tracking - Answers A property of a table that informs us how Caboodle will be updated when
changes are made to the source databases
Change tracking types - Answers 1) None, 2) Snapshot Change Tracking
