QlikView QSDA2018 - Qlik Sense Data Architect Certification Exam Exam

Page:    1 / 10   
Total 50 questions

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

  • A. Use the QlikView converter within the Dev Hub of Qlik Sense
  • B. Drag and drop a QVM file into the Qlik Sense hub and create a new app
  • C. Export the existing LOAD script into a QVS file for later reuse in Qlik Sense
  • D. Copy and paste the LOAD script of the existing QlikView app into the new app.


Answer : D

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?

  • A. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(Distinct LabPatientID)
  • B. load all three tables and use Count(Distinct PatientID)
  • C. load all three tables and use Count(PatientID)
  • D. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use count (LabPatientID)


Answer : D

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, ג€˜YYYDDMMג€™. Due to the source date format, the dates are being loaded as numbers.
Which function should the data architect use to fix this issue?

  • A. Timestamp
  • B. Date
  • C. Date#
  • D. Timestamp#


Answer : C

A data architect uses the Qlik GeoAnalytics connector to determine the closest airports to cities in an existing app. The built location generates 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?

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


Answer : D

Refer to the exhibits.





Which corrective action should be taken to achieve the expected view?

  • A. Alias one of the fields in the Orders table.
  • B. Use distinct in the LOAD statement.
  • C. Use Upper () to align the SalesPerson fields.
  • D. Add a link table.


Answer : C

Page:    1 / 10   
Total 50 questions