CDW110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM WITH CORRECT
ACTUAL QUESTIONS AND CORRECTLY
WELL DEFINED ANSWERS LATEST
ALREADY GRADED A+ 2025 – 2026 FOR
EPIC CERTIFICATION PREPARATION
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 - ANSWERS-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.
,True or False: All inferred rows in Caboodle have a primary
key of -1. - ANSWERS-False. Inferred rows in Caboodle have
non-negative primary key values because they represent an
entity that Caboodle has inferred the existence of. The
lookup columns for such rows will be set to -1 until the
Caboodle ETL process updates the data.
Identify the Caboodle table and column for the following
data point: The date the patient arrived at the ED -
ANSWERS-
Identify the Caboodle table and column for the following
data point: The chief complaints Epic ID - ANSWERS-
ChiefComplaintBridge.ChiefComplaintEpicId
Identify the Caboodle table and column for the following
data point: The patient's name - ANSWERS-
PatientDim.Name
Identify the Caboodle table and column for the following
data point: The Encounter's Epic CSN - ANSWERS-
EdVisitFact.EncounterEpicCsn
, Identify the Caboodle table and column for the following
data point: Allergy Status (LPL 3030) - ANSWERS-
AllergyFact.Status
Identify the Caboodle table and column for the following
data point: Allergy Severity (ECT 7150) - ANSWERS-
AllergyFact.Severity
Identify the Caboodle table and column for the following
data point: Allergen's Epic ID (ELG .1) - ANSWERS-
AllergenDim.AllergenEpicId
Identify the Caboodle table and column for the following
data point: Allergen's Name (ELG .2) - ANSWERS-
AllergenDim.Name
Identify the Caboodle table and column for the following
data point: First Reaction (LPL 3008) - ANSWERS-
AllergyFact.FirstReaction
Identify the Caboodle table for the following SlicerDicer
data model: The Visits Data Model - ANSWERS-VisitFact
FUNDAMENTALS EXAM WITH CORRECT
ACTUAL QUESTIONS AND CORRECTLY
WELL DEFINED ANSWERS LATEST
ALREADY GRADED A+ 2025 – 2026 FOR
EPIC CERTIFICATION PREPARATION
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 - ANSWERS-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.
,True or False: All inferred rows in Caboodle have a primary
key of -1. - ANSWERS-False. Inferred rows in Caboodle have
non-negative primary key values because they represent an
entity that Caboodle has inferred the existence of. The
lookup columns for such rows will be set to -1 until the
Caboodle ETL process updates the data.
Identify the Caboodle table and column for the following
data point: The date the patient arrived at the ED -
ANSWERS-
Identify the Caboodle table and column for the following
data point: The chief complaints Epic ID - ANSWERS-
ChiefComplaintBridge.ChiefComplaintEpicId
Identify the Caboodle table and column for the following
data point: The patient's name - ANSWERS-
PatientDim.Name
Identify the Caboodle table and column for the following
data point: The Encounter's Epic CSN - ANSWERS-
EdVisitFact.EncounterEpicCsn
, Identify the Caboodle table and column for the following
data point: Allergy Status (LPL 3030) - ANSWERS-
AllergyFact.Status
Identify the Caboodle table and column for the following
data point: Allergy Severity (ECT 7150) - ANSWERS-
AllergyFact.Severity
Identify the Caboodle table and column for the following
data point: Allergen's Epic ID (ELG .1) - ANSWERS-
AllergenDim.AllergenEpicId
Identify the Caboodle table and column for the following
data point: Allergen's Name (ELG .2) - ANSWERS-
AllergenDim.Name
Identify the Caboodle table and column for the following
data point: First Reaction (LPL 3008) - ANSWERS-
AllergyFact.FirstReaction
Identify the Caboodle table for the following SlicerDicer
data model: The Visits Data Model - ANSWERS-VisitFact
