CDW110V CABOODLE DAT A

• | Page

CDW110V CABOODLE DAT A

MODEL FUNDAMENTALS E XAM

WITH 100% CORRECT AN SWERS

Question 1: 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.

Question 2: Explain the relationship between the dbo and

FullAccess schemas.

CORRECT ANSWER: The Cogito Dictionary reflects the

dbo schema. The FullAccess schema contains almost everything in the dbo schema (minus a few metadata columns) plus additional columns in some tables. Since FullAccess has more data, report writers should use it when writing queries. However, report writers should also be familiar with dbo due to its relationship with the Cogito Dictionary.

• | Page

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

CORRECT ANSWER: False. A column can be both a

primary key (the column(s) used to uniquely identify a row) and a surrogate key (a key created during ETL that does not exist in the source database). In Caboodle, primary key columns are also surrogate keys.

Question 4: True or False: Naming conventions are enforced in Caboodle.

CORRECT ANSWER: True. Naming conventions, such

as Fact, are enforced in Caboodle.

Question 5: Identify the Caboodle table and column for

the following data point: The Primary Key of

AllergyFact.

CORRECT ANSWER: AllergyFact.AllergyKey

Question 6: Identify the Caboodle table and column for

the following data point: Allergy Status (LPL 3030).

CORRECT ANSWER: AllergyFact.Status

• | Page

Question 7: Identify the Caboodle table and column for

the following data point: Allergy Severity (ECT 7150).

CORRECT ANSWER: AllergyFact.Severity

Question 8: Identify the Caboodle table and column for

the following data point: Allergen's Epic ID (ELG .1).

CORRECT ANSWER: AllergenDim.AllergenEpicId

Question 9: Identify the Caboodle table and column for

the following data point: Allergen's Name (ELG .2).

CORRECT ANSWER: AllergenDim.Name

Question 10: Identify the Caboodle table and column for

the following data point: First Reaction (LPL 3008).

CORRECT ANSWER: AllergyFact.FirstReaction

Question 11: Identify the Caboodle table for the following

SlicerDicer data model: The Visits Data Model.

CORRECT ANSWER: VisitFact

• | Page

Question 12: Identify the Caboodle table for the following

SlicerDicer data model: The AP Claims Data Model.

CORRECT ANSWER: ReceivedClaimFact

Question 13: Identify the Caboodle table for the following

SlicerDicer data model: The Imaging Studies Data Model.

CORRECT ANSWER: ImagingFact

Question 14: Identify the Caboodle table for the following

SlicerDicer data model: The Patient Transports Data

Model.

CORRECT ANSWER: LogisticsRequestJobFact

Question 15: You are writing a report in Caboodle about

surgeries. A colleague on the OpTime team tells you that the patient is stored in I ORC 50. What is the best way to determine which Caboodle table and column extracts this data?