QlikView QV_Developer_01 Prüfungsthemen:
| Abschnitt | Gewichtung | Ziele |
|---|---|---|
| Thema 1: Bereitstellung und Sicherheit | 15% | - Dokumentieren von Sicherheitskonzepten - Implementierung von Section Access - Aspekte der Anwendungsoptimierung und -bereitstellung |
| Thema 2: Diagramme und Ausdrücke | 20% | - Erstellen von Diagrammausdrücken - Erstellen von berechneten Dimensionen und Kennzahlen - Verwenden von Set-Analyse und Aggregationsfunktionen |
| Thema 3: Datenmodellierung | 25% | - Verwalten von synthetischen Schlüsseln und Zirkelverweisen - Entwerfen logischer und effizienter Datenmodelle - Optimieren von Verknüpfungen zwischen Tabellen |
| Thema 4: Datentransformation | 20% | - Verwenden von Funktionen und Ausdrücken zur Datenbearbeitung - Implementieren von inkrementellen und optimierten Ladevorgängen - Laden und Transformieren von Daten mithilfe von Skripten |
| Thema 5: Anwendungsdesign | 20% | - Gestalten benutzerfreundlicher Oberflächen - Implementieren von Variablen und bedingten Darstellungen - Erstellen von Blättern und Objekten |
QlikView 11 Developer Certification Examination QV_Developer_01 Prüfungsfragen mit Lösungen
Refer to the exhibit to the right.
When the script displayed in the exhibit is reloaded, an error message is displayed.
Table not found
Left Join (SalesPerson)
LOAD ID,
DepartmentID
FROM
[DataSourceA.xlsx]
(ooxml, embedded labels, table is SalesPersonDepartment);
What is the likely cause of the error?
- A. The Left Join statement fails to correctly quote the referenced table name, such as Left Join ("SalesPerson").
- B. There is an error in the Customer table load and it is not created in memory.
- C. When loaded, the SalesPerson table is auto concatenated to Customer and does not exist when referenced.
- D. The Left Join statement fails to correctly bracket the referenced table name, such as Left Join ([SalesPerson]).
Antwort: C 🗳️
A customer has sales data containing a fact table, Sales and dimension tables, Customer, Item, and Vendor.
After loading the data, the Entity Relationship Diagram (ERD) has a synthetic table containing the fields Name and Address from the Vendor and Customer tables.
How can a developer eliminate the synthetic keys and appropriately link the data?
- A. alias all primary key fields
- B. qualify all tables and then unqualify all key fields
- C. left join the Customer data onto the Sales table
- D. qualify all tables
Antwort: B 🗳️
A customer specified that the QlikView application should be designed to fit a screen resolution of 1280 x 800 as a standard.
Which option will assist a designer while creating the user interface?
- A. Go to Settings menu > User Preferences > Design Tab and select Display Grid Lines
- B. Go to View menu > Fit Zoom to Window > 1280 x 800
- C. Go to View menu > Resize Window > 1280 x 800
- D. Go to Settings menu > User Preferences > Design Tab and select 1280 x 800
Antwort: C 🗳️
A customer has 30 target values that are used to evaluate the quality of an organization's facilities. At least half the target values are changed monthly by the business users.
What is the most efficient way for the developer to store, access, and maintain the target values?
- A. create a Variables tab in the load script and use 30 LET statements to assign the values to variables
- B. save the target names and values in an external file, load them into a QlikView table, and use a FOR loop to assign the values to variables
- C. manually create a variable for each value in Expression Overview and maintain them in Expression Overview
- D. embed the target values into each expression in which they are required
Antwort: B 🗳️
A Straight Table Chart calculates several metrics for each individual alphanumeric transaction detail record (TRAN_ID) and its Amount over several years of data. The calculation time for the chart is over two minutes.
How can a designer decrease the calculation time for the chart without compromising core functionality?
- A. create a Calculation Condition. =sum(Amount) > 0
- B. create a Calculation Condition. =TRAN_ID < 10000
- C. create a Calculation Condition. =sum(TRAN_ID) <= 10000
- D. create a Calculation Condition. =count(TRAN_ID) <= 10000
Antwort: D 🗳️
1255 Kundenbewertungen
