Online Access Free QV12DA Practice Test

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

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.Shorten the reload time of the document
• B.Create a cluster of at least two QlikView Servers
• C.Install the QlikView Distribution Service on another server
• D.Create a cluster of at least two QlikView Distribution Services

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: =OrderIDExpression: =Class (Margin, 250, ,Margin, )
• B.Dimension: =class (OrderID, 250, ,Margin, )Expression: =Count (DISTINCT OrderlD)
• C.Dimension: =Aggr (Sum (Margin) ,OrderID) )Expression: =Count (DISTINCT OrderlD)
• D.Dimension: =class (Margin, 250, ,Margin, )Expression: =Count (DISTINCT OrderlD)

A system administrator receives reports that assigned CALs have disappeared Which file should the system administrator restore from backup?

• A.Settings.ini
• B.Meta file
• C.LEF
• D.PGO file

A QlikView document contains Section Access and reduces the data to the users based on usernames When opening the documents all users are still able to see all data without any reductions.
Which QlikView Desktop setting is causing this result?

• A.Initial Selection Based on Section Access is unchecked
• B.Strict Exclusion is unchecked
• C.Initial Selection Based on Section Access is checked
• D.Initial Data Reduction Based on Section Access is unchecked