CDW 110v Caboodle Data Model
Fundamentals Exam with Questions and
Correct Answers 2025
True ,or ,False: ,A ,caboodle ,report ,may ,contain ,at ,most ,1 ,conformed ,dimension?
,- ,CORRECT ,ANSWER-False. ,A ,Caboodle ,report ,can ,contain ,multiple ,conformed
,dimensions.
Which ,of ,the ,following ,can ,be ,populated ,by ,more ,than ,one ,package? ,-
,CORRECT ,ANSWER-A ,single ,table ,and ,a ,single ,row ,in ,a ,table.
When ,would ,a ,foreign ,key ,column ,in ,Caboodle ,contain ,a ,-1? ,- ,CORRECT
,ANSWER-When ,the ,foreign ,key ,in ,the ,source ,data ,was ,null ,and ,a ,value ,was
,expected.
Which ,tool(s) ,in ,the ,Caboodle ,console ,would ,be ,used ,most ,often ,by ,Caboodle
,report ,writers? ,- ,CORRECT ,ANSWER-Dictionary ,and ,the ,Dictionary ,editor.
True ,or ,False: ,Caboodle ,and ,Clarity ,can ,be ,used ,interchangeably? ,- ,CORRECT
,ANSWER-False. ,Caboodle ,and ,Clarity ,cannot ,be ,used ,interchangeably.
Which ,of ,the ,following ,types ,of ,columns ,would ,you ,find ,in ,a ,type ,1 ,table? ,-
,CORRECT ,ANSWER-Surrogate ,key, ,foreign ,key, ,and ,a ,combo ,key.
Where ,does ,Epic ,data ,in ,Caboodle ,come ,from? ,- ,CORRECT ,ANSWER-From
,Clarity, ,which ,gets ,its ,data ,from ,Chronicles.
True ,or ,false: ,Only ,Epic ,can ,define ,SSIS ,packages ,to ,move ,data ,from ,Clarity ,to
,Caboodle? ,- ,CORRECT ,ANSWER-False. ,Caboodle ,developers ,can ,also ,SSIS
,packages ,to ,move ,data ,from ,Clarity ,to ,Caboodle.
Caboodle ,is ,designed ,to... ,- ,CORRECT ,ANSWER-Store ,Epic ,data, ,store ,non-
Epic ,data, ,make ,reporting ,easy, ,interoperate ,with ,SlicerDicer.
Caboodle ,is ,considered ,a ,normalized ,database. ,- ,CORRECT ,ANSWER-False
Name ,three ,documentation ,resources ,for ,Caboodle ,resources. ,- ,CORRECT
,ANSWER-Caboodle ,dictionary, ,Reporting ,with ,Caboodle ,document, ,Caboodle
,ER ,diagram.
, When ,writing ,reports, ,why ,is ,it ,better ,to ,use ,your ,organization's ,Caboodle
,console ,rather ,than ,the ,console ,used ,in ,training? ,- ,CORRECT ,ANSWER-
Because ,the ,console ,can ,be ,highly ,customized ,for ,your ,organization.
What ,are ,the ,differences ,between ,a ,normalized ,and ,dimensional ,data ,model? ,-
,CORRECT ,ANSWER-In ,a ,normalized ,data ,model, ,the ,focus ,is ,on ,not ,repeating
,data. ,Ina ,dimensional ,data ,model, ,the ,focus ,us ,on ,ease ,of ,reporting, ,and ,uses
,the ,star ,schema ,which ,focuses ,on ,a ,central ,fact ,table.
True ,or ,False: ,A ,new ,version ,of ,Caboodle ,is ,released ,every ,month. ,- ,CORRECT
,ANSWER-False, ,released ,every ,four ,to ,six ,months.
Explain ,the ,role ,of ,the ,Caboodle ,report ,writer. ,- ,CORRECT ,ANSWER-Queries
,data ,that ,already ,exists ,in ,the ,database.
Explain ,the ,role ,of ,the ,Caboodle ,administrator. ,- ,CORRECT ,ANSWER-Uses ,the
,Caboodle ,console ,to ,mange ,and ,monitor ,the ,ETL ,process.
Explain ,the ,Caboodle ,developer ,role. ,- ,CORRECT ,ANSWER-Designs ,custom
,Data ,Model ,Components ,and ,SSIS ,packages ,to ,bring ,additional ,data ,into ,the
,data ,warehouse.
True ,or ,False: ,Naming ,conventions ,are ,enforced ,in ,Caboodle. ,- ,CORRECT
,ANSWER-True. ,Naming ,conventions ,are ,enforced ,in ,Caboodle.
What ,is ,the ,relationship ,between ,SlicerDicer ,and ,Caboodle? ,- ,CORRECT
,ANSWER-SlicerDicer ,is ,Epic's ,self ,service ,reporting ,tool ,in ,Hyperspace ,that
,dynamically ,queries ,Caboodle ,data.
What ,is ,the ,surrogate ,key ,for ,MedicationOrderFact? ,- ,CORRECT ,ANSWER-
MedicationOrderKey
How ,are ,foreign ,keys ,documented ,in ,the ,Dictionary? ,- ,CORRECT ,ANSWER-
Table ,that ,link ,to ,or ,from ,a ,given ,table ,are ,listed ,under ,properties, ,and
,hyperlinks ,to ,the ,destination ,table ,are ,provided ,next ,to ,foreign ,key ,column
,descriptions.
True ,or ,False: ,A ,maximum ,of ,one ,foreign ,key ,can ,exist ,between ,two ,tables ,in
,Caboodle. ,- ,CORRECT ,ANSWER-False. ,Multiple ,foreign ,keys ,can ,exist ,between
,two ,tables ,in ,Caboodle.
How ,can ,MedicationOrderFact ,join ,to ,PatientDim? ,- ,CORRECT ,ANSWER-
MedicationOrderFact.PatientKey ,= ,PatientDim.PatientKey ,or
,MedicationOrderFact.PatientDurableKey ,= ,PatientDim.PatientDurableKey
Fundamentals Exam with Questions and
Correct Answers 2025
True ,or ,False: ,A ,caboodle ,report ,may ,contain ,at ,most ,1 ,conformed ,dimension?
,- ,CORRECT ,ANSWER-False. ,A ,Caboodle ,report ,can ,contain ,multiple ,conformed
,dimensions.
Which ,of ,the ,following ,can ,be ,populated ,by ,more ,than ,one ,package? ,-
,CORRECT ,ANSWER-A ,single ,table ,and ,a ,single ,row ,in ,a ,table.
When ,would ,a ,foreign ,key ,column ,in ,Caboodle ,contain ,a ,-1? ,- ,CORRECT
,ANSWER-When ,the ,foreign ,key ,in ,the ,source ,data ,was ,null ,and ,a ,value ,was
,expected.
Which ,tool(s) ,in ,the ,Caboodle ,console ,would ,be ,used ,most ,often ,by ,Caboodle
,report ,writers? ,- ,CORRECT ,ANSWER-Dictionary ,and ,the ,Dictionary ,editor.
True ,or ,False: ,Caboodle ,and ,Clarity ,can ,be ,used ,interchangeably? ,- ,CORRECT
,ANSWER-False. ,Caboodle ,and ,Clarity ,cannot ,be ,used ,interchangeably.
Which ,of ,the ,following ,types ,of ,columns ,would ,you ,find ,in ,a ,type ,1 ,table? ,-
,CORRECT ,ANSWER-Surrogate ,key, ,foreign ,key, ,and ,a ,combo ,key.
Where ,does ,Epic ,data ,in ,Caboodle ,come ,from? ,- ,CORRECT ,ANSWER-From
,Clarity, ,which ,gets ,its ,data ,from ,Chronicles.
True ,or ,false: ,Only ,Epic ,can ,define ,SSIS ,packages ,to ,move ,data ,from ,Clarity ,to
,Caboodle? ,- ,CORRECT ,ANSWER-False. ,Caboodle ,developers ,can ,also ,SSIS
,packages ,to ,move ,data ,from ,Clarity ,to ,Caboodle.
Caboodle ,is ,designed ,to... ,- ,CORRECT ,ANSWER-Store ,Epic ,data, ,store ,non-
Epic ,data, ,make ,reporting ,easy, ,interoperate ,with ,SlicerDicer.
Caboodle ,is ,considered ,a ,normalized ,database. ,- ,CORRECT ,ANSWER-False
Name ,three ,documentation ,resources ,for ,Caboodle ,resources. ,- ,CORRECT
,ANSWER-Caboodle ,dictionary, ,Reporting ,with ,Caboodle ,document, ,Caboodle
,ER ,diagram.
, When ,writing ,reports, ,why ,is ,it ,better ,to ,use ,your ,organization's ,Caboodle
,console ,rather ,than ,the ,console ,used ,in ,training? ,- ,CORRECT ,ANSWER-
Because ,the ,console ,can ,be ,highly ,customized ,for ,your ,organization.
What ,are ,the ,differences ,between ,a ,normalized ,and ,dimensional ,data ,model? ,-
,CORRECT ,ANSWER-In ,a ,normalized ,data ,model, ,the ,focus ,is ,on ,not ,repeating
,data. ,Ina ,dimensional ,data ,model, ,the ,focus ,us ,on ,ease ,of ,reporting, ,and ,uses
,the ,star ,schema ,which ,focuses ,on ,a ,central ,fact ,table.
True ,or ,False: ,A ,new ,version ,of ,Caboodle ,is ,released ,every ,month. ,- ,CORRECT
,ANSWER-False, ,released ,every ,four ,to ,six ,months.
Explain ,the ,role ,of ,the ,Caboodle ,report ,writer. ,- ,CORRECT ,ANSWER-Queries
,data ,that ,already ,exists ,in ,the ,database.
Explain ,the ,role ,of ,the ,Caboodle ,administrator. ,- ,CORRECT ,ANSWER-Uses ,the
,Caboodle ,console ,to ,mange ,and ,monitor ,the ,ETL ,process.
Explain ,the ,Caboodle ,developer ,role. ,- ,CORRECT ,ANSWER-Designs ,custom
,Data ,Model ,Components ,and ,SSIS ,packages ,to ,bring ,additional ,data ,into ,the
,data ,warehouse.
True ,or ,False: ,Naming ,conventions ,are ,enforced ,in ,Caboodle. ,- ,CORRECT
,ANSWER-True. ,Naming ,conventions ,are ,enforced ,in ,Caboodle.
What ,is ,the ,relationship ,between ,SlicerDicer ,and ,Caboodle? ,- ,CORRECT
,ANSWER-SlicerDicer ,is ,Epic's ,self ,service ,reporting ,tool ,in ,Hyperspace ,that
,dynamically ,queries ,Caboodle ,data.
What ,is ,the ,surrogate ,key ,for ,MedicationOrderFact? ,- ,CORRECT ,ANSWER-
MedicationOrderKey
How ,are ,foreign ,keys ,documented ,in ,the ,Dictionary? ,- ,CORRECT ,ANSWER-
Table ,that ,link ,to ,or ,from ,a ,given ,table ,are ,listed ,under ,properties, ,and
,hyperlinks ,to ,the ,destination ,table ,are ,provided ,next ,to ,foreign ,key ,column
,descriptions.
True ,or ,False: ,A ,maximum ,of ,one ,foreign ,key ,can ,exist ,between ,two ,tables ,in
,Caboodle. ,- ,CORRECT ,ANSWER-False. ,Multiple ,foreign ,keys ,can ,exist ,between
,two ,tables ,in ,Caboodle.
How ,can ,MedicationOrderFact ,join ,to ,PatientDim? ,- ,CORRECT ,ANSWER-
MedicationOrderFact.PatientKey ,= ,PatientDim.PatientKey ,or
,MedicationOrderFact.PatientDurableKey ,= ,PatientDim.PatientDurableKey
