Qlik Sense Business Analyst Certification (2024) — Question 16

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?

Answer options

• A. FilePath, FOR EACH, Peek, Drop
• B. FileSize, IF, THEN, END IF
• C. FilePath, IF, THEN, Drop
• D. FileExists, FOR EACH, IF

Correct answer: D

Explanation

The correct answer is D because it checks for the existence of the file before attempting to upload it, which aligns with the requirement to only upload if there are changes. Options A, B, and C do not properly address the need to verify file existence and handle the upload conditionally based on that check.