CDW 110v Caboodle Data Model Q&A (2025/2026) –
100+ Questions Dimensional Modeling, ETL,
Dictionary Use Epic Reporting Tools
SECTION 1: CABOODLE FUNDAMENTALS
# Question 1
Why is Caboodle used for reporting?
A) It stores data in a normalized format for efficient transactions.
B) It provides accessibility, efficiency, and fewer tables with simpler joins.
C) It replaces the need for any other reporting tools.
D) It only stores data for a single Epic module.
Correct Answer: B
Rationale: Caboodle is designed as a dimensional data warehouse that simplifies
reporting by using fewer tables with simpler join paths compared to transactional
systems like Clarity.
# Question 2
Which schema should be your default when reporting in Caboodle?
A) dbo
1
,B) FullAccess
C) Staging
D) Chronicles
Correct Answer: B
Rationale: The FullAccess schema houses views that simplify reporting. It contains
almost everything in the dbo schema plus additional columns, making it the
preferred schema for report writers.
SECTION 2: CABOODLE CONSOLE & DICTIONARY
# Question 3
What is the Caboodle Dictionary?
A) A tool for scheduling ETL executions
B) Basic metadata for tables, providing descriptions of tables and columns
available in the data model
C) A reporting dashboard for end users
D) A source database for transactions
Correct Answer: B
2
, Rationale: The Caboodle Dictionary provides descriptions of tables and columns
and helps identify which tables can be linked together through foreign key
relationships.
# Question 4
Which Caboodle Console tool provides an in-depth view of ETL packages and data
lineage?
A) Caboodle Executions
B) Caboodle Workqueues
C) Caboodle Dictionary Editor
D) Caboodle Configurations
Correct Answer: C
Rationale: The Dictionary Editor shows which Clarity tables are extracted, which
ETL packages populate Caboodle tables, and dependencies among tables.
# Question 5
What is the purpose of Caboodle Workqueues?
A) To schedule recurring data extracts
B) To log issues that occur during the ETL process requiring manual intervention
C) To modify system settings
3
100+ Questions Dimensional Modeling, ETL,
Dictionary Use Epic Reporting Tools
SECTION 1: CABOODLE FUNDAMENTALS
# Question 1
Why is Caboodle used for reporting?
A) It stores data in a normalized format for efficient transactions.
B) It provides accessibility, efficiency, and fewer tables with simpler joins.
C) It replaces the need for any other reporting tools.
D) It only stores data for a single Epic module.
Correct Answer: B
Rationale: Caboodle is designed as a dimensional data warehouse that simplifies
reporting by using fewer tables with simpler join paths compared to transactional
systems like Clarity.
# Question 2
Which schema should be your default when reporting in Caboodle?
A) dbo
1
,B) FullAccess
C) Staging
D) Chronicles
Correct Answer: B
Rationale: The FullAccess schema houses views that simplify reporting. It contains
almost everything in the dbo schema plus additional columns, making it the
preferred schema for report writers.
SECTION 2: CABOODLE CONSOLE & DICTIONARY
# Question 3
What is the Caboodle Dictionary?
A) A tool for scheduling ETL executions
B) Basic metadata for tables, providing descriptions of tables and columns
available in the data model
C) A reporting dashboard for end users
D) A source database for transactions
Correct Answer: B
2
, Rationale: The Caboodle Dictionary provides descriptions of tables and columns
and helps identify which tables can be linked together through foreign key
relationships.
# Question 4
Which Caboodle Console tool provides an in-depth view of ETL packages and data
lineage?
A) Caboodle Executions
B) Caboodle Workqueues
C) Caboodle Dictionary Editor
D) Caboodle Configurations
Correct Answer: C
Rationale: The Dictionary Editor shows which Clarity tables are extracted, which
ETL packages populate Caboodle tables, and dependencies among tables.
# Question 5
What is the purpose of Caboodle Workqueues?
A) To schedule recurring data extracts
B) To log issues that occur during the ETL process requiring manual intervention
C) To modify system settings
3
