Online Access Free C-HANAIMP-18 Exam Questions

You have generated a calculation view properties file.What does it contain?

• A.Dependencies between calculation views
• B.Descriptions of all objects defined in a calculation view
• C.Documentation to support the calculation view
• D.All settings defined in a calculation view

You are building a new calculation view A that uses calculation view B, as shown in the diagram. When you preview the calculation view A, the Account Number is not masked.

What could be the reason?

• A.The UNMASKED privilege for calculation view A has been granted.
• B.You previewed the data with the technical user in SAP Web IDE for SAP HANA.
• C.You did not define masking in calculation view A.
• D.Analytic privilege _SYS_BI_CP_ALL has been assigned.

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

• A.To access the full set of SQL functions
• B.To prevent queries from unfolding
• C.To benefit from additional SQL optimizations
• D.To allow imperative statements

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

• A.Assign them to a level below the root.
• B.Define an expression to determine a parent.
• C.Assign them to a node at the root level.
• D.Generate additional root nodes.

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?

• A.Your function refers to a scalar function.
• B.Your function includes a TRUNCATE statement.
• C.You did not define at least one input parameter.
• D.You did NOT define a valid table type.