CLR 110 Exam Questions With Correct
Answers.
How to get to Item Information Window? - AnswerCTRL click any editable data entry field in
Hyperspace
What does the Item Information Window contain? - AnswerINI and item number, clarity table
and column, help text, additional details that links to t...
How to get to Item Information Window? - Answer✔CTRL click any editable data entry field in
Hyperspace
What does the Item Information Window contain? - Answer✔INI and item number, clarity table
and column, help text, additional details that links to the Item Editor
Limitations of CTRL click - Answer✔Doesn't work for all data points. Often doesn't work for
read only fields
List methods for conducting Chronicles research - Answer✔Item Information Window, Record
Viewer, Item Editor, Category List Maintenance
Record viewer input needs - Answer✔Master file, record, contact
Record viewer output - Answer✔INI and item number
How is data displayed different in Chronicles vs Clarity for a category list? -
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? - Answer✔Caboodle would have -1 or -2, Clarity would just have Null
True or false: primary and foreign keys can be null in Clarity - Answer✔False. Foreign keys can
be null but primary cannot
What is the unique identifier for a record? - Answer✔Record ID
What is the unique identifier for a line? - Answer✔Line number
True or false: every master file contains CSNs - Answer✔False, only some
What level is a CDR unique on? - 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 - Answer✔False. That is only
true for derived tables, views just store the query
Item editor shows - Answer✔Definitions and properties of a chronicles item. Doesn't show a
particular value
Category list in item editor displays how many values? - Answer✔100
Category list maintenance - Answer✔Displays all values not just first 100
Release range - Answer✔Either all customer owned or all categories. For if customer sets
category values or if epic does
No add type - Answer✔Stores data directly on a record and is true for all contacts on that record
Response each time - Answer✔Stores values separately on each contact
Look back - Answer✔Stores values separately but last value is true until a new value is entered
Overtime Add Types - Answer✔Response each time and look back
List the different response types - Answer✔Single, multiple, related
Which two tools are used to find Clarity columns? - Answer✔Clarity compass and cogito data
dictionary
Where do you access the clarity compass? - Answer✔Column Search, Database Object Search
What does the clarity compass do? - Answer✔Sets definitions for how Chronicles items will
translate into Clarity
True or false: the relationship between Chronicles items and Clarity columns is one to one -
Answer✔False. And item can be extracted to multiple columns and a column can extract data
from multiple items
In what cases would there be no chronicles info in the column search? - Answer✔If the columns
extracts data not stored in a chronicles item or the columns extracts calculated data
How do data types change when ETL transform data from Chronicles to Clarity? -
Answer✔Strings become VARCHAR, numbers become NUMERIC, categories become
INTEGER or VARCHAR, dates times and instants become DATETIME
What does Database Object Search provide? - Answer✔Table Summary Tab shows info relevant
to the entire table
Where is the Claire Dictionary resource? - Answer✔UserWeb
True or false: the foreign key section of the clarity dictionary includes a full list of every possible
join between tables in Clarity - Answer✔False. Should be primarily used to identify category list
tables
2|Page
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 Brightstars. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
