CDW110 EXAM: 100% EXPERT VERIFIED STUDY GUIDE
REAL TESTING 2026|2027 QUESTIONS DETAILED
ANSWERS AND INSTRUCTOR NOTE FOR A+
GUARANTEED PASS
CHAPTER 1-What are the differences between a normalized and dimensional data model? -
Answers -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-Briefly define the roles of the Caboodle report writer, administrator, and developer. -
Answers -· 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.
1|Page
,CHAPTER 1-TRUE or FALSE: Naming conventions are enforced in Caboodle. - Answers -True.
Naming conventions, such as <name>Fact, are enforced in Caboodle.
CHAPTER 1-What is the relationship between SlicerDicer and Caboodle? - Answers -SlicerDicer is
Epic's self-service reporting tool in Hyperspace that dynamically queries Caboodle data.
CHAPTER 4-Suppose you're creating a report using EncounterFact and ProviderDim that displays
the name of each provider for each encounter. If an encounter's data loads into EncounterFact,
but that provider's data hasn't been extracted to ProviderDim, what value would appear in
ProviderDim.Name for this encounter? - Answers -There would be an inferred row in
ProviderDim, therefore ProviderDim.Name would show "*Unknown" for the encounter.
CHAPTER 4-A foreign key column in Caboodle contains the value -3. What could this mean? -
Answers -There are two possibilities: Either the data that once populated this row in Caboodle
has been deleted from the source or this is the row with -3 as its primary key, for which all
foreign key columns are also -3. To know which is true, check the primary key value for the given
row: a non-negative value indicates that this row represents deleted data in the source.
CHAPTER 4-If a foreign key is null in Clarity, what will appear in the corresponding column in
Caboodle? - Answers -If the foreign key was null in the source, then a -1 will appear in Caboodle
to represent an unspecified value. If the foreign key's data lineage was not defined by the
source package that loaded data for a particular row, then a -2 will appear in Caboodle to
represent a value that is not applicable.
CHAPTER 4-A row in a Caboodle table has a primary key value of -2. What value will be stored in
non-foreign key columns with a data type of "Date" for this row?
2|Page
, A. -2
B. NULL
C. 12/31/1840
D. *Not Applicable - Answers -b. NULL
For the row with a primary key of -2, foreign key columns will store a value of -2, string columns
will
store '*Not Applicable', and all other data type columns will store NULL.
CHAPTER 4-TRUE or FALSE: All inferred rows in Caboodle have a primary key of -1. - Answers -
False
Inferred rows in Caboodle have non-negative primary key values because they represent an
entity that Caboodle has inferred the existence of. The foreign key columns for such rows will be
set to -1 until the Caboodle ETL process updates the data.
CHAPTER 4-Referential Integrity - Answers -Referential integrity is enforced in Caboodle,
meaning that lookup columns will never contain null values. Furthermore, every value in a
lookup column has a match in the destination table.
Caboodle enforces referential integrity by:
• Placing "extra" rows in every table
• These rows have surrogate key values of -1, -2, and -3
• Applying default foreign key values (-1, -2, -3)
• Creating inferred rows
3|Page
REAL TESTING 2026|2027 QUESTIONS DETAILED
ANSWERS AND INSTRUCTOR NOTE FOR A+
GUARANTEED PASS
CHAPTER 1-What are the differences between a normalized and dimensional data model? -
Answers -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-Briefly define the roles of the Caboodle report writer, administrator, and developer. -
Answers -· 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.
1|Page
,CHAPTER 1-TRUE or FALSE: Naming conventions are enforced in Caboodle. - Answers -True.
Naming conventions, such as <name>Fact, are enforced in Caboodle.
CHAPTER 1-What is the relationship between SlicerDicer and Caboodle? - Answers -SlicerDicer is
Epic's self-service reporting tool in Hyperspace that dynamically queries Caboodle data.
CHAPTER 4-Suppose you're creating a report using EncounterFact and ProviderDim that displays
the name of each provider for each encounter. If an encounter's data loads into EncounterFact,
but that provider's data hasn't been extracted to ProviderDim, what value would appear in
ProviderDim.Name for this encounter? - Answers -There would be an inferred row in
ProviderDim, therefore ProviderDim.Name would show "*Unknown" for the encounter.
CHAPTER 4-A foreign key column in Caboodle contains the value -3. What could this mean? -
Answers -There are two possibilities: Either the data that once populated this row in Caboodle
has been deleted from the source or this is the row with -3 as its primary key, for which all
foreign key columns are also -3. To know which is true, check the primary key value for the given
row: a non-negative value indicates that this row represents deleted data in the source.
CHAPTER 4-If a foreign key is null in Clarity, what will appear in the corresponding column in
Caboodle? - Answers -If the foreign key was null in the source, then a -1 will appear in Caboodle
to represent an unspecified value. If the foreign key's data lineage was not defined by the
source package that loaded data for a particular row, then a -2 will appear in Caboodle to
represent a value that is not applicable.
CHAPTER 4-A row in a Caboodle table has a primary key value of -2. What value will be stored in
non-foreign key columns with a data type of "Date" for this row?
2|Page
, A. -2
B. NULL
C. 12/31/1840
D. *Not Applicable - Answers -b. NULL
For the row with a primary key of -2, foreign key columns will store a value of -2, string columns
will
store '*Not Applicable', and all other data type columns will store NULL.
CHAPTER 4-TRUE or FALSE: All inferred rows in Caboodle have a primary key of -1. - Answers -
False
Inferred rows in Caboodle have non-negative primary key values because they represent an
entity that Caboodle has inferred the existence of. The foreign key columns for such rows will be
set to -1 until the Caboodle ETL process updates the data.
CHAPTER 4-Referential Integrity - Answers -Referential integrity is enforced in Caboodle,
meaning that lookup columns will never contain null values. Furthermore, every value in a
lookup column has a match in the destination table.
Caboodle enforces referential integrity by:
• Placing "extra" rows in every table
• These rows have surrogate key values of -1, -2, and -3
• Applying default foreign key values (-1, -2, -3)
• Creating inferred rows
3|Page
