Exam QSDA2024 topic 1 question 45 discussion

Actual exam question from QlikView's QSDA2024

Question #: 45
Topic #: 1

[All QSDA2024 Questions]

A data architect executes the following script:
Table_A:
LOAD * INLINE [

Field_1, Field_2, Field_3 -
01, AB, 10
01, AC, 50
02, AD, 75
];
Join(Table_A)
Table_B:
LOAD * INLINE [

Field_1, Field_4, Field_5 -
01, 30%, 500
03, 60%, 1000
];
What will be the result of Table_A?