C_HANAIMP_16 by SAP Valid Free Exam Practice Test

Question 1

In your calculation view, you need to define a custom data source using SQLScript. In which object do you write your SQL Script?

A. Table function B. Virtual Table C. CDS view D. Procedure

Correct Answer: A

Question 2

How can you define a variable that presents its value help hierarchically?
Note: There are2 correct answers to this question.

A. Create a level hierarchy and assign it to the variable.
Ensure the variable's reference column is the top level of the hierarchy. B. Create a level hierarchy and assign it to the variable.
Ensure the variable's reference column is the leaf level of the hierarchy. C. Create a parent-child hierarchy and assign it to the variable.
Ensure the variable's reference column is the child attribute of the hierarchy. D. Create a parent-child hierarchy and assign it to the variable.
Ensure the variable's reference column is the parent attribute of the hierarchy.

Correct Answer: B

Question 3

In SAP Web IDE for SAP HANA, what can a flowgraph generate in a predictive analysis scenario?
Note: There are 2 correct answers to this question.

A. Container B. Function C. Task D. Procedure

Correct Answer: C,D

Question 4

What is the disk storage layer used for?
Note: There are 2 correct answers to this question.

A. To improve the parallel processing of queries B. To store the data primarily used for transactional processing C. To enable data to be recovered if hardware fails D. To unload the least-used data when the memory is full

Correct Answer: C,D

Question 5

What can you use SAP HANA smart data access for?
Note: There are 2 correct answers to this question.

A. To replicate remote data sources B. To load and harmonize data from disparate sources C. To expose data from remote tables D. To push down queries to data sources

Correct Answer: C,D

Question 6

What can you identify using the Performance Analysis Mode?
Note: There are 2 correct answers to this question.

A. If the data is in the hot or warm storage tier B. Joins that are defined on calculated columns C. Information about join cardinality D. Usage statistics of the calculation view

Correct Answer: B,C

Question 7

Why might you use SAP HANA Graph with text analysis?

A. To highlight similarities between documents using hierarchies B. To illustrate multi-point relationships between text entities C. To uncover the dependencies between parts of speech D. To provide a visual method to build a custom text analysis

Correct Answer: D

Question 8

When would you develop an SQL procedure instead of a function?

A. You need to use conditional logic. B. You want to create a dynamic analytic privilege. C. The code should modify data in the table. D. You need to implement Data Definition Language (DDL) statements. E. Optimal performance is apriority.

Correct Answer: C

SAP Certified Application Associate - SAP HANA 2.0 (SPS04) - C_HANAIMP_16 Exam Practice Test