CDW110V CABOODLE DATA MODEL
FUNDAMENTALS QUESTIONS AND
CORRECT ANSWERS A GRADED
Caboodle dDictionary d- d(correct danswer) d-Basic dmetadata dfor dtables. dFind
dDescriptions dof dtables dand dcolumns davailable din ddata dmodel. dIdentify dtables dthat
dcan dbe dlinked dtogether.
Caboodle dDictionary dEditor d- d(correct danswer) d-In ddepth dview dof dCaboodle dETL
dpackages dand ddata dlineage. dShows dClarity dtables ddata dthat dextracted dfrom dwhen
dpopulating dtables, dwhich dETL dpackages dare dused dby dCaboodle dtables dand
ddependencies damongst dthe dtables din dCaboodle.
Caboodle dExecutions d- d(correct danswer) d-Where dCaboodle dadministrators dcan
dcreate, dedit, drun dand dmonitor dexecutions. dCan dbe dused dto dschedule drecurring
dexecutions.
Caboodle dWorkqueues d- d(correct danswer) d-Logs dthe ddifferent dtypes dof dissues dthat
dcan doccur dduring dthe dETL dprocess dthat drequire dmanual dintervention dto dresolve.
Caboodle dconfigurations d- d(correct danswer) d-modify dsettings, dperform
dcustomizations dsuch das dadding dattributes dto dthe ddata dmodel dand dview dreports
drelated dto dCaboodle dconfiguration dand doperation.
Caboodle dBI dDevelopers d- d(correct danswer) d-write dCaboodle dreports dand dshould
dhave daccess dto dthe dCaboodle dDictionary don dthe dConsole. dDictionary dprovides
dtable ddescriptions, ddata dlineage dfor dtables dand dcolumns dand dforeign dkey
dinformation. dBI dDevelopers dshould dbe dfamiliar dwith dCaboodles ddimensional ddata
dmodel dand dat dleast done darea dof dhealthcare dreportings dsuch das drevenue dor
dclinical dreporting.
Caboodle dAdministrators d- d(correct danswer) d-have daccess dto dall dactivities don dthe
dCaboodle dConsole. dAdministrators dmonitor dexecutions, dtroubleshoot dwork dqueue
derrors dand destablish dsystem dlevel dconfigurations.
Caboodle dETL dDevelopers d- d(correct danswer) d-create dcustom dEPIC dand dn don
dEpic dcontent dfor dextraction dinto dthe ddata dwarehouse, ddocument dtheir dwork din dthe
ddictionary deditor dand dtest dtheir dwork dusing dthe dETL dtools davailable din dthe
dconsole. dCustom ddevelopment dnotes dand ddocumentation drelevant dto dreport dwriters
dwill dbe dvisible din dthe ddictionary.
, Why duse dCaboodle d- d(correct danswer) d-Accessibility, dEfficiency dand dfewer dtables
dand dsimpler djoins.
SSIS dpackage d- d(correct danswer) d-SQL dServer dIntegration dpackages d: dData dis
dextracted dfrom dsource dsystems d(Clarity) dtransformed din dthe dstaging ddatabase dand
dpresented dfor dusers din dthe dreporting ddatabase.
DMCs d- d(correct danswer) d-Data dModel dComponents
Data dModel dCompenents d- d(correct danswer) d-collection dof dmetadata dtables dthat
dsupport dthe dETL dprocess dand dreporting dviews dstored din dthe dFullAccess dschema.
DMC dtype dand dsuffixes d- d(correct danswer) d-Each dDMC dgets da dtype dand dsuffix.
dDim dfor ddimensions, dFact dfor dfacts, dBridge dfor dbridges, dDatamart dfor ddata dmarts,
dAttributeValueDim dfor dEAV dtables, dX dfor dcustom dtables
Caboodle dStar dSchema d- d(correct danswer) d-where done dcentral dfact dtable dwill djoin
dto dmany dassociated dlookup dor ddimension dtables.
Dimensional dData dModel d- d(correct danswer) d-This dstructure dintentionally dmakes
dsome dcompromises dto dthe dnormalized ddata dmodel dused dby dClarity din dorder dto
dfacilitate dreport dwriting. dThe dtrade doff dis dthat dit drequires dmore dcomplicated dETL
dprocess dto dmaintain.
Caboodle dconsists dof da dreporting ddatabase dand da dstaging ddatabase d- d(correct
danswer) d-
dbo d- d(correct danswer) d-Staging ddatabase: dimport dtables dand dmapping dtables dlive
dhere. dUsed dby dadministrators dfor dmoving ddata dinto dCaboodle. dReporting
dDatabase: ddbo dschema dstores dreporting ddata dand dacts das dthe ddata dsource dfor
dSlicerDicer. dCaboodle dDictionary dreflects dthe dcontents dof dthe ddbo dschema
EPIC d- d(correct danswer) d-Staging dDatabase: dEpic dschema don dthe dstaging
ddatabase dcontains dthe d_IdLookup dtables, dwhich dmap dsource dIDs dto dsystem-
generated dCaboodle dprimary dkeys din dthe dreporting ddatabase. dReporting dDatabase:
dPrior dto dEpic d2018 dthis dschema dstored dthe dtables dused dby dthe dSlicerDicer
dpatients ddata dmodel.
FullAccess d- d(correct danswer) d-Staging dDatabase: dThe dFullAccess dschema ddoes
dnot dexist don dthe dstaging ddatabase dReporting dDatabase: dThe dFullAccess dschema
dhouses dview dthat dtimplify dreporting. dFullAccess dshould dbe dyour ddefault dschema
dwhen dreporting.
DMC d- d(correct danswer) d-Data dModel dComponents
FUNDAMENTALS QUESTIONS AND
CORRECT ANSWERS A GRADED
Caboodle dDictionary d- d(correct danswer) d-Basic dmetadata dfor dtables. dFind
dDescriptions dof dtables dand dcolumns davailable din ddata dmodel. dIdentify dtables dthat
dcan dbe dlinked dtogether.
Caboodle dDictionary dEditor d- d(correct danswer) d-In ddepth dview dof dCaboodle dETL
dpackages dand ddata dlineage. dShows dClarity dtables ddata dthat dextracted dfrom dwhen
dpopulating dtables, dwhich dETL dpackages dare dused dby dCaboodle dtables dand
ddependencies damongst dthe dtables din dCaboodle.
Caboodle dExecutions d- d(correct danswer) d-Where dCaboodle dadministrators dcan
dcreate, dedit, drun dand dmonitor dexecutions. dCan dbe dused dto dschedule drecurring
dexecutions.
Caboodle dWorkqueues d- d(correct danswer) d-Logs dthe ddifferent dtypes dof dissues dthat
dcan doccur dduring dthe dETL dprocess dthat drequire dmanual dintervention dto dresolve.
Caboodle dconfigurations d- d(correct danswer) d-modify dsettings, dperform
dcustomizations dsuch das dadding dattributes dto dthe ddata dmodel dand dview dreports
drelated dto dCaboodle dconfiguration dand doperation.
Caboodle dBI dDevelopers d- d(correct danswer) d-write dCaboodle dreports dand dshould
dhave daccess dto dthe dCaboodle dDictionary don dthe dConsole. dDictionary dprovides
dtable ddescriptions, ddata dlineage dfor dtables dand dcolumns dand dforeign dkey
dinformation. dBI dDevelopers dshould dbe dfamiliar dwith dCaboodles ddimensional ddata
dmodel dand dat dleast done darea dof dhealthcare dreportings dsuch das drevenue dor
dclinical dreporting.
Caboodle dAdministrators d- d(correct danswer) d-have daccess dto dall dactivities don dthe
dCaboodle dConsole. dAdministrators dmonitor dexecutions, dtroubleshoot dwork dqueue
derrors dand destablish dsystem dlevel dconfigurations.
Caboodle dETL dDevelopers d- d(correct danswer) d-create dcustom dEPIC dand dn don
dEpic dcontent dfor dextraction dinto dthe ddata dwarehouse, ddocument dtheir dwork din dthe
ddictionary deditor dand dtest dtheir dwork dusing dthe dETL dtools davailable din dthe
dconsole. dCustom ddevelopment dnotes dand ddocumentation drelevant dto dreport dwriters
dwill dbe dvisible din dthe ddictionary.
, Why duse dCaboodle d- d(correct danswer) d-Accessibility, dEfficiency dand dfewer dtables
dand dsimpler djoins.
SSIS dpackage d- d(correct danswer) d-SQL dServer dIntegration dpackages d: dData dis
dextracted dfrom dsource dsystems d(Clarity) dtransformed din dthe dstaging ddatabase dand
dpresented dfor dusers din dthe dreporting ddatabase.
DMCs d- d(correct danswer) d-Data dModel dComponents
Data dModel dCompenents d- d(correct danswer) d-collection dof dmetadata dtables dthat
dsupport dthe dETL dprocess dand dreporting dviews dstored din dthe dFullAccess dschema.
DMC dtype dand dsuffixes d- d(correct danswer) d-Each dDMC dgets da dtype dand dsuffix.
dDim dfor ddimensions, dFact dfor dfacts, dBridge dfor dbridges, dDatamart dfor ddata dmarts,
dAttributeValueDim dfor dEAV dtables, dX dfor dcustom dtables
Caboodle dStar dSchema d- d(correct danswer) d-where done dcentral dfact dtable dwill djoin
dto dmany dassociated dlookup dor ddimension dtables.
Dimensional dData dModel d- d(correct danswer) d-This dstructure dintentionally dmakes
dsome dcompromises dto dthe dnormalized ddata dmodel dused dby dClarity din dorder dto
dfacilitate dreport dwriting. dThe dtrade doff dis dthat dit drequires dmore dcomplicated dETL
dprocess dto dmaintain.
Caboodle dconsists dof da dreporting ddatabase dand da dstaging ddatabase d- d(correct
danswer) d-
dbo d- d(correct danswer) d-Staging ddatabase: dimport dtables dand dmapping dtables dlive
dhere. dUsed dby dadministrators dfor dmoving ddata dinto dCaboodle. dReporting
dDatabase: ddbo dschema dstores dreporting ddata dand dacts das dthe ddata dsource dfor
dSlicerDicer. dCaboodle dDictionary dreflects dthe dcontents dof dthe ddbo dschema
EPIC d- d(correct danswer) d-Staging dDatabase: dEpic dschema don dthe dstaging
ddatabase dcontains dthe d_IdLookup dtables, dwhich dmap dsource dIDs dto dsystem-
generated dCaboodle dprimary dkeys din dthe dreporting ddatabase. dReporting dDatabase:
dPrior dto dEpic d2018 dthis dschema dstored dthe dtables dused dby dthe dSlicerDicer
dpatients ddata dmodel.
FullAccess d- d(correct danswer) d-Staging dDatabase: dThe dFullAccess dschema ddoes
dnot dexist don dthe dstaging ddatabase dReporting dDatabase: dThe dFullAccess dschema
dhouses dview dthat dtimplify dreporting. dFullAccess dshould dbe dyour ddefault dschema
dwhen dreporting.
DMC d- d(correct danswer) d-Data dModel dComponents
