ACING CLR 110: CLARITY DATA SET EXAM, WITH THE
LATEST A+ QUESTIONS AND ANSWERS GUIDE BOOK
Record viewer
An activity that provides a read only view of raw data in Chronicles it shows all items set
on a particular contact or record
Item editor
Shows the definition of a chronicles item. Lets you investigate the properties of a given
item
Category list
A list of divine values that can be stored in a chronicles item
Category list maintenance
Activity that allows you to see the complete category list. Better than item editor
Two tools in hyperspace to use as resources for clarity
Clarity compass column search and database object search
Online resources for clarity research
Clarity dictionary , report repository, ER diagram
Four things clarity columns can extract
Extract data from a single Chronicles item, from multiple Chronicles item, data not
stored in a chronicles item, it can extract calculated data
You will see an empty grid in column search in one of these two cases
The column extract data not stored in a chronicles item or the column extracts
calculated data
The column extract data not stored in a chronicles item or the column extracts
calculated data
Dates are extracted as blank on the date
Midnight
Times are extracted as the time on
1/1/1900
Extracted Table
Gets its data from chronicles during the nightly ETL
Load frequency
, How often data gets loaded into a specific clarity table
_C column
Clarity naming convention for columns that extract category values. Each row stores a
category value from a category list
To translate category values into names join to a table with the prefix blank
zC_
A category list table is often referred to as
ZC table
Clarity dictionary
Within the data handbook, provides reference information about clarity data model
Clarity Dictionary foreign key information section list?
System calculated and documented foreign keys.
Report repository
In data handbook and contains reference information for Epic released and customer
written reports
Name the two tools that manage the extraction of data from chronicles to clarity
Clarity Kompass defines structure of clarity tables and clarity Consol schedule The
extract of define tables . Used by Etl administration
Load frequency :: incremental = loads nightly ex order med; weekly full = ex
clarity bed
Join type to use when joining two tables with different frequencies
Left outer join
Response type multiple includes
Multiple response and related group
Epic doesn't delete columns or tables. They become deprecated and the table or
column is still existing clarity but no new data will be extracted. Collin is
deprecated data is no longer extract it to it. The replacement column is populated
going forward and a backfill process takes care of the previously existing Rows
and the table
How does Epic flag deprecated fields
LATEST A+ QUESTIONS AND ANSWERS GUIDE BOOK
Record viewer
An activity that provides a read only view of raw data in Chronicles it shows all items set
on a particular contact or record
Item editor
Shows the definition of a chronicles item. Lets you investigate the properties of a given
item
Category list
A list of divine values that can be stored in a chronicles item
Category list maintenance
Activity that allows you to see the complete category list. Better than item editor
Two tools in hyperspace to use as resources for clarity
Clarity compass column search and database object search
Online resources for clarity research
Clarity dictionary , report repository, ER diagram
Four things clarity columns can extract
Extract data from a single Chronicles item, from multiple Chronicles item, data not
stored in a chronicles item, it can extract calculated data
You will see an empty grid in column search in one of these two cases
The column extract data not stored in a chronicles item or the column extracts
calculated data
The column extract data not stored in a chronicles item or the column extracts
calculated data
Dates are extracted as blank on the date
Midnight
Times are extracted as the time on
1/1/1900
Extracted Table
Gets its data from chronicles during the nightly ETL
Load frequency
, How often data gets loaded into a specific clarity table
_C column
Clarity naming convention for columns that extract category values. Each row stores a
category value from a category list
To translate category values into names join to a table with the prefix blank
zC_
A category list table is often referred to as
ZC table
Clarity dictionary
Within the data handbook, provides reference information about clarity data model
Clarity Dictionary foreign key information section list?
System calculated and documented foreign keys.
Report repository
In data handbook and contains reference information for Epic released and customer
written reports
Name the two tools that manage the extraction of data from chronicles to clarity
Clarity Kompass defines structure of clarity tables and clarity Consol schedule The
extract of define tables . Used by Etl administration
Load frequency :: incremental = loads nightly ex order med; weekly full = ex
clarity bed
Join type to use when joining two tables with different frequencies
Left outer join
Response type multiple includes
Multiple response and related group
Epic doesn't delete columns or tables. They become deprecated and the table or
column is still existing clarity but no new data will be extracted. Collin is
deprecated data is no longer extract it to it. The replacement column is populated
going forward and a backfill process takes care of the previously existing Rows
and the table
How does Epic flag deprecated fields
