Q22. In Node.js, which file do you use to define external module dependencies? Please choose the correct answer.

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

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

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

Q26. Your multi-target application will use XSJS. Which module type do you create in your application project? Please choose the correct answer.

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

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

Q29. What are the characteristics of SAP HANA calculation views? There are 2 correct answers to this question.

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

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

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

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

Q34. What characterizes the Node.js environment? There are 2 correct answers to this question.

Q35. 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? Please choose the correct answer.
service{ “sample.odata::customer” as customer” navigates (“Customer_Orders* as “toOrders); “sample.odata::salesorder” as “Orders”;)

Q36. You need to check user input data in your OData request. Which exit type do you use? Please choose the correct answer.

Q37. You are asked to produce sales value for the month using sales order line items (sales price per item x quantity sold) what do you use to achieve this in a calculated column of a calculation view? There are 2 correct answers to this question.

Q38. Which activities do you perform on an application in the SAP HANA XS Advanced Cockpit? There are 2 correct answers to this question.

Q39. Who owns the database objects created in an SAP HANA Deployment Infrastructure (HDI) container? Please choose the correct answer.

Q40. What are the key characteristics of the calculation view’s Input Parameter? There are 3 correct answers to this question.