CDW 110V CABOODLE DATA MODEL
FUNDAMENTALS COMPREHENSIVE REVIEW
2026 COMPLETE QUESTIONS AND CORRECT
ANSWERS GRADED A+
◉ 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
,◉ You are writing a report in Caboodle about surgeries. A colleague
on 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?
Answer: Search the Cogito Dictionary for "ORC 50". To limit the
search results to ONLY Caboodle, search "CB: ORC 50".
◉ 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?
Answer: Investigate the data lineage for the column using the Cogito
Dictionary.
◉ 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
Answer: A, B, and C
◉ True or False: The ER Diagram contains information that cannot
be found anywhere else in the Cogito Dictionary?
Answer: False. The ER Diagram is a visual representation of
information that can be found in the dictionary
, ◉ Identify the Caboodle table and column for the following data
point: Encounter's Epic CSN
Answer: EncounterFact.EncounterEpicCsn
◉ Identify the Caboodle table and column for the following data
point: Type
Answer: EncounterFact.Type
◉ Identify the Caboodle table and column for the following data
point: Patient's name
Answer: PatientDim.Name
◉ Identify the Caboodle table and column for the following data
point: The patient's age in years
Answer: DurationDim.YearsDisplayString
◉ Identify the Caboodle table and column for the following data
point: Provider's name (SER .2)
Answer: ProviderDim.Name
◉ Identify the Caboodle table and column for the following data
point: Provider's primary specialty
FUNDAMENTALS COMPREHENSIVE REVIEW
2026 COMPLETE QUESTIONS AND CORRECT
ANSWERS GRADED A+
◉ 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
,◉ You are writing a report in Caboodle about surgeries. A colleague
on 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?
Answer: Search the Cogito Dictionary for "ORC 50". To limit the
search results to ONLY Caboodle, search "CB: ORC 50".
◉ 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?
Answer: Investigate the data lineage for the column using the Cogito
Dictionary.
◉ 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
Answer: A, B, and C
◉ True or False: The ER Diagram contains information that cannot
be found anywhere else in the Cogito Dictionary?
Answer: False. The ER Diagram is a visual representation of
information that can be found in the dictionary
, ◉ Identify the Caboodle table and column for the following data
point: Encounter's Epic CSN
Answer: EncounterFact.EncounterEpicCsn
◉ Identify the Caboodle table and column for the following data
point: Type
Answer: EncounterFact.Type
◉ Identify the Caboodle table and column for the following data
point: Patient's name
Answer: PatientDim.Name
◉ Identify the Caboodle table and column for the following data
point: The patient's age in years
Answer: DurationDim.YearsDisplayString
◉ Identify the Caboodle table and column for the following data
point: Provider's name (SER .2)
Answer: ProviderDim.Name
◉ Identify the Caboodle table and column for the following data
point: Provider's primary specialty
