CDW110V CABOODLE DATA MODEL FUNDAMENTALS EXAM STUDY
GUIDE AND PRACTICE EXAM ACCURATE REAL EXAM QUESTIONS
WITH VERIFIED ANSWERS EXPERT VERIFIED FOR A GUARANTEED
PASS LATEST UPDATE
Question 1
True or False: A Caboodle report may contain at most 1 conformed dimension?
A) False
B) True
Correct Answer: A) False
Rationale: A Caboodle report can contain multiple conformed dimensions, allowing for
complex data analysis across various business areas.
Question 2
Which of the following can be populated by more than one package (SSIS)?
A) A single row in a table only.
B) A single table only.
C) A single column in a table only.
D) A single table and a single row in a table.
E) A single package can only populate one table.
Correct Answer: D) A single table and a single row in a table.
Rationale: Multiple packages can contribute data to the same table, and different rows (or
even the same row in certain scenarios) within a table can be populated by different
packages.
Question 3
When would a foreign key column in Caboodle contain a -1?
A) When the foreign key in the source data was present and matched.
B) When the foreign key was not expected to have data.
C) When the data that once populated this row was deleted from the source.
D) When the foreign key in the source data was null and a value was expected.
E) When the foreign key is linked to an inferred row.
Correct Answer: D) When the foreign key in the source data was null and a value was
expected.
Rationale: A -1 in a foreign key column typically indicates an unspecified or null value from
the source system where a valid reference was anticipated.
Question 4
Which tool(s) in the Caboodle console would be used most often by Caboodle report writers?
A) ETL Management and Job Monitor.
B) Data Model Editor and Package Editor.
C) Configuration and Security.
D) Data Dictionary and Data Lineage.
E) Dictionary and the Dictionary editor.
,[Type here]
Correct Answer: E) Dictionary and the Dictionary editor.
Rationale: Report writers frequently use the Dictionary to understand table and column
definitions, and the Dictionary Editor to make sense of the data available for reporting.
Question 5
True or False: Caboodle and Clarity can be used interchangeably?
A) True
B) False
Correct Answer: B) False
Rationale: Caboodle and Clarity serve different purposes; Clarity is the operational
reporting database, while Caboodle is a data warehouse for analytical reporting, making
them non-interchangeable.
Question 6
Which of the following types of columns would you find in a type 1 table?
A) StartDate, EndDate, IsCurrent.
B) PatientDurableKey, PatientKey, IsCurrent.
C) Surrogate key, foreign key, and a combo key.
D) AttributeValue, AttributeName, ValueType.
E) Only a surrogate key.
Correct Answer: C) Surrogate key, foreign key, and a combo key.
Rationale: Type 1 tables (slowly changing dimensions Type 1) update existing records, so
they do not track historical changes with StartDate/EndDate. They typically contain a
surrogate key (primary key), foreign keys to link to other tables, and often a combo key to
identify the natural key from the source.
Question 7
Where does Epic data in Caboodle come from?
A) Directly from Chronicles.
B) Directly from Epic's Hyperspace.
C) From external non-Epic systems.
D) From Clarity, which gets its data from Chronicles.
E) From SlicerDicer.
Correct Answer: D) From Clarity, which gets its data from Chronicles.
Rationale: Caboodle extracts Epic data from Clarity, which is Epic's reporting database
populated from the transactional Chronicles database.
Question 8
True or false: Only Epic can define SSIS packages to move data from Clarity to Caboodle?
A) True
B) False
Correct Answer: B) False
,[Type here]
Rationale: Caboodle developers within an organization can also define SSIS packages to
move custom or additional data from Clarity (or other sources) to Caboodle.
Question 9
Caboodle is designed to...
A) Only store Epic data for transactional purposes.
B) Exclusively make real-time operational reporting easy.
C) Only provide data for direct clinical care.
D) Store Epic data, store non-Epic data, make reporting easy, and interoperate with
SlicerDicer.
E) Primarily optimize data entry speeds.
Correct Answer: D) Store Epic data, store non-Epic data, make reporting easy, and
interoperate with SlicerDicer.
Rationale: Caboodle is a comprehensive data warehouse, integrating both Epic and non-
Epic data for analytical reporting, and is a key backend for SlicerDicer.
Question 10
True or False: Caboodle is considered a normalized database.
A) True
B) False
Correct Answer: B) False
Rationale: Caboodle is designed as a dimensional data model (star schema) for ease of
reporting and analytical queries, which is denormalized compared to a transactional
normalized database.
Question 11
Name three documentation resources for Caboodle.
A) Caboodle Management Guide, Epic Community, Training Handouts.
B) Caboodle Data Flow Diagrams, SQL Server Management Studio, SSIS Package
Documentation.
C) Caboodle Configuration Guide, Job Monitor Logs, ETL Process Maps.
D) Caboodle dictionary, Reporting with Caboodle document, Caboodle ER diagram.
E) Caboodle Developer Guide, Release Notes, Forum Discussions.
Correct Answer: D) Caboodle dictionary, Reporting with Caboodle document, Caboodle ER
diagram.
Rationale: These are standard documentation resources provided for understanding and
working with the Caboodle data model.
Question 12
When writing reports, why is it better to use your organization's Caboodle console rather than the
console used in training?
A) The training console is often outdated.
, [Type here]
B) The training console has limited data.
C) Because the console can be highly customized for your organization.
D) The training console is slower.
E) The training console lacks security features.
Correct Answer: C) Because the console can be highly customized for your organization.
Rationale: Each organization's Caboodle instance is tailored with specific customizations,
including added tables, columns, and modified ETL processes, making their console the
accurate reflection of their data.
Question 13
What are the differences between a normalized and dimensional data model?
A) Normalized focuses on ease of reporting; dimensional on repeating data.
B) Normalized uses star schema; dimensional avoids it.
C) In a normalized data model, the focus is on not repeating data. In a dimensional data
model, the focus is on ease of reporting, and uses the star schema which focuses on a central
fact table.
D) Normalized is for analytical queries; dimensional is for transactional systems.
E) Normalized is always denormalized; dimensional is always normalized.
Correct Answer: C) In a normalized data model, the focus is on not repeating data. In a
dimensional data model, the focus is on ease of reporting, and uses the star schema which
focuses on a central fact table.
Rationale: This accurately captures the core distinction: normalized for transactional
integrity (no redundancy), dimensional for query performance (denormalized, star
schema).
Question 14
True or False: A new version of Caboodle is released every month.
A) True
B) False
Correct Answer: B) False
Rationale: Caboodle versions are released less frequently, typically aligning with Epic's
major releases. The text states "released every four to six months."
Question 15
Explain the role of the Caboodle report writer.
A) Designs custom Data Model Components.
B) Manages and monitors the ETL process.
C) Creates SSIS packages.
D) Queries data that already exists in the database.
E) Designs the overall data warehouse architecture.
Correct Answer: D) Queries data that already exists in the database.
GUIDE AND PRACTICE EXAM ACCURATE REAL EXAM QUESTIONS
WITH VERIFIED ANSWERS EXPERT VERIFIED FOR A GUARANTEED
PASS LATEST UPDATE
Question 1
True or False: A Caboodle report may contain at most 1 conformed dimension?
A) False
B) True
Correct Answer: A) False
Rationale: A Caboodle report can contain multiple conformed dimensions, allowing for
complex data analysis across various business areas.
Question 2
Which of the following can be populated by more than one package (SSIS)?
A) A single row in a table only.
B) A single table only.
C) A single column in a table only.
D) A single table and a single row in a table.
E) A single package can only populate one table.
Correct Answer: D) A single table and a single row in a table.
Rationale: Multiple packages can contribute data to the same table, and different rows (or
even the same row in certain scenarios) within a table can be populated by different
packages.
Question 3
When would a foreign key column in Caboodle contain a -1?
A) When the foreign key in the source data was present and matched.
B) When the foreign key was not expected to have data.
C) When the data that once populated this row was deleted from the source.
D) When the foreign key in the source data was null and a value was expected.
E) When the foreign key is linked to an inferred row.
Correct Answer: D) When the foreign key in the source data was null and a value was
expected.
Rationale: A -1 in a foreign key column typically indicates an unspecified or null value from
the source system where a valid reference was anticipated.
Question 4
Which tool(s) in the Caboodle console would be used most often by Caboodle report writers?
A) ETL Management and Job Monitor.
B) Data Model Editor and Package Editor.
C) Configuration and Security.
D) Data Dictionary and Data Lineage.
E) Dictionary and the Dictionary editor.
,[Type here]
Correct Answer: E) Dictionary and the Dictionary editor.
Rationale: Report writers frequently use the Dictionary to understand table and column
definitions, and the Dictionary Editor to make sense of the data available for reporting.
Question 5
True or False: Caboodle and Clarity can be used interchangeably?
A) True
B) False
Correct Answer: B) False
Rationale: Caboodle and Clarity serve different purposes; Clarity is the operational
reporting database, while Caboodle is a data warehouse for analytical reporting, making
them non-interchangeable.
Question 6
Which of the following types of columns would you find in a type 1 table?
A) StartDate, EndDate, IsCurrent.
B) PatientDurableKey, PatientKey, IsCurrent.
C) Surrogate key, foreign key, and a combo key.
D) AttributeValue, AttributeName, ValueType.
E) Only a surrogate key.
Correct Answer: C) Surrogate key, foreign key, and a combo key.
Rationale: Type 1 tables (slowly changing dimensions Type 1) update existing records, so
they do not track historical changes with StartDate/EndDate. They typically contain a
surrogate key (primary key), foreign keys to link to other tables, and often a combo key to
identify the natural key from the source.
Question 7
Where does Epic data in Caboodle come from?
A) Directly from Chronicles.
B) Directly from Epic's Hyperspace.
C) From external non-Epic systems.
D) From Clarity, which gets its data from Chronicles.
E) From SlicerDicer.
Correct Answer: D) From Clarity, which gets its data from Chronicles.
Rationale: Caboodle extracts Epic data from Clarity, which is Epic's reporting database
populated from the transactional Chronicles database.
Question 8
True or false: Only Epic can define SSIS packages to move data from Clarity to Caboodle?
A) True
B) False
Correct Answer: B) False
,[Type here]
Rationale: Caboodle developers within an organization can also define SSIS packages to
move custom or additional data from Clarity (or other sources) to Caboodle.
Question 9
Caboodle is designed to...
A) Only store Epic data for transactional purposes.
B) Exclusively make real-time operational reporting easy.
C) Only provide data for direct clinical care.
D) Store Epic data, store non-Epic data, make reporting easy, and interoperate with
SlicerDicer.
E) Primarily optimize data entry speeds.
Correct Answer: D) Store Epic data, store non-Epic data, make reporting easy, and
interoperate with SlicerDicer.
Rationale: Caboodle is a comprehensive data warehouse, integrating both Epic and non-
Epic data for analytical reporting, and is a key backend for SlicerDicer.
Question 10
True or False: Caboodle is considered a normalized database.
A) True
B) False
Correct Answer: B) False
Rationale: Caboodle is designed as a dimensional data model (star schema) for ease of
reporting and analytical queries, which is denormalized compared to a transactional
normalized database.
Question 11
Name three documentation resources for Caboodle.
A) Caboodle Management Guide, Epic Community, Training Handouts.
B) Caboodle Data Flow Diagrams, SQL Server Management Studio, SSIS Package
Documentation.
C) Caboodle Configuration Guide, Job Monitor Logs, ETL Process Maps.
D) Caboodle dictionary, Reporting with Caboodle document, Caboodle ER diagram.
E) Caboodle Developer Guide, Release Notes, Forum Discussions.
Correct Answer: D) Caboodle dictionary, Reporting with Caboodle document, Caboodle ER
diagram.
Rationale: These are standard documentation resources provided for understanding and
working with the Caboodle data model.
Question 12
When writing reports, why is it better to use your organization's Caboodle console rather than the
console used in training?
A) The training console is often outdated.
, [Type here]
B) The training console has limited data.
C) Because the console can be highly customized for your organization.
D) The training console is slower.
E) The training console lacks security features.
Correct Answer: C) Because the console can be highly customized for your organization.
Rationale: Each organization's Caboodle instance is tailored with specific customizations,
including added tables, columns, and modified ETL processes, making their console the
accurate reflection of their data.
Question 13
What are the differences between a normalized and dimensional data model?
A) Normalized focuses on ease of reporting; dimensional on repeating data.
B) Normalized uses star schema; dimensional avoids it.
C) In a normalized data model, the focus is on not repeating data. In a dimensional data
model, the focus is on ease of reporting, and uses the star schema which focuses on a central
fact table.
D) Normalized is for analytical queries; dimensional is for transactional systems.
E) Normalized is always denormalized; dimensional is always normalized.
Correct Answer: C) In a normalized data model, the focus is on not repeating data. In a
dimensional data model, the focus is on ease of reporting, and uses the star schema which
focuses on a central fact table.
Rationale: This accurately captures the core distinction: normalized for transactional
integrity (no redundancy), dimensional for query performance (denormalized, star
schema).
Question 14
True or False: A new version of Caboodle is released every month.
A) True
B) False
Correct Answer: B) False
Rationale: Caboodle versions are released less frequently, typically aligning with Epic's
major releases. The text states "released every four to six months."
Question 15
Explain the role of the Caboodle report writer.
A) Designs custom Data Model Components.
B) Manages and monitors the ETL process.
C) Creates SSIS packages.
D) Queries data that already exists in the database.
E) Designs the overall data warehouse architecture.
Correct Answer: D) Queries data that already exists in the database.
