SAP C_HAMOD_2404 Practice Test - Questions Answers
Question list
List of questions
Related questions
Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?
A SELECT privilege and an Analytic Privilege (Country United States) on the CUBE calculation view
A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country United States) on the DIMENSION calculation view
SELECT privileges and Analytic Privileges (Country United States) on both views
A SELECT privilege and an Analytic Privilege (Country United States) on the DIMENSION calculation view
You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.
Which of the following could be a valid reason?
You did not define at least one input parameter.
You did not define a valid table type.
Your table function includes a DELETE statement.
Your table function refers to a scalar function.
In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.
To generate a restricted column
To define a filter
To generate a calculated column
To generate hierarchies
To convert currencies
Why would you use an anonymous block when writing SQLScript?
To check the results without applying user privileges.
To test your code without generating a logic container.
To hide the actual tables by using aliases in the code.
To execute a statement without creating entries in the database log.
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.
Define constant values.
Reference the output of a procedure.
Assign a hierarchy node.
Map columns from lower nodes.
Create and map an input parameter.
Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you. When you preview calculation view A, what data do you see?
US for P1 and P2, and GE for P1 and P2
US for P1
US for P1 and GE for P1
US for P1 and P2, and GE for P2
You are creating a procedure to be consumed in a DYNAMIC analytic privilege. What must you consider? Note: There are 2 correct answers to this question.
The procedure should have the value DEFINER for the security mode
The procedure should include an input parameter to specify the user ID
The procedure should return a table with the list of allowed values
The procedure should be defined as read-only
You are deploying a new calculation view, A, that uses calculation view B, as shown in the diagram. When you preview calculation view A, the account number is not masked.
What could be the reason?
The UNMASKED privilege has NOT been granted at the schema level.
You did not define masking in calculation view A.
You previewed the data with the technical user in the SAP HANA modeling tool.
The type of the Account Number column is VARCHAR.
How can you define a variable that presents its value help hierarchically? Note: There are 2 correct answers to this question.
Create a level hierarchy and assign it to the variable. * Ensure the variable's reference column is the top level of the hierarchy.
Create a parent-child hierarchy and assign it to the variable. * Ensure the variable's reference column is the parent attribute of the hierarchy.
Create a parent-child hierarchy and assign it to the variable. * Ensure the variable's reference column is the child attribute of the hierarchy.
Create a level hierarchy and assign it to the variable. * Ensure the variable's reference column is the leaf level of the hierarchy.
What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.
Assign them to a parent determined by an expression.
Assign them to a leaf level node.
Assign them to an existing node at the root level.
Define them as additional root nodes.
Question