CLR110 Clarity Data Model EXAM LATEST
UPDATED VERSION QUESTIONS AND VERIFIED
CORRECT ANSWERS JUST RELEASED
What data types convert during ETL? - answer>>>String ->
VARCHAR Number -> NUMERICS
Dates/Times/Instants -> DATETIME
What does the table summary show within the database object search? -
answer>>>The Table Summary tab within the dictionary shows the Clarity
Compass information that is relevant to the entire table.
What is in the overview section of the summary form? - answer>>>- Different
chips that describe different attributes of the table,
- Organization specific table notes if your ETL administrator added table notes
- Grouped tables
Three attributes found in the chips that will be valuable for buisness
intelligence developers are: - answer>>>Type of Database object, load
frequency, and master file
What is in the columns section of the table summary? - answer>>>Name,
Data Type, Category Lookup,. Chronicles Info, Description
What is in the dependencies section of the table summary? - answer>>>The
dependencies section lists out the database objects that are dependent on
the table you are looking at. This will include database objects in Clarity
that depend on the database object you are viewing, as well as database
objects in Caboodle that extract data from this table in Clarity.
, CLR110 Clarity Data Model EXAM LATEST
UPDATED VERSION QUESTIONS AND VERIFIED
CORRECT ANSWERS JUST RELEASED
Clarity naming convention for columns that extract category values? -
answer>>>_C
The category list table for an item extracts the entire category list, and
follows a set format: - answer>>>ZC_[Category List Name]
Clarity Dictionary? - answer>>>The Clarity Dictionary contains
information such as: Table and column names
Table and column descriptions
Index information
Primary and foreign keys
Category values for Epic released category lists
How can you search with the Clarity Dictionary? - answer>>>Search by
typing in a keyword and refining with Clarity Table Names and Columns
Where is the Clarity Dictionary? - answer>>>The UserWeb
What is a limitation of the Clarity Dictionary? - answer>>>The Clarity
Dictionary stores only Epic-released Clarity definitions, which means it does
not contain any customizations made at your organization. To find
information contained in the Clarity Dictionary that also contains your
customizations, use the Clarity Compass.
What is a limitation of the Clarity Dictionary in the Foreign Key Information
Section? What should it be used for? - answer>>>The Foreign Key section of
, CLR110 Clarity Data Model EXAM LATEST
UPDATED VERSION QUESTIONS AND VERIFIED
CORRECT ANSWERS JUST RELEASED
the Clarity dictionary on the UserWeb does NOT include a full list of every
possible join between tables in Clarity. It should primarily be used to
identify category list tables.
, CLR110 Clarity Data Model EXAM LATEST
UPDATED VERSION QUESTIONS AND VERIFIED
CORRECT ANSWERS JUST RELEASED
How is Clarity Compass involved in the ETL process? - answer>>>Defines
what Chronicles/production data will be extracted into which Clarity tables
and columns. Defines the structure of your Clarity tables, including primary
keys.
How is Clarity Console involved in the ETL process? - answer>>>Schedules
the extract of defined tables from Chronicles into Clarity. Displays
information about previously run extracts.
What is Load Frequency? - answer>>>The load frequency of a table
determines how often the data in the table is extracted from Chronicles to
Clarity.
What is Incremental Load Frequency? - answer>>>The INCREMENTAL load
takes place nightly, so the data contained in most Clarity tables is updated
every 24 hours. Other load frequencies include WEEKLY and MONTHLY.
What does a change in EPIC software mean? - answer>>>A new version of
the Epic software results in old items being retired and replaced with new
items that behave more efficiently or in a different, more desired manner.
When is a column deprecated? - answer>>>- 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 - answer>>>Prior to
upgrade, your ETL administrator upgrades Clarity Compass E records in a
separate environment. These new E records are then compared to existing
UPDATED VERSION QUESTIONS AND VERIFIED
CORRECT ANSWERS JUST RELEASED
What data types convert during ETL? - answer>>>String ->
VARCHAR Number -> NUMERICS
Dates/Times/Instants -> DATETIME
What does the table summary show within the database object search? -
answer>>>The Table Summary tab within the dictionary shows the Clarity
Compass information that is relevant to the entire table.
What is in the overview section of the summary form? - answer>>>- Different
chips that describe different attributes of the table,
- Organization specific table notes if your ETL administrator added table notes
- Grouped tables
Three attributes found in the chips that will be valuable for buisness
intelligence developers are: - answer>>>Type of Database object, load
frequency, and master file
What is in the columns section of the table summary? - answer>>>Name,
Data Type, Category Lookup,. Chronicles Info, Description
What is in the dependencies section of the table summary? - answer>>>The
dependencies section lists out the database objects that are dependent on
the table you are looking at. This will include database objects in Clarity
that depend on the database object you are viewing, as well as database
objects in Caboodle that extract data from this table in Clarity.
, CLR110 Clarity Data Model EXAM LATEST
UPDATED VERSION QUESTIONS AND VERIFIED
CORRECT ANSWERS JUST RELEASED
Clarity naming convention for columns that extract category values? -
answer>>>_C
The category list table for an item extracts the entire category list, and
follows a set format: - answer>>>ZC_[Category List Name]
Clarity Dictionary? - answer>>>The Clarity Dictionary contains
information such as: Table and column names
Table and column descriptions
Index information
Primary and foreign keys
Category values for Epic released category lists
How can you search with the Clarity Dictionary? - answer>>>Search by
typing in a keyword and refining with Clarity Table Names and Columns
Where is the Clarity Dictionary? - answer>>>The UserWeb
What is a limitation of the Clarity Dictionary? - answer>>>The Clarity
Dictionary stores only Epic-released Clarity definitions, which means it does
not contain any customizations made at your organization. To find
information contained in the Clarity Dictionary that also contains your
customizations, use the Clarity Compass.
What is a limitation of the Clarity Dictionary in the Foreign Key Information
Section? What should it be used for? - answer>>>The Foreign Key section of
, CLR110 Clarity Data Model EXAM LATEST
UPDATED VERSION QUESTIONS AND VERIFIED
CORRECT ANSWERS JUST RELEASED
the Clarity dictionary on the UserWeb does NOT include a full list of every
possible join between tables in Clarity. It should primarily be used to
identify category list tables.
, CLR110 Clarity Data Model EXAM LATEST
UPDATED VERSION QUESTIONS AND VERIFIED
CORRECT ANSWERS JUST RELEASED
How is Clarity Compass involved in the ETL process? - answer>>>Defines
what Chronicles/production data will be extracted into which Clarity tables
and columns. Defines the structure of your Clarity tables, including primary
keys.
How is Clarity Console involved in the ETL process? - answer>>>Schedules
the extract of defined tables from Chronicles into Clarity. Displays
information about previously run extracts.
What is Load Frequency? - answer>>>The load frequency of a table
determines how often the data in the table is extracted from Chronicles to
Clarity.
What is Incremental Load Frequency? - answer>>>The INCREMENTAL load
takes place nightly, so the data contained in most Clarity tables is updated
every 24 hours. Other load frequencies include WEEKLY and MONTHLY.
What does a change in EPIC software mean? - answer>>>A new version of
the Epic software results in old items being retired and replaced with new
items that behave more efficiently or in a different, more desired manner.
When is a column deprecated? - answer>>>- 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 - answer>>>Prior to
upgrade, your ETL administrator upgrades Clarity Compass E records in a
separate environment. These new E records are then compared to existing
