CDW110v Caboodle Data Model Fundamentals Exam Latest Updated

CDW110v Caboodle Data Model
Fundamentals Exam Latest Updated


What is the relationship between SlicerDicer and Caboodle? - (CORRECT ANSWER)-
c c c c c c c c c c




SlicerDicer is Epic's self-service reporting tool in Hyperspace that dynamically queries
c c c c c c c c c c




c Caboodle data. c




Explain the relationship between the dbo and FullAccess schemas. - (CORRECT ANSWER)-
c c c c c c c c c c c




The Cogito Dictionary reflects the dbo schema. The FullAccess schema contains almost
c c c c c c c c c c c




c everything in the dbo schema (minus a few metadata columns) plus additional columns in
c c c c c c c c c c c c c




c some tables. Since FullAccess has more data, report writers should use it when writing
c c c c c c c c c c c c c




c queries. However, report writers should also be familiar with dbo due to its relationship
c c c c c c c c c c c c c




c with the Cogito Dictionary.
c c c




True or False: A column can either be a primary key or a surrogate key, but not both. -
c c c c c c c c c c c c c c c c c c




c (CORRECT ANSWER)-False. A column can be both a primary key (the column(s) used to
c c c c c c c c c c c c c




c uniquely identify a row) and a surrogate key (a key created during ETL that does not exist
c c c c c c c c c c c c c c c c




c in the source database). In Caboodle, primary key columns are also surrogate keys.
c c c c c c c c c c c c




True or False: Naming conventions are enforced in Caboodle. - (CORRECT ANSWER)-True.
c c c c c c c c c c c




c Naming conventions, such as <name>Fact, are enforced in Caboodle.
c c c c c c c c




Identify the Caboodle table and column for the following data point: The Primary Key of
c c c c c c c c c c c c c c




c AllergyFact - (CORRECT ANSWER)-AllergyFact.AllergyKey
c c c

, Identify the Caboodle table and column for the following data point: Allergy Status (LPL
c c c c c c c c c c c c c




c 3030) - (CORRECT ANSWER)-AllergyFact.Status
c c c




Identify the Caboodle table and column for the following data point: Allergy Severity (ECT
c c c c c c c c c c c c c




c 7150) - (CORRECT ANSWER)-AllergyFact.Severity
c c c




Identify the Caboodle table and column for the following data point: Allergen's Epic ID (ELG
c c c c c c c c c c c c c c




c .1) - (CORRECT ANSWER)-AllergenDim.AllergenEpicId
c c c




Identify the Caboodle table and column for the following data point: Allergen's Name (ELG
c c c c c c c c c c c c c




c .2) - (CORRECT ANSWER)-AllergenDim.Name
c c c




Identify the Caboodle table and column for the following data point: First Reaction (LPL
c c c c c c c c c c c c c




c 3008) - (CORRECT ANSWER)-AllergyFact.FirstReaction
c c c




Identify the Caboodle table for the following SlicerDicer data model: The Visits Data Model
c c c c c c c c c c c c c




c - (CORRECT ANSWER)-VisitFact
c c




Identify the Caboodle table for the following SlicerDicer data model: The AP Claims Data
c c c c c c c c c c c c c




c Model - (CORRECT ANSWER)-ReceivedClaimFact
c c c




Identify the Caboodle table for the following SlicerDicer data model: The Imaging Studies
c c c c c c c c c c c c




c Data Model - (CORRECT ANSWER)-ImagingFact
c c c c




Identify the Caboodle table for the following SlicerDicer data model: The Patient
c c c c c c c c c c c




c Transports Data Model - (CORRECT ANSWER)-LogisticsRequestJobFact
c c c c c




You are writing a report in Caboodle about surgeries. A colleague on the OpTime team tells
c c c c c c c c c c c c c c c




c you that the patient is stored in I ORC 50. What is the best way to determine which
c c c c c c c c c c c c c c c c c




c Caboodle table and column extracts this data? - (CORRECT ANSWER)-Search the Cogito
c c c c c c c c c c c