Qlik QSDA2021 : Qlik Sense Data Architect Certification Exam - February 2021 Release

Refer to the exhibit.

Refer to the exhibits.
The first table shows the source table (Original table).
This data represents the stocks stored every month for each product:
* The relevant fields are productid, qty, and date.
* The date field represents the calendar months using
* The qty field shows the product stock fluctuation from the current month versus the previous month. If there is no fluctuation between months, there are no new entries in the table.
The second table shows a Pivot table visualization the data analyst needs to create in the app displaying per each product the monthly trend of available stock.
For performance reasons, the data analyst requests the data architect to calculate the running stock quantity of each product for every month in the script.
Which approach should the data architect use?

• A. 1 Generate a Cartesian JOIN between productid and date in a Combined table
  2 RIGHT JOIN the Combined table with the Original table to populate the missing qty values
  3. Use PREVIOUS() and RANGESUMQ functions to create the running quantity totals for each product for every month
• B. 1 Generate a Calendar table with all dates between the minimum and maximum date values in an Original table
  2. LEFT JOIN the Calendar table back to the Original table to populate the missing qty values
• C. 1. Generate a Calendar table with all dates between the minimum and maximum date values in an Original table
  2. RIGHT JOIN the Calendar table back to the Original table to populate the missing qty values
  3. Use PEEK() and RANGECOUNTO functions to create the running quantity totals for each product for every month
• D. 1. Generate a Cartesian JOIN between productid and date in a Combined table
  2. LEFT JOIN the Combined table with the Original table to populate the missing qty values
  3. Use PREVIOUSO and SUM() functions to create the running quantity totals for each product for every month

Refer to the exhibits.

Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.
The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.
What should the data architect do to resolve this issue?

• A. Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field
• B. Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD
• C. Open the data manager, split the Customers table, and associate both tables on CustomerlD field
• D. Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table

Refer to the exhibit.

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. Review the values of the source mapping table
• B. Use a LEFT JOIN instead of the APPLYMAP
• C. Create two different mapping tables
• D. Use LOAD DISTINCT on the mapping table

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

Refer to the exhibit.

A company has different departments. Executive and Sales should always be the first values in a Department filter pane. Which script must the data architect use to meet this requirement?
A)

B)

C)

D)

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