CDW110 Exam-with 100% verified solutions-2024-2025.docx, Exams of Nursing

Download CDW110 Exam-with 100% verified solutions-2024-2025.docx and more Exams Nursing in PDF only on Docsity!

CDW110 Exam-with 100% verified solutions-

2024-

What is Caboodle? A data warehouse, designed to store Epic and non-Epic data in a unified data model for efficient reporting Caboodle staging database Data is transformed, checked for referential integrity, and cleaned Caboodle reporting database Comes from the staging database and is used by caboodle report writers to write reports SSIS Packages SQL Server Integration Services. The mechanism used to move data during the caboodle ETL process True or false: your organization can create custom SSIS packages to extract Clarity data or additional data sets True Schema A collection of database objects dbo schema Stores reporting data and acts as the data source for SlicerDicer FullAccess Schema Everything for report writers from the dbo schema and more FilteredAccess Schema Similar to FullAccess, but results are filtered based on user security Which schema should be the default schema for reporting? FullAccess

How to see what schema is being used for reports? SELECT SCHEMA_NAME() Which Cogito tools query from Caboodle? Mainly SlicerDicer, but also certain custom Radar metrics and Workbench templates True or false: all tables and columns in Caboodle are written in PascalCase True True or false: all key columns in Caboodle are surrogate keys True Surrogate key The column's value does not exist in the source database and is created during the ETL process. This is necessary because Caboodle contains both Epic and non-Epic data Lookup column A column in one table whose value identifies at least one row in another table. Most tables in Caboodle have at least one Compared to Fact tables, Dimension tables usually contain.. More data and fewer lookup columns True or false: lookup columns end in - Key True Where to look for identifying information for validation in Caboodle? EpicId or EpicCsn columns DMC Data Model Component. Consists of the table, the packages used to populate the table, and underlying metadata tables that assist with ETL Dimension tables One row for each entity within the set. Examples are ProviderDim, PatientDim

Fact tables One row for each occurrence of some significant, measurable event. Examples are MedicationOrderFact and EncounterFact Bridge tables For many to many relationships DataMart Report on data points from several DMCs in one place What does it mean when a DMC name ends with X.? It's custom made What are some of the pros of Caboodle being a dimensional data model? Intuitive, quicker to write a report, quicker run times due to fewer tables and joins What is the downside of Caboodle being a dimensional data model? More complicated ETL process to maintain Star schema Fact table surrounded by and linked to dimensions Where is the Caboodle data dictionary found? Analytics catalog Data dictionary overview section Description, type of database object, granularity Data dictionary column section Name, data type, availability in SlicerDicer, links to (lookup columns), chronicles info, description Data dictionary lineage section 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 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 Indicates what database objects a table is dependent on. Clarity or caboodle tables and columns Data dictionary queries section 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 True Change tracking A property of a table that informs us how Caboodle will be updated when changes are made to the source databases Change tracking types

1. None, 2) Snapshot Change Tracking How to tell if a table is using snapshot change tracking? Chip in the overview section of the table Non snapshot table Reflect the current content of the source data at the time of the most recent extract Non Snapchat table granularity One row per entity extracted to the table Snapshot table Use change tracking which allows to store but current and historical data Snapshot table granularity One row per entity for a date range

When using snapshot tables, additional filtered is needed to ensure that... Only current data is returned True or false: snapshot data tracks when a specific change took place False What is the granularity of PatientDim? A patient record for a date range What does the DurableKey identify in a table? Unique entities Which columns show the date range for a Snapchat column? StartDate and EndDate What are the default start and end dates? 1/1/1979, 12/31/ True or false: for a given DurableKey value, there is exactly one row where IsCurrent = 1 True What is the correct way to join a snapshot table? Join on DurableKey and filter IsCurrent = 1 True or false: DurableKey only exist in snapshot tables True Referential Integrity Lookup columns will always have a value and that value will find a match in the destination table True or false: due to referential integrity, there are no nulls in Caboodle tables False. Nulls can exist in non-lookup columns

True or false: Caboodle enforces referential integrity in all 3 schemas False, only dbo and FullAccess, not in FilteredAccess What is the lookup value or unspecified values?

What is the lookup value for non-applicable values?

What is the lookup value for deleted values?

How to filter out deleted data from a Fact table? Use the Count column. It stores a 1 when the row should be included in a calculation and a 0 when not What happens to the Durable Key when there is a deletion? It remains the same in the new row What happens string cells when there is a deletion? *Deleted What happens to all other cells when there is a deletion? NULL How can you tell a column is lookup? Ends in -Key True or false: in a Snapshot table, PrimaryKey and DurableKey remain untouched True Inferred row Placeholder rows that are added to the destination table when the lookup column value does not have a match in the destination table

True or false: a Snapchat column will add a row when data gets added to a spot where there was an inferred row False. The row just updates and overwrites existing values How to identify inferred rows in a table? _IsInferred column True or false: there is no difference between left outer join and inner join when joining with lookup column False. This is true for joining FROM a lookup column but not necessarily true when joining TO a lookup column Bridge table This is required to map a many-to-many relationship such as patients and their diagnoses What are the two columns in a bridge table? Key which is the lookup column to link to the dimension table. ComboKey which is the surrogate key that represents a unique combo of key names Data mart Brings together points from several DMCs into one place, serving as a comprehensive data source for a particular reporting need. What are data mart data sources? Caboodle or registries SetDim tables Dimension tables that store lists or sets of records VCG master file Stores groupers, which are lists of Chronicles records, ICD codes, or other concepts frequently used together in Hyperspace and are extracted to SetDim tables True or false: queries with SetDims need to be updates manually when new items are added False. It updates automatically in a future ETL EAV model

Entity attribute value. For cases where attributes change often. AttributeValueDims One form of EAV data in Caboodle. Contain attribute-value pairs AttributeDim Stores the list of all attributes used by the AttributeValueDim system True or false: AttributeValueDim tables are typically snapshot tables. True What are the extra columns in a snapshot table? DurableKey, StartDate, EndDate, IsCurrent True or false: a new row is created when a non Snapshot column is updated in a snapshot table False True or false: rows with negative primary key are filtered out of FilteredAccess schema? True When are inferred rows created? When a table with a lookup column to that table goes through ETL What are the string values in an inferred row? *Unknown What is the lookup value in an inferred row?

True or false: inferred rows are filtered out of FilteredAccess schema? True