CABOODLE EXAM STUDY SET
Epic9recommends9using9which9schema9as9the9default9schema9for9report9writing?
9Choose9one9or9all9that9apply.
A.9dbo9schema9on9staging9database
B.9dbo9schema9on9the9reporting9database
C.9Epic9schema9on9either9database
D.9FullAccess9schema9on9the9reporting9database9-9ans--
✔✔D.9FullAccess9schema9on9the9reporting9database
T/
F:9If9a9data9point9exists9in9Clarity,9but9not9in9Caboodle,9your9organization's9Caboodle9
Developers9can9create9a9custom9SSIS9package9to9extract9the9data9point9to9Caboodle.
9-9ans--✔✔True:9Caboodle9is9customizable.
How9can9you9tell9if9a9column9is9a9lookup9column9in9Caboodle?9Choose9all9that9apply.
A.9The9column9is9marked9as9snapshot
B.9The9ER9diagram9lists9the9column9and9what9table9it9joins9to.
C.9The9column9is9contained9in9a9fact9table.
D.9The9column9will9end9in9Key9but9not9be9the9primary9key9of9the9table.9-9ans--
✔✔B.T9he9ER9diagram9lists9the9column9and9what9table9it9joins9to.
D.9The9column9will9end9in9Key9but9not9be9the9primary9key9of9the9table.
Explanation:9Lookup9columns9join9to9other9tables9and9are9easily9spotted9in9Caboodle'
s9documentation.
In9the9query9section,9which9type9of9packages9will9be9loading9Epic9data?
9Choose9one9answer.9
A.9Chronicles9Package
B.9Clarity9Packages
C.9PublishedValueSet9Packages
D.9All9of9the9above9-9ans--✔✔B.9Clarity9Packages
EX:9All9Epic9data9in9Caboodle9has9a9source9of9Clarity.
Fact9tables9generally9have9more9_______9than9dimension9tables9have.9Choose9one9a
nswer.9
A.9Primary9key9columns
B.9Durable9key9columns
C.9Lookup9columns
Epic9recommends9using9which9schema9as9the9default9schema9for9report9writing?
9Choose9one9or9all9that9apply.
A.9dbo9schema9on9staging9database
B.9dbo9schema9on9the9reporting9database
C.9Epic9schema9on9either9database
D.9FullAccess9schema9on9the9reporting9database9-9ans--
✔✔D.9FullAccess9schema9on9the9reporting9database
T/
F:9If9a9data9point9exists9in9Clarity,9but9not9in9Caboodle,9your9organization's9Caboodle9
Developers9can9create9a9custom9SSIS9package9to9extract9the9data9point9to9Caboodle.
9-9ans--✔✔True:9Caboodle9is9customizable.
How9can9you9tell9if9a9column9is9a9lookup9column9in9Caboodle?9Choose9all9that9apply.
A.9The9column9is9marked9as9snapshot
B.9The9ER9diagram9lists9the9column9and9what9table9it9joins9to.
C.9The9column9is9contained9in9a9fact9table.
D.9The9column9will9end9in9Key9but9not9be9the9primary9key9of9the9table.9-9ans--
✔✔B.T9he9ER9diagram9lists9the9column9and9what9table9it9joins9to.
D.9The9column9will9end9in9Key9but9not9be9the9primary9key9of9the9table.
Explanation:9Lookup9columns9join9to9other9tables9and9are9easily9spotted9in9Caboodle'
s9documentation.
In9the9query9section,9which9type9of9packages9will9be9loading9Epic9data?
9Choose9one9answer.9
A.9Chronicles9Package
B.9Clarity9Packages
C.9PublishedValueSet9Packages
D.9All9of9the9above9-9ans--✔✔B.9Clarity9Packages
EX:9All9Epic9data9in9Caboodle9has9a9source9of9Clarity.
Fact9tables9generally9have9more9_______9than9dimension9tables9have.9Choose9one9a
nswer.9
A.9Primary9key9columns
B.9Durable9key9columns
C.9Lookup9columns