Test Online Free QlikView QSDA2022 Exam Questions and Answers

Refer to the exhibit.



A data architect is working with an app and creates some visualizations to check the data.
Some visualizations showissues 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.)

• A. The Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.
• B. 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
• C. In the Orders table, some values in the CustomerlD field do not exist in the Customers table.
• D. The OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table

Show Answer

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

Show Answer

Refer to the exhibit.



A data architect has a data model that includes historical order fulfillment centers. The order fulfillment centers occasionally changed location. The history of order fulfillment must be tracked on a per center, per location basis.
Which scripting function should the data architect use to meet this data modeling requirement?

• A. IntervalMatch
• B. Peek
• C. ApplyMap
• D. Inner Join

Show Answer

Refer to the exhibit.



A data architect executes the script.
What will be the value of the first row for Field_1?

• A. A
• B. D
• C. Null
• D. 4

Show Answer