Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home QlikView QSDA2018

QlikView QSDA2018 Exam Practice Questions (P. 1)

  • Full Access (50 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
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?
  1. A
    Use the QlikView converter within the Dev Hub of Qlik Sense
  2. B
    Drag and drop a QVM file into the Qlik Sense hub and create a new app
  3. C
    Export the existing LOAD script into a QVS file for later reuse in Qlik Sense
  4. D
    Copy and paste the LOAD script of the existing QlikView app into the new app.

Correct Answer:
D

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?
  1. A
    Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(Distinct LabPatientID)
  2. B
    load all three tables and use Count(Distinct PatientID)
  3. C
    load all three tables and use Count(PatientID)
  4. D
    Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use count (LabPatientID)

Correct Answer:
D

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, '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?
  1. A
    Timestamp
  2. B
    Date
  3. C
    Date#
  4. D
    Timestamp#

Correct Answer:
C

Question #4
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?
  1. A
    When selecting an operation in the Qlik GeoAnalytics connector, select Only load distinct.
  2. B
    When choosing which data to load, uncheck the non-unique field in the new data tables.
  3. C
    Concatenate the airport table and the existing tables into one master tables.
  4. D
    When selecting an operation in the Qlik GeoAnalytics connector, change the CRS to ג€Noneג€.

Correct Answer:
D

Question #5
Refer to the exhibits.




Which corrective action should be taken to achieve the expected view?
  1. A
    Alias one of the fields in the Orders table.
  2. B
    Use distinct in the LOAD statement.
  3. C
    Use Upper () to align the SalesPerson fields.
  4. D
    Add a link table.

Correct Answer:
C

Next Questions

All Pages