Page | 1
CDW110V CABOODLE DATA MODEL
FUNDAMENTALS 2025/ 2026 BRAND NEW
OFFICIAL QUESTIONS WITH ANSWERS.
1. Dimensional Data - correct answer -Focus is on ease of
reporting and uses the start schema which focuses on a central
fact table pertaining to a reportable event and surrounding
dimension tables providing context for the event.
2. Caboodle report writer - correct answer -Queries data that
already exists in database. Use knowledge of the tools and
source databases to conduct research into the necessary data
points required for a given report.
3. Caboodle Administrator - correct answer -Uses the Caboodle
console to manage and monitor the ETL process. Troubleshoot
ETL errors and handle configuration steps for database.
4. Caboodle Developer - correct answer -Designs custom DMCs
(Data Model Components) and writes SSIS packages to bring
additional data into the warehouse. EPIC or non EPIC data.
, Page | 2
5. What is the relationship between Caboodle and SlicerDicer -
correct answer -SlicerDicer is EPICs self service reporting tool
in Hyperspace that dynamically queries Caboodle data.
6. Caboodle Console - correct answer -A web application housed
on the Caboodle Server. Includes dictionary, dictionary editor,
executions, workqueues and configuration.
7. Data Warehouse - correct answer -A relational database and
can be queried by using SQL.
8. ETL - correct answer -Extract, Transform, Load
9. SSIS Package - correct answer -SQL Server Integration
Services packages. Development team creates package to
extract data to Caboodle from Clarity data and can extract from
3rd party data.
10. Staging database - correct answer -Intermediate storage
area for processing data during ETL. Contains IDLookup tables
CDW110V CABOODLE DATA MODEL
FUNDAMENTALS 2025/ 2026 BRAND NEW
OFFICIAL QUESTIONS WITH ANSWERS.
1. Dimensional Data - correct answer -Focus is on ease of
reporting and uses the start schema which focuses on a central
fact table pertaining to a reportable event and surrounding
dimension tables providing context for the event.
2. Caboodle report writer - correct answer -Queries data that
already exists in database. Use knowledge of the tools and
source databases to conduct research into the necessary data
points required for a given report.
3. Caboodle Administrator - correct answer -Uses the Caboodle
console to manage and monitor the ETL process. Troubleshoot
ETL errors and handle configuration steps for database.
4. Caboodle Developer - correct answer -Designs custom DMCs
(Data Model Components) and writes SSIS packages to bring
additional data into the warehouse. EPIC or non EPIC data.
, Page | 2
5. What is the relationship between Caboodle and SlicerDicer -
correct answer -SlicerDicer is EPICs self service reporting tool
in Hyperspace that dynamically queries Caboodle data.
6. Caboodle Console - correct answer -A web application housed
on the Caboodle Server. Includes dictionary, dictionary editor,
executions, workqueues and configuration.
7. Data Warehouse - correct answer -A relational database and
can be queried by using SQL.
8. ETL - correct answer -Extract, Transform, Load
9. SSIS Package - correct answer -SQL Server Integration
Services packages. Development team creates package to
extract data to Caboodle from Clarity data and can extract from
3rd party data.
10. Staging database - correct answer -Intermediate storage
area for processing data during ETL. Contains IDLookup tables
