Caboodle Exam Study Set Correct 100%

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 - ANSWERD. 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. - ANSWERTrue: 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. - ANSWERB.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 - ANSWERB. 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 - ANSWERC. Lookup columns Which of the following types of columns exist in all fact and dimension tables in Caboodle