Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. QlikView
  5. QSDA2022

QlikView QSDA2022 Exam Questions
Qlik Sense Data Architect Certification Exam - 2022 (Page 3 )

Updated On: 16-Feb-2026
Page 3 of 17
PDF with 77 Questions

A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails.
Which statement should the data architect use?

  1. $<Include=lib://TextFiles/Variables.txt);
  2. $(Must_Include=lib://TextFiles/Variables.txt);
  3. (Must_Include=lib://TextFiies/Variables.txt);
  4. (Includs=lib://TextFiles/Variables.txt);

Answer(s): B

Explanation:

The MustInclude statement provides an error if the include fails and is used when including files in Qlik Sense. The other statements do not provide an error if the include fails. https://www.qlik.com/us/-/media/files/training/global-us/qlik-sense-certification-exam-study- guide-en.pdf?la=en&hash=9DA9DEBC7D27BF1CA8373E81F2614C85 qlik-sense-certification-exam-study-guide-en.pdf
https://www.qlik.com/us/-/media/files/training/global-us/qlik-sense-certification-exam-study- guide-en.pdf?la=en&hash=9DA9DEBC7D27BF1CA8373E81F2614C85

https://community.qlik.com/t5/Support-Knowledge-Base/Talk-to-Experts-Tuesday-Migrating-from- QlikView-to-Qlik-Sense/ta-p/1746935
Talk to Experts Tuesday - Migrating from QlikView to Qlik Sense FAQ https://community.qlik.com/t5/Support-Knowledge-Base/Talk-to-Experts-Tuesday-Migrating-from- QlikView-to-Qlik-Sense/ta-p/1746935
https://www.qlik.com/us/services/training/certifications-and-qualifications Certifications & Qualifications | Qlik
https://www.qlik.com/us/services/training/certifications-and-qualifications

The $(Must_Include) statement is used to load a file or a set of files and generate an error if the load fails. The "Must_Include" function will stop the script execution if the file is not found or cannot be loaded. The correct syntax for using the "Must_Include" statement is $(Must_Include=lib://TextFiles/Variables.txt);



Refer to the exhibit.



A data architect needs to add a Budget table to the current Qlik Sense app. A Budget table with the fields Budget, CustomerlD, and ProductlD is loaded into the model.
What will be created?

  1. A circular reference with one table disconnected
  2. A synthetic table with two synthetic keys
  3. A synthetic table with three synthetic keys
  4. A synthetic table and one synthetic key

Answer(s): A

Explanation:





Refer io the exhibit.
A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A. (For example, only the row containing A, 1, 456 should be loaded from Table_B.) Which script should the data architect use?









Answer(s): B

Explanation:



A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales The sort order of the values of the fields is unknown When two or more sales people have sold the same amount, the expression should return all of those sales people Which expression should the data architect use?

  1. FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )
  2. Concat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')
  3. FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )
  4. Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')

Answer(s): D

Explanation:



Refer to the exhibits.



Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.
The app is used to analyze the number of orders by customer.
When the users create a bar chart to review the figures, the data shown is incorrect.
What should the data architect do to resolve this issue?

  1. Open the data manager, split the Customers table, and associate both tables on CustomerlD field
  2. Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field
  3. Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD
  4. Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table

Answer(s): C

Explanation:






Post your Comments and Discuss QlikView QSDA2022 exam dumps with other Community members:

Join the QSDA2022 Discussion