QlikView-System-Administrator Exam Information and Guideline
QlikView System Administrator Certification 2025
Below are complete topics detail with latest syllabus and course outline, that will help you good knowledge about exam objectives and topics that you have to prepare. These contents are covered in questions and answers pool of exam.
Exam Name: QlikView System Administrator
Exam Format: Multiple-choice, scenario-based questions
Number of Questions: ~40-60 questions
Duration: ~60-90 minutes (varies by exam version)
Passing Score: ~70-75% (varies)
Delivery Method: Online proctored or at a Pearson VUE test center
1. QlikView Architecture and Components
- QlikView Server Architecture: Understanding the role of the QlikView Server, Publisher, and other components.
- QlikView Desktop vs. QlikView Server: Differences and use cases.
- QlikView Services:
- QlikView Distribution Service (QDS)
- QlikView Management Service (QMS)
- QlikView Web Server (IIS/Apache integration)
- Repository: Storage of metadata, security rules, and document settings.
- Cluster Services: Scalability and high availability configurations.
- QMC (QlikView Management Console) – Web-based admin interface for managing QlikView deployments.
- QVS (QlikView Server) – Core service for serving QlikView documents.
- QDS (QlikView Distribution Service) – Handles scheduled reloads and distribution.
- QVP (QlikView Publisher) – Manages task distribution and reloads.
- DSC (Document Storage Container) – Stores QVW files in a clustered environment.
2. Installation and Configuration
- System Requirements: Hardware, software, and OS compatibility.
- Installation Modes: Standalone, distributed, and clustered setups.
- License Management: Types of licenses (Named, CAL, Document, etc.).
- Port Configuration: Default and custom ports (4747, 4799, 80/443).
- Security Configuration: HTTPS setup, certificate management.
- Load Balancing: Configuring for high availability.
- CAL (Client Access License) – Types: Professional, Analyzer, User, Session.
- FQDN (Fully Qualified Domain Name) – Required for proper clustering.
- Service Principal Name (SPN) – Used for Kerberos authentication.
- QlikView Cluster – Multiple QVS instances working together.
3. Security and Authentication
- Authentication Methods:
- Windows Integrated (NTLM, Kerberos)
- Header-based (Proxy, SAML, LDAP)
- DMS (Directory Services Connector)
- Section Access: Dynamic data reduction based on user roles.
- Security Rules: Managing access in QMC (folders, streams, documents).
- Audit Logging: Tracking user activities and system changes.
- Data Security: Row-level security, document-level security.
- Section Access – Script-based security for row-level restrictions.
- DMS (Directory Services Connector) – Syncs AD/LDAP with QlikView.
- NTFS Permissions – File-level security for QVW documents.
- JWT (JSON Web Token) – Used in modern authentication flows.
4. Server Management and Optimization
- Task Management: Reload tasks, distribution tasks, and triggers.
- Performance Tuning:
- RAM optimization (Document Cache, RAM thresholds)
- CPU utilization (Multicore support)
- Logging and Monitoring:
- QlikView logs (Server, Publisher, DSC)
- Performance counters (CPU, memory, disk I/O)
- Scaling Strategies: Vertical vs. horizontal scaling.
- Backup and Recovery: Disaster recovery planning.
- Document Cache – Stores frequently accessed QVWs in memory.
- RAM Peak – Maximum memory usage before unloading documents.
- QlikView Scheduler – Manages reload tasks.
- QlikView Scalability Services (QSS) – Enables clustering.
5. Deployment and Distribution
- QlikView Publisher: Configuring distribution tasks.
- Reload Triggers: Time-based, event-based, or dependency-based.
- Distribution Methods: Email, file system, FTP, and SharePoint.
- Delta Loads: Incremental data updates.
- QlikView Extensions: Customizing deployments.
- Delta Load – Partial reloads to update only new/changed data.
- QVX (QlikView Data Exchange) – Used for optimized data loads.
- Task Chains – Sequential execution of reload tasks.
- Static and Dynamic Recipients – Email distribution options.
6. Troubleshooting and Maintenance
- Common Errors: License issues, memory errors, connectivity problems.
- Log Analysis: Debugging using QlikView logs (Trace, Error, Audit).
- Recovery Procedures: Restoring corrupted documents/services.
- Patch Management: Applying updates and hotfixes.
- Support Resources: Qlik Community, Helpdesk, Knowledge Base.
- QlikView Diagnostic Tool (QDT) – Collects logs for troubleshooting.
- Memory Leak – Unreleased RAM causing performance issues.
- QVF (QlikView File Format) – Backup format for documents.
- Hotfix – Patch for specific bugs or vulnerabilities.
7. Integration with Other Systems
- Qlik Sense Integration: Co-existing with QlikView.
- Database Connectivity: ODBC, OLE DB, REST APIs.
- Cloud Deployments: AWS, Azure, or hybrid setups.
- Third-Party Tools: PowerShell scripting, monitoring tools (Splunk, Nagios).
- ODBC (Open Database Connectivity) – Standard database connection.
- REST API – Used for automation and integrations.
- Hybrid Deployment – Mix of on-premise and cloud hosting.