Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

My CLR110 Clarity Data Model Fundamentals > Investigating Clarity > Flashcards

Investigating Clarity Flashcards

1
Q

Clarity Compass is accessed with which 2 activities in Hyperspace?

A

Column Search
Database Object Search

-May 2022, 3-6

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

When do you use Column Search?

A

When you need to find the table and column that extracts a known INI and item number

-May 2022, 3.6

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A single Chronicles item can extract ______columns in Clarity.

A. Single
B. Multiple
C. None

A

B. Multiple

-May 2022, 3.7

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

The general naming structure would have the grouped tables include a suffix of:

A _2, _3
B _ZC
C. _V

A

A. _2, _3

-May 2022, 3.10

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

C. 5

-May 2022, 3.11

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

T/F Naming conventions are strictly enforced in Clarity.

A

FALSE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

The load frequency of a table determines 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

A

A. Incremental

-May 2022, 3-18

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

T/F Epic doesn’t delete columns or tables once released.

A

True

-May 2022, 3-20

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

A. Data is no longer extracted to it.

-May 2022, 3.20

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

FALSE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

False. The Clarity Compass stores these definitions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

Column Search, to enter the Clarity Compass

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are two tools within Hyperspace you can use as resources for Clarity queries?

A
  1. Clarity Compass2. Analytics Catalog(Aug. 2021, 3.5)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are two online tools you can use for Clarity research?

A
  1. Clarity Dictionary2. Report Repository(Aug. 2021, 3.5)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is the Clarity Compass?

A
  1. Defines what Chronicles data will be extracted into which Clarity tables and columns.2. Defines the structure of your Clarity Tables, including primary keys.1. The Clarity Compass is used to set the definitions for how Chronicles items will translate into Clarity.2. It is used to define the structure of your Clarity tables.(Aug. 2021, 3.17, 3.6)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

How many ways can you access the Clarity Compass data?

A

Two ways:1. Column Search2. Database Object SearchBoth are found within Hyperspace and will open different sections of the dictionary.(Aug. 2021, 3.6)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

How can you access Column Search?

A
  1. Chart Search (ctrl + spacebar)
  2. The Column Search magnifying glass

-May 2022, 3.6

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

List the two things you can search by in Column Search.

A
  1. Chronicles address (INI + Item number)2. Clarity column name(Aug. 2021, 3.6)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Where does the Column Search activity take you?

A

• To the Columns tab of the Clarity Compass. • The Columns tab shows information about a particular column within a Clarity table.(Aug. 2021, 3.6)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Clarity columns can extract four types of data. What are they?

A

Clarity columns can:
1. Extract data from a single Chronicles item
2. Extract data from multiple Chronicles items
3. Extract data not stored in a Chronicles item
4. Extract calculated data

(Aug. 2021, 3.7)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

In the Clarity Compass, why would you see an empty grid in the Chronicles Info section of the Column tab?

A

You will generally see an empty grid in one of two cases:

  1. The column extracts data not stored in a Chronicles item.
  2. The column extracts calculated data.

-May 2022, 3.8

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Does Clarity extract every Chronicles item?

A

No. Some items store internal data that would not be relevant outside the context of Chronicles.(Aug. 2021. 3.8)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Does Clarity use the same data types as Chronicles?

A

No. When the Clarity ETL process transforms the data into a relational format, it also converts the data into standard datatypes used by relational databases (the ANSI standard).(Aug. 2021, 3.9)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

When would you use the Database Object Search instead of the Column Search?

A

If you know the table name you can use the Database Object Search.(Aug. 2021, 3.9)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

How can you access the Database Object Search?

A
  1. Chart Search (ctrl + spacebar)2. The Database Object Search magnifying glass(Aug. 2021, 3.9)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

List the two things you can search by in the Database Object Search.

A
  1. The table name2. The name of another database object (Aug. 2021, 3.6)
29
Q

Where in the Clarity Compass will you find chips that describe different attributes of the table?

A

The Overview section of the Summary tab.(Aug. 2021, 3.10)

30
Q

What three table attributes, found in the chips, will be valuable for business intelligence developers?

A
  1. Type of Database Object2. Load Frequency3. Master File(Aug. 2021, 3.10)
31
Q

What information can be found in the Overview section of the Summary tab?

A

• Organization specific table notes provided by your ETL administrator• Chips that describe different table attributes• Grouped tables(Aug. 2021, 3.10)

32
Q

When are grouped tables created?

A

Grouped tables are created when an original table has enough columns to warrant splitting it into different tables.The general naming structure would have the grouped tables include a suffix of _2, _3 etc. You can think of grouped tables as extension tables.(Aug. 2021, 3.10)

33
Q

Do grouped tables have a unique primary key?

A

No. Grouped tables have the same primary key and the same number of rows.(Aug. 2021, 3.10)

34
Q

What does the Columns section of the Clarity Compass provide?

A

The Columns section lists out key information about the column found in the database object.(Aug. 2021, 3.10)

35
Q

What can you find in the Dependencies section of the Summary tab?

A

The dependencies section lists out the database objects that are dependent on the table you are looking at.(Aug. 2021, 3.11)

36
Q

Does the Dependencies section include Caboodle database objects that extract data from this Clarity table?

A

Yes(Aug. 2021, 3.11)

37
Q

What section in the Summary tab lists the indexed columns within the database object?

A

The Indexes section.(Aug. 2021, 3.11)

38
Q

Why would you use an indexed column?

