Page 1 of 50
CDW 110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM*** QUESTIONS AND
ANSWERS | VERIFIED AND WELL DETAILED
ANSWERS |DOWNLOAD AND PASS | LATEST
EXAM UPDATE 2026/2027
True or False: Any change to Patient data in Clarity will
generate a new row in PatientDim after the next extract.
❖False, only changes in type 2 data would result in a
new row being generated.
True of false: The _Current view tables in the FullAccess
schema contains a subset of the rows contained in their
corresponding type 2 tables.
❖True. _Current view tables in the Fullaccess schema
contain a subset of the rows contained in their
corresponding type 2 tables.
,Page 2 of 50
What is a durable key?
❖Type 2 tables have a durable key column which stores
the same value for all rows that correspond to the
same entity. This allows for grouping or summarizing
data by the entity.
If a patient has a PCP assigned, but that providers' data
hasn't been extracted to ProviderDim, what value would
appear in ProviderDim.name for this patient?
❖*unknown (an inferred row)
A foreign key column in Caboodle contains the value -3.
What could this mean?
❖Either the data that once populated this row was
deleted from the source, or this is the -3 row, for
which all foreign key columns are also -3.
,Page 3 of 50
If a foreign key is null in Clarity, what will appear in the
corresponding column in Caboodle?
❖If the foreign key was expected to have data, then a -1
will appear in Caboodle to represent an unspecified
value. If the foreign key was not expected to contain
data, then a -2 will appear in the row to represent a
value that is not applicable.
What is the difference between a MappingFact table and
a Bridge table?
❖Both are used to map many-to-many relationships,
however, Bridge table always link to a Dimension
table while MappingFact tables link to Fact tables.
What two columns do all Bridge tables have?
, Page 4 of 50
❖Every Bridge table has a Combo key to which other
tables join, and a foreign key to join to its associated
Dim table.
What Chronicles Data structure underlies many of the EAV
tables in Caboodle?
❖SmartData Element data stored in the HLV master file
in Chronicles.
True or false: AttributeValueDim tables are more granular
than their associated Fact table?
❖True. EAV tables are more granular than their
associated Fact table.
What is the granularity of MedicationOrderFact?
❖An order.
CDW 110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM*** QUESTIONS AND
ANSWERS | VERIFIED AND WELL DETAILED
ANSWERS |DOWNLOAD AND PASS | LATEST
EXAM UPDATE 2026/2027
True or False: Any change to Patient data in Clarity will
generate a new row in PatientDim after the next extract.
❖False, only changes in type 2 data would result in a
new row being generated.
True of false: The _Current view tables in the FullAccess
schema contains a subset of the rows contained in their
corresponding type 2 tables.
❖True. _Current view tables in the Fullaccess schema
contain a subset of the rows contained in their
corresponding type 2 tables.
,Page 2 of 50
What is a durable key?
❖Type 2 tables have a durable key column which stores
the same value for all rows that correspond to the
same entity. This allows for grouping or summarizing
data by the entity.
If a patient has a PCP assigned, but that providers' data
hasn't been extracted to ProviderDim, what value would
appear in ProviderDim.name for this patient?
❖*unknown (an inferred row)
A foreign key column in Caboodle contains the value -3.
What could this mean?
❖Either the data that once populated this row was
deleted from the source, or this is the -3 row, for
which all foreign key columns are also -3.
,Page 3 of 50
If a foreign key is null in Clarity, what will appear in the
corresponding column in Caboodle?
❖If the foreign key was expected to have data, then a -1
will appear in Caboodle to represent an unspecified
value. If the foreign key was not expected to contain
data, then a -2 will appear in the row to represent a
value that is not applicable.
What is the difference between a MappingFact table and
a Bridge table?
❖Both are used to map many-to-many relationships,
however, Bridge table always link to a Dimension
table while MappingFact tables link to Fact tables.
What two columns do all Bridge tables have?
, Page 4 of 50
❖Every Bridge table has a Combo key to which other
tables join, and a foreign key to join to its associated
Dim table.
What Chronicles Data structure underlies many of the EAV
tables in Caboodle?
❖SmartData Element data stored in the HLV master file
in Chronicles.
True or false: AttributeValueDim tables are more granular
than their associated Fact table?
❖True. EAV tables are more granular than their
associated Fact table.
What is the granularity of MedicationOrderFact?
❖An order.
