SAP Certified Development Associate - SAP HANA 2.0 SPS02

Question 1

You have created two analytic views for actual and planned financial data each. The data covers multiple years. You want to display the actual data, planned data, and their difference in three separate columns in a report. The difference column is a calculated column.
How can you model this?

A. - Combine the analytic views in the new analytic view using a referential join

B. - Combine the analytic views in the calculation view using a UNION
WITH CONSTANT VALUES

C. - Combine the analytic views in a new calculation view using a UNION

D. - Combine the analytic views in the calculation view using a UNION

Correct Answer: B

Question 2

In the SAP HANA repository, you have an SAPUI5 application without
data exchange with the SAP HANA platform. You need to migrate the
application to SAP HANA extended application services, advanced
model (XS advanced).
Which objects do you need to create in SAP Web IDE for SAP HANA?
Note: There are 2 correct answers to this question.

A. HDB module

B. HTML5 module

C. NodE.js module

D. Multi-Target application project

Correct Answer: B,D

Question 3

You want to create a graphical calculation view using the SAP
HANA studio. Which steps are mandatory for this task? (Choose
three)

A. Save and activate the view.

B. Define output fields.

C. Write an SQL script.

D. Define a projection.

E. Choose a data sourcE.

Correct Answer: A,B,E

Question 4

Which Administration and Monitoring tools are included
in the SAP HANA extended application services, advanced
model (XS advanced)?
Note: There are 2 correct answers to this question.

A. User Management

B. Version Control

C. Application Role Builder

D. Change Management

Correct Answer: A,C

Question 5

In a Query panel, Report developer wants to add multiple
conditions in a Where clause statement. Which of the operator
type should be used?

A. Arithmetic operator

B. Set Operator

C. Relational or comparison operator

D. Boolean Operator

Correct Answer: D

Question 6

A SAP HANA developer has two tables and while joining
the tables he is getting output as number of rows in table A
multiplied by table B.
Which of the below Join type is used?

A. Cross join

B. Inner join

C. Outer join

D. Self join

Correct Answer: A

Question 7

You created a model on a table XYZ.PRODUCTS. You
successfully activated the model. When you run the data preview you
receive an error message "Insufficient privilegE. Not authorized".
Which of the following 4 statements do you execute to resolve the
error before you reactivate the model?

A. GRANT SELECT on SCHEMA XYZ to _SYS_REPO

B. GRANT SELECT on PRODUCTS to _SYS_REPO WITH
GRANT OPTION

C. GRANT SELECT on SCHEMA XYZ to _SYS_BIC WITH
GRANT OPTION

D. GRANT SELECT on PRODUCTS to _SYS_BIC

Correct Answer: B

Question 8

You want to aggregate the grand total sales amount into one
currency.
In which of the following cases would you perform the calculation
before aggregation? (Choose two)

A. When a line item table contains sales values in one currency.

B. When an aggregate table by country contains sales values in
one currency.

C. When an aggregate table by country contains sales values
in three different currencies.

D. When a line item table contains sales values of two
different currencies.

Correct Answer: C,D

SAP Certified Development Associate - SAP HANA 2.0 SPS02 - C-HANADEV-14 Exam Practice Test

Latest Update

Useful Links

Contact Us