CDW110v Caboodle Exam (2025/2026) – 200 Questions on Data Model, Fact/Dim Tables, SQL & SlicerDicer

CDW110v Caboodle Data Model
Fundamentals EXAM
QUESTIONS AND VERIFIED
ANSWERS 2025(GRADED A+)
DETAILED ANSWERS!!

What is the relationship between SlicerDicer and Caboodle? - 🧠 ANSWER

✔✔SlicerDicer is Epic's self-service reporting tool in Hyperspace that

dynamically queries Caboodle data.

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.

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.

True or False: Naming conventions are enforced in Caboodle. - 🧠 ANSWER

✔✔True. Naming conventions, such as <name>Fact, are enforced in

Caboodle.

Identify the Caboodle table and column for the following data point: The

Primary Key of AllergyFact - 🧠 ANSWER ✔✔AllergyFact.AllergyKey


Identify the Caboodle table and column for the following data point: Allergy

Status (LPL 3030) - 🧠 ANSWER ✔✔AllergyFact.Status

, Identify the Caboodle table and column for the following data point: Allergy

Severity (ECT 7150) - 🧠 ANSWER ✔✔AllergyFact.Severity


Identify the Caboodle table and column for the following data point:

Allergen's Epic ID (ELG .1) - 🧠 ANSWER ✔✔AllergenDim.AllergenEpicId


Identify the Caboodle table and column for the following data point:

Allergen's Name (ELG .2) - 🧠 ANSWER ✔✔AllergenDim.Name


Identify the Caboodle table and column for the following data point: First

Reaction (LPL 3008) - 🧠 ANSWER ✔✔AllergyFact.FirstReaction


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

Visits Data Model - 🧠 ANSWER ✔✔VisitFact


Identify the Caboodle table for the following SlicerDicer data model: The AP

Claims Data Model - 🧠 ANSWER ✔✔ReceivedClaimFact


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

Imaging Studies Data Model - 🧠 ANSWER ✔✔ImagingFact


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

Patient Transports Data Model - 🧠 ANSWER ✔✔LogisticsRequestJobFact




COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2026. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED