Free Qlik QSDA2018 Exam Dumps Questions & Answers

Refer to the exhibit.

Which values of the REGION field will be visible for User C when the user opens the app?

• A.  EAST and WEST
• B.  EAST, WEST and SOUTH
• C.  NORTH, EAST, WEST, and SOUTH
• D.  NORTH, EAST and WEST

Refer to the exhibit.

The data model shown has a synthetic key for information that contains actual sales and budget sales for a multi-national company As a business requirement, users must be able to drill down by department and country. Datajnust not be lost.
Due to data quality issues, some departments are NOT included in the Sales and Budget tables.
The data architect needs a method to eliminate synthetic keys that generates the fastest performing data model Which method should the data architect use?

• A.  A link table to associate the two tables
• B.  Field aliases or comment out redundant fields
• C.  A forced concatenation statement
• D.  A Left Join statement in the script

A data architect is working on a time and expense app for an organization that has Sales, Marketing, and Finance departments Department managers should only be able to view the data for their department's team members.
Where should the data architect apply this security restriction?

• A.  Qlik Management Console
• B.  Data load editor
• C.  Data manager
• D.  Expression editor

The dates are stored as strings in the database. The data architect must convert the dates to date format The reload must be as fast as possible.
Which script should the data architect use?
A)

B)

C)

D)

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

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