← Back to exam page

QSDA2021 – Qlik Sense Data Architect Certification ExamFebruary 2021 Release

Loading demo links...

Showing 1–3 of 8 questions

Question 1

A data architect is building a model to show trends in visualizations across seven date fields. The seven date fields reside in different tables. The data architect must efficiently build this data model.

Requirements:

• A single date selector

• Show all dates, even those with NO activity

• Minimize the impact on server resources and p

Which two solutions should the data architect use? (Select two.)

Select all that apply, then click Submit answer.

  • ○

    Canonical calendar
  • ○

    Generic load
  • ○

    Data island
  • ○

    Multiple calendars

  • ○

    Link table
Question 2

Refer to the exhibit.

A data architect is working with an app and creates some visualizations to check the data. Some visualizations show issues in the data set.

* The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.

* The Sales monthly trend bar chart does not work with the Month field.

Which two data issues should the data architect fix in the app? (Select two.)

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

A data architect needs to revise an existing app.

The number of data rows has grown rapidly recently. While the app is in production, users are becoming increasingly unhappy about the response times when they make selections

Which two methods should be used to improve performance? (Select two.)

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