C_HANAIMP_17 Online Practice Questions and Answers

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.

What is the correct approach?

A. Combine the transaction tables using a join node in a calculation view of type cube. Use the multi-join capability of the join node to connect the transactional tables with the dimension calculation views.

B. Combine the transaction tables using a star join node in a calculation view of type cube with star join. Use a join node to join the dimensions to the fact table.

C. Combine the transaction tables using an aggregation node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table.

D. Combine the transaction tables using a join node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table.

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.

You have made changes to the design-time files of several calculation views in your DEV environment. These calculation views belong to the same project. Before deploying your calculation views to a PROD environment, which sequence of steps is required in the DEV environment?

A. Export the HDB module -> Export the project

B. Build the HDB module -> Build the project

C. Activate the project -> Build the HDB module

D. Build the project -> Build the HDB module

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

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.

You created a table function to remove previous records, sum the current total weekly working hours for each employee, and updated the personnel table. The build of the table function fails. Which of the following could be a valid reason?

A. You did NOT define a valid table type.

B. Your function refers to a scalar function.

C. You did not define at least one input parameter.

D. Your function includes a TRUNCATE statement

Why do you use the debug query mode in a calculation view?

A. To observe the generated SQL for each node

B. To highlight potential performance issues at design-time

C. To measure the overall run-time of the query

D. To check which database engines will be invoked by each node