Free Qlik QSDA2018 Exam Dumps Questions & Answers

Refer to the exhibits



Which corrective action should be taken to achieve the expected view?

• A.  Alias one of the fields in the Orders table.
• B.  Use upper () to align the Salesperson fields
• C.  Use distinct in the LOAD statement.
• D.  Add a link table.

Refer to the exhibit.

The Country field in a CRM app is a free-form text field More spelling variations and countries are expected in the future A data architect must create a field called CountryCode based on the value in the Country field.
Which script should the data architect create to perform this task?
A)

B)

C)

D)

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

Refer to the exhibit.

A data architect has two tables that contain Sales and Target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeelD.
The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for Target are too high, and employees with NO sales should be excluded Which function should the data architecwise to resolve these issues?

• A.  Inner Join
• B.  Left Join
• C.  Left Keep
• D.  Outer Join

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?

• A.  In the data manager, use the data profiling card to split the ShipmentID by the'-' character
• B.  In the data load editor, load the ShipmentID field and apply the PurgeChar(ShipmentlD,'-') function
• C.  In the data load editor, load the ShipmentID field and apply the KeepCharQ and Trim() functions
• D.  In the data manager, use the data profiling card to replace the'-' characters in the ShipmentID

Refer to the exhibit.

An organization stores sales data in SQL Server. A database administrator creates a view to show the transaction data The data architect must
* Create a data model that shows the total sales for each salesperson by month
* Create an indicator that shows whether the total monthly sales meet or exceed the monthly quota, which is always $1,200 Which script should the data architect use to meet these requirements?
A)

B)

C)

D)

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