QlikView QSDA2022 Online Practice Questions and Exam Preparation

QlikView QSDA2022 Online Questions & Answers

• Question 11:

  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. Utilize INTERVALMATCH to load the currency conversion rate between dates the conversation changed INNER JOIN the resultant table back into the master calendar
  B. OUTER JOIN the calendar with the currency conversion table ORDER BY the date and use the PEEK function to fill in blank values
  C. 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
  D. Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table
  B. OUTER JOIN the calendar with the currency conversion table ORDER BY the date and use the PEEK function to fill in blank values

  ---

  Explanation/Reference:

• Question 12:

  A data architect needs to load Table_A from an Excel file and sort the data by Field_2.

  Which script should the data architect use?

  

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

  ---

  Explanation/Reference:

• Question 13:

  A company needs to analyze sales data based on the exchange rate of the different countries every day About 30 reports must be produced with an average of 20r000 rows each. This process is estimated to take about three hours. Reports will be in Excel and distributed to business users according to defined security rules

  Which two products should the data architect use to build this solution? (Select two.)

  A. OQIikGeoAnalytics
  B. ODAG
  C. QIikDataMarket
  D. Qlik Storytelling
  E. QIik NPrinting
  B. ODAG
  E. QIik NPrinting

  ---

  Explanation/Reference:

  The best answer choices are B. ODAG and E. QIik NPrinting. ODAG (On Demand Application Generation) is a product from Qlik that can be used to quickly generate reports from large datasets. It can produce reports with up to 20,000 rows and can do so in less than three hours. NPrinting is a product from Qlik that can be used to distribute the reports in Excel format according to the defined security rules.

• Question 14:

  Refer to the exhibit.

  

  Which changes on the database will the script capture?

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

• Question 15:

  A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table. Which script code should the data architect use?

  

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

  ---

  Explanation/Reference:

• Question 16:

  

  On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue. What should the data architect do?

  A. Use a LEFT JOIN instead of the APPLYMAP
  B. Use LOAD DISTINCT on the mapping table
  C. Create two different mapping tables
  D. Review the values of the source mapping table
  D. Review the values of the source mapping table

• Question 17:

  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. APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;
  B. MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;
  C. MAP EmloyeeKey USING Associations;
  D. RENAME FIELDS USING Associations;
  C. MAP EmloyeeKey USING Associations;

  ---

  Explanation/Reference:

  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.

• Question 18:

  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 link table with master calendar fields 2. Create a single filter using fields from the master calendar
  B. 1. Load the Shipments and Orders table via the data manager 2. Create a single filter using fields from the Orders table
  C. 1. Create a master calendar and join into the Shipments and Orders table 2. Create a single filter using fields from the Shipments table
  D. 1. Create a master calendar table as a data island 2. Create a single filter using fields from the master calendar
  A. 1. Create a link table with master calendar fields 2. Create a single filter using fields from the master calendar

  ---

  Explanation/Reference:

• Question 19:

  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. MID ( SUBFIELD (Key , ' ', 2), 3)
  C. RIGHT(SUBFIELD (Key,' ', 2), 3)
  D. LEFT(SUBFIELD(Key, ' ', 2), 2)
  D. LEFT(SUBFIELD(Key, ' ', 2), 2)

  ---

  Explanation/Reference:

  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

• Question 20:

  Refer to the exhibit.

  

  The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table Which script should the data architect use?

  

  

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

  ---

  Explanation/Reference: