CDW 110V CABOODLE DATA MODEL 2024 ACTUAL
EXAM QUESTION AND CORRECT ANSWERS
VERIFIED ANSWERS ALREADY GRADED A+
RATED
Where to look for identifying information for validation in Caboodle? - ANSWER✔✔EpicId or EpicCsn columns DMC - ANSWER✔✔Data Model Component. Consists of the table, the packages used to populate the table, and underlying metadata tables that assist with ETL Dimension tables - ANSWER✔✔One row for each entity within the set. Examples are ProviderDim, PatientDim Fact tables - ANSWER✔✔One row for each occurrence of some significant, measurable event. Examples are MedicationOrderFact and EncounterFact Bridge tables - ANSWER✔✔For many to many relationships DataMart - ANSWER✔✔Report on data points from several DMCs in one place What does it mean when a DMC name ends with X.? - ANSWER✔✔It's custom made What are some of the pros of Caboodle being a dimensional data model? - ANSWER✔✔Intuitive, quicker to write a report, quicker run times due to fewer tables and joins 1 / 2
What is the downside of Caboodle being a dimensional data model? - ANSWER✔✔More complicated ETL process to maintain Star schema - ANSWER✔✔Fact table surrounded by and linked to dimensions Where is the Caboodle data dictionary found? - ANSWER✔✔Analytics catalog Data dictionary overview section - ANSWER✔✔Description, type of database object, granularity Data dictionary column section - ANSWER✔✔Name, data type, availability in SlicerDicer, links to (lookup columns), chronicles info, description Data dictionary lineage section - ANSWER✔✔Available in expanded column. Contains chronicles INI nd item numbers and how the item can be used in SlicerDicer sessions (FDS records) Data dictionary ER diagram section - ANSWER✔✔Classic star schema for investigating joins. Only for Fact and DataMart. Non join columns can also be listed by clicking the key to expand into full column list Data dictionary dependencies section - ANSWER✔✔Indicates what database objects a table is dependent on. Clarity or caboodle tables and columns Data dictionary queries section - ANSWER✔✔Lists SSIS packages that populate the table and their queries True or false: it is possible for more than one SSIS package and more than one data source to populate a table in caboodle - ANSWER✔✔True Change tracking - ANSWER✔✔A property of a table that informs us how Caboodle will be updated when changes are made to the source databases Change tracking types - ANSWER✔✔1) None, 2) Snapshot Change Tracking How to tell if a table is using snapshot change tracking? - ANSWER✔✔Chip in the overview section of the table Non snapshot table - ANSWER✔✔Reflect the current content of the source data at the time of the most recent extract Non Snapchat table granularity - ANSWER✔✔One row per entity extracted to the table
- / 2