CDW110V CABOODLE DATA MODEL FUNDAMENTALS EXAM QUESTIONS & ANSWERS

CDW110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM QUESTIONS &
ANSWERS


Caboodle9 Dictionary9 -9 (CORRECT9 ANSWER)-
b b b b




Basic9 metadata9 for9 tables.9 Find9 Descriptions9 of9 tables9 and9 columns9 available9 in9 dat
b b b b b b b b b b b b




a9 model.9 Identify9 tables9 that9 can9 be9 linked9 together.
b b b b b b b b




Caboodle9 Dictionary9 Editor9 -9 (CORRECT9 ANSWER)-
b b b b b




In9 depth9 view9 of9 Caboodle9 ETL9 packages9 and9 data9 lineage.9 Shows9 Clarity9 tables9 da
b b b b b b b b b b b b b




ta9 that9 extracted9 from9 when9 populating9 tables,9 which9 ETL9 packages9 are9 used9 by9 C
b b b b b b b b b b b b b




aboodle9 tables9 and9 dependencies9 amongst9 the9 tables9 in9 Caboodle.
b b b b b b b b




Caboodle9 Executions9 -9 (CORRECT9 ANSWER)-
b b b b




Where9 Caboodle9 administrators9 can9 create,9 edit,9 run9 and9 monitor9 executions.9 Can9
b b b b b b b b b b b




be9 used9 to9 schedule9 recurring9 executions.
b b b b b




Caboodle9 Workqueues9 -9 (CORRECT9 ANSWER)-
b b b b




Logs9 the9 different9 types9 of9 issues9 that9 can9 occur9 during9 the9 ETL9 process9 that9 req
b b b b b b b b b b b b b b




uire9 manual9 intervention9 to9 resolve.
b b b b




Caboodle9 configurations9 -9 (CORRECT9 ANSWER)-
b b b b




modify9 settings,9 perform9 customizations9 such9 as9 adding9 attributes9 to9 the9 data9 mod
b b b b b b b b b b b




el9 and9 view9 reports9 related9 to9 Caboodle9 configuration9 and9 operation.
b b b b b b b b b

, Caboodle9 BI9 Developers9 -9 (CORRECT9 ANSWER)- b b b b b




write9 Caboodle9 reports9 and9 should9 have9 access9 to9 the9 Caboodle9 Dictionary9 on9 the9
b b b b b b b b b b b b




Console.9 Dictionary9 provides9 table9 descriptions,9 data9 lineage9 for9 tables9 and9 column
b b b b b b b b b b b




s9 and9 foreign9 key9 information.9 BI9 Developers9 should9 be9 familiar9 with9 Caboodles9 di
b b b b b b b b b b b b




mensional9 data9 model9 and9 at9 least9 one9 area9 of9 healthcare9 reportings9 such9 as9 reve
b b b b b b b b b b b b b




nue9 or9 clinical9 reporting.
b b b




Caboodle9 Administrators9 -9 (CORRECT9 ANSWER)- b b b b




have9 access9 to9 all9 activities9 on9 the9 Caboodle9 Console.9 Administrators9 monitor9 exec
b b b b b b b b b b b




utions,9 troubleshoot9 work9 queue9 errors9 and9 establish9 system9 level9 configurations.
b b b b b b b b b




Caboodle9 ETL9 Developers9 -9 (CORRECT9 ANSWER)-b b b b b




create9 custom9 EPIC9 and9 n9 on9 Epic9 content9 for9 extraction9 into9 the9 data9 warehouse,
b b b b b b b b b b b b b




9bdocument9btheir9bwork9bin9bthe9bdictionary9beditor9band9btest9btheir9bwork9busing9bthe9bETL9b

tools9 available9 in9 the9 console.9 Custom9 development9 notes9 and9 documentation9 relev
b b b b b b b b b b




ant9 to9 report9 writers9 will9 be9 visible9 in9 the9 dictionary.
b b b b b b b b b




Why9 use9 Caboodle9 -9 (CORRECT9 ANSWER)-
b b b b b




Accessibility,9 Efficiency9 and9 fewer9 tables9 and9 simpler9 joins.
b b b b b b b




SSIS9 package9 -9 (CORRECT9 ANSWER)-
b b b b




SQL9 Server9 Integration9 packages9 :9 Data9 is9 extracted9 from9 source9 systems9 (Clarity)9
b b b b b b b b b b b b




transformed9 in9 the9 staging9 database9 and9 presented9 for9 users9 in9 the9 reporting9 data
b b b b b b b b b b b b




base.


DMCs9 -9 (CORRECT9 ANSWER)-Data9 Model9 Components
b b b b b




Data9 Model9 Compenents9 -9 (CORRECT9 ANSWER)-
b b b b b




collection9 of9 metadata9 tables9 that9 support9 the9 ETL9 process9 and9 reporting9 views9 st
b b b b b b b b b b b b




ored9 in9 the9 FullAccess9 schema.
b b b b