SAP C_HANAIMP_18 Exam Questions Instant Access

Question 1

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

ABuild the project -> Build the HDB module

BExport the HDB module -> Export the project

CActivate the project -> Build the HDB module

DBuild the HDB module -> Build the project

Answer : A

Question 2

What is the SQL keyword used to process input parameters defined in a calculation view?

AHint

BPlaceholder

CWhere

DSet

Answer : B

Question 3

Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

ADynamic

BHierarchy function

CSQL expression

DAttributes

EGraph

Answer : A, C, D

Question 4

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

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

BTo retain the correct aggregation behavior in stacked views

CTo include columns that are NOT requested by a query but are essential for the correct result

DTo exclude columns that are NOT requested by a query to avoid incorrect results

Answer : C

Question 5

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

ATo enable SQL access to your hierarchies

BTo provide a data source that can only be consumed by a function or procedure

CTo provide a high performance model when only attributes are required

DTo provide a data source that is only consumed by other calculation views

Answer : D

Question 6

Why would you create SQL in calculation views?

ATo implement custom logic

BTo provide an alternative to graphical modeling

CTo enable write capabilities

DTo fine-tune performance

Answer : A

Question 7

Which of the following data sources can you include in a graphical calculation view?Note: There are 2 correct answers to this question.

AProcedure

BRow table

CScalar function

DTable function

Answer : B, D

SAP Certified Application Associate - SAP HANA 2.0 SPS06 C_HANAIMP_18 Exam Questions