QLIK SENSE DATA ARCHITECT (QSDA2018) CERTIFICATION EXAM SAMPLE QUESTIONS AND PROVEN ANSWERS

QLIK SENSE DATA ARCHITECT
(QSDA2018) CERTIFICATION EXAM
SAMPLE QUESTIONS AND PROVEN
ANSWERS

What should the data architect do?



a) Open the debugger, set number of lines to 100, and click Run

b) Insert a breakpoint at the LOAD command, open the debugger, and 0 step through the code

c) Open the debugger, check Limited Load, and click Run

d) Create a smaller data set in the database to load into the app ANSW✅✅Answer:

c) Open the debugger, check Limited Load, and click Run



02. The Human Resources department sends the data architect an Employees table with newly hired
employees in a monthly spreadsheet.

The spreadsheet always has the same data structure and fields, but sometimes includes duplicates
of previously hired employees. The data architect must load the Employees table into the data
model each month, without duplication of the records.

Which action should the data architect take to meet this requirement?



a) Load the first Employees table and perform a full OUTER JOIN with the latest Employees table to
the original.

b) Load the first Employees table, updating the next month's Employees table using WHERE NOT
EXISTS clause.

c) Load the Employees table by concatenating the latest Employees table to the previous month's
table.

d) Load the Employees table each month and LEFT JOIN the current table to the previous month's
table. ANSW✅✅Answer:

b) Load the first Employees table, updating the next month's Employees table using WHERE NOT
EXISTS clause.