Free Qlik QSDA2021 Exam Dumps Questions & Answers

Refer to the exhibit.

A data architect executes the script.
What will be the value of the first row for Field_1?

• A.  4
• B.  A
• C.  Null
• D.  D

Refer to the exhibit.

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

• A.  Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments
• B.  Remove the LineNo field from both tables and use the AutoNumber function on the OrderlC field
• C.  Create a composite key using OrdertD and LineNo
• D.  Remove the LineNo field from Shipments and use the AutoNumber function on the

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?

• A.  Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD
• B.  Open the data manager, split the Customers table, and associate both tables on CustomerlD field
• C.  Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field
• D.  Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table

Refer to the exhibit.

Which changes on the database will the script capture?

• A.  Insert. Update, and Remove rows
• B.  Insert and Update rows
• C.  Insert and Remove rows
• D.  Update and Remove rows

Refer to the exhibit.

Refer to the exhibit
A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe The script runs successfully, but the Stores table does not have any values.
What should the data architect do?

• A.  Use Concatenate before loading the Stores table
• B.  Use where exists (ID)
• C.  Use where exists (ID, StorelD)