QSDA2021 by Qlik Valid Free Exam Practice Test

Question 1

Refer to the exhibit.

Refer to the exhibits.
The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, contains the teams and team members registered for specific sports.
In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.
What should the data architect do in the data load editor?

A. Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport B. Apply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field C. Apply a FOR loop to load to the MasterSports table creating the values for the Sport field

Correct Answer: C

Question 2

Refer to the exhibit.

While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis.
The data architect runs the following script to resolve this issue:

A. 3 B. 4 C. 6 D. 1

Correct Answer: B

Question 3

A data architect needs to develop a script to export tables from a model based upon rules from an independent file. The structure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.
The TableToExport values are already verified to exist in the model.
In addition, the format will always be QVD, and the copies will be incrementally numbered.
For example, the Customer table would be exported as:
What is the minimum set of scripting strategies the data architect must use?

A. One loop and one SELECT CASE statement B. Two loops without any conditional statement C. Two loops and one IF statement D. One loop and two IF statements

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 4

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 where exists (ID) B. Use Concatenate before loading the Stores table C. Use where exists (ID, StorelD)

Correct Answer: A

Question 5

Refer to the exhibit.

Refer to the exhibit.
A data architect is loading two tables: Orders and Product. The Product table includes attributes and values for each ProductID such as Colour, Price, Category, and Description.
The business analyst can filter by the value of these attributes. For performance reasons, the Data Model will use two tables.
Which solution should the data architect apply in the Data Load Editor to build the ProductDetails table?
For performance reasons, the Data Model will use two tables a Load Editor to build the ProductDetails table?

A. Use a Generic Load in the Product table and a For loop to left join each Generic table B. Use a For loop to apply a Generic load to the Product table and concatenate the generic tables together C. Use a For loop to concatenate all of the Products table and apply a Generic Load to the final concatenate table

Correct Answer: A

Qlik Sense Data Architect Certification Exam - February 2021 Release - QSDA2021 Exam Practice Test