CORRECT Answers
1. What is Caboodle? A dimensional data model for ease of reporting
and data exploration.
1. Data Warehouse
2. An ETL Process
3. A set of Administrative Tools
4. A Development Platform
2. What is the architecture of caboodle? Caboodle includes both staging and a reporting
database. Data is extracted from source systems,
transformed in the staging database, and pre-
sented for users in the reporting database. This
movement of data is realized via a set of SQL
Server Integration Services (SSIS) packages. You
can also customize Caboodle by creating your
own packages.
3. What is included in Caboodle? A standard dimensional data model optimized
for performance, ease of reporting, and collab-
oration between organizations.
Integration of existing Epic data through a stan-
dard ETL process.
Infrastructure for incorporating non-Epic data
into the released data model.
Integrated administration tools for managing
and monitoring the system.
A built-in data dictionary with customization
notes to guide business intelligence developers
, using the data to write reports.
2/7