Exam (elaborations)
Epic Crystal Reporting/Clarity/SQL Exam Questions and Answers Verified 2024
- Course
- Institution
Epic Crystal Reporting/Clarity/SQL Exam Questions and Answers Verified 2024
[Show more]
Content preview
Epic Crystal Reporting/Clarity/SQL 2024-2025Exam Questions and Answers Verified 2024
______ tables usually have names that start with "F_" - ANSWER-Derived Tables
________ usually have names that start with "V_" - ANSWER-Views
_________ _________ will contain information such as report author, report title, and
comments (Crystal) - ANSWER-Summary Information
_________ __________ the main area of the Preview tab. This is where your results
are displayed (Crystal) - ANSWER-Standard View
_________ fields perform a calculation over a group of records - ANSWER-Summary
Fields
_________ is never equal to anything - ANSWER-NULL
__________ data is extracted, transformed into tables, and loaded into Clarity -
ANSWER-Chronicles Data
__________ reports are very integrated with our workflow - ANSWER-Operational
Reports
__________ statements allow you to use logical expressions to determine values to
display in your results grid - ANSWER-CASE statements
___________ __________ allows you to jump to different pages of your results -
ANSWER-Page Controls
___________ is a relational database used to store and report on your organization's
Epic data. - ANSWER-Clarity
___________ is the programming language on which Chronicles is built - ANSWER-
Cache Script
___________ items store data directly on a record, not a specific contact - ANSWER-
No-Add Items
____________ is required with all CASE statements - ANSWER-END
____________ parameters must be used for Epic-Clarity Integration - ANSWER-Static
Parameters
,_____________ fields are used to manipulate the data to display as required on the
report - ANSWER-Formula Fields
_____________ functions change data from one type to another - ANSWER-
Conversion Functions
_____________ items store values separately on each contact, but assume that the last
value entered remains true until a new value is entered - ANSWER-Lookback Items
_____________ items store values separately on each of a record's contacts -
ANSWER-Response Each Time
________________ can run off of production data, or it can run off of your shadow data
- ANSWER-Reporting Workbench
_______allows you to view and jump to various grouping levels in your report, examine
current parameter values, and search for specific results (Crystal) - ANSWER-Preview
Panel
" " - ANSWER-Denotes literals. Any text between the quotes is printed as it appears
between the quotes
"{PAT_ENC.TEMPERATURE} F" can be displayed using a _____________. -
ANSWER-Text Object
( ) in Crystal Reports - ANSWER-Used for arguments that follow a function
[ ] in Crystal Reports - ANSWER-Denotes subscript or arrays
{ } in Crystal Reports - ANSWER-Denotes fields. All field types are enclosed in French
braces
// in Crystal Reports - ANSWER-Denotes that everything following the is a comment and
will be ignored by the formula
A ________ can allow you to quickly combine two separate groups of results -
ANSWER-Union
A _________ is a means of combining fields from two tables by using values common
to each - ANSWER-Join
A __________ is usually displayed next to fields that are part of a table's primary key
and allows you to quickly locate that field - ANSWER-Red flag
A ___________ item can hold different answers on different contacts - ANSWER-
Response Each Time
, A _____________ item can hold multiple answers on one contact - ANSWER-Multiple
Response
A date and time stored in a single item - ANSWER-Instant
A department in CLARITY_DEP is represented as one ____________. - ANSWER-Row
A prompt for a piece of information - ANSWER-Item
A single record might have many ___________. - ANSWER-Contacts
A specific entity within a master file - ANSWER-Record
A SQL query is broken out into several different ___________. - ANSWER-Clauses
A storage entity in chronicles used to organize a particular type of record - ANSWER-
Master File
A subquery is always enclosed within _____________. - ANSWER-Parentheses
A tool that extracts data from your chronicles production system, transforms it into a
relational format, and loads it onto a separate reporting server - ANSWER-Clarity
A user shows you a file they want to report on. How can you find where in chronicles
that field files to? - ANSWER-Control left-click
Allows you to assign new and temporary names to tables and columns - ANSWER-
Aliasing
An input is called a __________ and an output is called an _________. - ANSWER-
Argument; Result
Any text strings included in a formula must be____________. - ANSWER-Enclosed in
quotation marks
By default, the UNION command will return _________________. - ANSWER-Only
distinct values
By unchecking _________________ it will ensure you are only saving the report
definition. - ANSWER-Save Data with Report
Can you edit the SQL query directly in Crystal? - ANSWER-No. It is read-only.
The benefits of buying summaries with Stuvia:
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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 LUCKYSTAR2022. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81989 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now