CDW110v Caboodle Data Model Fundamentals Exam 2025/2026 Questions With Completed Solutions.

CDW110v Caboodle Data Model
Fundamentals

A column in Caboodle does not contain the data you expect to see. To determine if the issue
is within the source data or the ETL process, you want to investigate the Clarity data. How
can you determine which Clarity column is used to populate the Caboodle column? -
ANS-Investigate the data lineage for the column using the Cogito Dictionary.
\A lookup column in Caboodle contains the value -3. What could this mean? - ANS-There
are two possibilities: Either the data that once populated this row in Caboodle has been
deleted from the source or this is the row with -3 as its primary key, for which all lookup
columns are also -3. To know which is true, check the primary key value for the given row: a
non-negative value indicates that this row represents deleted data in the source.
\A row in a Caboodle table has a primary key value of -2. What value will be stored in
columns with a data type of "Date" for this row that are not lookup columns?
A. -2
B. NULL
C. 12/31/1840
D. *Not Applicable - ANS-b. NULL, For the row with a primary key of -2, lookup columns will
store a value of -2, string columns will store '*Not Applicable', and all other data type
columns will store NULL.
\Consider the following query:

SELECT DurableKey FROM <TableName>

Which of the following statements are true?

A. This query will only run if <TableName> is a snapshot table
B. This query will run regardless of whether <TableName> has change tracking
C. The value in the DurableKey column could repeat in multiple rows of the results
D. There is no table in Caboodle for which this query will run - ANS-A. This query will only
run if <TableName> is a snapshot table, and C. The value in the DurableKey column could
repeat in multiple rows of the results
\Explain the relationship between the dbo and FullAccess schemas. - ANS-The Cogito
Dictionary reflects the dbo schema. The FullAccess schema contains almost everything in
the dbo schema (minus a few metadata columns) plus additional columns in some tables.
Since FullAccess has more data, report writers should use it when writing queries. However,
report writers should also be familiar with dbo due to its relationship with the Cogito
Dictionary.
\How does data get into Caboodle? - ANS-Data gets into Caboodle through SSIS packages
from Clarity or a 3rd party database.
\How many SSIS packages can populate a single table in Caboodle.
A. A single SSIS package
B. Multiple SSIS packages all from Clarity
C. Multiple SSIS packages from multiple sources - ANS-A, B, and C

, \Identify the Caboodle table and column for the following data point, INI, and Item #:
Administration Date, I LPL 4010 - ANS-ImmunizationEventFact.AdministrationDateKey
\Identify the Caboodle table and column for the following data point, INI, and Item #:
Encounter CSN, I EPT 8 - ANS-EncounterFact.EncounterEpicCsn
\Identify the Caboodle table and column for the following data point, INI, and Item #:
Immunization Name, I LIM .2 - ANS-ImmunizationDim.Name
\Identify the Caboodle table and column for the following data point, INI, and Item #: Patient's
Age, none - ANS-ImmunizationEventFact.AgeKey
\Identify the Caboodle table and column for the following data point, INI, and Item #: The
immunizations in the VCG grouper, I VCG .1 - ANS-ImmunizationSetDim.ValueSetEpicId =
'1137225'
\Identify the Caboodle table and column for the following data point: Allergen's Epic ID (ELG
.1) - ANS-AllergenDim.AllergenEpicId
\Identify the Caboodle table and column for the following data point: Allergen's Name (ELG
.2) - ANS-AllergenDim.Name
\Identify the Caboodle table and column for the following data point: Allergy Severity (ECT
7150) - ANS-AllergyFact.Severity
\Identify the Caboodle table and column for the following data point: Allergy Status (LPL
3030) - ANS-AllergyFact.Status
\Identify the Caboodle table and column for the following data point: Column in the -Fact
table to remove deleted data - ANS-MedicationOrderFact._IsDeleted = 0
\Identify the Caboodle table and column for the following data point: Column to identify
deleted primary care providers - ANS-ProviderDim._IsDeleted = 1
\Identify the Caboodle table and column for the following data point: Column to identify
inferred patients - ANS-PatientDim._IsInferred
\Identify the Caboodle table and column for the following data point: Column used to find
Office Visits (I EPT 30) - ANS-EncounterFact.Type = 'Office Visit'
\Identify the Caboodle table and column for the following data point: Column used to identify
office visits that have been completed (I EPT 87318) -
ANS-EncounterFact.DerivedEncounterStatus = 'Complete'
\Identify the Caboodle table and column for the following data point: Days as attending -
ANS-HospitalAdmissionAttributedProviderDataMart.NumberOfDistinctDaysAsInpatientAtten
ding
\Identify the Caboodle table and column for the following data point: Encounter's Epic CSN -
ANS-EncounterFact.EncounterEpicCsn
\Identify the Caboodle table and column for the following data point: First Reaction (LPL
3008) - ANS-AllergyFact.FirstReaction
\Identify the Caboodle table and column for the following data point: Hours as attending -
ANS-HospitalAdmissionAttributedProviderDataMart.NumberOfHoursAsInpatientAttending
\Identify the Caboodle table and column for the following data point: Medications that are
considered opioids - ANS-MedicationDim.Opioid
\Identify the Caboodle table and column for the following data point: Number of Encounters -
ANS-HospitalAdmissionAttributedProviderDataMart.HospitalAdmissionKey
\Identify the Caboodle table and column for the following data point: Patient's name -
ANS-PatientDim.Name
\Identify the Caboodle table and column for the following data point: Provider Epic ID -
ANS-ProviderDim.ProviderEpicId