ACING CLR 110: SECTION 4 AND 5.THE LATEST A+
QUESTIONS AND ANSWERS GUIDE BOOK.
Chronicles
Hierarchical database with real-time data
Clarity
Relational Database With normalized data model
Caboodle
Dimensional data model for ease of reporting and data exploration
(TRUE?FALSE) Clarity was designed to easily store and retrieve large amounts of
information about one entity at a
time.
FALSE
(TRUE/FALSE) Chronicles was designed to easily store and retrieve large
amounts of information about one entity at a
time.
TRUE
Two main principles for constructing tables in the Clarity database
Minimize redundant data and maintain consistent granularity
How does Clarity minimize data redundancy while maintaining granularity?
By mapping a single Chronicles master file to multiple Clarity tables
What 3 key pieces of information do you need to understand the mapping of
Chronicle's item to Clarity?
Chronicles item's add type and response type, and a Clarity table's primary key.
What two Chronicles item characteristics are particularly important for Clarity
queries?
Add Type and Response Type
Where is a No-Add item stored?
On the record
Where is an OverTime item stored
On the contact
What does the Response Type indicate
, How many lines of data an item can hold
What are the two categories of Response Types?
Single and Multiple
What two type of identifies can Chronicles records contain?
Internal and external
The value stored in .1 item on a Chronicles record is referred to as?
record ID
The record ID on a Chronicles record is unique (TRUE/FALSE)
TRUE
External identifiers on Chronicles records are unique (TRUE/FALSE)
FALSE
What are the 2 udentifiers for Epic contacts?
CSN and CDR + record ID
CDR
Contact Date Real
CSN
Contact Serial Number unqiue for all contacts within master file
What is the format of the CDR
Date in Epic's internal format, followed by two decimal places that start at .00 and
increment for each additional contact on the same date.
Master files without a CSN use which two items to identify a contact?
CDR and record ID
All master files contain a CSN (TRUE/FALSE)
FALSE
The meaning of a contact can differ between master files (TRUE/FALSE)
TRUE
The meaning of a contact can differ within a master file (TRUE/FALSE)
TRUE
Not every master file contains a contact (TRUE/FALSE)
FALSE
If a master file has a single contact which is not meaningful, the Add-Type is
QUESTIONS AND ANSWERS GUIDE BOOK.
Chronicles
Hierarchical database with real-time data
Clarity
Relational Database With normalized data model
Caboodle
Dimensional data model for ease of reporting and data exploration
(TRUE?FALSE) Clarity was designed to easily store and retrieve large amounts of
information about one entity at a
time.
FALSE
(TRUE/FALSE) Chronicles was designed to easily store and retrieve large
amounts of information about one entity at a
time.
TRUE
Two main principles for constructing tables in the Clarity database
Minimize redundant data and maintain consistent granularity
How does Clarity minimize data redundancy while maintaining granularity?
By mapping a single Chronicles master file to multiple Clarity tables
What 3 key pieces of information do you need to understand the mapping of
Chronicle's item to Clarity?
Chronicles item's add type and response type, and a Clarity table's primary key.
What two Chronicles item characteristics are particularly important for Clarity
queries?
Add Type and Response Type
Where is a No-Add item stored?
On the record
Where is an OverTime item stored
On the contact
What does the Response Type indicate
, How many lines of data an item can hold
What are the two categories of Response Types?
Single and Multiple
What two type of identifies can Chronicles records contain?
Internal and external
The value stored in .1 item on a Chronicles record is referred to as?
record ID
The record ID on a Chronicles record is unique (TRUE/FALSE)
TRUE
External identifiers on Chronicles records are unique (TRUE/FALSE)
FALSE
What are the 2 udentifiers for Epic contacts?
CSN and CDR + record ID
CDR
Contact Date Real
CSN
Contact Serial Number unqiue for all contacts within master file
What is the format of the CDR
Date in Epic's internal format, followed by two decimal places that start at .00 and
increment for each additional contact on the same date.
Master files without a CSN use which two items to identify a contact?
CDR and record ID
All master files contain a CSN (TRUE/FALSE)
FALSE
The meaning of a contact can differ between master files (TRUE/FALSE)
TRUE
The meaning of a contact can differ within a master file (TRUE/FALSE)
TRUE
Not every master file contains a contact (TRUE/FALSE)
FALSE
If a master file has a single contact which is not meaningful, the Add-Type is
