CABOODLE EXAM STUDY SET QUESTIONS AND CORRECT ANSWERS
7 views 0 purchase
Course
Caboodle
Institution
Caboodle
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 ...
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Willsmith22. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.