Practice SAP HANA 2.0 SPS06 C_HANADEV_18 Exam Questions

Jonnie Karnath2023-07-24T07:34:14+00:00

The SAP Certified Development Associate – SAP HANA 2.0 SPS06 (C_HANADEV_18) exam is designed for individuals who want to demonstrate their knowledge and skills in developing applications using SAP HANA. Certspots offers SAP HANA 2.0 SPS06 C_HANADEV_18 Exam Questions to help individuals prepare for the exam. These C_HANADEV_18 practice questions are designed to simulate the actual exam and provide candidates with an opportunity to test their knowledge and identify areas that require further study. By using Certspots SAP HANA 2.0 SPS06 C_HANADEV_18 Exam Questions, individuals can gain the confidence and knowledge they need to successfully pass the SAP Certified Development Associate – SAP HANA 2.0 SPS06 (C_HANADEV_18) exam.

Page 1 of 3

1. You implement a native SAP HANA application using SAP HANA extended application services, advanced model (XS advanced) and SAPUI5. Where is the UI rendering executed? Please choose the correct answer.

On the SAPUI5 HTML5 module

On the SAP Fiori front-end server

On the front-end client device

On the XS advanced application server

2. Which Git commands are available with the SAP Web IDE for SAP HANA? There are 3 correct answers to this question.

Test changes

Push code

Clone a repository

Redeploy the code

Merge changes

3. You develop a Node.js application for the SAP HANA platform that executes a SQL statement in the SAP HANA database.

Which modules do you use? There are 2 correct answers to this question.

@sap/instance-manager

@sap/xsenv

@sap/hdbext

@sap/node-vsi

4. Which parameter do you adapt to change the file that is initially delivered by an HTML5 module? Please choose the correct answer.

Service_url parameter of the mta.xml file

Welcome file parameter of the xs-app.json file

Start parameter of the package.json file

Runners parameter of the projectjson file

5. Which of the following are characteristics of database procedures?

Database procedures can have both input and output parameters; however, a parameter CANNOT be both input and output.

Database procedures can have several output parameters, and a mix of both scalar and table types is possible.

If, in the database procedure header, you use the READS SQL DATA option, then INSERT statements are prohibited; however, dynamic SQL is allowed.

If, in the database procedure header, you use the SQL SECURITY INVOKER option, then only the owner of the procedure can start it.

6. Which Node.js module do you use to run an SQL statement against the SAP HANA database? Please choose the correct answer.

@sap/hdi

@sap/xsenv

@sap/xssec

@sap/hdbext

7. Which artifacts do you define in the persistence model to access objects in an external SAP HANA Deployment Infrastructure container? Please choose the correct answer.

Views

Synonyms

Imports

Procedures

8. What do you use to set up unit testing for your SQL Script procedure? Please choose the correct answer.

SQL Script logging procedures

A library with language SQLSCRIPT TEST

The SQL Script debugger

The SQL Script Code Analyzer

9. Which OData capacity do you use when you need to restrict the number or selection of exposed columns? Please choose the correct answer.

Parameter entity sets

Aggregation

Key specification

Property projection

10. Which elements can you specify with the SAP WeblDE for SAP HANA graphical editor for Core Data Services data models? There are 3 correct answers to this question.

Entity

Synonym

Procedure

Context

Association

Page 2 of 3

11. You define exception handling in a SQL Script procedure.

What can you use declare exit handlers for? There are 2 correct answers to this question.

Generic SQL conditions

Generic SQL exceptions

Specific SQL error codes

Specific SQL conditions

12. What are the main SAP HANA engines responsible for executing calculation views? There are 3 correct answers to this question.

Java Engine

XS Engine

OLAP Engine

Calculation Engine

Join Engine

13. What types of user-defined functions are supported by SAP HANA? Note: There are 2 correct answers to this question.

Table

Scalar

Aggregate

Hierarchy

