SAP Certified Associate - Data Engineer - SAP HANA C_HAMOD_2404 Question # 3 Topic 1 Discussion
C_HAMOD_2404 Exam Topic 1 Question 3 Discussion:
Question #: 3
Topic #: 1
You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned. What could be the problem? Note: There are 2 correct answers to this question.
A.
The Country column is requested.
B.
Join cardinality is set: 1.
C.
The Keep flag is activated for the Customer column.
If Table B is not pruned in a referential join, the possible issues could be:
C. The Keep flag is activated for the Customer column: This prevents pruning by forcing the inclusion of the column in query execution.
D. Integrity constraint is set to RIGHT: This setting implies that Table B data must always be considered in the join, disabling pruning.
Pruning depends on join conditions and flags; ensuring no unnecessary constraints is essential for proper optimization.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit