CLR110 EXAM STUDY GUIDE QUESTIONS AND ANSWERS GRADED A+

CLR110 EXAM STUDY GUIDE QUESTIONS AND ANSWERS
GRADED A+
✔✔What are the two possible identifiers for contacts in Epic? - ✔✔Contact serial
number (CSN) or contact date real (CDR) combined with record ID

✔✔What are the two master file categories - ✔✔Static and dynamic

✔✔Which column becomes part of the primary key in multiple response items? -
✔✔LINE

✔✔What is the primary key of single, no add item? - ✔✔Record ID

✔✔What is the primary key of single, overtime item? - ✔✔CSN or Record ID + CDR

✔✔What is the primary key of multiple, no add item? - ✔✔Record ID + LINE

✔✔What is the primary key of multiple, overtime item? - ✔✔CSN or Record ID + CDR +
LINE

✔✔True or false: all data in a single extracted table in Clarity typically come from the
same chronicles master file - ✔✔True

✔✔True or false: all data in a single extracted table in clarity come from items with the
same add type and response type - ✔✔True

✔✔True or false: multiple response chronicles items typically extract to separate clarity
tables - ✔✔True, unless they are part of the same related group

✔✔True or false: you should join from most granular table first - ✔✔True

✔✔True or false: clarity has a set naming convention? - ✔✔False

✔✔How do you connect master files to each other? - ✔✔Networked items

✔✔True or false: a particular networked item will always reference the same master file
- ✔✔True

✔✔What do you need to do if you join to the same table more than once in a query? -
✔✔Alias the table in each join