14. Your multi-target application will use XSJS.

Which module type do you create in your application project? Please choose the correct answer.

Java

SAP HANA database

Node.js

HTML5

15. You implement an asynchronous Node.js service that sends requests to the database.

How do you handle the database responses? There are 2 correct answers to this question.

Process the callback methods in the order in which the requests are sent by the service.

Call a method directly after every send request.

Process the callback methods in the order in which the requests are returned from the database.

16. Which trace do you use to create a graphical representation of an individual SQL Statement? Please choose the correct answer.

Expensive statements trace

Performance trace

Plan trace

SQL trace

17. From which tool can you run the XS command line? Please choose the correct answer.

Local operating system shell

SAP HANA studio

SAP WeblDE for SAP HANA

SAP HANA cockpit

18. In which of the following objects can you use Commit and Rollback statements? Please choose the correct answer.

Scalar user-defined function

SQL Script procedure

Table user-defined function

Scripted calculation view

19. You need to create a native SAP HANA application that fully leverages the SAP HANA platform.

How do you implement data-intensive calculations? Please choose the correct answer.

Push the calculations onto the application layer.

Push the calculations onto the database layer

Push the calculations onto the presentation layer.

Distribute calculations between application layer and presentation layer.

20. Which application runtimes are currently supported by the SAP Cloud Application Programming Model? There are 2 correct answers to this question.

Node.js

Python

Java

Page 3 of 3

21. 1.Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question.

SCHEMAS

TABLES

OBJECTS

ROLES

22. You want to exclusively use declarative logic in an SQL Script procedure.

Which of the following operators can you use? There are 2 correct answers to this question.

COMM IT statement

IF condition

TABLE variable

MAP_REDUCE function

23. Which join type is NOT supported by join optimization (pruning)? Please choose the correct answer.

Outer Join

Text Join

Referential Join

Inner Join

24. A user is dropped with the "cascade" option. The user schema also contains objects owned by other users, or on which other users have privileges.

What happens to the objects? There are 2 correct answers to this question.

The objects on which other users have privileges are NOT dropped.

The objects on which other users have privileges are dropped.

The objects owned by other users are NOT dropped.

The objects owned by other users are dropped.

25. You create a simple data model to store user information. The model contains two tables: one for the user information, and the other for user address details.

The user can only have one address. You also need a view to show the complete information of the user including the address.

Which actions do you perform if you use CDS artifacts only? Please choose the correct answer.

Create two entities for the user and address. Create an association in the user entity to the address entity. Define a User Details view using select on the address entity and using the association to read the user information.

Create two entities for the user and address. Create an association in the user entity to the address entity.

Define a User Details view using select on the user entity and using the association to read the address information. Create two entities for the user and address. Extend the user entity with address columns.

Create a view named User Details using select on the user entity. x-s Create two entities for the user and address. Create a User Details calculation view and join the user and address information.

26. What are some of the advantages of SQL Script compared to plain SQL queries? There are 2 correct answers to this question.

It enables modular parameterized programing.

It increases performance by parallel execution of complex SQL statements.

It contains a well-defined ANSI standard.

It retrieves a high data volume from a database.

27. Which OData capacities are supported in SAP HANA extended application services, advanced model (XSA)? There are 3 correct answers to this question.

Union

Aggregation

Join

Projection

Association

28. What happens if you define a database object in the persistence model and deploying using the SAP HANA Deployment Infrastructure (HDI)? Please choose the correct answer.

A descriptive representation of the object is created in Hot during runtime.

The corresponding runtime object is created in the database module of the multi-target application during runtime.

The HDI container is created when the design-time object is saved.

The corresponding runtime object is created in the HDI container on deployment

29. How do you specify the target currency for currency conversion in calculation views? There are 3 correct answers to this question.

In a column

In a table function

With an input parameter

With a fixed value

In a procedure

Facebook Twitter LinkedIn Google + Email