Caboodle LATEST UPDATED 2025/2026
Exam WITH COMPLETE Questions AND
SURE VERIFIED solutions 100%
GRADED AT A+ SCORE SURE
GUARANTEED PASS!!
1. What is the relationship between SlicerDicer and Caboodle? -
ANSWER ✔ SlicerDicer is Epic's self-service reporting tool in
Hyperspace that dynamically queries Caboodle data.
2. Identify the Caboodle table and column for the following data
point: The date the patient arrived at the ED - ANSWER ✔
3. Identify the Caboodle table and column for the following data
point: The chief complaints Epic ID - ANSWER ✔
ChiefComplaintBridge.ChiefComplaintEpicId
4. Identify the Caboodle table and column for the following data
point: The patient's name - ANSWER ✔ PatientDim.Name
5. Identify the Caboodle table and column for the following data
point: The Encounter's Epic CSN - ANSWER ✔
EdVisitFact.EncounterEpicCsn
6. Explain the relationship between the dbo and FullAccess schemas.
- ANSWER ✔ 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.
7. True or False: A column can either be a primary key or a surrogate
key, but not both. - ANSWER ✔ False. A column can be both a
primary key (the column(s) used to uniquely identify a row) and a
surrogate key (a key created during ETL that does not exist in the
source database). In Caboodle, primary key columns are also
surrogate keys.
8. True or False: Naming conventions are enforced in Caboodle. -
ANSWER ✔ True. Naming conventions, such as <name>Fact, are
enforced in Caboodle.
9. Identify the Caboodle table and column for the following data
point: The Primary Key of AllergyFact - ANSWER ✔
AllergyFact.AllergyKey
10. Identify the Caboodle table and column for the following
data point: Allergy Status (LPL 3030) - ANSWER ✔
AllergyFact.Status
11. Identify the Caboodle table and column for the following
data point: Allergy Severity (ECT 7150) - ANSWER ✔
AllergyFact.Severity
12. Identify the Caboodle table and column for the following
data point: Allergen's Epic ID (ELG .1) - ANSWER ✔
AllergenDim.AllergenEpicId
13. Identify the Caboodle table and column for the following
data point: Allergen's Name (ELG .2) - ANSWER ✔
AllergenDim.Name
Exam WITH COMPLETE Questions AND
SURE VERIFIED solutions 100%
GRADED AT A+ SCORE SURE
GUARANTEED PASS!!
1. What is the relationship between SlicerDicer and Caboodle? -
ANSWER ✔ SlicerDicer is Epic's self-service reporting tool in
Hyperspace that dynamically queries Caboodle data.
2. Identify the Caboodle table and column for the following data
point: The date the patient arrived at the ED - ANSWER ✔
3. Identify the Caboodle table and column for the following data
point: The chief complaints Epic ID - ANSWER ✔
ChiefComplaintBridge.ChiefComplaintEpicId
4. Identify the Caboodle table and column for the following data
point: The patient's name - ANSWER ✔ PatientDim.Name
5. Identify the Caboodle table and column for the following data
point: The Encounter's Epic CSN - ANSWER ✔
EdVisitFact.EncounterEpicCsn
6. Explain the relationship between the dbo and FullAccess schemas.
- ANSWER ✔ 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.
7. True or False: A column can either be a primary key or a surrogate
key, but not both. - ANSWER ✔ False. A column can be both a
primary key (the column(s) used to uniquely identify a row) and a
surrogate key (a key created during ETL that does not exist in the
source database). In Caboodle, primary key columns are also
surrogate keys.
8. True or False: Naming conventions are enforced in Caboodle. -
ANSWER ✔ True. Naming conventions, such as <name>Fact, are
enforced in Caboodle.
9. Identify the Caboodle table and column for the following data
point: The Primary Key of AllergyFact - ANSWER ✔
AllergyFact.AllergyKey
10. Identify the Caboodle table and column for the following
data point: Allergy Status (LPL 3030) - ANSWER ✔
AllergyFact.Status
11. Identify the Caboodle table and column for the following
data point: Allergy Severity (ECT 7150) - ANSWER ✔
AllergyFact.Severity
12. Identify the Caboodle table and column for the following
data point: Allergen's Epic ID (ELG .1) - ANSWER ✔
AllergenDim.AllergenEpicId
13. Identify the Caboodle table and column for the following
data point: Allergen's Name (ELG .2) - ANSWER ✔
AllergenDim.Name
