[Oct-2023] Exam Sure Pass Qlik Certification with QSDA2021 exam questions
Real Qlik QSDA2021 Exam Questions Study Guide
NEW QUESTION # 27
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 Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar 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 OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table
- D. In the Orders table, some values in the CustomerlD field do not exist in the Customers table.
Answer: C,D
NEW QUESTION # 28
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 apply the variables to the app using a mapping table
- B. Save the script for the number interpretation variables in a text file and INLUDE function to insert the variables
- C. Save the script for the number interpretation variables in a text file and use the CALL function to insert the variables.
- D. Create an Excel file with the number interpretation variables and use a FOR Next loop to load the variables into Qlik Sense
Answer: B
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 # 29
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. * Hierarchy(EmployeelD. ManagerlD Name, Manager Name, Structure V, Depth)
* HierarchyLevelEmployeelD, ManagerlD, Name, Manager, Name, Structure, Depth '/') - B. * HierarchyLevel(EmployeelD, ManagerlD Name Level, '/', Structure)
* HierarchyBelongsTo(EmployeelD, ManagerlD, Name ManagerlD, Manager, Depth) - C. * HierarchyBelongs.To(EmployeeID, ManagerlD, Name ManagerlD, Manager, Depth)
- D. * HierarchyBelongsTo(ManagerlD, Manager, ManagerlD, ManagerlD, Manager Level)
* Hierarchy(EmployeelD, ManagerlD, Name. Manager Name, Structure '/' Depth)
Answer: C
NEW QUESTION # 30
A data architect needs to arrange data to create an app with a map where multiple location points consolidate into hexagonal areas based on postal codes The areas will be color coded based on the number of vendors in the location.
Which GeoAnalytics operation should the data architect use?
- A. Intersect
- B. AddressLookup
- C. Binning
- D. Simplify
Answer: C
Explanation:
Binning is a GeoAnalytics operation that can be used to arrange data into hexagonal areas based on postal codes. The areas can then be color coded based on the number of vendors in the location. Source: Qlik Binning is a GeoAnalytics operation that allows data points to be grouped into hexagonal areas based on a geographic field, such as postal codes. The data architect can use binning to group the location points by postal code and then color code the resulting hexagonal areas based on the number of vendors in each location.
This operation is useful for visualizing spatial data and identifying patterns or trends in the data.
NEW QUESTION # 31
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, StorelD)
- B. Use Concatenate before loading the Stores table
- C. Use where exists (ID)
Answer: C
NEW QUESTION # 32
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 circular reference with one table disconnected
- B. A synthetic table with three synthetic keys
- C. A synthetic table and one synthetic key
- D. A synthetic table with two synthetic keys
Answer: A
NEW QUESTION # 33
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
Answer: A
NEW QUESTION # 34
ITALY IT001 HR
GERMANY DE002 HR
SPAIN SP03 FINANCE
FRANCE FRO04 SALES
Refer to the exhibit
A company stores the employee data within a key composed of Country UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.
- A. LTRIM (SUBFIELD (Key, ' ', 2), 2)
- B. RIGHT(SUBFIELD (Key,' ', 2), 3)
- C. MID ( SUBFIELD (Key , ' ', 2), 3)
- D. LEFT(SUBFIELD(Key, ' ', 2), 2)
Answer: D
Explanation:
This expression will extract the unique code from the key by using the SUBFIELD function to separate the key into its components, and then using the LEFT function to extract the first two characters of the second component. Source: Qlik
NEW QUESTION # 35
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 A439926003 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. FileSize, IF, THEN, END IF
- B. FileExists, FOR EACH, IF
- C. FilePath, FOR EACH, Peek, Drop
- D. FilePath, IF, THEN. Drop
Answer: A
NEW QUESTION # 36
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 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 - 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 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 - D. 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
Answer: C
NEW QUESTION # 37
Refer to the exhibit.
Which changes on the database will the script capture?
- A. Update and Remove rows
- B. Insert. Update, and Remove rows
- C. Insert and Update rows
- D. Insert and Remove rows
Answer: B
NEW QUESTION # 38
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. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlC field
- B. Remove the LineNo field from Shipments and use the AutoNumber function on the
- C. Create a composite key using OrdertD and LineNo
- D. Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments
Answer: D
NEW QUESTION # 39
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 For loop to concatenate all of the Products table and apply a Generic Load to the final concatenate table
- B. Use a For loop to apply a Generic load to the Product table and concatenate the generic tables together
- C. Use a Generic Load in the Product table and a For loop to left join each Generic table
Answer: C
NEW QUESTION # 40
Refer to the exhibit.
Refer to the exhibits.
An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times.
The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result.
How should the data architect modify the data model to correct this issue?
- A. Join the Departments and Salespeople tables to resolve the many-to-many relationship
- B. Join the Transactions and Salespeople tables to resolve the many-to-many relationship
- C. Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship
- D. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
Answer: C
NEW QUESTION # 41
A global retailer has a large database in which millions of sales transactions are added per hour.
Each regional sales manager should only see details for customers in their region. After filtering based on criteria such as region, gender, and income level, sales managers should be able to see the most current detailed transactions.
What should a data architect do to meet these requirements?
- A. Use On-Demand App Generation (ODAG) and section access
- B. Create an app for each sales manager with Qlik GeoAnalytics
- C. Use section access and include a service account in the table
- D. Use section access to restrict sales manager access by region
Answer: D
NEW QUESTION # 42
Refer to the exhibit.
A company has different departments. Executive and Sales should always be the first values in a Department filter pane. Which script must the data architect use to meet this requirement?
A)
B)
C)
D)
- A. Option C
- B. Option A
- C. Option D
- D. Option B
Answer: C
NEW QUESTION # 43
Refer to the exhibit.
A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.
Which feature should the data architect use to meet these requirements?
- A. Class function in a calculated dimension
- B. Class function in the script and use variables
- C. Nested IFs in a calculated dimension
- D. IntervalMatch and use variables
Answer: A
NEW QUESTION # 44
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. RENAME FIELDS USING Associations;
- B. MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;
- C. APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;
- D. MAP EmloyeeKey USING Associations;
Answer: D
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 # 45
A data architect needs to build an Order Fulfillment app. The business requires front-end performance is optimized.
The OrderDate and ShipmentDate are located in different tables.
The user needs to identify the data type and must be able to:
* Show trends for orders and shipments
* Use a single filter for both date fields
* Analyze data over fiscal periods
Which steps should the data architect take to build the data model?
- A. 1. Create a master calendar table as a data island
2. Create a single filter using fields from the master calendar - B. 1. Create a master calendar and join into the Shipments and Orders table
2. Create a single filter using fields from the Shipments table - C. 1. Load the Shipments and Orders table via the data manager
2. Create a single filter using fields from the Orders table - D. 1. Create a link table with master calendar fields
2. Create a single filter using fields from the master calendar
Answer: D
NEW QUESTION # 46
Refer to the exhibit.
A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A.
(For example, only the row containing A, 1, 456 should be loaded from Table_B.)
Which script should the data architect use?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 47
......
Updated and Accurate QSDA2021 Questions for passing the exam Quickly: https://www.pass4suresvce.com/QSDA2021-pass4sure-vce-dumps.html
Download Real QSDA2021 Exam Dumps for candidates. 100% Free Dump Files: https://drive.google.com/open?id=1DMhhMrCkj6sggnO9r-KB4SLAGCgVhw9_