SAP C_HANAIMP_18 Exam Practice Test Instant Access

Question 1

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

Question 2

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

Question 3

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

Question 4

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

Question 5

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

Question 6

Why does SAP issue warnings about the use of imperative or procedural SQLScript statements?

AThey could modify the database.

BThey call multiple processing engines.

CThey introduce potential security risks.

DThey can limit parallelization of query execution.

Answer : C

Question 7

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?

AA SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

BSELECT privileges and Analytic Privileges (Country = United States) on both views

CA SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

DA SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view

Answer : A

SAP C_HANAIMP_18 SAP Certified Application Associate - SAP HANA 2.0 SPS06 Exam Practice Test