← Back to exam page

QSDA2021 – Qlik Sense Data Architect Certification ExamFebruary 2021 Release

Loading demo links...

Showing 4–6 of 8 questions

Question 4

The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.

Which method should the data architect use to manage the modifications in all apps?

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.
Question 5

A data architect is creating an app using three tables. After executing the script, a warning displays

Which two steps should the data architect do to resolve this warning? (Select two.)

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
Question 6

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?

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;