Caboodle Exam Study Set Questions
with Complete Solutions
Epic recommends using which schema as the default schema for report writing? Choose one or
all that apply.
A. dbo schema on staging database
B. dbo schema on the reporting database
C. Epic schema on either database
D. FullAccess schema on the reporting database - ANSWERS-D. FullAccess schema on the
reporting database
T/F: If a data point exists in Clarity, but not in Caboodle, your organization's Caboodle
Developers can create a custom SSIS package to extract the data point to Caboodle. - ANSWERS-
True: Caboodle is customizable.
How can you tell if a column is a lookup column in Caboodle? Choose all that apply.
A. The column is marked as snapshot
B. The ER diagram lists the column and what table it joins to.
C. The column is contained in a fact table.
D. The column will end in Key but not be the primary key of the table. - ANSWERS-B.T he ER
diagram lists the column and what table it joins to.
D. The column will end in Key but not be the primary key of the table.
Explanation: Lookup columns join to other tables and are easily spotted in Caboodle's
documentation.
In the query section, which type of packages will be loading Epic data? Choose one answer.
A. Chronicles Package
with Complete Solutions
Epic recommends using which schema as the default schema for report writing? Choose one or
all that apply.
A. dbo schema on staging database
B. dbo schema on the reporting database
C. Epic schema on either database
D. FullAccess schema on the reporting database - ANSWERS-D. FullAccess schema on the
reporting database
T/F: If a data point exists in Clarity, but not in Caboodle, your organization's Caboodle
Developers can create a custom SSIS package to extract the data point to Caboodle. - ANSWERS-
True: Caboodle is customizable.
How can you tell if a column is a lookup column in Caboodle? Choose all that apply.
A. The column is marked as snapshot
B. The ER diagram lists the column and what table it joins to.
C. The column is contained in a fact table.
D. The column will end in Key but not be the primary key of the table. - ANSWERS-B.T he ER
diagram lists the column and what table it joins to.
D. The column will end in Key but not be the primary key of the table.
Explanation: Lookup columns join to other tables and are easily spotted in Caboodle's
documentation.
In the query section, which type of packages will be loading Epic data? Choose one answer.
A. Chronicles Package
