Exam (elaborations)
CDW110 /86 Questions And Answers
- Institution
- CDW110 /86 Questions And Answers
CDW110 /86 Questions And Answers
[Show more]
Content preview
CDW110 /86 Questions And AnswersQuiz :What is Caboodle? - Answer :A data warehouse, designed to store Epic
and non-Epic data in a unified data model for efficient reporting
Quiz :Caboodle staging database - Answer :Data is transformed, checked for
referential integrity, and cleaned
Quiz :Caboodle reporting database - Answer :Comes from the staging
database and is used by caboodle report writers to write reports
Quiz :SSIS Packages - Answer :SQL Server Integration Services. The mechanism
used to move data during the caboodle ETL process
Quiz :True or false: your organization can create custom SSIS packages to
extract Clarity data or additional data sets - Answer :True
Quiz :Schema - Answer :A collection of database objects
Quiz :dbo schema - Answer :Stores reporting data and acts as the data source
for SlicerDicer
Quiz :FullAccess Schema - Answer :Everything for report writers from the dbo
schema and more
Quiz :FilteredAccess Schema - Answer :Similar to FullAccess, but results are
filtered based on user security
Quiz :Which schema should be the default schema for reporting? -
Answer :FullAccess
Quiz :How to see what schema is being used for reports? - Answer :SELECT
SCHEMA_NAME()
Quiz :Which Cogito tools query from Caboodle? - Answer :Mainly SlicerDicer,
but also certain custom Radar metrics and Workbench templates
Quiz :True or false: all tables and columns in Caboodle are written in
PascalCase - Answer :True
, Quiz :True or false: all key columns in Caboodle are surrogate keys -
Answer :True
Quiz :Surrogate key - Answer :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
Quiz :Lookup column - Answer :A column in one table whose value identifies
at least one row in another table. Most tables in Caboodle have at least one
Quiz :Compared to Fact tables, Dimension tables usually contain.. -
Answer :More data and fewer lookup columns
Quiz :True or false: lookup columns end in -Key - Answer :True
Quiz :Where to look for identifying information for validation in Caboodle? -
Answer :EpicId or EpicCsn columns
Quiz :DMC - Answer :Data Model Component. Consists of the table, the
packages used to populate the table, and underlying metadata tables that
assist with ETL
Quiz :Dimension tables - Answer :One row for each entity within the set.
Examples are ProviderDim, PatientDim
Quiz :Fact tables - Answer :One row for each occurrence of some significant,
measurable event. Examples are MedicationOrderFact and EncounterFact
Quiz :Bridge tables - Answer :For many to many relationships
Quiz :DataMart - Answer :Report on data points from several DMCs in one
place
Quiz :What does it mean when a DMC name ends with X.? - Answer :It's
custom made
Quiz :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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller HELLENAH. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £8.15. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now