CDW 110v Caboodle Data Model Fundamentals EXAM
2026 || Most Recent Exam 2026-2027 Actual Complete
Real Exam Questions And Correct Answers (Verified
Answers) Already Graded A+ | Guaranteed Success!!
Newest Exam | Just Released!!
Why do profile dimensions have fewer rows than their parent
fact tables? - ANSWER-A row in a profile dimension represents
a unique combination of values (for example, VisitProfileDim
stores unique combinations of encounter type, visit type, and
financial class). Since combinations aren't repeated, profile
dimensions must contain fewer rows than their parent fact
table.
Additionally, the data points in a profile dimension often come
from category lists in Chronicles, so there's a limited number of
possible values they can take on.
T/F: A single bridge table can only referenced by one fact or
dimension table. -
ANSWER-False
Multiple facts and dimensions can reference a single bridge
table. For example, PatientDim and VisitFact both contain
foreign keys for DiagnosisBridge.
How can MedicationOrderFact join to PatientDim?
- ANSWER-
,MedicationOrderFact.PatientKey =
PatientDim.PatientKey or
MedicationOrderFact.PatientDurableKey =
PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? -
ANSWER-Yes,
example MedicationOrderFact can join to
EncounterFact.
Which of the following would you expect to be stored in a
dimension table? -
ANSWER-Users and Diagnosis
Definitions
Which of the following are possible to do in Caboodle? -
ANSWER-Joining a fact table to another fact table, Fact table to
dimension table, dimension table to dimension table, 2 different
EAV dim table to an attribute dim table
True or False: Any change to Patient data in Clarity will
generate a new row in PatientDim after the next extract. -
ANSWER-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. – ANSWER-True. _Current view
, tables in the Fullaccess schema contain a subset of the rows
contained in their corresponding type 2 tables.
What is a durable key? - ANSWER-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? - ANSWER-*unknown (an
inferred row)
A foreign key column in Caboodle contains the value -3. What
could this mean?
- ANSWER-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.
If a foreign key is null in Clarity, what will appear in the
corresponding column in Caboodle? - ANSWER-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? - ANSWER-Both are used to map many-to-many
2026 || Most Recent Exam 2026-2027 Actual Complete
Real Exam Questions And Correct Answers (Verified
Answers) Already Graded A+ | Guaranteed Success!!
Newest Exam | Just Released!!
Why do profile dimensions have fewer rows than their parent
fact tables? - ANSWER-A row in a profile dimension represents
a unique combination of values (for example, VisitProfileDim
stores unique combinations of encounter type, visit type, and
financial class). Since combinations aren't repeated, profile
dimensions must contain fewer rows than their parent fact
table.
Additionally, the data points in a profile dimension often come
from category lists in Chronicles, so there's a limited number of
possible values they can take on.
T/F: A single bridge table can only referenced by one fact or
dimension table. -
ANSWER-False
Multiple facts and dimensions can reference a single bridge
table. For example, PatientDim and VisitFact both contain
foreign keys for DiagnosisBridge.
How can MedicationOrderFact join to PatientDim?
- ANSWER-
,MedicationOrderFact.PatientKey =
PatientDim.PatientKey or
MedicationOrderFact.PatientDurableKey =
PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? -
ANSWER-Yes,
example MedicationOrderFact can join to
EncounterFact.
Which of the following would you expect to be stored in a
dimension table? -
ANSWER-Users and Diagnosis
Definitions
Which of the following are possible to do in Caboodle? -
ANSWER-Joining a fact table to another fact table, Fact table to
dimension table, dimension table to dimension table, 2 different
EAV dim table to an attribute dim table
True or False: Any change to Patient data in Clarity will
generate a new row in PatientDim after the next extract. -
ANSWER-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. – ANSWER-True. _Current view
, tables in the Fullaccess schema contain a subset of the rows
contained in their corresponding type 2 tables.
What is a durable key? - ANSWER-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? - ANSWER-*unknown (an
inferred row)
A foreign key column in Caboodle contains the value -3. What
could this mean?
- ANSWER-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.
If a foreign key is null in Clarity, what will appear in the
corresponding column in Caboodle? - ANSWER-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? - ANSWER-Both are used to map many-to-many
