SAP
C_HAMOD_2404
Q1:
Why would you implement SQL in calculation views? Note: There are 2 correct answers to this question.
☐
A
To increase the possibilities for consumption☐
B
To fine-tune performance☐
C
To implement custom functions☐
D
To define dynamic analytic privileges
SAP
C_HAMOD_2404
Q2:
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?
○
A
Procedure○
B
Scalar function○
C
Anonymous block○
D
Table function
SAP
C_HAMOD_2404
Q3:
In a calculation view, your table function node executes a table function that requires input parameters.
How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.
☐
A
Define constant values.☐
B
Reference the output of a procedure.☐
C
Assign a hierarchy node.☐
D
Map columns from lower nodes.☐
E
Create and map an input parameter.
SAP
C_HAMOD_2404
Q4:
Why would you use an anonymous block when writing SQLScript?
○
A
To check the results without applying user privileges.○
B
To test your code without generating a logic container.○
C
To hide the actual tables by using aliases in the code.○
D
To execute a statement without creating entries in the database log.
SAP
C_HAMOD_2404
Q5:
In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.
☐
A
To generate a restricted column☐
B
To define a filter☐
C
To generate a calculated column☐
D
To generate hierarchies☐
E
To convert currencies