QlikView QSDA2022 Online Practice Questions and Exam Preparation

QlikView QSDA2022 Online Questions & Answers

• Question 31:

  

  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. HierarchyLevel(EmployeelD, ManagerlD Name Level, '/', Structure) HierarchyBelongsTo(EmployeelD, ManagerlD, Name ManagerlD, Manager, Depth)
  B. HierarchyBelongsTo(ManagerlD, Manager, ManagerlD, ManagerlD, Manager Level) Hierarchy(EmployeelD, ManagerlD, Name. Manager Name, Structure `/' Depth)
  C. Hierarchy(EmployeelD. ManagerlD Name, Manager Name, Structure V, Depth) HierarchyLevelEmployeelD, ManagerlD, Name, Manager, Name, Structure, Depth `/')
  D. HierarchyBelongs.To(EmployeeID, ManagerlD, Name ManagerlD, Manager, Depth)
  D. HierarchyBelongs.To(EmployeeID, ManagerlD, Name ManagerlD, Manager, Depth)

  ---

  Explanation/Reference:

• Question 32:

  A data architect executes the following script:

  

  What will be the result of Table A?

  

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

  ---

  Explanation/Reference:

• Question 33:

  Refer to the exhibit.

  

  A data architect has a data model that includes historical order fulfillment centers. The order fulfillment centers occasionally changed location. The history of order fulfillment must be tracked on a per center, per location basis. Which scripting function should the data architect use to meet this data modeling requirement?

  A. IntervalMatch
  B. Peek
  C. ApplyMap
  D. Inner Join
  C. ApplyMap

  ---

  Explanation/Reference:

  In this scenario, the data architect needs to track the history of order fulfillment centers on a per center, per location basis. This means that the data architect needs to match the historical order fulfillment center data with the

  current order fulfillment center data, based on the center and location.

  The ApplyMap function allows you to create a mapping between the data in one table and the data in another table, based on a common field. The data architect can use ApplyMap to create a mapping between the historical order fulfillment

  center data and the current order fulfillment center data, based on the center and location fields.

• Question 34:

  

  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. Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship
  B. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
  C. Join the Departments and Salespeople tables to resolve the many-to-many relationship
  D. Join the Transactions and Salespeople tables to resolve the many-to-many relationship
  A. Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship

• Question 35:

  Refer to the exhibit.

  

  A business analyst reports that the 'CompanyAge' field does NOT display for users The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name.

  Which line number should the data architect use?

  A. 242 because field name appears in the output Panel of the debugger
  B. 251 because the field name appears in the Variable panel of the debugger
  C. 251 because the field name appears in the Qlik Log files
  D. 251 because the field name appears in the Output panel of the debugger
  D. 251 because the field name appears in the Output panel of the debugger

• Question 36:

  A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze data. Some fields must NOT appear in any field list. How should a data architect meet these requirements?

  A. Use HidePrefix variable
  B. Add fields to master items
  C. Use security rules
  D. Use HideField variable
  C. Use security rules

  ---

  Explanation/Reference:

  The best way for a data architect to meet the requirements of not allowing some fields to appear in any field list is to use security rules. Security rules can be used to restrict access to certain fields, which will ensure that they don't appear in any field list or visualization. Additionally, security rules can also be used to restrict access to certain data models, ensuring that only users with the right permissions can view and analyze the data.

  Row-level security (RLS) with Power BI - Power BI | Microsoft Learn https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls What Is Data Visualization? Definition and Examples | Tableau https://www.tableau.com/learn/articles/data-visualization 80+ Top Power BI Interview Questions and Answers [Updated 2023] https://www.edureka.co/blog/interview-questions/power-bi-interview-questions/

• Question 37:

  

  Refer io 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. Option A
  B. Option B
  C. Option C
  D. Option D
  B. Option B

  ---

  Explanation/Reference:

• Question 38:

  Refer to the exhibit.

  

  The data architect needs to build a model that contains Sales and Budget data for each customer. Some customers have Sales without a Budget, and other customers have a Budget with no Sales

  During loading, the data architect resolves a synthetic key by creating the composite key

  For validation, the data architect creates a table containing Customer, Month. Sales, and Budget columns.

  What does the data architect see when selecting a month?

  A. All Customers, all Budget and all Sales records
  B. Customer and Sales records for that month, but missing values for Budget
  C. Customer and Budget records for that month, but missing values for Sales
  D. Customer, Sales, and Budget records for that month
  D. Customer, Sales, and Budget records for that month

• Question 39:

  

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

• Question 40:

  Refer to the exhibit.

  

  A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam. The data architect selects the field "StudentID" from the Students table and sees the following:

  

  A data architect needs to fix this anomaly.

  What should the data architect do to ensure data integrity?

  A. Update the Students table and add 16.7% of the missing records
  B. Remove records from the Exams table where StudentID is null
  C. Update the Exams table and add 33.4% of the missing records
  D. In the LOAD script, add DISTINCT before the Students and Exams tables
  D. In the LOAD script, add DISTINCT before the Students and Exams tables