CLR 110 Clarity Review UPDATED ACTUAL Questions and CORRECT Answers
In Clarity, which of the following columns In Clarity the only column that CANNOT be NULL is a column in the primary key of a
COULD contain a NULL value table
If a Chronicles item can store one or more values, it is a multiple response item. If the
A Chronicles item can store one or more options come from a limited list, that item may be a category item, where the
options from a limited list. Which of the category list is the list
following could of options, or networked, where the records or contacts in the destination master file
account for this behavior? is the list of
options
A Chronicles item stores a single value but If a Chronicles item can store only one value, it is a single response item. If a
can store a separate value for each contact separate
on a record. value is stored on each contact the add type is Overtime
Which of the following could account for
this behavior?
False. Clarity does not enforce naming conventions, so not all category columns will
True or False: All category columns in join to a lookup
Clarity will join to a Category Lookup table table starting with ZC_. Although many do follow this pattern, you should always
that begins with refer to the
ZC_. Category Lookup Table listed in the Data Dictionary to determine the correct table
for joining.
How would you find the Clarity table and Open analytics catalog, in search enter EPT 18864 and it would list them.
column that extracts EPT 18864: Attending
Provider?
What happens when a column is marked as No more data will be extracted into the column.
Deprecated?
In which of the following scenarios would it You need to use CLARITY_DEP_CUST_FIELDS in a report. You found the table in the
be appropriate, and even necessary, to Data
reach out to Dictionary but cannot query the table on your database
your Clarity ETL administrator?
In Clarity, which of the following columns In Clarity the only column that CANNOT be NULL is a column in the primary key of a
COULD contain a NULL value table
If a Chronicles item can store one or more values, it is a multiple response item. If the
A Chronicles item can store one or more options come from a limited list, that item may be a category item, where the
options from a limited list. Which of the category list is the list
following could of options, or networked, where the records or contacts in the destination master file
account for this behavior? is the list of
options
A Chronicles item stores a single value but If a Chronicles item can store only one value, it is a single response item. If a
can store a separate value for each contact separate
on a record. value is stored on each contact the add type is Overtime
Which of the following could account for
this behavior?
False. Clarity does not enforce naming conventions, so not all category columns will
True or False: All category columns in join to a lookup
Clarity will join to a Category Lookup table table starting with ZC_. Although many do follow this pattern, you should always
that begins with refer to the
ZC_. Category Lookup Table listed in the Data Dictionary to determine the correct table
for joining.
How would you find the Clarity table and Open analytics catalog, in search enter EPT 18864 and it would list them.
column that extracts EPT 18864: Attending
Provider?
What happens when a column is marked as No more data will be extracted into the column.
Deprecated?
In which of the following scenarios would it You need to use CLARITY_DEP_CUST_FIELDS in a report. You found the table in the
be appropriate, and even necessary, to Data
reach out to Dictionary but cannot query the table on your database
your Clarity ETL administrator?
