C_HANAIMP_18 Practice Online

Question 1

What conditions must be met before you can implement time dependency on a hierarchy in a calculation view? (2 Correct)

A : The hierarchy must be a parent-child hierarchy.

B : The hierarchy must be a level hierarchy.

C : The key date parameter must be derived from an input parameter

D : The hierarchy must be enabled for SQL access

Answer: A,D

Question 2

Which of the following can a level hierarchy do?

A : Have time-dependency

B : Be used for a bill of materials (BOM) structure

C : Enable drill down in a value help list

D : Show variable deepness in the data

Answer: C

Question 3

What is used in SQL to indicate that there is no value?

A : Zero

B : Empty quotes

C : NULL

D : Spaces

Answer: C

Question 4

Your newly created analytic privilege does NOT want to build. What must you do?

A : Grant rights to the _SYS_REPO user

B : Assign the ::access role to the HDI container user.

C : Change the Apply Privileges property of the view.

D : Change the analytic privilege to use an SQL Expression.

Answer: C

Question 5

Which tool generates and executes the SQL for a specific node of your calculation view?

A : Debug Query mode

B : Explain plan

C : SQL analyzer

D : Database explorer

Answer: A

Name:	SAP Certified Application Associate - SAP HANA 2.0 SPS06
Exam Code:	C_HANAIMP_18
Certification:	SAP Certified Application Associate
Vendor:	SAP
Total Questions:	428
Last Updated:	Apr 23, 2024