Practice QSDA2021 Questions With Certification guide Q&A from Training Expert TestSimulate

Free Qlik QSDA2021 Test Practice Test Questions Exam Dumps

NEW QUESTION # 10
A data architect needs to develop multiple apps for various departments. More departments are requesting apps over time The company uses specific requirements for the number interpretation variables (e.g., ThousandSep, DecimalSep) found at the beginning of a LOAD script.
The data architect wants to reduce duplicate scripts but does not want to copy and paste the number interpretation variables each time new app is created. The data architect prefers to use the least amount of script in Qlik Sense.
How should the data architect meet these requirements?

• A. Create an Excel file with the number interpretation variables and use a FOR Next loop to load the variables into Qlik Sense
• B. Create an Excel file with the number interpretation variables and apply the variables to the app using a mapping table
• C. Save the script for the number interpretation variables in a text file and use the CALL function to insert the variables.
• D. Save the script for the number interpretation variables in a text file and INLUDE function to insert the variables

Answer: D

Explanation:
This method involves saving the script for the number interpretation variables in a separate text file, and then using the INCLUDE function to insert the variables into each new app script that is created. This reduces the need to copy and paste the number interpretation variables each time a new app is created and allows the data architect to use the least amount of script in Qlik Sense.
The INCLUDE function is a script statement that allows you to insert the contents of one script file into another script file. This can be used to insert common scripts, such as the number interpretation variables, into multiple app scripts.

NEW QUESTION # 11
Refer to the exhibit.

A Human Resources Director needs an app to analyze organizational structure. The Directory is particularly interested in the longest levels of line management.
Two table loads are required. Both use the same basic structure.

Which two table load prefixes are needed?

• A. * HierarchyBelongsTo(ManagerlD, Manager, ManagerlD, ManagerlD, Manager Level)
  * Hierarchy(EmployeelD, ManagerlD, Name. Manager Name, Structure '/' Depth)
• B. * HierarchyBelongs.To(EmployeeID, ManagerlD, Name ManagerlD, Manager, Depth)
• C. * HierarchyLevel(EmployeelD, ManagerlD Name Level, '/', Structure)
  * HierarchyBelongsTo(EmployeelD, ManagerlD, Name ManagerlD, Manager, Depth)
• D. * Hierarchy(EmployeelD. ManagerlD Name, Manager Name, Structure V, Depth)
  * HierarchyLevelEmployeelD, ManagerlD, Name, Manager, Name, Structure, Depth '/')

Answer: B

NEW QUESTION # 12
A data architect of an organization that has implemented Qlik Sense on Windows needs to load large amounts of data from a database that is continuously updated New records are added, and existing records get updated and deleted. Each record has a LastModified field.
All existing records are exported into a QVD file. The data architect wants to load the records into Qlik Sense efficiently.
Which steps should the data architect take to meet these requirements?

• A. 1. Use a partial LOAD to load new and updated data from the database.
  2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records
  3. Use the PEEK function to remove the deleted rows
• B. 1. Load the existing data from the QVD
  2. Load new and updated data from the database Concatenate with the table loaded from the QVD.
  3. Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records
• C. 1 Load the existing data from the QVD
  2. Load the new and updated data from the database without the rows that have just been loaded from the QVD and concatenate with data from the QVD
  3. Load all records from the key field from the database and use an INNER JOIN on the previous table
• D. 1 Load the new and updated data from the database.
  2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records.
  3. Load all records from the key field from the database and use an INNER JOIN on the previous table.

Answer: D

NEW QUESTION # 13
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. Create a composite key using OrdertD and LineNo
• C. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlC field
• D. Remove the LineNo field from Shipments and use the AutoNumber function on the

Answer: A

NEW QUESTION # 14
Refer to the exhibits.

A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?

