Qlik qv12sa practice test

QlikView 12 System Administrator Certification Exam


Question 1

A system administrator reviews the Status > Tasks tab in the QlikView Management Console which
displays a failed reload task. Which two logs are needed to troubleshoot the problem? (Select two )

  • A. QlikView Root Log
  • B. QlikView Task Log
  • C. QlikView Document Log
  • D. QlikView WorkOrder Log
  • E. QlikView Server Event Log
Answer:

B, E

Discussions

Question 2

A system administrator needs to create a QlikView Publisher task that triggers the execution of a
Windows batch file on successful reload of a QlikView document.
Which task should the administrator create?

  • A. A Reload only task
  • B. A Loop and Reduce task
  • C. An External Program Supporting task
  • D. An Event Driven Execution (EDX) triggered task
Answer:

D

Discussions

Question 3

Which two file formats or databases are supported for the QlikView Publisher Repository? (Select
two.)

  • A. CSV
  • B. XML
  • C. MySQL database
  • D. NoSQL database
  • E. MS SQL database
Answer:

B, E

Discussions

Question 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. Increase the Windows server system RAM
  • B. Increase the Windows server pagefile sys size
  • C. Migrate QlikView Distribution Service to a separate Windows server
  • D. Decrease the Working Set Low to make sure enough system RAM is available for QlikView Publisher to function
  • E. Edit the QlikView Publisher tasks so the distribution is set to All Authenticated Users instead of Named Users
Answer:

B, D, E

Discussions

Question 5

A QlikView Server is using more than 93% of its total memory. Users report slow performance when
working within a QlikView document. The Working Set Low value is 70% and the Working Set High
value is 90%.
What is causing the performance issue on the server?

  • A. The QlikView Server PGO files have been removed
  • B. The Object Calculation Time Limit has been reached
  • C. The QlikView Server swapped physical RAM to virtual memory
  • D. The QlikView Server has begun to drop cached results from memory
Answer:

C

Discussions

Question 6

A company has three QlikView developers who lease QlikView Desktop licenses from QlikView
Server, two business analysts who access five QlikView documents on a daily basis, and a supervisor
who accesses a specific QlikView document every day.
Which CALs should be assigned to meet these requirements?

  • A. 5 Named User CALs and 1 Document CAL
  • B. 3 Named User CALs and 10 Document CALs
  • C. 2 Named User CALs, 3 Document CALs and 1 Session CAL
  • D. 3 Named User CALs, 2 Document CALs and 1 Session CAL
Answer:

D

Discussions

Question 7

A system administrator needs to open a support case for an issue related to QlikView Distribution
Service task failures. The administrator gathers the appropriate QlikView document and task log files
for support staff to analyze.
What additional information should the administrator provide for support staff to ensure optimum
response and resolution time?

  • A. QlikView system information
  • B. Example QlikView documents
  • C. Example QlikView data files (QVDs)
  • D. Meta files related to the failing QlikView documents
Answer:

B

Discussions

Question 8

A system administrator needs to deliver QlikView Data (QVD) files to developers to create new QVW
files. The QlikView deployment includes QlikView Publisher.
How should the administrator meet this requirement?

  • A. Add the STORE command to the load script in an existing QVW file, then provide the QVD location to the developers
  • B. Create a new QVW that includes the STORE command in the load script, then configure a reload/distribution task from this
  • C. Use the QVD Creation feature on the Supporting Tasks QMC page to create a new QVD file then distribute the QVD to the developers
  • D. Use the Database Command feature on the Supporting Tasks QMC page to create a new QVD file then distribute the QVD to the developers
Answer:

D

Discussions

Question 9

A system administrator needs to add resilience redundancy and increase capacity of a QlikView
Distribution Service (QDS) What should the administrator do?

  • A. Add more free disk space to the server running the QDS
  • B. Add more CPU and memory resources to the server running the QDS
  • C. Install, license and configure additional QDS nodes in a QDS Cluster
  • D. Install license and configure additional QlikView Server nodes in a QlikView Server Cluster
Answer:

C

Discussions

Question 10

A system administrator creates a task for a QlikView document with Section Access implemented.
The administrator enters the correct values into the Data Protection fields to allow the QlikView
service account to reload the file. When the task runs, it fails to reload the QlikView document
The administrator finds this error message in the QlikView distribution log file:
Error: Document open call failed. The document might require username and password.
What should the administrator do to resolve the task failure?

  • A. Add the QlikView service account to Section Access in the QlikView document
  • B. Enter an administrator username and password that is part of the Section Access
  • C. Validate the QlikView service account username and password are correct in the task
  • D. Ensure the QlikView service account has file permissions to read the QlikView document
Answer:

C

Discussions
To page 2