CDW110V CABOODLE DATA MODEL
FUNDAMENTALS EXAM 2024 NEWEST 2
VERSIONS 230 QUESTIONS WITH DETAILED
VERIFIED ANSWERS (100% CORRECT)
/ALREADY GRADED A+
VERSION A
What is the relationship between SlicerDicer and Caboodle?
- ....ANSWER...SlicerDicer is Epic's self-service reporting
tool in Hyperspace that dynamically queries Caboodle data.
Explain the relationship between the dbo and FullAccess
schemas. - ....ANSWER...The Cogito Dictionary reflects the
dbo schema. The FullAccess schema contains almost
everything in the dbo schema (minus a few metadata
columns) plus additional columns in some tables. Since
FullAccess has more data, report writers should use it when
writing queries. However, report writers should also be
familiar with dbo due to its relationship with the Cogito
Dictionary.
Suppose you're creating a report using EncounterFact and
ProviderDim that displays the name of each provider for
each encounter. If an encounter's data loads into
EncounterFact, but that provider's data hasn't been extracted
to ProviderDim, what value would appear in
ProviderDim.Name for this encounter? -
....ANSWER...There would be an inferred row in
,ProviderDim, therefore ProviderDim.Name would show
"*Unknown" for the encounter.
A lookup column in Caboodle contains the value -3. What
could this mean? - ....ANSWER...There are two
possibilities: Either the data that once populated this row in
Caboodle has been deleted from the source or this is the row
with -3 as its primary key, for which all lookup columns are
also -3. To know which is true, check the primary key value
for the given row: a non-negative value indicates that this
row represents deleted data in the source.
If a lookup column is null in Clarity, what will appear in the
corresponding column in Caboodle? - ....ANSWER...If the
lookup column was null in the source and the SSIS package
defines the data lineage, then a -1 will appear in Caboodle to
represent an unspecified value. If the look up columns's data
lineage was not defined by the SSIS package that loaded
data for a particular row, then a -2 will appear in Caboodle
to represent a value that is not applicable.
Log into Hyperspace as the Cogito Tools Administrator,
open the Patients data model in SlicerDicer, and click
Troubleshoot. What is the purpose of the WHERE clause in
this data model? - ....ANSWER...The WHERE clause
(WHERE subq.DurableKey > 0) filters out the rows with
negative durable key values from PatientDim. Since these
rows do not represent actual patients, they should not be
included in the total count of patients in the Patients data
model.
,A row in a Caboodle table has a primary key value of -2.
What value will be stored in columns with a data type of
"Date" for this row that are not lookup columns?
A. -2
B. NULL
C. 12/31/1840
D. *Not Applicable - ....ANSWER...b. NULL, For the row
with a primary key of -2, lookup columns will store a value
of -2, string columns will store '*Not Applicable', and all
other data type columns will store NULL.
True or False: All inferred rows in Caboodle have a primary
key of -1. - ....ANSWER...False. Inferred rows in Caboodle
have non-negative primary key values because they
represent an entity that Caboodle has inferred the existence
of. The lookup columns for such rows will be set to -1 until
the Caboodle ETL process updates the data.
You are writing a report in Caboodle about surgeries. A
colleague on the OpTime team tells you that the patient is
stored in I ORC 50. What is the best way to determine
which Caboodle table and column extracts this data? -
....ANSWER...Search the Cogito Dictionary for "ORC 50".
To limit the search results to ONLY Caboodle, search "CB:
ORC 50".
A column in Caboodle does not contain the data you expect
to see. To determine if the issue is within the source data or
the ETL process, you want to investigate the Clarity data.
How can you determine which Clarity column is used to
, populate the Caboodle column? - ....ANSWER...Investigate
the data lineage for the column using the Cogito Dictionary.
How many SSIS packages can populate a single table in
Caboodle.
A. A single SSIS package
B. Multiple SSIS packages all from Clarity
C. Multiple SSIS packages from multiple sources -
....ANSWER...A, B, and C
True or False: The ER Diagram contains information that
cannot be found anywhere else in the Cogito Dictionary? -
....ANSWER...False. The ER Diagram is a visual
representation of information that can be found in the
dictionary
Identify the Caboodle table and column for the following
data point: Encounter's Epic CSN -
....ANSWER...EncounterFact.EncounterEpicCsn
Identify the Caboodle table and column for the following
data point: Type - ....ANSWER...EncounterFact.Type
Identify the Caboodle table and column for the following
data point: Patient's name - ....ANSWER...PatientDim.Name
Identify the Caboodle table and column for the following
data point: The patient's age in years -
....ANSWER...DurationDim.YearsDisplayString
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 Charitywairimu. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $18.49. You're not tied to anything after your purchase.
