SAP Certified Application Associate - SAP HANA 2.0 (SPS05) (C_HANAIMP_17) Free Practice Test

Question 1

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. Copy and adapt the SQL code generated by a flow graph into the table function

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

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

Correct Answer: B,C

Question 2

What are the components of a custom text analysis?
Note: There are 3 correct answers to this question.

A. Dictionary

B. Rule set

C. Python script

D. Term Document Matrix

E. Configuration

Correct Answer: A,B,E

Question 3

What restrictions apply to a Graph node that you include in a calculation view?

A. It must be the final node in the dataflow.

B. It must be the first node in the dataflow.

C. Its data source must be provided by a projection node.

D. It cannot be included in a calculation view of type dimension.

Correct Answer: B

Question 4

Why do you build a calculation view of type SQL Access only?

A. To provide a high-performance model when only attributes are required

B. To provide a data source that is only consumed by other calculation views

C. To provide a data source that can only be consumed by a function or procedure

D. To enable SQL access to your hierarchies

Correct Answer: B

Question 5

Which type of join supports a temporal condition in a calculation view?

A. Inner join

B. Left outer join

C. Text join

D. Referential join

Correct Answer: A

Question 6

Why do you implement Active / active read-enabled mode?

A. To enhance security for data access

B. To improve query performance

C. To provide offline access to data

D. To synchronize query results with operational data

Correct Answer: D

Question 7

You have imported a new calculation view in a folder that contains a .hdinamespace file. This calculation view consumes one data source which is a table. When trying to build the calculation view, there is a namespace-related issue and the build fails.
What could be the reason? Note: There are 2 correct answers.

A. The name space used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

B. The .hdinamespace file specifies a different name space property than the one in the identifier of the calculation view.

C. The imported calculation view and its data source have different namespaces.

D. The hdinamespace specifies "sub-folder": "append'', so calculation views can only be created in sub-folders.

Correct Answer: A,C

Question 8

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 defined in a calculation view of type SQL ACCESSONLY.

B. The hierarchy must be a local hierarchy.

C. The hierarchy must be a shared hierarchy.

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

Correct Answer: C,D

Question 9

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

A. Identify hierarchy nodes that have no parent

B. Describe the relationship between nodes using attributes

C. Count the number of siblings for each hierarchy node

D. Calculate distance between root and each hierarchy node

E. Determine the shortest path between each pair of nodes

Correct Answer: B,C,D

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA 2.0 (SPS05) (C_HANAIMP_17) Free Practice Test