CLR 110 - Clarity Data Model Fundamentals
Newest with Complete Questions and Correct
Detailed Answers| Brand New Version!
Graded A+
______ (which usually have names that start with "V_") don't hold data in
themselves, but run queries against other Clarity tables and present the results in
a form that can be used as table. - ✔✔ANSWER✔✔->>Views
The ______ ______ gives us information about the table itself -
✔✔ANSWER✔✔->>Table Summary
Certain tables have enough columns to warrant splitting them up into different
tables. These are called - ✔✔ANSWER✔✔->>Grouped Tables
,The Extracted field in the table summary does not dictate whether or not the
table is extracted at your organization. Rather, the field signifies that the tables
can be extracted through the normal ______ ______. - ✔✔ANSWER✔✔-
>>ETL process
The ______ ______ ______, a compiled HTML version of the contents of the
Clarity Compass - ✔✔ANSWER✔✔->>Clarity Data Dictionary
Anything that can be found in the Table Summary section of the Compass can
generally be found in the ______ ______ ______ as well - ✔✔ANSWER✔✔-
>>Clarity Data Dictionary
If you want to search for the column that extracts a certain Chronicles INI/item
(like you would do in Column Search in Hyperspace), you can do that by entering
the INI and item you want to search for ______ ______ ______ -
✔✔ANSWER✔✔->>in double quotes
If you need to use two copies of ORDER_PROC, why shouldn't you give the two
copies the aliases ORDER_PROC_1 and ORDER_PROC_2? - ✔✔ANSWER✔✔-
>>If you were to use ORDER_PROC_2 as an alias it would be difficult to determine
if you are using the ORDER_PROC_2 table or if it is an alias you have assigned to
the ORDER_PROC table.
True or False. The best way to determine whether an inner join or a left outer join
should be used is the starting table's primary key. - ✔✔ANSWER✔✔-
>>False. The reporting need, load type and frequency will determine whether two
tables should be joined using a left outer join or an inner join.
,A Clarity table's primary key includes a "CSN". What does this mean? -
✔✔ANSWER✔✔->>A CSN is a Contact Serial Number, which identifies a
specific contact within a specific record. A table with a CSN in its primary key
extracts overtime data - if it extracted no-add data, you wouldn't need to identify
a contact.
A Clarity table's primary key includes a line count, What does this mean? -
✔✔ANSWER✔✔->>Only Chronicles items with a response type of multiple-
response or related group have line counts, so you know the table must extract
multiple-response or related group items.
______ ______ ______ can help you identify tables related to a table you already
know - ✔✔ANSWER✔✔->>Database Object Search
While a join decides which tables will be used, a ______ ______ tells the report
which rows from each table should be considered for use in the report. -
✔✔ANSWER✔✔->>join type
An ______ ______ will return only rows that have matches in both tables -
✔✔ANSWER✔✔->>inner join
A ______ ______ ______can be thought of visually as an inner join, plus all the
rows in the left hand table that don't have matches in the right. -
✔✔ANSWER✔✔->>Left Outer Join
A ______ ______ ______ can be thought of visually as an inner join, plus all the
rows in the right table that don't have matches in the left. Similarly, it can be
thought of as a left outer join where the tables have changed sides. -
✔✔ANSWER✔✔->>Right Outer Join
, A ______ ______ ______ will return all rows from both tables with data from
each table if available. It will include rows that have matches in either table as
well as those that don't. It can be thought of visually as everything. -
✔✔ANSWER✔✔->>Full Outer Join
There are two main ways to extract a Clarity table - using a Full Extract and
Incremental Extract. These are called ______ ______ - ✔✔ANSWER✔✔-
>>Load Types
Which Load Type truncates (deletes) any data already in the Clarity table and re-
extracts the entire table from Chronicles - ✔✔ANSWER✔✔->>Full (FULL)
What is the first step in the report writing process? - ✔✔ANSWER✔✔-
>>Analyze request for key features...
-Who needs it
-What purpose
-How much data should it return
-How up to date does the data need to be
-How does the data need to be formatted
Operational or Analytical?
Top 100 Chief Complaints in the ED - ✔✔ANSWER✔✔->>Analytical
Newest with Complete Questions and Correct
Detailed Answers| Brand New Version!
Graded A+
______ (which usually have names that start with "V_") don't hold data in
themselves, but run queries against other Clarity tables and present the results in
a form that can be used as table. - ✔✔ANSWER✔✔->>Views
The ______ ______ gives us information about the table itself -
✔✔ANSWER✔✔->>Table Summary
Certain tables have enough columns to warrant splitting them up into different
tables. These are called - ✔✔ANSWER✔✔->>Grouped Tables
,The Extracted field in the table summary does not dictate whether or not the
table is extracted at your organization. Rather, the field signifies that the tables
can be extracted through the normal ______ ______. - ✔✔ANSWER✔✔-
>>ETL process
The ______ ______ ______, a compiled HTML version of the contents of the
Clarity Compass - ✔✔ANSWER✔✔->>Clarity Data Dictionary
Anything that can be found in the Table Summary section of the Compass can
generally be found in the ______ ______ ______ as well - ✔✔ANSWER✔✔-
>>Clarity Data Dictionary
If you want to search for the column that extracts a certain Chronicles INI/item
(like you would do in Column Search in Hyperspace), you can do that by entering
the INI and item you want to search for ______ ______ ______ -
✔✔ANSWER✔✔->>in double quotes
If you need to use two copies of ORDER_PROC, why shouldn't you give the two
copies the aliases ORDER_PROC_1 and ORDER_PROC_2? - ✔✔ANSWER✔✔-
>>If you were to use ORDER_PROC_2 as an alias it would be difficult to determine
if you are using the ORDER_PROC_2 table or if it is an alias you have assigned to
the ORDER_PROC table.
True or False. The best way to determine whether an inner join or a left outer join
should be used is the starting table's primary key. - ✔✔ANSWER✔✔-
>>False. The reporting need, load type and frequency will determine whether two
tables should be joined using a left outer join or an inner join.
,A Clarity table's primary key includes a "CSN". What does this mean? -
✔✔ANSWER✔✔->>A CSN is a Contact Serial Number, which identifies a
specific contact within a specific record. A table with a CSN in its primary key
extracts overtime data - if it extracted no-add data, you wouldn't need to identify
a contact.
A Clarity table's primary key includes a line count, What does this mean? -
✔✔ANSWER✔✔->>Only Chronicles items with a response type of multiple-
response or related group have line counts, so you know the table must extract
multiple-response or related group items.
______ ______ ______ can help you identify tables related to a table you already
know - ✔✔ANSWER✔✔->>Database Object Search
While a join decides which tables will be used, a ______ ______ tells the report
which rows from each table should be considered for use in the report. -
✔✔ANSWER✔✔->>join type
An ______ ______ will return only rows that have matches in both tables -
✔✔ANSWER✔✔->>inner join
A ______ ______ ______can be thought of visually as an inner join, plus all the
rows in the left hand table that don't have matches in the right. -
✔✔ANSWER✔✔->>Left Outer Join
A ______ ______ ______ can be thought of visually as an inner join, plus all the
rows in the right table that don't have matches in the left. Similarly, it can be
thought of as a left outer join where the tables have changed sides. -
✔✔ANSWER✔✔->>Right Outer Join
, A ______ ______ ______ will return all rows from both tables with data from
each table if available. It will include rows that have matches in either table as
well as those that don't. It can be thought of visually as everything. -
✔✔ANSWER✔✔->>Full Outer Join
There are two main ways to extract a Clarity table - using a Full Extract and
Incremental Extract. These are called ______ ______ - ✔✔ANSWER✔✔-
>>Load Types
Which Load Type truncates (deletes) any data already in the Clarity table and re-
extracts the entire table from Chronicles - ✔✔ANSWER✔✔->>Full (FULL)
What is the first step in the report writing process? - ✔✔ANSWER✔✔-
>>Analyze request for key features...
-Who needs it
-What purpose
-How much data should it return
-How up to date does the data need to be
-How does the data need to be formatted
Operational or Analytical?
Top 100 Chief Complaints in the ED - ✔✔ANSWER✔✔->>Analytical
