QlikView QV12DA Prüfungsthemen:
| Abschnitt | Gewichtung | Ziele |
|---|---|---|
| Datenarchitektur und -design | 20–25 % | - Verständnis dimensionaler Datenmodelle - Verknüpfungstabellen und zusammengeführte Tabellen - Zirkuläre Verweise und Lösungsansätze - Design von Stern- und Schneeflockenschemata - Abwägung zwischen Komplexität des Datenmodells und Leistung |
| Leistungsoptimierung | 15–20 % | - Verfahren zur Optimierung des Datenmodells - Speicherverwaltung - Verknüpfungstypen und deren Auswirkungen - Erkennung und Auflösung synthetischer Schlüssel - Analyse im Tabellenbetrachter |
| Design des Datenladeprozesses | 20–25 % | - LOAD-Anweisungen und Datentransformationen - Erstellung und Optimierung von QVD-Dateien - RESIDENT- und vorangehende Ladevorgänge - Grundlagen der Skripterstellung - Verarbeitung unterschiedlicher Datenquellen - Strategien für inkrementelle Ladevorgänge |
| Datentransformation | 20–25 % | - Kreuztabellen und Pivottabellen - Intervallabgleich - Datenqualität und -prüfung - Zuordnungstabellen und ApplyMap - Verfahren zur Datenbereinigung |
| Sicherheit und Datenverwaltung | 15–20 % | - Sicherheit auf Feld- und Zeilenebene - Empfohlene Vorgehensweisen im Bereich Sicherheit - Verfahren zur Datenreduktion - Umsetzung von Section Access |
QlikView 12 Data Architect Certification QV12DA Prüfungsfragen mit Lösungen
1. A system administrator needs to create a task that creates new QlikView documents with data associated with the Year field only. The QlikView documents need to be created using the Document Name and the values in the Year field.
What should the administrator do to meet the requirement?
A) Set the Reduced Document name field to %SourceDocumentName% %DocumentField,Year% and the Loop and Reduce with Field value field to Year
B) Set the Reduced Document name field to %SourceDocumentName% %yyyy% and the Loop and Reduce with Field value field to Year
C) Set the Reduced Document name field to %SourceDocumentName% %DocumentField,Year% and the Simple Reduce value field to Year
D) Set the Reduced Document name field to %SourceDocumentName% %yyyy% and the Simple Reduce value field to Year
2. A system administrator has a QlikView Server cluster environment. The administrator needs to configure the load balance method to direct clients to the least busy QlikView Server.
Which setting should the administrator adjust?
A) Server Cluster Name
B) Loaded Document
C) Random
D) CPU with RAM Overload
3. 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) Ensure the QlikView service account has file permissions to read the QlikView document
B) Validate the QlikView service account username and password are correct in the task
C) Add the QlikView service account to Section Access in the QlikView document
D) Enter an administrator username and password that is part of the Section Access
4. A developer requests access to an API to execute reloads from external software The developer is using NTFS security to authorize against the system Which two steps should a system administrator complete to provide the developer with the appropriate permissions? (Select two.)
A) Ensure the developer,s document can access the QlikView Management Service on TCP port 4799 if a firewall is configured
B) Ensure the QlikView Management Service runs in DMS mode and the developer,s username and password are correct
C) Turn off the firewall on the server with the QlikView Management Service
D) Add the developer to the QlikView Management API local security group on the server with the QlikView Management Service
E) Add the developer to the QlikView Administrators local security group on the server with the QlikView Management Service
5. Which three are required to configure a clustered QlikView Server deployment? (Select three )
A) Identical hardware resources for CPU and RAM
B) The same QlikView Server version build number
C) A clustered QlikView Publisher license key
D) A clustered QlikView Server license key
E) A shared storage location on the same network subnet for Root folder
Fragen und Antworten:
| 1. Frage Antwort: A | 2. Frage Antwort: D | 3. Frage Antwort: B | 4. Frage Antwort: A,D | 5. Frage Antwort: B,D,E |
1370 Kundenbewertungen