• A. Leverage a FOR loop between the start date and end date of the master calendar Use the MATCH function to add the currency conversion rates to the master calendar
• B. Utilize INTERVALMATCH to load the currency conversion rate between dates the conversation changed INNER JOIN the resultant table back into the master calendar
• C. OUTER JOIN the calendar with the currency conversion table
  ORDER BY the date and use the PEEK function to fill in blank values
• D. Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table

Answer: C

NEW QUESTION # 15
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. 0
• B. 1
• C. 2
• D. 3

Answer: C

NEW QUESTION # 16
Refer to the exhibit.

A data architect is working on a Qlik Sense app the business has created to analyze the company orders and shipments. To understand the table structure, the business has given the following summary:
* Every order creates a unique orderlD and an order date in the Orders table
* An order can contain one or more order lines one for each product ID in the order details table
* Products in the order are shipped (shipment date) as soon as tliey are ready and can be shipped separately
* The dates need to be analyzed separately by Year Month, and Quarter
The data architect realizes the data model has issues that must be fixed.
Which steps should the data architect perform?

• A. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table
  2. Delete the ShipmentID in the Orders table
  3 Delete the ProductID and OrderlD in the Shipments table
  4. Concatenate Orders and OrderDetails
• B. 1. Create a key with OrderlD and ProductID in the OrderDeta Is table and in the Shipments table
  2. Delete the ShipmentID in the Orders table
  3. Delete the ProductID and OrderlD in the Shipmi
  4. Left join Orders and OrderDetails
  5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate
• C. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Orders table
  2. Delete the ShipmentID in the Shipments table
  3. Delete the ProductID and OrderlD in the OrderDetails table
  4. Concatenate Orders and OrderDetails
  5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate
• D. 1. Create a key with OrderlD and ProductID in the OrderDetails tab e and in the Orders table
  2. Delete the ShipmentID in the Shipments table
  3. Delete the ProductID and OrderlD in the OrderDetails
  4. Left join Orders and OrderDetails
  5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

Answer: A

NEW QUESTION # 17
Refer to the exhibit.

A data architect is creating an app using three tables. After executing the script, a warning displays Which two steps should the data architect do to resolve this warning? (Select two.)

• A. insert "Join (ProductDetails)" in front of the Load statement in line 24 to combine ProductPriceList with ProductDetails
• B. Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.
• C. Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line 24).
• D. Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).

Answer: D

NEW QUESTION # 18
A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.
These systems identify employees differently Employees in the HR system are identified with an alpha-numeric key Employees in the Sales system are identified using an integer key.
The Human Resources manager creates a table that maps these keys to another, called Associations.
The resultant data model must meet the following requirements:
* Associations must be valid
* The model must be optimized for performance
* The option must support multiple tables added
Which solution should the data architect use to meet these requirements?

• A. MAP EmloyeeKey USING Associations;
• B. MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;
• C. RENAME FIELDS USING Associations;
• D. APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;

Answer: A

Explanation:
The MAP function maps the EmployeeKey in the Sales system to the EmployeeKey in the HR system using the Associations table. This allows the data architect to join the data from the Sales system and the HR system using the same key, ensuring that the associations are valid.
Using the MAP function also optimizes the performance of the data model as it eliminates the need for multiple joins between the data from the Sales and HR systems.
This solution also supports multiple tables added, as the MAP function can be applied to any table that needs to be joined with the HR system data.

NEW QUESTION # 19
A company has a stream with multiple apps One of the apps is a multi-regional sales app.
A data architect must set up security for users to access the stream, enter the app, and view specific sheets and data.
Which features should the data architect use to meet these requirements?

• A. Section access and sheet properties
• B. QMC security rules and custom properties
• C. Section access and set analysis
• D. QMC security rules and section access

Answer: D

NEW QUESTION # 20
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 two IF statements
• B. Two loops without any conditional statement
• C. Two loops and one IF statement
• D. One loop and one SELECT CASE statement

Answer: D

