CDW110v Caboodle Data Model Fundamentals Actual Exam Questions and Answers 2025

What is the relationship SlicerDicer is Epic's self-service reporting tool in
between SlicerDicer and Hyperspace that dynamically queries Caboodle
Caboodle? data.



Explain the relationship The Cogito Dictionary reflects the dbo schema. The
between the dbo and FullAccess schema contains almost everything in
FullAccess schemas. 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.




True or False: A column False. A column can be both a primary key (the
can either be a primary column(s) used to uniquely identify a row) and a
key or a surrogate key, surrogate key (a key created during ETL that does
but not both. not exist in the source database). In Caboodle,
primary key columns are also surrogate keys.



True or False: Naming True. Naming conventions, such as <name>Fact,
conventions are are enforced in Caboodle.
enforced in Caboodle.



Identify the Caboodle AllergyFact.AllergyKey
table and column for the
following data point: The
Primary Key of
AllergyFact



Identify the Caboodle AllergyFact.Status
table and column for the
following data point:
Allergy Status (LPL 3030)



Identify the Caboodle AllergyFact.Severity
table and column for the
following data point:

,Allergy Severity (ECT
7150)



Identify the Caboodle AllergenDim.AllergenEpicId
table and column for the
following data point:
Allergen's Epic ID (ELG
.1)



Identify the Caboodle AllergenDim.Name
table and column for the
following data point:
Allergen's Name (ELG .2)



Identify the Caboodle AllergyFact.FirstReaction
table and column for the
following data point:
First Reaction (LPL 3008)



Identify the Caboodle VisitFact
table for the following
SlicerDicer data model:
The Visits Data Model



Identify the Caboodle ReceivedClaimFact
table for the following
SlicerDicer data model:
The AP Claims Data
Model




Identify the Caboodle ImagingFact
table for the following
SlicerDicer data model:
The Imaging Studies
Data Model



Identify the Caboodle LogisticsRequestJobFact
table for the following
SlicerDicer data model:

, The Patient Transports
Data Model



You are writing a report Search the Cogito Dictionary for "ORC 50". To limit
in Caboodle about the search results to ONLY Caboodle, search "CB:
surgeries. A colleague on ORC 50".
the OpTime team tells
you that the patient is
stored in I ORC 50. What
is the best way to
determine which
Caboodle table and
column extracts this
data?



A column in Caboodle Investigate the data lineage for the column using
does not contain the the Cogito Dictionary.
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?



How many SSIS A, B, and C
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



True or False: The ER False. The ER Diagram is a visual representation of
Diagram contains information that can be found in the dictionary
information that cannot
be found anywhere else
in the Cogito Dictionary?



Identify the Caboodle EncounterFact.EncounterEpicCsn
table and column for the