CDW110 EXAM ACTUAL EXAM 83 REAL EXAM QUESTIONS AND CORRECT DETAILED ANSWERS WITH RATIONALES (VERIFIED ANSWERS)|ALREADY GRADED A
0 view 0 purchase
Course
CDW110 E
Institution
CDW110 E
CDW110 EXAM ACTUAL EXAM 83 REAL EXAM QUESTIONS AND CORRECT DETAILED ANSWERS WITH RATIONALES (VERIFIED ANSWERS)|ALREADY GRADED A
CDW110 EXAM ACTUAL EXAM 83 REAL EXAM QUESTIONS AND CORRECT DETAILED ANSWERS WITH RATIONALES (VERIFIED ANSWERS)|ALREADY GRADED A
CDW110 EXAM ACTUAL EXAM 83 REAL EXAM...
cdw110 exam 2023 2024 actual exam 83 real exam que
Written for
CDW110 E
All documents for this subject (1)
Seller
Follow
erickarimi
Reviews received
Content preview
What is Caboodle?-ANSWER-A data warehouse, designed to store Epic and non-Epic
data in a unified data model for efficient reporting
Caboodle staging database-ANSWER-Data is transformed, checked for referential
integrity, and cleaned
Caboodle reporting database-ANSWER-Comes from the staging database and is used
by caboodle report writers to write reports
SSIS Packages-ANSWER-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-ANSWER-True
Schema-ANSWER-A collection of database objects
dbo schema-ANSWER-Stores reporting data and acts as the data source for SlicerDicer
FullAccess Schema-ANSWER-Everything for report writers from the dbo schema and
more
FilteredAccess Schema-ANSWER-Similar to FullAccess, but results are filtered based
on user security
Which schema should be the default schema for reporting?-ANSWER-FullAccess
How to see what schema is being used for reports?-ANSWER-SELECT
SCHEMA_NAME()
Which Cogito tools query from Caboodle?-ANSWER-Mainly SlicerDicer, but also certain
custom Radar metrics and Workbench templates
True or false: all tables and columns in Caboodle are written in PascalCase-ANSWER-
True
True or false: all key columns in Caboodle are surrogate keys-ANSWER-True
, 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
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
Compared to Fact tables, Dimension tables usually contain..-ANSWER-More data and
fewer lookup columns
True or false: lookup columns end in -Key-ANSWER-True
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
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
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 or Stuvia-credit 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 erickarimi. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.
