QlikView QSDA2024 Exam Questions

Question 6 of 17

Refer to the exhibit.
Exam QSDA2024: Question 6 - Image 1

A data architect is provided with five tables. One table has Sales Information. The other four tables provide attributes that the end user will group and filter by.
There is only one Sales Person in each Region and only one Region per Customer.
Which data model is the most optimal for use in this situation?

Correct Answer: D

Question 7 of 17

Refer to the exhibit.
The Section Access security table for an app is shown. User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns.
Which is the result?

The table is removed from the user interface.

The user gets an ‘Incomplete visualization’ error.

The user gets a ‘Field not found’ error.

The table is displayed without the LEVEL column.

Correct Answer: D

Question 8 of 17

A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload. When data is updated, a new file is placed into a folder mapped to E:\123456789. The data connection points to this folder.
The data architect plans a script which will:
1. Verify that the file exists
2. If the file exists, upload it. Otherwise, skip to the next piece of code.
The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure. Which option should the data architect use to meet these requirements?

FilePath, FOR EACH, Peek, Drop

FileSize, IF, THEN, END IF

FilePath, IF, THEN, Drop

FileExists, FOR EACH, IF

Correct Answer: D

Question 9 of 17

Refer to the exhibit.
Exam QSDA2024: Question 9 - Image 1

A system creates log files and csv files daily and places these files in a folder. The log files are named automatically by the source system and change regularly. All csv files must be loaded into Qlik Sense for analysis.
Which method should be used to meet the requirements?

SET vFileList = 'Day1','Day2','Day3';
FOR EACH vFile in $(vFileList)
LOAD * FROM [lib://Data (User1) /multi/$(vFile).csv];
NEXT

LOAD *
FROM [lib://Data (User1)/multi/*]
(csv);

LOAD *
FROM [lib://Data (User1)/multi/*]
(txt)

SET vLib = chr(39) & 'lib://Data (User1)/multi/*.csv' & chr(39);
FOR EACH File in filelist($(vLib))
LOAD * FROM [$(File)];
NEXT

Correct Answer: B

Question 10 of 17

Refer to the exhibit.
Exam QSDA2024: Question 10 - Image 1

A data architect is loading the tables and a synthetic key is generated.
How should the data architect resolve the synthetic key?

Remove the LineNo field from Shipments and use the AutoNumber function on the OrderID field

Remove the LineNo field from both tables and use the AutoNumber function on the OrderID field

Create a composite key using OrderID and LineNo

Create a composite key using OrderID and LineNo, and remove OrderID and LineNo from Shipments

Correct Answer: C