QUESTION: 5

Why should you define calculated column expressions using plain SQL and avoid using column engine language?

To prevent queries from unfolding
To access the full set of SQL functions
To allow imperative statements
To benefit from additional SQL optimizations

Answer(s): D

QUESTION: 6

In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

Procedure
Scalar function
Anonymous block
Table function

Answer(s): D

Show Answer Next Question

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name.How do you ensure that each customer name appears only once in the results?

Define a restricted column in a union node.
In the union node, map both source customer name columns to one target column.
Include an aggregation node above the union node.
Add an intersect node above the union node.

Answer(s): C

Show Answer Next Question

QUESTION: 8

Which options do you have to handle orphan nodes in your hierarchy?
Note: There are 2 correct answers to this question.

Assign them to a level below the root.
Define an expression to determine a parent.
Assign them to a node at the root level.
Generate additional root nodes.

Answer(s): C,D

Show Answer Next Question

Free SAP C_HANAIMP_18 Exam Questions (page: 3)

QUESTION: 5

QUESTION: 6

QUESTION: 7

QUESTION: 8

C_HANAIMP_18 Exam Discussions & Posts