C_HANAIMP_17 Online Practice Questions and Answers

What do you use a hierarchy function for? Note: There are 3 correct answers.

A. Calculate distance between root and each hierarchy node

B. Identify hierarchy nodes that have no parent

C. Count the number of siblings for each hierarchy node

D. Determine the shortest path between each pair of nodes

E. Describe the relationship between nodes using attributes

Why might you use the Keep Flag property in an aggregation node?

A. To cache the results of the aggregation node for drill-down

B. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

C. To include columns that are NOT requested by a query but are essential for the correct result

D. To retain the correct aggregation behavior in stacked views.

How do you embed a decision tree in to your calculation view using a table function? Note: There are 2 correct answers to this question.

A. Call the SAP-provided PAL decision tree procedure from the table function

B. Use dynamic SQL in the table function to generate the SQL code

C. Copy and adapt the SQL code generated by a flow graph into the table function

D. Build a flow graph and call it from the table function using input parameters

Which of the following approaches improve the performance of joins in a cube calculation view? Note: There are 2 correct answers to this question.

A. Use an inner join.

B. Limit the number of joined columns.

C. Implement pruning rules.

D. Specify the join cardinality.

What are the key steps to implement currency conversion in a calculation view?

A. Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Build the conversion rule

B. Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Assign the conversion rule to your calculation view

C. Assign semantic type Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column

D. Assign semantic type Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type

What does a graph neighborhood search reveal?

A. Edges that contain the same attributes

B. Shortest path between vertices

C. Vertices that are closely connected

D. Vertices that contain the same attributes

In a calculation view, which object type do you assign to a projection node to consume a Predictive Analysis Library (PAL) function?

A. Synonym

B. Scalar function

C. Table function

D. Input parameter

You want to expose a hierarchy that is defined in a calculation view for access to SQL which of the following conditions must be met?

Note: There are 2 correct answers .

A. The hierarchy must be a local hierarchy.

B. The hierarchy must be exposed by a calculation view of type CUBE with star join.

C. The hierarchy must be defined in a calculation view of type SQL ACCESSONLY.

D. The hierarchy must be a shared hierarchy.

In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA?

A. You have a large row store table that is consumed in a view with a variable on COUNTRY column.

B. You have a large column store table that is consumed in a view with a variable on COUNTRY column.

C. You have a dedicated table lo generate the lists of help values for an input parameter.

D. Your stacked model consists of multiple calculation views.

Why do we use Git when modeling calculation views?

A. Develop conceptual prototypes

B. Enable collaboration between developers

C. Provide access to external schemas

D. Control specifically object versioning