Qlik Sense Data Architect Certification Exam (QSDA2018) - QlikView Exam Questions

Refer to the exhibit.



A data architect must load the two tables without creating a synthetic key. The data architect also must make sure expressions like Sum([Budgeted Sales]) are calculated correctly. Which load script meets these requirements? A)

Budget: load * inline I



Year, Region, Budgeted Sales
2015, south, 16];
inner join (Budget)

Sales: 2015, North, 2, 8 2015, West, 1, 12 load * inline [ 2015, East, 2, 9 2015, North, 10 2015, West, 12 2015, East, 14 2015, North, 1, 10 2015, West, 2, 11 2015, East, 1, 14 2015, South, 1, 16 Year, Region, Semester, Actual Sales 2015, South, 2, 7 B)



Budget: load * inline [ Year, Region, Budgeted Sales 2015, North, 10 2015, West, 12 2015, East, 14 2015, South, 16]:

Sales: concatenate (Budget) load * inline I Year, Region, Semester, Actual Sales 2015, North, 1, 10 .015, North, 2, a 1015, West, 1, 12 2015, West, 2, 11 2015, East, 1, 14 2015, East, 2, 9 2015, South, 1,16 2015, South, 2, 7 1: C)

Refer to the exhibit.



One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet The Region field only has values for the first record for the region. The data architect must perform a transformation so that each row contains the correct Region. Which function should the data architect implement to resolve this issue?

Refer to the exhibits Executives need to see the total sales by region for the current year. The data architect inherits App1
from a former employee who tried to address this requirement. Two Microsoft Excel spreadsheets,
Region and Employee, are used as the data source. The data architect creates a table and identifies errors in the amount of sales per region Which method should the data architect use to resolve the errors''

The data model from an existing Qlik Sense app needs to be reused in another Qlik Sense app.

Which load strategy should a data architect use to transfer this data in the most efficient way?

A data architect must br*ak down a 13-character ShipmentID code in the following format, #-###-##- ##-#. Separate fields must be created from the numeric values separated by the hyphen (-). The data architect must extract five sub-fields (ShipmentLoc, Quantity. CategorylD. StoreLoc. and Division)
from the 13-character code

How should the data architect meet this requirement?