QlikView QSDA2018 Exam Questions in PDF and Online

QUESTION: 1

A car manufacturer has several QlikView apps. The manufacturer decides to migrate some specific apps to Qlik Sense. The manufacturer wants to reuse front-end variables from the previous QlikView app.
Which strategy should a data architect use to meet these requirements?

Use the QlikView converter within the Dev Hub of Qlik Sense
Drag and drop a QVW file into the Qlik Sense hub and create a new app
Export the existing LOAD script into a QVS file for later reuse in Qlik Sense
Copy and paste the LOAD script of the existing QlikView app into the new app

Answer(s): A

Reveal Solution Next Question

QUESTION: 2

A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.
- Encounters, lab orders, and medication data are maintained in three separate tables linked by PatientID
- PatientID values in all three tables are completely accurate - Patients may have encounters without lab orders or medications The data architect needs to make sure that the count of patient lab orders is correct.
Which method should the data architect to meet this requirement?

Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(Distinct LabPatientID)
Load all three tables and use Count{Distinct PatientID)
Load all three tables and use Count(PatientlD)
Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(LabPatientlD)

Answer(s): A

Reveal Solution Next Question

QUESTION: 3

Refer to the exhibit.
A data architect needs to build a sales dashboard. Data is stored in a legacy database. The extracted data contains the date in the format, 'YYYYDDMM'
Due to the source date format, the dates are being loaded as numbers.
Which function should the data architect use to fix this issue?

Timestamp
Date
Date#
Timestamp#

Answer(s): C

Reveal Solution Next Question

QUESTION: 4

A data architect uses the Qlik GeoAnalytics connector to determine the closest airports to cities in an existing app. The built-in location servicetjenerates data for the airport locations The data load editor runs the script and sees a circular reference and a synthetic key How should the data architect fix these issues'?

When selecting an operation in the Qlik GeoAnalytics connector, select Only load distinct .
When choosing which data to load, uncheck the non-unique field in the new data tables.
Concatenate the airport table and the existing tables into one master table.
When selecting an operation in the Qlik GeoAnalytics connector, change the CRS to 'None".

Answer(s): D

Reveal Solution Next Question