A

Using indexed columns as filters in a query can:1. Improve performance2. Speed up the query(Aug. 2021, 3.11)

39
Q

What happens to the column name when the column extracts from a Chronicles item with a data type of category?

A

_C will be added to the column name.Example: PATIENT.STATE_C(Aug. 2021, 3.14)

40
Q

Where does the category value stored in each row of an _C column come from?

A

Each row of an _C column stores a category value from a category list.(Aug. 2021, 3.14)

41
Q

How would you translate category values into names?

A

Join to a table with the prefix ZC_.(Aug. 2021, 3.14)

42
Q

What’s the difference between a Category List Table and a ZC Table?

A

There is no difference. Both names are referring to the same thing.(Aug. 2021, 3.14)

43
Q

Where can you go to easily identify the correct category list table (ZC_ table)?

A

Look for header Category Lookup in the Columns section of the Summary tab in the Clarity Dictionary.(Aug. 2021, 3.15)

44
Q

Where can you access the Clarity Dictionary if you don’t have access to Hyperspace?

A

The Clarity Dictionary can be found on the UserWeb through the Data Handbook.

-May 2022, 3.15

45
Q

If you don’t have access to Hyperspace, where would you go to identify category list tables?

A

The Clarity Dictionary on the UserWeb in the Foreign Key section.(Aug. 2021, 3.16)

46
Q

What are the two main tools used in the Clarity ETL process?

A
  1. Clarity Compass • Maps Chronicles items to Clarity tables and columns. • Stores table definitions 2. Clarity Console • Schedules the extract of defined tables from Chronicles to Clarity.(Aug. 2021, 3.17)
47
Q

What does the load frequency of a table determine?

A

The load frequency of a table determines how often the data in the table is extracted from Chronicles to Clarity.(Aug. 2021, 3.17)

48
Q

What is the most common load frequency?

A

INCREMENTAL. The INCREMENTAL load takes place nightly, so the data contained in most Clarity tables is updated every 24 hours.(Aug. 2021, 3.17)

49
Q

List three load frequencies.

A
  1. INCREMENTAL2. WEEKLY3. MONTHLY(Aug. 2021, 3.17)
50
Q

Why is it important to know the extract frequencies of the tables that you’re using?

A

Different tables can have different load frequencies meaning some tables can be more up-to-date than others.(Aug. 2021, 3.18)

51
Q

What type of join should you use if your joining two tables with different frequencies?

A

A left outer join may be needed to make sure the report returns the necessary data.(Aug. 2021, 3.18)

52
Q

Why is the Report Repository considered a resource for Clarity research?

A

The Report Repository contains reference information for Epic-released and custom-written reports.It is also a useful resource to investigate Clarity tables used in a similar report request.(Aug. 2021, 3.16)

53
Q

What does it mean when a column is deprecated?

A

Data will no longer be extracted to it.(Aug. 2021, 3.19)

54
Q

What causes a table or column be deprecated?

A

A deprecated column is a result of an Epic software update. Old items are retired and replaced with new items that behave more efficiently or in a more desired manner. (Aug. 2021, 3.19)

55
Q

Does a deprecated table or column continue to exist in the Clarity database?

A

Yes. No new data will be extracted to it but it will still exist in the Clarity database.(Aug. 2021, 3.19)

56
Q

What are two ways the Clarity Compass identifies deprecated columns?

A
  1. By adding a Deprecated chip to the column Name2. It is stated in the column Description(Aug. 2021, 3.20)
57
Q

Who should you check with to determine what, if any, changes to Clarity may affect your reports after an upgrade?

A

The Clarity ETL Administrator.(Aug. 2021, 3.20)

58
Q

What is the Compass Comparison for?

A

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.(Aug. 2021, 3.21)

59
Q

What does the Data Model Change Analyzer (DMCA) return?

A

The DMCA returns a list of reports that will be affected by these changes.(Aug. 2021, 3.21)

60
Q

What stores a list of all possible database objects that can be extracted to the Clarity database?

A

The Clarity Compass.(Aug. 2021, 3.21)

61
Q

Where does the Cogito Dictionary live?

A

In the Analytics Catalog.

-May 2022, 3.17

62
Q

When searching the Cogito Dictionary how do you specify which database you want to search?

A

To find Clarity and Caboodle tables in the Analytics Catalog, filter the catalog for a specific database using:• CL:• CB:(Aug. 2021, 3.23)

63
Q

Does every Epic application have a set of core Clarity tables?

A

Yes

-May 2022, 3.23

64
Q

What do core Clarity tables contain?

A

The majority of reportable data points populated by workflows for that application.(Aug. 2021, 3.27)

65
Q

True or False:Every Clarity table has a list of the applications for which it is considered “core”.

A

True(Aug. 2021, 3.27)

66
Q

Why wouldn’t you have access to every table in the Clarity database?

A

You will only have access to the tables that are core to the Epic applications you have licenses for.(Aug. 2021, 3.27)

67
Q

How would you quickly determine whether a given table will be available in your clarity database?

A

Check the Custom field located in the Clarity Compass header section. If it says “Yes”, then the table has been configured for extraction to the Clarity database. (Aug. 2021, 3.27)

68
Q

What is KB_SQL used to translate?

A

KB_SQL translates the data stored in Chronicles from M Script to the relational tables and columns of Clarity.(Aug. 2021, 3.28)

My CLR110 Clarity Data Model Fundamentals (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions