CLR110 Clarity Data Model Exam| Questions, all
Solved 100% Correct with Verified Answers| Latest
Update
What is a response type? - ✔✔An item's Response Type determines how many lines of data
an item can hold. For example, at any one time, a patient has only one date of birth, but she
can have multiple symptoms, or a multi-line address.
Single Response? - ✔✔Only one line of data can be stored per contact.
Multiple Response? - ✔✔Multiple lines of data can be stored per contact.
These lines might be discrete pieces of data, such as multiple symptoms, or they might be
multiple lines of a block of text, such as an address.
Related Group - ✔✔Multiple lines of data can be stored per contact, and each one of these
lines is related to a line in another item.
These lines might refer to a list of relatives' names and their phone numbers.
A lab manager tells you he wants a report on lab specimens, and shows you the field where he
can input various information. What method would you use to find the INI + Item numbers of
the data he's looking for? - ✔✔Ctrl + Click
A clinical administrator requests a query to include data for a patient's registries. She's not sure
of the INI and Item number, but she knows patient is on the Lung Cancer Screening registry.
What tool would you use to find the INI and item number given this information? -
✔✔Record Viewer
In Clarity, which of the following columns COULD contain a Null value?
A.) A foreign key column that would store the patient's primary care provider
,B.) A date column that would store the discharge date for an encounter
C.) A string col.umn that stores a patient's email address
D.) A numeric column that stores the patient's age in years
E.) A column that is the primary key of a table - ✔✔All but E. In Clarity the only column that
CANNOT be NULL is a column in the primary key of a table.
What is the Item Information Window? - ✔✔When you control-left click on a data entry field
in Hyperspace, the Item Information window appears. This window shows the INI and item
number in which this data is stored, along with other information about the item as a whole. If
you click the More >> button, additional item details appear including the add type, response
type, and networked INI if the item is a networked item.
What is Category List Maintenance? - ✔✔Allows you to see all category values in a category
list... Item editor only allows you to see the first 100
What is the three step process to find Clarity tables and columns given a Chronicles sample data
point? - ✔✔1. Find the INI + Item number of the data point to use on the report.
2. Use the INI + Item number to find the appropriate Clarity table and column.
3. Join the Clarity tables togethers using the correct foreign key.
What Clarity Tools may be used as resources for Clarity queries? - ✔✔> Clarity Compass
which is accessed with two activities in Hyperspace
- Column SearchDatabase
- Object Search
> Analytics Catalog
Online resources for Clarity research include:
> Clarity Dictionary
> Report Repository
, What is the Clarity Compass? - ✔✔The Clarity Compass provides organization-specific
information about your Clarity database. The Clarity Compass is used to set the definitions for
how Chronicles items will translate into Clarity. It is used by ETL administrators at your
organization to define the structure of your Clarity tables, and is useful for the business
intelligence developer in order to view the mapping.
What are the two ways to access the Clarity Compass data? (Both in Hyperspace) - ✔✔1.
Column Search
2. Database Object Search
What does Column Search allow you to do? - ✔✔- Search by a Chronicles INI and Item
number, or a Clarity column name
- Brings you to the Columns tab in the Clarity Compass
What does Database Object Search allow you to do? - ✔✔- Search by a table name, or the
name of another database object
- Brings you to the Summary tab in the Clarity Compass
What is shown in the columns tab? - ✔✔Column Name, Chronicles Info, Data Type,
Deprecated?, Replacement Columns, Column Description, Column Notes
Why might you see an empty grid in column search? - ✔✔The column extracts data not
stored in a Chronicles Item, or it extracts calculated data
What data types are used in Chronicles? - ✔✔String, Number, Date, Instant, and Category
What data types convert during ETL? - ✔✔String -> VARCHAR
Number -> NUMERICS
Dates/Times/Instants -> DATETIME
Solved 100% Correct with Verified Answers| Latest
Update
What is a response type? - ✔✔An item's Response Type determines how many lines of data
an item can hold. For example, at any one time, a patient has only one date of birth, but she
can have multiple symptoms, or a multi-line address.
Single Response? - ✔✔Only one line of data can be stored per contact.
Multiple Response? - ✔✔Multiple lines of data can be stored per contact.
These lines might be discrete pieces of data, such as multiple symptoms, or they might be
multiple lines of a block of text, such as an address.
Related Group - ✔✔Multiple lines of data can be stored per contact, and each one of these
lines is related to a line in another item.
These lines might refer to a list of relatives' names and their phone numbers.
A lab manager tells you he wants a report on lab specimens, and shows you the field where he
can input various information. What method would you use to find the INI + Item numbers of
the data he's looking for? - ✔✔Ctrl + Click
A clinical administrator requests a query to include data for a patient's registries. She's not sure
of the INI and Item number, but she knows patient is on the Lung Cancer Screening registry.
What tool would you use to find the INI and item number given this information? -
✔✔Record Viewer
In Clarity, which of the following columns COULD contain a Null value?
A.) A foreign key column that would store the patient's primary care provider
,B.) A date column that would store the discharge date for an encounter
C.) A string col.umn that stores a patient's email address
D.) A numeric column that stores the patient's age in years
E.) A column that is the primary key of a table - ✔✔All but E. In Clarity the only column that
CANNOT be NULL is a column in the primary key of a table.
What is the Item Information Window? - ✔✔When you control-left click on a data entry field
in Hyperspace, the Item Information window appears. This window shows the INI and item
number in which this data is stored, along with other information about the item as a whole. If
you click the More >> button, additional item details appear including the add type, response
type, and networked INI if the item is a networked item.
What is Category List Maintenance? - ✔✔Allows you to see all category values in a category
list... Item editor only allows you to see the first 100
What is the three step process to find Clarity tables and columns given a Chronicles sample data
point? - ✔✔1. Find the INI + Item number of the data point to use on the report.
2. Use the INI + Item number to find the appropriate Clarity table and column.
3. Join the Clarity tables togethers using the correct foreign key.
What Clarity Tools may be used as resources for Clarity queries? - ✔✔> Clarity Compass
which is accessed with two activities in Hyperspace
- Column SearchDatabase
- Object Search
> Analytics Catalog
Online resources for Clarity research include:
> Clarity Dictionary
> Report Repository
, What is the Clarity Compass? - ✔✔The Clarity Compass provides organization-specific
information about your Clarity database. The Clarity Compass is used to set the definitions for
how Chronicles items will translate into Clarity. It is used by ETL administrators at your
organization to define the structure of your Clarity tables, and is useful for the business
intelligence developer in order to view the mapping.
What are the two ways to access the Clarity Compass data? (Both in Hyperspace) - ✔✔1.
Column Search
2. Database Object Search
What does Column Search allow you to do? - ✔✔- Search by a Chronicles INI and Item
number, or a Clarity column name
- Brings you to the Columns tab in the Clarity Compass
What does Database Object Search allow you to do? - ✔✔- Search by a table name, or the
name of another database object
- Brings you to the Summary tab in the Clarity Compass
What is shown in the columns tab? - ✔✔Column Name, Chronicles Info, Data Type,
Deprecated?, Replacement Columns, Column Description, Column Notes
Why might you see an empty grid in column search? - ✔✔The column extracts data not
stored in a Chronicles Item, or it extracts calculated data
What data types are used in Chronicles? - ✔✔String, Number, Date, Instant, and Category
What data types convert during ETL? - ✔✔String -> VARCHAR
Number -> NUMERICS
Dates/Times/Instants -> DATETIME
