Investigating Clarity

Question 1

Clarity Compass which is accessed with 2 activities in Hyperspace are?

Answer 1

Column Search

Database Object Search

Question 2

When do you use Column Search?

Answer 2

INI and item number

Question 3

A single Chronicles item can extract ______columns in Clarity.
A Single
B. Multiple
C.None

Answer 3

B Multiple

Question 4

The general naming structure would have the groupled tables include a suffix of
A _2, _3
B _ZC
C. _V

Answer 4

A. _2, _3

Question 5

A category list table for an item extract the entire category list, and follows a set format: ZC_[Category List Name]
How many columns do these tables have?
A. 3
B. 4
C. 5
D None

Answer 5

C 5

Question 6

T/F Naming conventions are strictly enforced in Clarity.

Answer 6

False

Question 7

The load frequency of a table determinish how often the data in the table is extracted from Chronicles to Clarity.  The most common load frequency is?
A. Incremental
B. Weekly
C. Monthly
D. hourly

Answer 7

Incremental

Question 8

T/F Epic delete columns or tables once released.

Answer 8

False.

Question 9

When a column is deprecated, 
A. Data is no longer extracted to it.
B. The data is turned to NULL
C. A backfill process take care of previously exiting rows in the table by turning them all to 0
D. the column is removed from the table

Answer 9

A. Data is no longer extracted to it.

Question 10

T/F If you find a table in the Clarity Compass, will it necessarily be on your Clarity database?

Answer 10

false

Question 11

T/F The Clarity Console stores definitions for the database objects that can be extracted
to and stored in the Clarity database.

Answer 11

False. The Clarity Compass stores these definitions.

Question 12

Which tool would you use to find the table and column that extracts EPT 18864: Attending Provider?

Answer 12

Column Search, to enter the Clarity Compass

Question 13

In which of the following scenarios would it be appropriate, and even necessary, to reach out to your Clarity ETL administrator?
A. You need to use CLARITY_DEP_CUST_FIELDS in a report. You found the table in the Clarity Compass, but cannot query the table on your database.
B. You found a view that looks useful in your reports. You query the view, get data returned, but you want to know how this view fits in with your reports.

Answer 13

A: CLARITY_DEP_CUST_FIELDS likely has not been extracted to the Clarity database. Your ETL
administrator can enable this for you.

Question 14

Reviewing a colleague’s report, you see an unfamiliar table and want to find out more about it. However, you try looking it up, but can’t find it in the Clarity Dictionary. Why might this happen, and where should you look instead?

Answer 14

The Clarity Dictionary from the UserWeb contains only Epic‐released definitions. Any modifications made by your database administrators will not be reflected. To find all customizations, access the Clarity Compass within Hyperspace.