Free QSDA2021 – Qlik Sense Data Architect Certification ExamFebruary 2021 Release Practice Test Question

Select all that apply, then click Submit answer.

• ○

  Canonical calendar

• ○

  Generic load

• ○

  Data island

• ○

  Multiple calendars

• ○

  Link table

Select all that apply, then click Submit answer.

• ○

  The Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.

• ○

  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

• ○

  In the Orders table, some values in the CustomerlD field do not exist in the Customers table.

• ○

  The OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table

Select all that apply, then click Submit answer.

• ○

  Use dynamic script generation with variables

• ○

  Denormalize the schema

• ○

  Make sure any Ul variables are preceded by '='

• ○

  Use flags in the data model to simplify set analysis

• ○

  Create master items for all complex expressions

Select an option, then click Submit answer.

• ○

  Create a variable repository and load them using INCLUDE statements in the apps where needed

• ○

  Create a selection app with all the master items and use an on-demand app generation method.

• ○

  Create a core app with all the master items needed and use a BINARY load in the other apps.

• ○

  Create only a single app with all the master items needed and protect it with SECTION ACCESS.

Select an option, then click Submit answer.

• ○

  Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.

• ○

  Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).

• ○

  Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line 24).

• ○

  insert "Join (ProductDetails)" in front of the Load statement in line 24 to combine ProductPriceList with ProductDetails

Select an option, then click Submit answer.

• ○

  APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;

• ○

  MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;

• ○

  MAP EmloyeeKey USING Associations;

• ○

  RENAME FIELDS USING Associations;

Select an option, then click Submit answer.

• ○

  ApplyMap with two parameters after the Mapping load

• ○

  Left Join between tables and Description xlsx in every Department table

• ○

  Enter "Missing description" in the blank rows for Description xlsx then Mapping Load

• ○

  ApplyMap with three parameters after the Mapping load

Select an option, then click Submit answer.

• ○

  Save the script for the number interpretation variables in a text file and use the CALL function to insert the variables.

• ○

  Create an Excel file with the number interpretation variables and use a FOR Next loop to load the variables into Qlik Sense

• ○

  Save the script for the number interpretation variables in a text file and INLUDE function to insert the variables

• ○

  Create an Excel file with the number interpretation variables and apply the variables to the app using a mapping table