CDW110 APPROVED EXAM 2025/2026 EVALUATION QUESTIONS
WITH ANSWERS GRADED A+
Which schema should be the default schema for reporting? - FullAccess
How to see what schema is being used for reports? - SELECT
SCHEMA_NAME()
Which Cogito tools query from Caboodle? - Mainly SlicerDicer, but also
certain custom Radar metrics and Workbench templates
True or false: all tables and columns in Caboodle are written in PascalCase
- True
True or false: all key columns in Caboodle are surrogate keys - True
Surrogate key - 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 - 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.. - More data
and fewer lookup columns
True or false: lookup columns end in -Key - True
Where to look for identifying information for validation in Caboodle? - EpicId
or EpicCsn columns
DMC - Data Model Component. Consists of the table, the packages used to
populate the table, and underlying metadata tables that assist with ETL
Dimension tables - One row for each entity within the set. Examples are
ProviderDim, PatientDim
Fact tables - One row for each occurrence of some significant, measurable
event. Examples are MedicationOrderFact and EncounterFact
, Bridge tables - For many to many relationships
DataMart - Report on data points from several DMCs in one place
What does it mean when a DMC name ends with X.? - It's custom made
What are some of the pros of Caboodle being a dimensional data model? -
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? - More
complicated ETL process to maintain
Star schema - Fact table surrounded by and linked to dimensions
Where is the Caboodle data dictionary found? - Analytics catalog
Data dictionary overview section - Description, type of database object,
granularity
Data dictionary column section - Name, data type, availability in
SlicerDicer, links to (lookup columns), chronicles info, description
Data dictionary lineage section - 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 - 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 - Indicates what database objects a
table is dependent on. Clarity or caboodle tables and columns
Data dictionary queries section - 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 - True
WITH ANSWERS GRADED A+
Which schema should be the default schema for reporting? - FullAccess
How to see what schema is being used for reports? - SELECT
SCHEMA_NAME()
Which Cogito tools query from Caboodle? - Mainly SlicerDicer, but also
certain custom Radar metrics and Workbench templates
True or false: all tables and columns in Caboodle are written in PascalCase
- True
True or false: all key columns in Caboodle are surrogate keys - True
Surrogate key - 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 - 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.. - More data
and fewer lookup columns
True or false: lookup columns end in -Key - True
Where to look for identifying information for validation in Caboodle? - EpicId
or EpicCsn columns
DMC - Data Model Component. Consists of the table, the packages used to
populate the table, and underlying metadata tables that assist with ETL
Dimension tables - One row for each entity within the set. Examples are
ProviderDim, PatientDim
Fact tables - One row for each occurrence of some significant, measurable
event. Examples are MedicationOrderFact and EncounterFact
, Bridge tables - For many to many relationships
DataMart - Report on data points from several DMCs in one place
What does it mean when a DMC name ends with X.? - It's custom made
What are some of the pros of Caboodle being a dimensional data model? -
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? - More
complicated ETL process to maintain
Star schema - Fact table surrounded by and linked to dimensions
Where is the Caboodle data dictionary found? - Analytics catalog
Data dictionary overview section - Description, type of database object,
granularity
Data dictionary column section - Name, data type, availability in
SlicerDicer, links to (lookup columns), chronicles info, description
Data dictionary lineage section - 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 - 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 - Indicates what database objects a
table is dependent on. Clarity or caboodle tables and columns
Data dictionary queries section - 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 - True
