CLR 110 Exam - Questions With Accurate
Solutions
How to get to Item Information Window? Correct Answer -
CTRL click any editable data entry field in Hyperspace
What does the Item Information Window contain? Correct Answer
- INI and item number, clarity table and column, help text,
additional details that links to the Item Editor
Limitations of CTRL click Correct Answer - Doesn't work for all
data points. Often doesn't work for read only fields
List methods for conducting Chronicles research Correct Answer -
Item Information Window, Record Viewer, Item Editor, Category
List Maintenance
Record viewer input needs Correct Answer - Master file,
record, contact
Record viewer output Correct Answer - INI and item number
How is data displayed different in Chronicles vs Clarity for a
category list? Correct Answer - Chronicles has category value
and name, Clarity only has category value
How is the data extraction different in Caboodle vs Clarity when
there is no value entered in chronicles? Correct Answer -
Caboodle would have -1 or -2, Clarity would just have Null
True or false: primary and foreign keys can be null in Clarity
Correct Answer - False. Foreign keys can be null but primary
cannot
, What is the unique identifier for a record? Correct Answer -
Record ID
What is the unique identifier for a line? Correct Answer - Line
number
True or false: every master file contains CSNs Correct Answer -
False, only some
What level is a CDR unique on? Correct Answer - Record level.
So we also need Record ID to uniquely identify the contact
True or false: views and derived tables are results saved at ETL
Correct Answer - False. That is only true for derived tables,
views just store the query
Item editor shows Correct Answer - Definitions and properties
of a chronicles item. Doesn't show a particular value
Category list in item editor displays how many values? Correct
Answer - 100
Category list maintenance Correct Answer - Displays all values
not just first 100
Release range Correct Answer - Either all customer owned or
all categories. For if customer sets category values or if epic does
No add type Correct Answer - Stores data directly on a record
and is true for all contacts on that record
Response each time Correct Answer - Stores values separately
on each contact
Solutions
How to get to Item Information Window? Correct Answer -
CTRL click any editable data entry field in Hyperspace
What does the Item Information Window contain? Correct Answer
- INI and item number, clarity table and column, help text,
additional details that links to the Item Editor
Limitations of CTRL click Correct Answer - Doesn't work for all
data points. Often doesn't work for read only fields
List methods for conducting Chronicles research Correct Answer -
Item Information Window, Record Viewer, Item Editor, Category
List Maintenance
Record viewer input needs Correct Answer - Master file,
record, contact
Record viewer output Correct Answer - INI and item number
How is data displayed different in Chronicles vs Clarity for a
category list? Correct Answer - Chronicles has category value
and name, Clarity only has category value
How is the data extraction different in Caboodle vs Clarity when
there is no value entered in chronicles? Correct Answer -
Caboodle would have -1 or -2, Clarity would just have Null
True or false: primary and foreign keys can be null in Clarity
Correct Answer - False. Foreign keys can be null but primary
cannot
, What is the unique identifier for a record? Correct Answer -
Record ID
What is the unique identifier for a line? Correct Answer - Line
number
True or false: every master file contains CSNs Correct Answer -
False, only some
What level is a CDR unique on? Correct Answer - Record level.
So we also need Record ID to uniquely identify the contact
True or false: views and derived tables are results saved at ETL
Correct Answer - False. That is only true for derived tables,
views just store the query
Item editor shows Correct Answer - Definitions and properties
of a chronicles item. Doesn't show a particular value
Category list in item editor displays how many values? Correct
Answer - 100
Category list maintenance Correct Answer - Displays all values
not just first 100
Release range Correct Answer - Either all customer owned or
all categories. For if customer sets category values or if epic does
No add type Correct Answer - Stores data directly on a record
and is true for all contacts on that record
Response each time Correct Answer - Stores values separately
on each contact