Explanation:
The data architect will need to use a single loop to iterate through the rows of the independent file containing the export rules. Within the loop, they will need to use a SELECT CASE statement to determine which table in the model to export based on the TableToExport value in the current row of the independent file. They can then use the StoreAsFilename value to determine the target root filename, and the NumberOfCopies value to determine the number of copies to export.
This approach makes use of a single loop to iterate through the rows of the independent file, and a SELECT CASE statement to determine which table to export based on the TableToExport value in the current row. It is the most efficient way to accomplish the task with minimal scripting.
You can find the Qlik scripting documentation for Store statement here: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Store.htm and SELECT CASE statement here: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptStatements/Select.htm

NEW QUESTION # 21
A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales The sort order of the values of the fields is unknown When two or more sales people have sold the same amount, the expression should return all of those sales people Which expression should the data architect use?

• A. FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )
• B. FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )
• C. Concat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')
• D. Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')

Answer: D

NEW QUESTION # 22
Refer to the exhibit.

A data architect is working with an app and creates some visualizations to check the dat a. Some visualizations show issues in the data set.
* The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.
* The Sales monthly trend bar chart does not work with the Month field.
Which two data issues should the data architect fix in the app? (Select two.)

• A. The OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table
• B. In the Orders table, some CustomerlD values are null because there are orders with no customer.
  and needs to be incorporated in the table using the Calendar table, null because there are orders with no customer
• C. The Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.
• D. In the Orders table, some values in the CustomerlD field do not exist in the Customers table.

Answer: A,D

NEW QUESTION # 23
Refer to the exhibit.

A data architect needs to add a Budget table to the current Qlik Sense app. A Budget table with the fields Budget, CustomerlD, and ProductlD is loaded into the model. What will be created?

• A. A synthetic table with two synthetic keys
• B. A synthetic table with three synthetic keys
• C. A synthetic table and one synthetic key
• D. A circular reference with one table disconnected

Answer: D

NEW QUESTION # 24
The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.
Which method should the data architect use to manage the modifications in all apps?

• A. Create a selection app with all the master items and use an on-demand app generation method.
• B. Create only a single app with all the master items needed and protect it with SECTION ACCESS.
• C. Create a variable repository and load them using INCLUDE statements in the apps where needed
• D. Create a core app with all the master items needed and use a BINARY load in the other apps.

Answer: C

Explanation:
This method allows the data architect to store the KPIs in a single repository and then use INCLUDE statements to load them into the other apps. This makes it easy to modify the KPIs in one place and have the changes reflected in all the apps. Source: Qlik A variable repository is a central location where all of the master items used in the apps can be stored and managed. By creating a variable repository and loading the master items into each app using INCLUDE statements, the data architect can make modifications to the master items in one place, and the changes will be automatically propagated to all of the apps that use the master items.
This method allows for easy management of the master items and eliminates the need to make changes to each app individually, which can be time-consuming and prone to errors.

NEW QUESTION # 25
Refer to the exhibit.
A data architect is loading two tables into a data model from a SQL database These tables are related on key fields CustomerlD and CustomerKey.
Which script is valid to load the tables and maintain the correct association?
A)

B)

C)

D)

• A. Option D
• B. Option A
• C. Option B
• D. Option C

Answer: D

NEW QUESTION # 26
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 to the MasterSports table with the SUBFIELD function to create the Sport field
• B. Apply a FOR loop to load to the MasterSports table creating the values for the Sport field
• C. Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport

Answer: B

NEW QUESTION # 27
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)

Answer: B

NEW QUESTION # 28
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. Five
• D. Three

Answer: D

NEW QUESTION # 29
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 JOIN Orders and Customers on the CustomerlD field
• C. Open the data manager, split the Customers table, and associate both tables on CustomerlD field
• D. Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table

Answer: A

NEW QUESTION # 30
......

Prepare Top Qlik QSDA2021 Exam Audio Study Guide Practice Questions Edition: https://www.testsimulate.com/QSDA2021-study-materials.html