QSDA2024 Practice Test

A data architect needs to load data from two different databases. Additional data will be added from a folder that contains QVDs, text files, and Excel files.

What is the minimum number of data connections required?

A. Four

B. Two

C. Three

D. Five

A data architect needs to develop three separate apps (Sales, Finance, and Operations). The three apps share numerous identical calculation expressions.

The goals include:

• Reducing duplicate script
• Saving time on expression modifications
• Increasing reusable Qlik developer assets.

The data architect creates a common script and stores it on a file server that Qlik Sense can access. How should the data architect complete the requirements?

A. Macro on server

B. Execute server script

C. Include script function

D. Call batch file

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:\486396169. 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?

A. FilePath, FOR EACH, Peek, Drop

B. FileSize, IF, THEN, END IF

C. FilePath, IF, THEN, Drop

D. FileExists, FOR EACH, IF

A data architect needs to acquire social media data for the past 10 years. The data architect needs to track all changes made to the source data, include all relevant fields, and reload the application four times a day.

What information does the data architect need?

A. A field with social media source, a set of key fields to sort out updated records, configure reload task to load four times a day

B. A field with record creation time, a secondary key field to remove deleted records, configure reload task to load four times a day

C. A field with ModificationTime, a primary key field to sort out updated records, insert and append records, update records

D. A field with ModificationTime, a primary key field to sort out updated records, insert and update records, remove records

A company's analytics team is migrating from QlikView to Qlik Sense. During the transition there is an opportunity to improve overall reporting.

Which set of criteria must the data architect consider while planning for the migration?

A. Application size, application theme, storytelling, data model, IT use case

B. User sessions, source data architecture, compatibility, data model, business use case

C. QlikView archival, source data architecture, load script, data model, business use case

D. Application metadata, application theme, user sessions, load script, IT use case