A designer needs to create a chart displaying the number of patients currently checked into a hospital by
age group.
What is the appropriate Dimension for the chart?
A. number of patients
B. checked-in status
C. hospital
D. age group
A customer needs multi-language support for a QlikView application. The languages that need to be
supported immediately are English, German, and Dutch; in the future, however, additional languages may
be needed.
Which solution should a developer use to meet the customer's needs?
A. a separate document for each language
B. variables for language-specific items and the option to select a specific language in a field
C. a language definition table in the data model containing all descriptions for each language, and the option to select a specific language in a field
D. a language definition table in the data model containing all descriptions for each language, automatically linking the business user to a language
Refer to the exhibit below.
A QlikView report does not match the legacy report it was designed to replace. The purpose of the report
is to count the number of customers per year and in total.
Why is there a difference between the Total row values in the two reports?
A. The legacy report calculates the total customer occurrences, while the QlikView report counts only distinct customers.
B. The legacy report calculates the total customer occurrences, while the QlikView report calculates the customer ranking.
C. The legacy report totals the number of customers correctly, while the QlikView report is dropping records.
D. The legacy report totals the number of customers correctly, while the QlikView total row is set to sum of rows.
A project to develop a QlikView application for a customer requires splitting developers into two teams.
One team will focus on developing source database query knowledge to create a reusable data layer.
There are several application-specific business rules for this project. The customer needs to incrementally
accumulate history for the QlikView application over time.
The second team will focus on developing the presentation layer. This team also has data modeling and
scripting expertise, but does not have source database query knowledge.
Which data loading strategy should the developers use on the project?
A. create a series of QVWs that apply the business rules and then binary load them into the presentation layer QVW
B. create the presentation layer QVW and connect directly to the source data and apply the business rules in the script
C. create QVDs of the source data and load them into the presentation layer QVW and apply the business rules in the script
D. create QVDs of the source data, apply the business rules and store a second layer of QVDs, and then load these QVDs into the presentation layer QVW
A customer needs a better understanding of inventory trends over time. However, the source database
contains only the current product inventory levels.
Which technique will take advantage of QlikView capabilities to meet the customer's needs?
A. using a QlikView script to store an accumulation of periodic snapshots to a table in the source database
B. using a QVD file to store an accumulation of periodic snapshots from the source database
C. using a QVX file to store an accumulation of periodic snapshots from the source database
D. using a QlikView script to store an accumulation of periodic snapshots to an XML file
Refer to the exhibit to the right.
A customer has two databases containing employee data for different regions. Based on the script displayed in the exhibit, what will be the resulting table schema?
A. one table named Employees_US
B. one table named Employees_UK
C. two tables named Employees_US and Employees_UK with no associations
D. two tables named Employees_US and Employees_UK with a synthetic key
A customer specified that the QlikView application should be designed to fit a screen resolution of 1280 x
800 as a standard.
Which option will assist a designer while creating the user interface?
A. Go to View menu > Reselect Window > 1280 x 800
B. Go to View menu > Fit Zoom to Window > 1280 x 800
C. Go to settings menu > User Preferences > Design Tab and select 1280 x 800
D. Go to settings menu > User Preferences > Design Tab and select Display Grid Lines
How can a designer display the field selections that have been made within a chart caption?
A. by inserting a Current selections box into the Text in Chart B. by using an expression with GetCurrentselections in the Window Title option on the General tab
C. by using an expression with SET Analysis and the system Fields in the Title Text option on the Caption tab
D. by selecting show Current selections on the Caption tab
A customer needs an application to reload in a short time period. The source tables are log files that are
appended to on a daily basis.
Which performance tuning option should a developer use?
A. the QVD files to store the source tables
B. the Partial Reload command with the append option
C. the Load prefix Buffer with the incremental option
D. the Load prefix Buffer and set the Keep Outdated QVD Buffers in the Document Properties
Which technique should a developer use to clearly describe dimensions and measures for end users who need to use collaborative objects?
A. add field metadata tags to fields in the load script
B. put a How To sheet in the application
C. put descriptive information in each object's help text
D. add a system table to the application