QlikView QV12DA Exam Syllabus Topics:

QlikView 12 Data Architect Certification Sample Questions:

Question #1
A system administrator upgrades to QlikView 12. Tasks no longer start or trigger. The administrator uses Windows Task Manager to look at the environment and notices the overall CPU usage is above 75%.
Which QVDistributionService.exe.config setting should be changed to allow tasks to start?

A. Adjust the QvbWaitTimeoutMinutes value from the default value of 45 to 85
B. Adjust the CpuOverLoadLimit value from the default value of 75 to 85
C. Adjust the FileSizelnMbToCheckForFullDisc value from the default value of 20 to 85
D. Adjust the MemoryOverloadLimit value from the default value of 90 to 85

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

Question #3
A system administrator is testing a QlikView Server where the Publisher is also licensed After completing the testing phase, the system administrator wants to copy all tasks from the test environment to the production environment.
What should the system administrator do?

A. Use the Remote Management Service to set up a link in the production environment towards the test environment and pull the tasks into the production environment.
B. Create a triggered task that will export all tasks from the test environment and import these tasks in the productionenvironment using Task Dependencies
C. Export the tasks from the test environment using the QlikView Management Console and use the Paste icon to import thetasks into the production environment
D. Use the Remote Management Service to set up a link in the test environment towards the production environment and pushthe tasks to the production environment.

Question #4
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. Create a new QVW that includes the STORE command in the load script, then configure a reload/distribution task from this
B. Use the Database Command feature on the Supporting Tasks QMC page to create a new QVD file then distribute the QVD to the developers
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. Add the STORE command to the load script in an existing QVW file, then provide the QVD location to the developers

Question #5
A sales manager wants a bar chart showing a distribution of the deals displayed in $250 intervals of the profit margin. Which dimension and expression should a data architect use?
Response:

A. Dimension: =Aggr (Sum (Margin) ,OrderID) )Expression: =Count (DISTINCT OrderlD)
B. Dimension: =OrderIDExpression: =Class (Margin, 250, ,Margin, )
C. Dimension: =class (Margin, 250, ,Margin, )Expression: =Count (DISTINCT OrderlD)
D. Dimension: =class (OrderID, 250, ,Margin, )Expression: =Count (DISTINCT OrderlD)

Solutions: