CDW110V UPDATED EXAM SCRIPT QUESTIONS AND
ANSWERS GUARANTEE A+
✔✔How do you look up the data lineage of a column? - ✔✔
✔✔How do you identify Epic data in Caboodle? - ✔✔
✔✔How do you identify non-Epic data in Caboodle? - ✔✔
✔✔Explain who uses the Caboodle Console. - ✔✔
✔✔Explain how data is loaded into Caboodle. - ✔✔
✔✔T/F: All changes to the data extracted to PatientDim generate new rows. - ✔✔False
Although PatientDim is a type 2, only certain columns in it are type 2. Changes to the
data stored in type 1 columns do not create new rows. Rather, the existing value is
overwritten across existing rows for a given entity.
✔✔T/F: In the FullAccess schema, joining to a type 2 table always returns the current
values for the entities in the views. - ✔✔False
The FullAccess views contain the historical information, just like the dbo tables do,
unless you join to the _Current views.
✔✔Type 1 Data - ✔✔
✔✔Type 2 Data - ✔✔
✔✔"_Current" View - ✔✔
✔✔StartDate Column - ✔✔
✔✔EndDate Column - ✔✔
✔✔Durable Key - ✔✔
✔✔How do you identify whether changing data will trigger an update to an existing row
or create a new row? - ✔✔
✔✔How do you successfully report with current and/or historical data? - ✔✔
✔✔How do you use durable keys to find the information about an entity and understand
its history? - ✔✔
, ✔✔How do you identify from looking at the data in a table whether the table is type 1 or
type 2? - ✔✔
✔✔Explain foreign key references from Type 2 tables. - ✔✔
✔✔Explain the difference between Type 1 and Type 2 data. - ✔✔
✔✔Explain the difference between Type 1 and Type 2 tables. - ✔✔
✔✔Suppose you are creating a report that displays the name of each patient's current
PCP. If a particular patient's PCP has not been extracted to ProviderDim, how will their
name appear in the report? - ✔✔Since the patient's data references their PCP, an
inferred row would have been created for their PCP in ProviderDim. All strings in
inferred rows (except IdType) are "*Unknown," so that is what would appear for the
provider's name.
✔✔T/F: Inferred rows can only exist for a limited time. - ✔✔False
An inferred row will remain until data for its corresponding entity is extracted.
✔✔If a foreign key is null in Clarity, what will appear in the corresponding column in
Caboodle? - ✔✔If the foreign key was expected to contain 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 Caboodle to
represent a value that is not applicable.
✔✔Define Deleted Rows - ✔✔
✔✔Define Not Applicable Rows - ✔✔
✔✔Define Unspecified Rows - ✔✔
✔✔Define Inferred Rows - ✔✔
✔✔Explain how Caboodle enforces referential integrity. - ✔✔
✔✔Explain how Caboodle handles deleted data. - ✔✔
✔✔Why do profile dimensions have fewer rows than their parent fact tables? - ✔✔A row
in a profile dimension represents a unique combination of values (for example,
VisitProfileDim stores unique combinations of encounter type, visit type, and financial
class). Since combinations aren't repeated, profile dimensions must contain fewer rows
than their parent fact table.
ANSWERS GUARANTEE A+
✔✔How do you look up the data lineage of a column? - ✔✔
✔✔How do you identify Epic data in Caboodle? - ✔✔
✔✔How do you identify non-Epic data in Caboodle? - ✔✔
✔✔Explain who uses the Caboodle Console. - ✔✔
✔✔Explain how data is loaded into Caboodle. - ✔✔
✔✔T/F: All changes to the data extracted to PatientDim generate new rows. - ✔✔False
Although PatientDim is a type 2, only certain columns in it are type 2. Changes to the
data stored in type 1 columns do not create new rows. Rather, the existing value is
overwritten across existing rows for a given entity.
✔✔T/F: In the FullAccess schema, joining to a type 2 table always returns the current
values for the entities in the views. - ✔✔False
The FullAccess views contain the historical information, just like the dbo tables do,
unless you join to the _Current views.
✔✔Type 1 Data - ✔✔
✔✔Type 2 Data - ✔✔
✔✔"_Current" View - ✔✔
✔✔StartDate Column - ✔✔
✔✔EndDate Column - ✔✔
✔✔Durable Key - ✔✔
✔✔How do you identify whether changing data will trigger an update to an existing row
or create a new row? - ✔✔
✔✔How do you successfully report with current and/or historical data? - ✔✔
✔✔How do you use durable keys to find the information about an entity and understand
its history? - ✔✔
, ✔✔How do you identify from looking at the data in a table whether the table is type 1 or
type 2? - ✔✔
✔✔Explain foreign key references from Type 2 tables. - ✔✔
✔✔Explain the difference between Type 1 and Type 2 data. - ✔✔
✔✔Explain the difference between Type 1 and Type 2 tables. - ✔✔
✔✔Suppose you are creating a report that displays the name of each patient's current
PCP. If a particular patient's PCP has not been extracted to ProviderDim, how will their
name appear in the report? - ✔✔Since the patient's data references their PCP, an
inferred row would have been created for their PCP in ProviderDim. All strings in
inferred rows (except IdType) are "*Unknown," so that is what would appear for the
provider's name.
✔✔T/F: Inferred rows can only exist for a limited time. - ✔✔False
An inferred row will remain until data for its corresponding entity is extracted.
✔✔If a foreign key is null in Clarity, what will appear in the corresponding column in
Caboodle? - ✔✔If the foreign key was expected to contain 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 Caboodle to
represent a value that is not applicable.
✔✔Define Deleted Rows - ✔✔
✔✔Define Not Applicable Rows - ✔✔
✔✔Define Unspecified Rows - ✔✔
✔✔Define Inferred Rows - ✔✔
✔✔Explain how Caboodle enforces referential integrity. - ✔✔
✔✔Explain how Caboodle handles deleted data. - ✔✔
✔✔Why do profile dimensions have fewer rows than their parent fact tables? - ✔✔A row
in a profile dimension represents a unique combination of values (for example,
VisitProfileDim stores unique combinations of encounter type, visit type, and financial
class). Since combinations aren't repeated, profile dimensions must contain fewer rows
than their parent fact table.
