CDW 110v Caboodle Data Model
Fundamentals – Complete Q&A
Welcome to this comprehensive CDW 110v Caboodle Data Model
Fundamentals study guide. This document contains practice questions
and answers covering Caboodle architecture, dimensional modeling, ETL
processes, the Caboodle Dictionary, schema structures, keys, lineage, and
reporting best practices.
Section 1: Caboodle Basics & Architecture (Questions
1-30)
Question 1
What is Caboodle in its simplest sense?
A. A transactional database
B. A data warehouse
C. A reporting dashboard
D. An ETL tool
*Correct Answer: B. *
Rationale: Caboodle in its simplest sense is a data warehouse, designed to
store Epic and non-Epic data. It is a relational database made up of tables
and columns that can be queried using SQL.
,Question 2
Caboodle is part of which Epic suite?
A. Epic Chronicles
B. Epic's Cogito ergo sum Enterprise Intelligence suite
C. Epic Clarity
D. Epic Hyperspace
*Correct Answer: B. *
Rationale: Caboodle is one reporting tool in Epic's Cogito ergo sum
Enterprise Intelligence suite.
Question 3
Which of the following is NOT a component of Caboodle?
A. The ETL process that moves data into the data warehouse
B. The infrastructure and tools for managing and monitoring the system
C. The Chronicles production database
D. The Caboodle Console
*Correct Answer: C. *
Rationale: Caboodle includes the ETL process, the infrastructure and tools for
managing the system, and the Caboodle Console. Chronicles is the
production database, not a component of Caboodle.
Question 4
Caboodle is designed to store:
A. Only Epic data
B. Only non-Epic data
,C. Both Epic and non-Epic data
D. Only clinical data
*Correct Answer: C. *
Rationale: Caboodle is designed to store Epic and non-Epic data in a single,
unified data model that has been designed for efficient reporting.
Question 5
What is Chronicles?
A. Epic's data warehouse
B. Epic's production database
C. Epic's reporting tool
D. Epic's ETL tool
*Correct Answer: B. *
Rationale: Chronicles is Epic's production database. End users enter data into
Chronicles through their daily activities. This database is hierarchical and
requires its own reporting tools.
Question 6
What is Clarity?
A. Epic's production database
B. The relational database that extracts data from Chronicles via ETL
C. Epic's data warehouse
D. Epic's reporting dashboard
*Correct Answer: B. *
, Rationale: Clarity extracts data from the Chronicles database through a
standard ETL process. After transformation, the data is stored in a relational
database on a separate server.
Question 7
Where does Epic data in Caboodle come from?
A. Directly from Chronicles
B. From Clarity, which gets its data from Chronicles
C. From the Caboodle Console
D. From SlicerDicer
*Correct Answer: B. *
Rationale: Epic data in Caboodle comes from Clarity, which gets its data
from Chronicles.
Question 8
True or False: Caboodle and Clarity can be used interchangeably.
A. True
B. False
*Correct Answer: B. *
Rationale: Caboodle and Clarity cannot be used interchangeably. They serve
different purposes in the Epic data ecosystem.
Fundamentals – Complete Q&A
Welcome to this comprehensive CDW 110v Caboodle Data Model
Fundamentals study guide. This document contains practice questions
and answers covering Caboodle architecture, dimensional modeling, ETL
processes, the Caboodle Dictionary, schema structures, keys, lineage, and
reporting best practices.
Section 1: Caboodle Basics & Architecture (Questions
1-30)
Question 1
What is Caboodle in its simplest sense?
A. A transactional database
B. A data warehouse
C. A reporting dashboard
D. An ETL tool
*Correct Answer: B. *
Rationale: Caboodle in its simplest sense is a data warehouse, designed to
store Epic and non-Epic data. It is a relational database made up of tables
and columns that can be queried using SQL.
,Question 2
Caboodle is part of which Epic suite?
A. Epic Chronicles
B. Epic's Cogito ergo sum Enterprise Intelligence suite
C. Epic Clarity
D. Epic Hyperspace
*Correct Answer: B. *
Rationale: Caboodle is one reporting tool in Epic's Cogito ergo sum
Enterprise Intelligence suite.
Question 3
Which of the following is NOT a component of Caboodle?
A. The ETL process that moves data into the data warehouse
B. The infrastructure and tools for managing and monitoring the system
C. The Chronicles production database
D. The Caboodle Console
*Correct Answer: C. *
Rationale: Caboodle includes the ETL process, the infrastructure and tools for
managing the system, and the Caboodle Console. Chronicles is the
production database, not a component of Caboodle.
Question 4
Caboodle is designed to store:
A. Only Epic data
B. Only non-Epic data
,C. Both Epic and non-Epic data
D. Only clinical data
*Correct Answer: C. *
Rationale: Caboodle is designed to store Epic and non-Epic data in a single,
unified data model that has been designed for efficient reporting.
Question 5
What is Chronicles?
A. Epic's data warehouse
B. Epic's production database
C. Epic's reporting tool
D. Epic's ETL tool
*Correct Answer: B. *
Rationale: Chronicles is Epic's production database. End users enter data into
Chronicles through their daily activities. This database is hierarchical and
requires its own reporting tools.
Question 6
What is Clarity?
A. Epic's production database
B. The relational database that extracts data from Chronicles via ETL
C. Epic's data warehouse
D. Epic's reporting dashboard
*Correct Answer: B. *
, Rationale: Clarity extracts data from the Chronicles database through a
standard ETL process. After transformation, the data is stored in a relational
database on a separate server.
Question 7
Where does Epic data in Caboodle come from?
A. Directly from Chronicles
B. From Clarity, which gets its data from Chronicles
C. From the Caboodle Console
D. From SlicerDicer
*Correct Answer: B. *
Rationale: Epic data in Caboodle comes from Clarity, which gets its data
from Chronicles.
Question 8
True or False: Caboodle and Clarity can be used interchangeably.
A. True
B. False
*Correct Answer: B. *
Rationale: Caboodle and Clarity cannot be used interchangeably. They serve
different purposes in the Epic data ecosystem.
