Qlik QSDA2018 Prüfungsthemen:
| Abschnitt | Gewichtung | Ziele |
|---|---|---|
| Datentransformationen | 38% | - Verarbeitung von Datumsangaben und Strukturierung von Inhalten - Erstellung von Skripten und Behandlung von Nullwerten - Skripterstellung für das inkrementelle Laden von Daten |
| Prüfung und Validierung | 6% | - Validierung und Prüfung von Skripten - Methoden zur Datenvalidierung |
| Entwurf des Datenmodells | 28% | - Ermittlung von Kennzahlen und Merkmalen - Optimierung und Gestaltung des Modells |
| Ermittlung der Anforderungen | 20% | - Ermittlung der beteiligten Interessengruppen und der zu erfassenden Kennzahlen - Festlegen des Detaillierungsgrads sowie der erforderlichen Sicherheitsmaßnahmen - Festlegen der zentralen Geschäftsanforderungen |
| Datenanbindung | 8% | - Auswahl geeigneter Verbindungsmethoden - Ermittlung der Datenquellen und Connectors |
Qlik Sense Data Architect Certification Exam - June 2018 Release QSDA2018 Prüfungsfragen mit Lösungen
A health system needs to analyze patient admissions and discharges in a chart with a common date axis that looks like the chart below.
The initial data table (InpatientEncounters) contains a patient admission date and a discharge date for each patient encounter. The data architect will use set analysis to calculate the number of admissions and discharges in the chart.
The data architect needs to design a data model with a minimum number of tables. Which tables should the data architect create to meet these requirements?
- A. DateLink and CommonCalendar
- B. DateLink, AdmissionCalendar. and DischargeCalendar
- C. AdmissionCalendar and DischargeCalendar
- D. AdmissionCalendar, DischargeCalendar, and CommonCalendar
Antwort: D 🗳️
Refer to the exhibit.
One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet The Region field only has values for the first record for the region. The data architect must perform a transformation so that each row contains the correct Region.
Which function should the data architect implement to resolve this issue?
- A. CrossTable
- B. Above
- C. Previous
- D. IntervalMatch
Antwort: D 🗳️
A data architect needs to develop three separate apps (Sales, Finance, and Operations). The three apps share numerous identical calculation expressions.
The data architect wants to reduce duplicate script, save time on expression modifications, and increase reusable Qlik developer assets.
The data architect creates a common script and stores it on a file server that Qlik Sense can access.
How should the data architect complete the requirements'?
- A. Macro on server
- B. Call batch file
- C. Include script function
- D. Execute server script
Antwort: C 🗳️
Refer to the exhibit.
A data architect has two tables that contain Sales and Target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeelD.
The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for Target are too high, and employees with NO sales should be excluded Which function should the data architecwise to resolve these issues?
- A. Inner Join
- B. Left Join
- C. Outer Join
- D. Left Keep
Antwort: D 🗳️
Refer to the exhibit.
A fashion retail company needs to analyze data about product inventory. The company needs to filter by attributes by such as color, material, and size.
Which strategy should a data architect use to meet these requirements?
- A. Loop through the table to transpose fields
- B. Use the hierarchy load statement to expand hierarchy levels
- C. Turn data rows into fields by using a generic load
- D. Use crosstable in the load statement to unpivot
Antwort: C 🗳️
0 Kundenbewertungen
