Free Qlik QSDA2021 Exam Dumps Questions & Answers

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.  * HierarchyBelongsTo(ManagerlD, Manager, ManagerlD, ManagerlD, Manager Level)
  * Hierarchy(EmployeelD, ManagerlD, Name. Manager Name, Structure '/' Depth)
• D.  * HierarchyBelongs.To(EmployeeID, ManagerlD, Name ManagerlD, Manager, Depth)

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.  Use section access to restrict sales manager access by region
• C.  Use section access and include a service account in the table
• D.  Create an app for each sales manager with Qlik GeoAnalytics

Refer to the exhibit.

Which changes on the database will the script capture?

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

A data architect executes the following script:

What will be the result of Table A?
A)

B)

C)

D)

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

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 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
• B.  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
• 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 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