SAP HANA 2.0 SPS04 Exam C_HANADEV_16 Dumps Questions

1. Which of the following SQL Script elements do you use to transform a set of arrays into an intermediate table variable? Please choose the correct answer.

2. Your team develops an application using SAP Web IDE for SAP HANA.

How can you share the application source code with other team users?

3. You develop native SAP HANA applications in SAP HANA extended application services, advanced model (XS advanced).

What are some of the advantages compared to developing in SAP HANA extended application services, classic model (XS classic)? Note: There are 3 correct answers to this question.

4. Which services can you use in SAP HANA 2.0, express edition? Note: There are 3 correct answers to this question.

5. In a calculation view, what are the different types of input mapping available in Table Function? There are 2 correct answers to this question.

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

7. You need to access a remote database table object within your HDB module in an MTA project. In SAP HANA extended application services, advanced model (XS advanced) a user-provided service was created to access the external schema. The service is already declared in the MTA project YAML file.

Which activities do you perform? Note: There are 3 correct answers to this question.

8. A Node.js module is executed for the first time in SAP HANA extended application services, advanced model (XS advanced).

Which of the following activities are performed automatically? There are 2 correct answers to this question.

9. Which of the following models a servet-side model in the SAPUI5 context?

10. What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question.

11. Which activities do you perform with the Applications tool of SAP HANA XS Advanced Cockpit? Note: There are 2 correct answers to this question.

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

13. Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XS advanced)? Note: There are 3 correct answers to this question.

14. Which of the following SQLScript elements do you use to transform a set of arrays into an intermediate table variable?

15. You need to view the data model exposed by an OData V2 service.

What must you append to the service URL?

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

17. For what do you use the RESIGNAL statement in SQLScript?

18. 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.

19. Your multi-target application will use XSJS.

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

20. You use APPLY_FILTER to add a dynamic WHERE clause on SELECT statements.

On which objects can you apply the filter? Note: There are 2 correct answers to this question.

21. Which new components can you use to develop native SAP HANA applications in SAP HANA extended application services; advanced model (XS advanced)? Note: There are 2 correct answers to this question.

22. 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"}]}}

23. Which elements can you specify with the SAP Web IDE for SAP HANA graphical editor for Core Data Services data models? Note: There are 3 correct answers to this question.

24. Which of the following joins can be defined only with multi-column join in calculation views? Please choose the correct answer.

25. To perform a specific task of an XS advanced application, what does a user need? Please choose the correct answer.

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

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

28. You define exception handling in a SQLScript procedure.

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

29. You implement a native SAP HANA application using SAP HANA extended application services, advanced mode (XS advanced) and SAPUI5.

Where is the UI rendering executed?

30. Which parameters does the APPLY_FILTER function support? There are 2 correct answers to this question.

31. You need to initially load data from a .CSV file into a Core Data Services table in SAP HANA extended application services; advanced model (XS advanced).

Which file type do you create?

32. 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.

33. How do you debug a Node.js module in SAP Web IDE for SAP HANA?

34. You configure an OData service for a transactional SAPUI5 application What is the default data access behavior of the OData service?

35. You develop an OData service using XSODATA.

Which HTTP commands can you use to define the operations on the resources? There are 3 correct answers to this question.

36. 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

37. Which metadata declarations can you specify in an SQLScript procedure when you use the SAP HANA Deployment Infrastructure? Note: There are 2 correct answers to this question.

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

Which of the following SQLScript features do you use?

39. Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XS advanced)? Note: There are 2 correct answers to this question.

40. 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";}