Questions And100 Verified CORRECT Answers

CLR110 Clarity Data Model (ACTUAL Questions And100% Verified CORRECT Answers

A Chronicles item can store one or more options from a limited list. Which of the following could account for this behavior? (Choose all that apply)

• Single Response
• Multiple Response
• Networked
• Overtime
• No-Add
• Category
• B, C and F. If a Chronicles item can store one or more

options it is a multiple response item. If the options come from a limited list, that item may be a category item, where the category list is the list of options, or networked, where the records or contacts in the destination master file is the list of options

What are the steps to writing a report request?

• Identify the data elements you will need for the report.
• Find the INI + Item numbers of the data points to use on the

report

• Use the INI + Item numbers to find the appropriate Clarity

tables and columns. 1 / 4

• Join the Clarity tables together using the correct foreign key

information

When is a column deprecated?

• The most common reason for deprecation is due to a change

in the underlying Chronicles data.

• Deprecated in order to direct report writes to use a better

reporting structure

What are the steps to identifying changes between Prior to upgrade, your ETL administrator upgrades Clarity Compass E records in a separate environment. These new E records are then compared to existing C records using a tool called the Compass Comparison, which returns a list of new and changed tables and columns.

If you find a table in the Clarity Compass, will it necessarily be on your Clarity database?Not always the case. The Clarity Compass will show all of the tables that are possible but at your organization you might not have every table extracted

How can you find out if a table is in your clarity database? 2 / 4

Query it in SQL, look for C records in the Clarity Compass, check to see there are executions listed on the Summary form

How do you filter the combined Caboodle/Clarity dictionary in the analytics catalog?CL for Clarity; CB for Caboodle

Also search by INI & Item Number

Which filter would you use in analytics catalog to search Clarity / Caboodle Database objects?The Data Dictionary filter will limit results in the Analytics Catalog to database objects in Clarity or Caboodle

You are curious if you can report on SPEC_DB_MAIN and RES_DB_MAIN in Caboodle. What section should you look at in the ana cat dictionary?The dependencies section will tell us what database objects in Clarity or Caboodle depend on this database object

How may E Records?One E Record for every database object possible in Clarity 3 / 4

What is an E Record?The E record, which is a record in the E0B (zero not the letter

• contains the table information that is found in the Clarity

compass.

What is a C Record?One of the steps that your Clarity administrator will need to do in order to begin extracting a new table will be to create a copy of the E record. The copy of the E record will begin with the letter C, and is called the C record. The information is the same on the E and the C record, but the C records are the database objects that the console is extracting.

What is the hierarchy of the Chronicles Data Structure?Master file > Record > Contact > Item

What programming language codes Chronicles?The M programming language

What is KB_SQL?

• / 4