CDW 110v Caboodle Data Model Fundamentals-Questions with Correct Answers/ Verified
5 views 0 purchase
Course
CDW 110v
Institution
CDW 110v
True or False: A caboodle report may contain at most 1 conformed dimension? - False. A
Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - A single table and a single
row in a table.
When would a foreign key column in Ca...
CDW 110v Caboodle Data Model Fundamentals-Questions with
Correct Answers/ Verified
True or False: A caboodle report may contain at most 1 conformed dimension? - ✔✔False. A
Caboodle report can contain multiple conformed dimensions.
Which of the following can be populated by more than one package? - ✔✔A single table and a single
row in a table.
When would a foreign key column in Caboodle contain a -1? - ✔✔When the foreign key in the
source data was null and a value was expected.
Which tool(s) in the Caboodle console would be used most often by Caboodle report writers? -
✔✔Dictionary and the Dictionary editor.
True or False: Caboodle and Clarity can be used interchangeably? - ✔✔False. Caboodle and Clarity
cannot be used interchangeably.
Which of the following types of columns would you find in a type 1 table? - ✔✔Surrogate key,
foreign key, and a combo key.
Where does Epic data in Caboodle come from? - ✔✔From Clarity, which gets its data from
Chronicles.
True or false: Only Epic can define SSIS packages to move data from Clarity to Caboodle? - ✔✔False.
Caboodle developers can also SSIS packages to move data from Clarity to Caboodle.
Caboodle is designed to... - ✔✔Store Epic data, store non-Epic data, make reporting easy,
interoperate with SlicerDicer.
Caboodle is considered a normalized database. - ✔✔False
Name three documentation resources for Caboodle resources. - ✔✔Caboodle dictionary, Reporting
with Caboodle document, Caboodle ER diagram.
,When writing reports, why is it better to use your organization's Caboodle console rather than the
console used in training? - ✔✔Because the console can be highly customized for your organization.
What are the differences between a normalized and dimensional data model? - ✔✔In a normalized
data model, the focus is on not repeating data. Ina dimensional data model, the focus us on ease of
reporting, and uses the star schema which focuses on a central fact table.
True or False: A new version of Caboodle is released every month. - ✔✔False, released every four to
six months.
Explain the role of the Caboodle report writer. - ✔✔Queries data that already exists in the database.
Explain the role of the Caboodle administrator. - ✔✔Uses the Caboodle console to mange and
monitor the ETL process.
Explain the Caboodle developer role. - ✔✔Designs custom Data Model Components and SSIS
packages to bring additional data into the data warehouse.
True or False: Naming conventions are enforced in Caboodle. - ✔✔True. Naming conventions are
enforced in Caboodle.
What is the relationship between SlicerDicer and Caboodle? - ✔✔SlicerDicer is Epic's self service
reporting tool in Hyperspace that dynamically queries Caboodle data.
What is the surrogate key for MedicationOrderFact? - ✔✔MedicationOrderKey
How are foreign keys documented in the Dictionary? - ✔✔Table that link to or from a given table are
listed under properties, and hyperlinks to the destination table are provided next to foreign key
column descriptions.
True or False: A maximum of one foreign key can exist between two tables in Caboodle. - ✔✔False.
Multiple foreign keys can exist between two tables in Caboodle.
, How can MedicationOrderFact join to PatientDim? - ✔✔MedicationOrderFact.PatientKey =
PatientDim.PatientKey or MedicationOrderFact.PatientDurableKey = PatientDim.PatientDurableKey
In Caboodle, can Fact tables be joined to other fact tables? - ✔✔Yes, example MedicationOrderFact
can join to EncounterFact.
Which of the following would you expect to be stored in a dimension table? - ✔✔Users and
Diagnosis Definitions
Which of the following are possible to do in Caboodle? - ✔✔Joining a fact table to another fact table,
Fact table to dimension table, dimension table to dimension table, 2 different EAV dim table to an
attribute dim table
True or False: Any change to Patient data in Clarity will generate a new row in PatientDim after the
next extract. - ✔✔False, only changes in type 2 data would result in a new row being generated.
True of false: The _Current view tables in the FullAccess schema contains a subset of the rows
contained in their corresponding type 2 tables. - ✔✔True. _Current view tables in the Fullaccess
schema contain a subset of the rows contained in their corresponding type 2 tables.
What is a durable key? - ✔✔Type 2 tables have a durable key column which stores the same value
for all rows that correspond to the same entity. This allows for grouping or summarizing data by the
entity.
If a patient has a PCP assigned, but that providers' data hasn't been extracted to ProviderDim, what
value would appear in ProviderDim.name for this patient? - ✔✔*unknown (an inferred row)
A foreign key column in Caboodle contains the value -3. What could this mean? - ✔✔Either the data
that once populated this row was deleted from the source, or this is the -3 row, for which all foreign
key columns are also -3.
If a foreign key is null in Clarity, what will appear in the corresponding column in Caboodle? - ✔✔If
the foreign key was expected to have data, then a -1 will appear in Caboodle to represent an
unspecified value. If the foreign key was not expected to contain data, then a -2 will appear in the
row to represent a value that is not applicable.
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 MikeHarris. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
