QlikView 12 Data Architect Certification Sample Questions:

1. A QlikView developer has been assigned a Named User CAL. The developer is testing the same QlikView document on two different web browsers simultaneously. When switching between browsers and opening the AccessPoint this error message displays: Lost connection to server.
The system administrator finds this message in the Qlikview Server Session log file Killed because Named User CAL was needed from another client.
The administrator needs to enable the developer to test the QlikView document on two different web browsers simultaneously What should the administrator do?

A) Assign the developer a Document CAL for the duration of the testing
B) Assign the developer a Local QlikView Desktop license
C) Instruct the developer to download the QlikView document and test locally
D) Remove any Document or Named User CALs for the user so they will use Session CALs

2. A QlikView Server deployment with QlikView Publisher license has been deployed on a single server When the system reloads a specific QlikView document, users experience decreased performance while viewing QlikView documents. The system administrator determines that the QlikView document was developed correctly.
What should the administrator do to improve the performance of the system?

A) Create a cluster of at least two QlikView Distribution Services
B) Shorten the reload time of the document
C) Install the QlikView Distribution Service on another server
D) Create a cluster of at least two QlikView Servers

3. A data architect analyzes daily transaction data and wants to reduce the current reload time with the following requirements:
- The application must show five years of data including the current year
- The data is loaded from yearly QVDs except for the current year
- The current year data is obtained directly from the database s
Which two options can reduce the reload time?
(Select two.)
Response:

A) Reduce the granularity of the data
B) Load all data directly from the database
C) Load a smaller period of data directly from the database
D) Reduce the number of rows loaded into the application
E) Remove columns from the data model that are NOT required

4. All QlikView Server services are installed and configured to run on a single Windows server QlikView Publisher tasks fail intermittently, and the document log appears to stop processing without any error notifications.
To troubleshoot the issue, a Windows Performance Monitor set was configured and shows that the QVS.exe system RAM usage is extremely high QlikView Publisher reload tasks schedule cannot be altered Which three steps should the system administrator take to resolve the problem? (Select three )

A) Decrease the Working Set Low to make sure enough system RAM is available for QlikView Publisher to function
B) Edit the QlikView Publisher tasks so the distribution is set to All Authenticated Users instead of Named Users
C) Increase the Windows server system RAM
D) Increase the Windows server pagefile sys size
E) Migrate QlikView Distribution Service to a separate Windows server

5. A system administrator looks in the QMC > Status > QVS Statistics No documents are open in the QlikView Server but the memory usage of the QlikView Server (QVS) process is still above 10 GB.
Which is the cause of this behavior?

A) Cached data for unloaded documents remains in memory to decrease calculation time
B) The Object Calculation Time Limit is too high, which causes the hypercube cache to stay for too long
C) A reload is currently running that uses memory in the QlikView Server until it is finished
D) The Document Timeout setting is too high, which causes documents to never time out and unload

Solutions: