CDW110 EXAM SCRIPT 2026 FULL
QUESTION BANK 200 QUESTIONS WITH
ACCURATE ANSWERS
⩥ Why can't a Caboodle report return a diagnosis made this morning?
A. Diagnoses count as PHI, and legal restrictions prevent diagnoses
from being loaded into a new database
B. None of Epic's source databases capture diagnosis information
C. Caboodle extracts data nightly
D. None of the above; Caboodle is fully capable of reporting on a
diagnosis made this morning. Answer: C. Caboodle ETL runs every
night. It can only load data available at the time of ETL, and a diagnosis
made this morning wouldn't be available until tomorrow.
⩥ A Caboodle table exists with the name of
WoundAssessmentDataMart. What does each row most likely represent?
A. A wound
B. A wound assessment
C. A data mart
D. A custom table your organization has created. Answer: B. The text
preceding one of Caboodle's enforced table suffixes describes what the
,table stores. The suffix here is DataMart, and the preceding text is
WoundAssessment.
⩥ Assume your organization collects pharmacy data and hospital
admission data through Epic and collects hospital employee data using a
non‐Epic system. Which of the following report requests could be met
with Caboodle but not with Clarity?
A. The number of distinct medications dispensed by the pharmacy each
month
B. Which medications are ordered the most often
C. Peak occupancy times for beds and rooms in the hospital
D. Which hospital employees worked the most hours during peak
occupancy times. Answer: D. This report requires details about hospital
employees, and the scenario establishes that a non‐Epic system captures
hospital employee data. Of Epic's databases, only Caboodle can
integrate Epic and non‐Epic data.
⩥ You need to filter on the date represented by a DateKey column to
dates in the past decade. What is the recommended way to do this?
A. Join to DateDim and filter on DisplayString
B. Join to DateDim and filter on DateValue
C. Filter directly on the DateKey column
, D. Find an associated TimeOfDayKey column, construct a datetime, and
filter on this output. Answer: C. It is more efficient to filter directly on
DateKey values than to join to DateDim. In this scenario, it was
unnecessary to filter at any level more detailed than date.
⩥ Consider this screenshot about LabComponentResultFact.Flag:
[Image]
Which load package﴾s﴿ use Chronicles item ORD 2020 to populate this
column?
A. Neither
B. Just Lab Component Result Load
C. Just Lab Synoptic Result Load
D. Both. Answer: B. Only the Lab Component Result Load package
displays ORD 2020 in its Chronicles Info section.
⩥ Consider this screenshot about LabComponentResultFact.Flag:
[Image]
What Clarity column does the Lab Synoptic Result Load package use to
populate the Flag column for rows it loads?
QUESTION BANK 200 QUESTIONS WITH
ACCURATE ANSWERS
⩥ Why can't a Caboodle report return a diagnosis made this morning?
A. Diagnoses count as PHI, and legal restrictions prevent diagnoses
from being loaded into a new database
B. None of Epic's source databases capture diagnosis information
C. Caboodle extracts data nightly
D. None of the above; Caboodle is fully capable of reporting on a
diagnosis made this morning. Answer: C. Caboodle ETL runs every
night. It can only load data available at the time of ETL, and a diagnosis
made this morning wouldn't be available until tomorrow.
⩥ A Caboodle table exists with the name of
WoundAssessmentDataMart. What does each row most likely represent?
A. A wound
B. A wound assessment
C. A data mart
D. A custom table your organization has created. Answer: B. The text
preceding one of Caboodle's enforced table suffixes describes what the
,table stores. The suffix here is DataMart, and the preceding text is
WoundAssessment.
⩥ Assume your organization collects pharmacy data and hospital
admission data through Epic and collects hospital employee data using a
non‐Epic system. Which of the following report requests could be met
with Caboodle but not with Clarity?
A. The number of distinct medications dispensed by the pharmacy each
month
B. Which medications are ordered the most often
C. Peak occupancy times for beds and rooms in the hospital
D. Which hospital employees worked the most hours during peak
occupancy times. Answer: D. This report requires details about hospital
employees, and the scenario establishes that a non‐Epic system captures
hospital employee data. Of Epic's databases, only Caboodle can
integrate Epic and non‐Epic data.
⩥ You need to filter on the date represented by a DateKey column to
dates in the past decade. What is the recommended way to do this?
A. Join to DateDim and filter on DisplayString
B. Join to DateDim and filter on DateValue
C. Filter directly on the DateKey column
, D. Find an associated TimeOfDayKey column, construct a datetime, and
filter on this output. Answer: C. It is more efficient to filter directly on
DateKey values than to join to DateDim. In this scenario, it was
unnecessary to filter at any level more detailed than date.
⩥ Consider this screenshot about LabComponentResultFact.Flag:
[Image]
Which load package﴾s﴿ use Chronicles item ORD 2020 to populate this
column?
A. Neither
B. Just Lab Component Result Load
C. Just Lab Synoptic Result Load
D. Both. Answer: B. Only the Lab Component Result Load package
displays ORD 2020 in its Chronicles Info section.
⩥ Consider this screenshot about LabComponentResultFact.Flag:
[Image]
What Clarity column does the Lab Synoptic Result Load package use to
populate the Flag column for rows it loads?
