CABOODLE EXAM STUDY SET
QUESTIONS AND CORRECT ANSWERS
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 - correct 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. -
correct 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. - correct 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
B. Clarity Packages
C. PublishedValueSet Packages
D. All of the above - correct answers ✔✔ -B. Clarity Packages
EX: All Epic data in Caboodle has a source of Clarity.
Fact tables generally have more _______ than dimension tables have. Choose one
answer.
A. Primary key columns
B. Durable key columns
C. Lookup columns
D. Columns - correct answers ✔✔ -C. Lookup columns
QUESTIONS AND CORRECT ANSWERS
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 - correct 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. -
correct 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. - correct 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
B. Clarity Packages
C. PublishedValueSet Packages
D. All of the above - correct answers ✔✔ -B. Clarity Packages
EX: All Epic data in Caboodle has a source of Clarity.
Fact tables generally have more _______ than dimension tables have. Choose one
answer.
A. Primary key columns
B. Durable key columns
C. Lookup columns
D. Columns - correct answers ✔✔ -C. Lookup columns
