100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
CLR110 Clarity Data Model Fundamentals CORRECT QUESTIONS & SOLUTIONS(GRADED A) $12.99   Add to cart

Exam (elaborations)

CLR110 Clarity Data Model Fundamentals CORRECT QUESTIONS & SOLUTIONS(GRADED A)

 7 views  0 purchase
  • Course
  • CLR110 Clarity Data Model Fundamentals
  • Institution
  • CLR110 Clarity Data Model Fundamentals

Compared to views, derived tables generally take less time to run because the data has been stored on the DB - ANSWER True, views are saved queries, their use can affect performance. Derived tables are stored procedures and thus perform better Which tools can be used to learn more about Clarity ...

[Show more]

Preview 3 out of 25  pages

  • November 6, 2024
  • 25
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • CLR110 Clarity Data Model Fundamentals
  • CLR110 Clarity Data Model Fundamentals
avatar-seller
shantelleG
CLR110 Clarity Data Model Fundamentals CORRECT
QUESTIONS & SOLUTIONS(GRADED A)

Compared to views, derived tables generally take less time to run because the data has been stored on
the DB - ANSWER True, views are saved queries, their use can affect performance. Derived tables are
stored procedures and thus perform better



Which tools can be used to learn more about Clarity tables and columns? - ANSWER Analytics catalog

Database object search

Column search

Clarity Dictionary on the



A lab manager tells you he wants a report on lab specimens, and shows you the field where he can input
various information. What method would you use to find the INI + Item numbers of the data

he's looking for? - ANSWER Ctrl + Click



I IDM 130 is a networked item that is not filled in for this record. What value will be extracted to Clarity
for this item, and other Chronicles items that are not filled out? - ANSWER Null



What value will be extracted to Caboodle for this item, and other networked items that are not filled out
in Chronicles? - ANSWER if the column is a key column, Caboodle will have a ‐1 letting report writers
know that this value was not populated in the source, while still enforcing referential integrity.



T/F columns that are non primary keys contain null values - ANSWER True, even foreign key may be null.



Why do null values exist in Clarity - ANSWER Not all fields are populated in Chronicles

ETL data cleansing deletes incorrectly formatted data

Data is deprecated y no longer extracted

,!Appendix E: Record Viewer Tip Sheet contains more information on the filtering options available in the
record viewer - ANSWER



Item Editor - ANSWER Shows the definition of chronicle items.

Shows information about how the item behaves for all values



Hot Keys - ANSWER Opening Chart Search - Ctrl + Space



What is a category list? - ANSWER a list of defined values that can be stored in a Chronicles item



Benefits and limitations of using category as a filter - ANSWER 1. more efficient

2. cannot only see first 100 values in item editor - must use category list maintenance to see complete
list



add types - ANSWER no add

response each time

lookback



what is an add type - ANSWER describes how long a piece of data is valid



no add - ANSWER considered true for all cases.

if changed then old value is replaced

example: SSN, birthday



response each time - ANSWER data stored separate on each contact record

if blank then it is considered unknown

example: weight, blood pressure



lookback - ANSWER store each item separately but if blank considers last value to be true

, Example: age, address



No‐Add - ANSWER add type

stored on record, not contact.

considered true for all contacts



!Since both respond each time and lookback items store data on the contact, these add types are
referred to as overtime add types.

No‐Add data is stored at the record level Overtime data is stored at the contact level. - ANSWER



Response Each Time - ANSWER Response type

stored separately on each of the records contacts

if blank, should be considered unknown



Lookback - ANSWER add type

stored separately on each contact

assume that last value entered remains true



Response Type - ANSWER determines how many lines an item can hold at one time

- Single Response

- Multiple Response

- Related Group



!Since both multiple response and related group items store more than one type of data, these response
types may collectively be referred to as multiple response types.



Single data stores one line of data, while Multiple data stores multiple lines of data. - ANSWER



A clinical administrator requests a query to include data for a patient's registries. She's not sure of the INI
and Item number, but she knows patient is on the Lung Cancer Screening registry. What

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller shantelleG. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $12.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

67096 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$12.99
  • (0)
  Add to cart