Exam (elaborations)
CDW110V CABOODLE DATA MODEL FUNDAMENTALS QUESTIONS AND CORRECT ANSWERS A GRADED
- Course
- Institution
CDW110V CABOODLE DATA MODEL FUNDAMENTALS QUESTIONS AND CORRECT ANSWERS A GRADED
[Show more]
Seller
Follow
Content preview
CDW110V CABOODLE DATA MODELFUNDAMENTALS 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
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 $13.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
51662 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 15 years now