CDW110 EXAM 2026 EXAM SCRIPT FULL
QUESTION BANK WITH VERIFIED
SOLUTIONS AND STEP BY STEP
EXPLANATIONS
⩥ (ETL Terms) Extract. Answer: Extracts to Caboodle from Clarity can
be either backfill or incremental. Backfill extracts load or reload every
row in a table from Clarity, whereas incremental extracts load only
changed rows. Existing data is available while extracts are in progress.
⩥ (ETL Terms)package. Answer: A package is a definition of an extract
of data from one specific source to a specific import table. For example,
a fact might have packages for Epic inpatient data, Epic outpatient data,
and several non-Epic data sources. Packages are defined in SSIS .dtsx
files.
⩥ Chapter 1. (Study Checklist) Identify key characteristics of the
dimensional data model.. Answer: MADE for report writers.
· Simpler and more intuitive.
· Easily extensible.
· More performant..
⩥ Chapter 1. (Study Checklist) Identify documentation resources for
reporting out of Caboodle. Answer: Caboodle Dictionary
,Reporting with Caboodle document
Caboodle ER diagram
⩥ Chapter 1. (Study Checklist) Identify reporting needs that best fit
Caboodle. Answer: Custom data packages can be written by Caboodle
developers to accommodate your organization's reporting needs.
⩥ (General Reporting Tips) Add a filter to most queries to exclude
Caboodle's special rows for unspecified, not applicable, and deleted
records, which have surrogate keys of -1, -2, and -3. Answer: Include
only rows where the key is greater than 0.
⩥ (General Reporting Tips) Caboodle has a numbers table,
NumbersDim, that you can use as needed in your reports. Answer:
NumbersDim contains the integers from 1 to 1,000,000, which you can
reference to help manipulate strings and complete other processes. If you
need more than 1,000,000 rows to accomplish a task, you can refer to
NumbersDim multiple times in your query.
⩥ Chapter 1. (Study Checklist) How does Epic data flow into Caboodle.
Answer: Epic data moves between several databases before it gets to
Caboodle.
CHRONICLES flows into CLARITY via ETL. After transformation, the
data is stored in a relational database on a separate server. Even though
,the structure of the Chronicles and Clarity databases differ significantly,
the ETL process preserves the relationships mapped in Chronicles.
CLARITY flows into Caboodle data is extracted
from Clarity, transformed in the staging database, and presented for
users in the reporting database. This movement of data is realized via a
set of SQL Server Integration Services (SSIS) packages.
⩥ Chapter 1. (Study Checklist) How does Non-Epic data flow into
Caboodle. Answer: The Caboodle developer designs custom DMCs
(Data Model Components) and writes SSIS
packages to bring additional data into the warehouse. This may be
additional Epic data from Clarity or non‐Epic data from 3rd party
sources.
⩥ CHAPTER 1. (Reviewing the Chapter) What are the differences
between a normalized and dimensional data model?. Answer: In a
normalized data model, the focus is on not repeating data, which reduces
the size of the
database.
In a dimensional data model, the focus is on ease of reporting and uses
the star schema, which focuses on a central fact table pertaining to a
reportable event and surrounding dimension tables providing context for
the event.
, CONTEXT...It gives CONTEXT
⩥ CHAPTER 1. (Reviewing the Chapter) Briefly define the roles of the
Caboodle report writer, administrator, and developer.. Answer: · The
Caboodle report writer queries data that already exists in the database.
They use their knowledge of the tools and the source database(s) to
conduct research into the necessary data points required for a given
report.
· The Caboodle administrator uses the Caboodle Console to manage and
monitor the ETL process. They troubleshoot ETL errors and handle
configuration steps for the database.
· The Caboodle developer designs custom DMCs (Data Model
Components) and writes SSIS packages to bring additional data into the
warehouse. This may be additional Epic data from Clarity or non‐Epic
data from 3rd party sources.
⩥ CHAPTER 1. (Reviewing the Chapter) TRUE or FALSE: Naming
conventions are enforced in Caboodle.. Answer: True. Naming
conventions, such as <name>Fact, are enforced in Caboodle.
⩥ CHAPTER 1. (Reviewing the Chapter) What is the relationship
between SlicerDicer and Caboodle?. Answer: SlicerDicer is Epic's self-
QUESTION BANK WITH VERIFIED
SOLUTIONS AND STEP BY STEP
EXPLANATIONS
⩥ (ETL Terms) Extract. Answer: Extracts to Caboodle from Clarity can
be either backfill or incremental. Backfill extracts load or reload every
row in a table from Clarity, whereas incremental extracts load only
changed rows. Existing data is available while extracts are in progress.
⩥ (ETL Terms)package. Answer: A package is a definition of an extract
of data from one specific source to a specific import table. For example,
a fact might have packages for Epic inpatient data, Epic outpatient data,
and several non-Epic data sources. Packages are defined in SSIS .dtsx
files.
⩥ Chapter 1. (Study Checklist) Identify key characteristics of the
dimensional data model.. Answer: MADE for report writers.
· Simpler and more intuitive.
· Easily extensible.
· More performant..
⩥ Chapter 1. (Study Checklist) Identify documentation resources for
reporting out of Caboodle. Answer: Caboodle Dictionary
,Reporting with Caboodle document
Caboodle ER diagram
⩥ Chapter 1. (Study Checklist) Identify reporting needs that best fit
Caboodle. Answer: Custom data packages can be written by Caboodle
developers to accommodate your organization's reporting needs.
⩥ (General Reporting Tips) Add a filter to most queries to exclude
Caboodle's special rows for unspecified, not applicable, and deleted
records, which have surrogate keys of -1, -2, and -3. Answer: Include
only rows where the key is greater than 0.
⩥ (General Reporting Tips) Caboodle has a numbers table,
NumbersDim, that you can use as needed in your reports. Answer:
NumbersDim contains the integers from 1 to 1,000,000, which you can
reference to help manipulate strings and complete other processes. If you
need more than 1,000,000 rows to accomplish a task, you can refer to
NumbersDim multiple times in your query.
⩥ Chapter 1. (Study Checklist) How does Epic data flow into Caboodle.
Answer: Epic data moves between several databases before it gets to
Caboodle.
CHRONICLES flows into CLARITY via ETL. After transformation, the
data is stored in a relational database on a separate server. Even though
,the structure of the Chronicles and Clarity databases differ significantly,
the ETL process preserves the relationships mapped in Chronicles.
CLARITY flows into Caboodle data is extracted
from Clarity, transformed in the staging database, and presented for
users in the reporting database. This movement of data is realized via a
set of SQL Server Integration Services (SSIS) packages.
⩥ Chapter 1. (Study Checklist) How does Non-Epic data flow into
Caboodle. Answer: The Caboodle developer designs custom DMCs
(Data Model Components) and writes SSIS
packages to bring additional data into the warehouse. This may be
additional Epic data from Clarity or non‐Epic data from 3rd party
sources.
⩥ CHAPTER 1. (Reviewing the Chapter) What are the differences
between a normalized and dimensional data model?. Answer: In a
normalized data model, the focus is on not repeating data, which reduces
the size of the
database.
In a dimensional data model, the focus is on ease of reporting and uses
the star schema, which focuses on a central fact table pertaining to a
reportable event and surrounding dimension tables providing context for
the event.
, CONTEXT...It gives CONTEXT
⩥ CHAPTER 1. (Reviewing the Chapter) Briefly define the roles of the
Caboodle report writer, administrator, and developer.. Answer: · The
Caboodle report writer queries data that already exists in the database.
They use their knowledge of the tools and the source database(s) to
conduct research into the necessary data points required for a given
report.
· The Caboodle administrator uses the Caboodle Console to manage and
monitor the ETL process. They troubleshoot ETL errors and handle
configuration steps for the database.
· The Caboodle developer designs custom DMCs (Data Model
Components) and writes SSIS packages to bring additional data into the
warehouse. This may be additional Epic data from Clarity or non‐Epic
data from 3rd party sources.
⩥ CHAPTER 1. (Reviewing the Chapter) TRUE or FALSE: Naming
conventions are enforced in Caboodle.. Answer: True. Naming
conventions, such as <name>Fact, are enforced in Caboodle.
⩥ CHAPTER 1. (Reviewing the Chapter) What is the relationship
between SlicerDicer and Caboodle?. Answer: SlicerDicer is Epic's self-
