CLR110 TEST PAPER QUESTIONS AND ANSWERS GRADED
A+
✔✔What does the clarity compass do? - ✔✔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 - ✔✔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? - ✔✔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? -
✔✔Strings become VARCHAR, numbers become NUMERIC, categories become
INTEGER or VARCHAR, dates times and instants become DATETIME
✔✔What does Database Object Search provide? - ✔✔Table Summary Tab shows info
relevant to the entire table
✔✔Where is the Claire Dictionary resource? - ✔✔UserWeb
✔✔True or false: the foreign key section of the clarity dictionary includes a full list of
every possible join between tables in Clarity - ✔✔False. Should be primarily used to
identify category list tables
✔✔Which two tools are used in the Clarity ETL process? - ✔✔Clarity Compass and
Clarity Console
✔✔Clarity Compass - ✔✔Defines what Chronicles/production data will be extracted into
which Clarity tables and columns. Defines the structure of your Clarity tables, including
primary keys - Hyperspace
✔✔Clarity Console - ✔✔Schedules the extract of defined tables from Chronicles into
Clarity - Web-based
✔✔Load Frequency of a table - ✔✔Determines how often the data in the table is
extracted from chronicles to clarity
✔✔Who sets the load frequency and where is it set? - ✔✔Set by clarity ETL
administrator in the Clarity Console
✔✔What is the most common load frequency? - ✔✔Incremental (nightly)
, ✔✔What are other load frequencies? - ✔✔Weekly, monthly
✔✔Which join should you use for two tables that have different load frequencies? -
✔✔Left outer
✔✔True or false: columns and tables can be deleted in clarity - ✔✔False
✔✔Deprecation - ✔✔Table or column still exists but data is no longer extracted to it and
a replacement column is populated and backfilled
✔✔Where to view database version changes? - ✔✔Compass Comparison or Data
Model Change Analyzer
✔✔True or false: one chronicles master file translates into one clarity table - ✔✔False.
They have different granularity
✔✔True or false: internal and external identifiers are unique - ✔✔False. Only internal
must be unique
✔✔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
A+
✔✔What does the clarity compass do? - ✔✔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 - ✔✔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? - ✔✔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? -
✔✔Strings become VARCHAR, numbers become NUMERIC, categories become
INTEGER or VARCHAR, dates times and instants become DATETIME
✔✔What does Database Object Search provide? - ✔✔Table Summary Tab shows info
relevant to the entire table
✔✔Where is the Claire Dictionary resource? - ✔✔UserWeb
✔✔True or false: the foreign key section of the clarity dictionary includes a full list of
every possible join between tables in Clarity - ✔✔False. Should be primarily used to
identify category list tables
✔✔Which two tools are used in the Clarity ETL process? - ✔✔Clarity Compass and
Clarity Console
✔✔Clarity Compass - ✔✔Defines what Chronicles/production data will be extracted into
which Clarity tables and columns. Defines the structure of your Clarity tables, including
primary keys - Hyperspace
✔✔Clarity Console - ✔✔Schedules the extract of defined tables from Chronicles into
Clarity - Web-based
✔✔Load Frequency of a table - ✔✔Determines how often the data in the table is
extracted from chronicles to clarity
✔✔Who sets the load frequency and where is it set? - ✔✔Set by clarity ETL
administrator in the Clarity Console
✔✔What is the most common load frequency? - ✔✔Incremental (nightly)
, ✔✔What are other load frequencies? - ✔✔Weekly, monthly
✔✔Which join should you use for two tables that have different load frequencies? -
✔✔Left outer
✔✔True or false: columns and tables can be deleted in clarity - ✔✔False
✔✔Deprecation - ✔✔Table or column still exists but data is no longer extracted to it and
a replacement column is populated and backfilled
✔✔Where to view database version changes? - ✔✔Compass Comparison or Data
Model Change Analyzer
✔✔True or false: one chronicles master file translates into one clarity table - ✔✔False.
They have different granularity
✔✔True or false: internal and external identifiers are unique - ✔✔False. Only internal
must be unique
✔✔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
