SAP Certified Application Associate - SAP HANA Cloud Modeling Sample Questions:

1. Why would an SQL developer work with SQLScript?Note: There are 3 correct answers to this question.

A) To include ABAP syntax in the code
B) To exploit additional data types
C) To implement conditional logic
D) To pass parameters from calculation views
E) To automate the generation of the code

2. You created a procedure to be consumed in an analytic privilege of the type DYNAMIC, but it isn't working as expected.What could be the reason?Note: There are 2 correct answers to this question.

A) You defined more than one output parameter
B) No input parameter is specified
C) The procedure is write-enabled
D) The output parameter is defined as NVARCHAR

3. You set the Null Handling property for an attribute but do not set a default value.What is displayed when null values are found in a column of data type NVARCHAR?

A) <empty string>
B) "?"
C) "0"
D) "Null"

4. You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned.

What could be the problem?Note: There are 2 correct answers to this question.

A) Join cardinality is set :1.
B) The Country column is requested.
C) The Keep flag is activated for the Customer column.
D) Integrity constraint is set to RIGHT.

5. Why would you use parameter mapping in a calculation view?Note: There are 2 correct answers to this question.

A) To convert the data types of input parameters
B) To pass variable values to external value help views
C) To assign variables to one or more attributes
D) To push down filters to the lowest level calculation views

Solutions: