QUESTION: 13

ITALY IT001 HR
GERMANY DE002 HR
SPAIN SP03 FINANCE
FRANCE FRO04 SALES
Refer to the exhibit
A company stores the employee data within a key composed of Country UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.

LTRIM (SUBFIELD (Key, ' ', 2), 2)
MID ( SUBFIELD (Key , ' ', 2), 3)
RIGHT(SUBFIELD (Key,' ', 2), 3)
LEFT(SUBFIELD(Key, ' ', 2), 2)

Answer(s): D

Explanation:

This expression will extract the unique code from the key by using the SUBFIELD function to separate the key into its components, and then using the LEFT function to extract the first two characters of the second component. Source: Qlik

Reveal Solution Next Question

QUESTION: 14

A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.
These systems identify employees differently Employees in the HR system are identified with an alpha-numeric key Employees in the Sales system are identified using an integer key. The Human Resources manager creates a table that maps these keys to another, called Associations. The resultant data model must meet the following requirements:
· Associations must be valid

· The model must be optimized for performance
· The option must support multiple tables added
Which solution should the data architect use to meet these requirements?

APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;
MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;
MAP EmloyeeKey USING Associations;
RENAME FIELDS USING Associations;

Answer(s): C

Explanation:

The MAP function maps the EmployeeKey in the Sales system to the EmployeeKey in the HR system using the Associations table. This allows the data architect to join the data from the Sales system and the HR system using the same key, ensuring that the associations are valid. Using the MAP function also optimizes the performance of the data model as it eliminates the need for multiple joins between the data from the Sales and HR systems. This solution also supports multiple tables added, as the MAP function can be applied to any table that needs to be joined with the HR system data.

Reveal Solution Next Question

QUESTION: 15

A data architect is creating an app using three tables. After executing the script, a warning displays Which two steps should the data architect do to resolve this warning? (Select two.)

Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.
Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).
Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line 24).
insert "Join (ProductDetails)" in front of the Load statement in line 24 to combine ProductPriceList with ProductDetails

Answer(s): B

Explanation:

Reveal Solution Next Question

QUESTION: 16

Refer to the exhibit.

A data architect is loading two tables into a data model from a SQL database These tables are related on key fields CustomerlD and CustomerKey.
Which script is valid to load the tables and maintain the correct association?