Download CDW110V CABOODLE DATA MODEL FUNDAMENTALS EXAM QUESTIONS WITH DETAILED VERIFIED ANSWERS and more Quizzes Computer Science in PDF only on Docsity!
CDW110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM QUESTIONS
WITH DETAILED VERIFIED ANSWERS
ALREADY GRADED A+
"How many SSIS packages can populate a single table in Caboodle. A. A single SSIS package B. Multiple SSIS packages all from Clarity C. Multiple SSIS packages from multiple sources - CORRECT ANSWER=> A, B, and C" "True or False: The ER Diagram contains information that cannot be found anywhere else in the Cogito Dictionary? - CORRECT 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 - CORRECT ANSWER=> EncounterFact.EncounterEpicCsn" "Identify the Caboodle table and column for the following data point: Type - CORRECT ANSWER=> EncounterFact.Type" "Identify the Caboodle table and column for the following data point: Patient's name - CORRECT ANSWER=> PatientDim.Name" "Identify the Caboodle table and column for the following data point: The patient's age in years
- CORRECT ANSWER=> DurationDim.YearsDisplayString" "Identify the Caboodle table and column for the following data point: Provider's name (SER .2) - CORRECT ANSWER=> ProviderDim.Name" "Identify the Caboodle table and column for the following data point: Provider's primary specialty - CORRECT ANSWER=> ProviderDim.PrimarySpecialty"
"Identify the Caboodle table and column for the following data point: The department's name (DEP .2) - CORRECT ANSWER=> DepartmentDim.Name" "Identify the Caboodle table and column for the following data point: The patient's name - CORRECT ANSWER=> PatientDim.Name" "Identify the Caboodle table and column for the following data point: The date of the Encounter
- CORRECT ANSWER=> EncounterFact.Date" "Identify the Caboodle table and column for the following data point: Column used to find Office Visits (I EPT 30) - CORRECT 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) - CORRECT ANSWER=> EncounterFact.DerivedEncounterStatus = 'Complete'" "Identify the Caboodle table and column for the following data point: The patient's MRN - CORRECT ANSWER=> PatientDim.PrimaryMrn" "Identify the Caboodle table and column for the following data point: The patient's name - CORRECT ANSWER=> PatientDim.Name" "Identify the Caboodle table and column for the following data point: Medications that are considered opioids - CORRECT ANSWER=> MedicationDim.Opioid" "True or False: Any change to patient data in Clarity will generate a new row in PatientDim after the next extract. - CORRECT ANSWER=> False. Assuming the data is extracted to Caboodle, only changes to snapshot columns would generate a new row in PatientDim." "What is a durable key? - CORRECT ANSWER=> Snapshot tables have a durable key column which stores the same value for all rows that correspond to the same entity. This allows for accurate grouping and summarizing." "Log into Hyperspace as the Cogito Tools Administrator, open the Patients data model in SlicerDicer, and click Troubleshoot. What table and column is used to generate a count of patients in SlicerDicer? Why would this column be preferable to the primary key? - CORRECT ANSWER=> PatientDim.DurableKey. This column stores exactly one value per patient in PatientDim. Since PatientDim is a snapshot table, the DurableKey provides a more accurate
"Identify the Caboodle table and column for the following data point: Column in the -Fact table to remove deleted data - CORRECT ANSWER=> MedicationOrderFact._IsDeleted = 0" "Identify the Caboodle table and column for the following data point: The Patient's Epic ID - CORRECT ANSWER=> PatientDim.PatientEpicId" "Identify the Caboodle table and column for the following data point: The patient's name - CORRECT ANSWER=> PatientDim.Name" "Identify the Caboodle table and column for the following data point: The patient's zip code - CORRECT ANSWER=> PatientDim.PostalCode" "Identify the Caboodle table and column for the following data point: The patient's phone number - CORRECT ANSWER=> PatientDim.HomePhoneNumber" "Identify the Caboodle table and column for the following data point: The patient's MyChart Status - CORRECT ANSWER=> PatientDim.MyChartStatus" "Identify the Caboodle table and column for the following data point: Column to identify deleted primary care providers - CORRECT ANSWER=> ProviderDim._IsDeleted = 1" "Suppose you're creating a report using EncounterFact and ProviderDim that displays the name of each provider for each encounter. If an encounter's data loads into EncounterFact, but that provider's data hasn't been extracted to ProviderDim, what value would appear in ProviderDim.Name for this encounter? - CORRECT ANSWER=> There would be an inferred row in ProviderDim, therefore ProviderDim.Name would show "*Unknown" for the encounter." "A lookup column in Caboodle contains the value -3. What could this mean? - CORRECT ANSWER=> There are two possibilities: Either the data that once populated this row in Caboodle has been deleted from the source or this is the row with -3 as its primary key, for which all lookup columns are also -3. To know which is true, check the primary key value for the given row: a non-negative value indicates that this row represents deleted data in the source." "If a lookup column is null in Clarity, what will appear in the corresponding column in Caboodle?
- CORRECT ANSWER=> If the lookup column was null in the source and the SSIS package defines the data lineage, then a -1 will appear in Caboodle to represent an unspecified value. If the look up columns's data lineage was not defined by the SSIS package that loaded data for a particular row, then a -2 will appear in Caboodle to represent a value that is not applicable."
"Log into Hyperspace as the Cogito Tools Administrator, open the Patients data model in SlicerDicer, and click Troubleshoot. What is the purpose of the WHERE clause in this data model? - CORRECT ANSWER=> The WHERE clause (WHERE subq.DurableKey > 0) filters out the rows with negative durable key values from PatientDim. Since these rows do not represent actual patients, they should not be included in the total count of patients in the Patients data model." "A row in a Caboodle table has a primary key value of -2. What value will be stored in columns with a data type of "Date" for this row that are not lookup columns? A. - B. NULL C. 12/31/ D. Not Applicable - CORRECT ANSWER=> b. NULL, For the row with a primary key of -2, lookup columns will store a value of -2, string columns will store 'Not Applicable', and all other data type columns will store NULL." "True or False: All inferred rows in Caboodle have a primary key of -1. - CORRECT ANSWER=> False. Inferred rows in Caboodle have non-negative primary key values because they represent an entity that Caboodle has inferred the existence of. The lookup columns for such rows will be set to -1 until the Caboodle ETL process updates the data." "Identify the Caboodle table and column for the following data point: The date the patient arrived at the ED - CORRECT ANSWER=> " "Identify the Caboodle table and column for the following data point: The chief complaints Epic ID - CORRECT ANSWER=> ChiefComplaintBridge.ChiefComplaintEpicId" "Identify the Caboodle table and column for the following data point: The patient's name - CORRECT ANSWER=> PatientDim.Name" "Identify the Caboodle table and column for the following data point: The Encounter's Epic CSN
- CORRECT ANSWER=> EdVisitFact.EncounterEpicCsn" "Identify the Caboodle table and column for the following data point: The patient's Epic ID - CORRECT ANSWER=> PatientDim.PatientEpicId"
"Identify the Caboodle table and column for the following data point: Days as attending - CORRECT ANSWER=> HospitalAdmissionAttributedProviderDataMart.NumberOfDistinctDaysAsInpatientAttending" "Identify the Caboodle table and column for the following data point: Number of Encounters - CORRECT ANSWER=> HospitalAdmissionAttributedProviderDataMart.HospitalAdmissionKey" "Identify the Caboodle table and column for the following data point, INI, and Item #: Administration Date, I LPL 4010 - CORRECT ANSWER=> ImmunizationEventFact.AdministrationDateKey" "Identify the Caboodle table and column for the following data point, INI, and Item #: Immunization Name, I LIM .2 - CORRECT ANSWER=> ImmunizationDim.Name" "Identify the Caboodle table and column for the following data point, INI, and Item #: Patient's Age, none - CORRECT ANSWER=> ImmunizationEventFact.AgeKey" "Identify the Caboodle table and column for the following data point, INI, and Item #: Encounter CSN, I EPT 8 - CORRECT ANSWER=> EncounterFact.EncounterEpicCsn" "Identify the Caboodle table and column for the following data point, INI, and Item #: The immunizations in the VCG grouper, I VCG .1 - CORRECT ANSWER=> ImmunizationSetDim.ValueSetEpicId = '1137225'" "Identify the Caboodle table and column for the following data point: The patient's name - CORRECT ANSWER=> PatientDim.Name" "Identify the Caboodle table and column for the following data point: The patient's Epic ID - CORRECT ANSWER=> PatientDim.PatientEpicId" "Identify the Caboodle table and column for the following data point: The attribute's name (HLX .2) - CORRECT ANSWER=> AttributeDim.Name" "Identify the Caboodle table and column for the following data point: The value for the current diet type - CORRECT ANSWER=> PatientAttributeValueDim.Value"
"What two columns do all bridge tables have? - CORRECT ANSWER=> Every bridge table has a ComboKey to which other tables join and a lookup column used to join to its associated dimension table." "Use the Cogito Dictionary to list 3 examples of DataMart tables. - CORRECT ANSWER=> DiabetesRegistryDataMartX, HospitalReadmissionDataMart, OpioidOrderDataMart... and many others" "Why might a BID choose to use a data mart table when writing a report? - CORRECT ANSWER=> Data mart tables are designed for specific reporting topics. If a report was about opioid orders, the OpioidOrderDataMart consolidates much of the information necessary for a report. Consider researching in Reporting with Caboodle to see Epic released data marts for reporting topics" "What is found in a -SetDim table in Caboodle? - CORRECT ANSWER=> -SetDim tables contain groupers from Chronicles or other sources. Groupers are records from a master file grouped together. Groups of departments can be found in DepartmentSetDim. Groups of immunizations can be found in ImmunizationSetDim." "What is the difference between a MappingFact table and a Bridge table? - CORRECT ANSWER=> Both bridge tables and MappingFact tables are used to map many-to-many relationships. However, Bridge tables use a combo key as part of their definition and always link to a single dimension table while MappingFact tables may link to one or more fact or dimension tables." "True or False. Researching Caboodle should be completed in Hyperspace in the Cogito Dictionary portion of the Analytics Catalog. - CORRECT ANSWER=> True" "What schema reflects the contents of the Caboodle portion of the Cogito Dictionary? - CORRECT ANSWER=> The dbo schema" "How does data get into Caboodle? - CORRECT ANSWER=> Data gets into Caboodle through SSIS packages from Clarity or a 3rd party database." "True or False. More than one SSIS package can populate a Caboodle table. - CORRECT ANSWER=> True." "True or False. In Caboodle, primary key columns store Chronicles identifiers, such as a record ID or a CSN. - CORRECT ANSWER=> False. All primary key columns in Caboodle are surrogate keys."
