CDW110V CABOODLE DATA MODEL FUNDAMENTALS
2024 ACTUAL EXAM QUESTION AND CORRECT
ANSWERS VERIFIED ANSWERS ALREADY GRADED
A+
RATED
How many SSIS packages can populate a single table in Caboodle.
- A single SSIS package
- Multiple SSIS packages all from Clarity
- Multiple SSIS packages from multiple sources - ANSWER✔✔A, B, and C
True or False: The ER Diagram contains information that cannot be found anywhere else in the Cogito Dictionary? - ANSWER✔✔False. The ER Diagram is a visual representation of information that can be found in the dictionary
Identify the Caboodle table and column for the following data point: Encounter's Epic CSN - ANSWER✔✔EncounterFact.EncounterEpicCsn
Identify the Caboodle table and column for the following data point: Type -
ANSWER✔✔EncounterFact.Type
- / 2
Identify the Caboodle table and column for the following data point: Patient's name - ANSWER✔✔PatientDim.Name
Identify the Caboodle table and column for the following data point: The patient's age in years - ANSWER✔✔DurationDim.YearsDisplayString
Identify the Caboodle table and column for the following data point: Provider's name (SER .2) - ANSWER✔✔ProviderDim.Name
Identify the Caboodle table and column for the following data point: Provider's primary specialty - ANSWER✔✔ProviderDim.PrimarySpecialty
Identify the Caboodle table and column for the following data point: The department's name (DEP .2) - ANSWER✔✔DepartmentDim.Name
Identify the Caboodle table and column for the following data point: The patient's name - ANSWER✔✔PatientDim.Name
Identify the Caboodle table and column for the following data point: The date of the Encounter - ANSWER✔✔EncounterFact.Date
Identify the Caboodle table and column for the following data point: Column used to find Office Visits (I EPT 30) - ANSWER✔✔EncounterFact.Type = 'Office Visit'
Identify the Caboodle table and column for the following data point: Column used to identify office visits that have been completed (I EPT 87318) - ANSWER✔✔EncounterFact.DerivedEncounterStatus = 'Complete'
Identify the Caboodle table and column for the following data point: The patient's MRN - ANSWER✔✔PatientDim.PrimaryMrn
- / 2