Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

ATo ensure semantic correctness

BTo force filters to apply at the lowest node

CTo hide columns that are not required

DTo avoid duplicate rows in the output

Answer : B

Which of the following supports data replication?

ASAP HANA smart data access

BSAP HANA, streaming analytics option

CSAP HANA smart data quality

DSAP HANA smart data integration

Answer : D

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

Why would you develop an SQL procedure instead of a function?Note: There are 3 correct answers to this question.

AYou want to create a dynamic analytic privilege.

BA temporary table must be created within the code.

COptimal performance is a priority.

DThe code should modify data in a table.

EYou need to use conditional logic.

Answer : A, B, D

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

ADebug Query mode

BExplain plan

CSQL analyzer

DDatabase explorer

Answer : A

Free C_HANAIMP_18 Questions for SAP C_HANAIMP_18 Exam as PDF & Practice Test Software