Try Free SAP HANA 2.0 SPS05 C_HANADEV_17 Dumps

test2022-04-03T23:19:13+00:00

Looking for real C_HANADEV_17 Dumps? SAP Certified Development Associate – SAP HANA 2.0 SPS05 certification exam verifies that the candidate has the knowledge to develop native software applications running on the SAP HANA Platform. If you are looking for C_HANADEV_17 Dumps, FreeTestShare C_HANADEV_17 Dumps can help you pass SAP Certified Development Associate – SAP HANA 2.0 SPS05 Exam easily! We offer 100% real C_HANADEV_17 exam questions and answers for you to ace the C_HANADEV_17 exam on the first try!

Try these C_HANADEV_17 actual exam questions and answers for free.

Page 1 of 3

1. You need to restrict the selected columns exposed to the client .

Which OData capability do you use?

Parameter entity sets

Key specification

Aggregation

Property projection

2. Please review the JSON model in the screenshot.

Which of the following absolute binding paths are valid? Note: There are 3 correct answers to this question.

{company: {name: "ACME", info: {employees:3}, contacts: [{name: "Barbara", phone: "873"},{name: "Gerry", phone: '"734"}]}}

/contacts/0/name

/company/name

/company/contacts/2/phone

/company/info/employees

/company/contacts/1/name

3. In Node.js, which file do you use to define external module dependencies?

mta.yaml

package.json

pom.xml

server.js

4. You need to debug a Node.js application using SAP Web IDE for SAP HANA.

What must you do? Note: There are 3 correct answers to this question.

Open the debugger.

Attach debugger to the node module.

Specify the proper GIT repository in the debug properties.

Set a breakpoint in the application.

Build the application with the debug option.

5. Which keywords do you use to define an OData association? Note: There are 3 correct answers to this question.

UNION

PRINCIPAL

JOIN

DEPENDENT

MULTIPLICITY

6. You need to install SAP HANA 2.0, express edition to develop a native SAP HANA application .

Which of the following deployment options do you have? Note: There are 2 correct answers to this question.

Installation on Linux OS

Installation on Windows Server

Usage of virtual machine on Microsoft Windows

Installation on Mac OS

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

Imports

Synonyms

Views

Procedures

8. What are the characteristics of the calculation view of type "SQL Access Only"? There are 2 correct answers to this question.

Can be directly used for multidimensional analysis

Can be direct y accessed via SQL

Can be directly exposed to all client tools

Can be directly used as modeled data source for another view

9. You need to bind UI5 controls to a data source.

Between which parts of the SAPUI5 application must you create databinding?

Model and Controller

Controller and View

View and Model

Application Descriptor and View

10. You create an isolated block of code which runs as an independent transaction .

Which of the following SQL Script features do you use?

Autonomous transactions

Blocked transactions

Anonymous transactions

Anonymous transaction block

Page 2 of 3

11. You need to check user input data in your OData request .

Which exit type do you use?

Consistency

Modification

Verification

Validation

12. You create a multi-target application in SAP Web IDE for SAP HANA .

Which source code management option do you use?

SVC-based repository

SAP HANA repository

GIT-based repository

SAP HANA repository workspace

13. An OData service contains an entity set called Products .

Which resource path do you add to the OData service URL to view all available products?

/Products

/Products/"

/Products/ALL

/Products/$metadata

14. After reviewing the SQL Analyzer results, which of the following would you consider for optimizing the performance? There are 2 correct answers to this question

Re-prioritize with Workload Management.

Change the data model.

Use CE functions.

Modify SQL hints.

15. To comply with the SAP Fiori principles, which view type is recommended by SAP?

JSON

XML

HTML

JavaScript

16. What are some of the benefits of developing applications on SAP HANA? Note: There are 2 correct answers to this question.

Execution of stored procedures is faster due to the in-memory database.

Reliable segregation of OLAP and OLTP workloads on different SAP HANA databases.

Faster response times by using SAP HANA integrated UI rendering.

HTML5-compliant Web-based user interface is supported.

17. You create a simple data model to store user information. The model contains two tables: One for the user information, 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 to you perform if you use CDS artifacts only?

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.

Create two entities for the user and address. Create a User Details calculation view and join the user and address information.

Create two entities for the user and address. Create an association in the user entity to the address O 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 O entity. Define a User Details view using select on the user entity and using the association to read the address information.

18. In an SAPU15 application, where do you find the reference to sap-ui-core.js?

In the URL to the SAPU15 application

In the bound attributes data model

In the manifest.json descriptor file

In the bootstrap section of the index.html

19. You developed a multi-target application that contains only a database module .

Which environment are the runtime objects createdin? Please choose the correct answer.

Java Runtime Environment (JRE)

SAP HANA Runtime Tools (HRTT)

SAP Web IDE for SAP HANA

HANA Deployment Infrastructure Container

20. Which configuration file indicates the program that is executed upon startup when you run the Node.js module?

mta.yaml

project.json

package.json

server.js

Page 3 of 3

21. What do you reference in a role template? Please choose the correct answer.

Roles

Routes

Role Collections

Scopes

22. What are the issue categories that SQL Script Code Analyser scans for? There are 3 correct answers to this question.

Performance

Consistency

Security

Business logic

Privileges

23. You use path expressions (associations) in your Core Data Services to combine entities instead of using SQL joins.

What is a benefit to use these associations?

It increases the performance of the query.

It enforces referential constraint.

It improves the writability and readability of the query.

It invokes authorization checks on database level.

24. Which programming paradigms are supported by SQL Script? Note: There are 2 correct answers to this question.

Symbolic

Declarative

Logic

Imperative

25. An OData Service contains an entity set called Products.

Which resource path do you add to the OData Service URL to view the available products?

serviceURL/ Metadata / Products

serviceURL/ Format/ Products

serviceURL/Products

serviceURL/ Products/ Metadata

26. You create an SAP HANA extended application services, advanced model (XS advanced) multi-target application using the SAP Web IDE for SAP HANA.

Which files can be generated automatically by the wizard when you create the SAP HANA database (HDB)

module? Note: There are 2 correct answers to this question.

hdiconfig

package.json

hdinamespace

server.js

27. You need to synchronize all unsynchronized changes of the remote GIT branch with a local GIT branch .

Which operation do you use?

Pull

Push

Rebase

Reset

28. What statement must you insert to the following OData service to complete the navigation definition from the customer entity set to the corresponding sales orders?

Service{ "sample.odata;; customer" as "Customer" navigates ("Customer_Orders" as "toOrders");"sample.odata: salesorders" as "Orders";}

Key specification

Aggregation

Join condition

Association

29. Which GIT commands are available with the SAP Web IDE for SAP HANA? Note: There are 3 correct answers to this question.

Redeploy the code

Clone a repository

Merge changes

Push code

Test changes