C_HANADEV_17 – SAP Certified Development Associate – SAP HANA 2.0 SPS05 (120 Questions)

By completing the “SAP Certified Development Associate – SAP HANA 2.0 SPS05” exam, the candidate may demonstrate that they have the skills necessary to create native software applications that work with the SAP HANA Platform. This certification expands on the fundamental information learned throughout relevant SAP HANA training. The course covers the programming languages and tools required to create the various components of a SAP HANA software application.

Topic Areas

C_HANADEV_17 – SAP Certified Development Associate – SAP HANA 2.0 SPS05 exam covers the following topics:

Get any SAP video course – https://zarantech.teachable.com/courses/category/sap

Exam details:

Here is the List of MCQ’s (Multiple Choice Questions):                         (The correct answers are mentioned with *)

1. From which tool can you run the XS command line? Please choose the correct answer.
a. SAP HANA cockpit
b. SAP HANA studio
c. Local operating system shell
d. SAP WebIDE for SAP HANA*

2. You create an SAP HANA extended application services, advanced model (XS advanced) multi-target application. What does the mta.xml file contain? Please choose the correct answer.
a. The Node.js package definition with dependencies and initial run configurations
b. The application global elements, modules, resources, properties, and parameters*
c. The application router description with the authentication methods and access routes
d. The plugin name and version for every supported file suffix

3. 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.
a. Push the calculations onto the database layer*
b. Push the calculations onto the presentation layer.
c. Push the calculations onto the application layer.
d. Distribute calculations between application layer and presentation layer.

4. In Node.js, which file do you use to define external module dependencies? Please choose the correct answer.
a. mta.yaml
b. pom.xml
c. server.js
d. package.json*

5. 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”;)
a. Association*
b. Join condition
c. Aggregation
d. Key specification

6. How do you specify the target currency for currency conversion in calculation views? There are 3 correct answers to this question.
a. In a table function
b. With a fixed value
c. With an input parameter*
d. In a column*
e. In a procedure*

7. Which OData capacities are supported in SAP HANA extended application services, advanced model (XSA)? There are 3 correct answers to this question.
a. Aggregation*
b. Projection*
c. Union
d. Association*
e. Join

8. Which of the following are characteristics of SAPUI5? There are 3 correct answers to this question.
a. Provides a device-specific user experience
b. Enables responsive application design*
c. Supports customer-specific theming*
d. Renders the UI on the server side
e. Provides an extensibility concept*

9. What are the steps to debug a Node.js application using SAP Web IDE for SAP HANA? There are 3 correct answers to this question.
a. Specify the proper Git repository in the debug properties.
b. Set a breakpoint in the application.*
c. Attach the debugger to the node module.*
d. Open the debugger.*
e. Build the application with the debug option.

10. You work on a multi-target application that uses the SAP HANA Deployment Infrastructure (HDI). Which operations can you perform in the SAP Web IDE for SAP HANA?
There are 2 correct answers to this question.
a. Choose the supported SAP HANA versions.
b. Create objects in the SAP HANA repository.*
c. Deploy HTML5 modules to the SAP HANA database.*
d. Configure the artifact namespaces.

11. What is the package descriptor package.json used for? There are 2 correct answers to this question.
a. To set the router version*
b. To define the routes
c. To list the package dependencies*
d. To define back-end destinations

12. You need to manage an exception in a SQLScript. Which SQLScript features can you use? There are 2 correct answers to this question.
a. SIGNAL*
b. DEFINE RESIGNAL
c. CREATE EXIT HANDLER
d. DECLARE EXIT HANDLER*

13. 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.
a. SET
b. UNSET
c. ARRAY
d. UNNEST*

14. Which Git command do you use to consolidate all changes from one branch with another branch using a single commit? Please choose the correct answer.
a. Merge*
b. Commit
c. Rebase
d. Push

15. 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? Please choose the correct answer.
a. A file with extension .hdbti*
b. A fie with extension .hdbtable
c. A file with extension .hdbdd

16. You created an HDI database role, using the SAP Web IDE for SAP HANA and deployed your project. Afterward, you made some modifications to the runtime role.
What happens when you change and re-build the design-time role? Please choose the correct answer.
a. The runtime modifications are overwritten.*
b. The deployment of the role fails.
c. You need to confirm the runtime modifications
d. The runtime modifications are kept.

17. You developed a multi-target application that contains only a database module. Which environment are the runtime objects created in? Please choose the correct answer.
a. HANA Deployment Infrastructure Container
b. SAP Web IDE for SAP HANA*
c. SAP HANA Runtime Tools (HRTT)
d. Java Runtime Environment (JRE)

18. 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.
a. A new service is executed on the application server.
b. The source code is compiled to create an executable binary file.*
c. The required modules are downloaded based on module dependencies.*
d. A new SAP HANA Deployment Infrastructure (HDI) container is created.

19. What do you use to set up unit testing for your SQL Script procedure? Please choose the correct answer.
a. SQL Script logging procedures
b. The SQL Script debugger*
c. The SQL Script Code Analyzer
d. A library with language SQLSCRIPT TEST

20. Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XS advanced)? There are 2 correct answers to this question.
a. Create an MTA project.
b. Store the source in the SAP HANA repository.*
c. Activate artifacts via _SYS_REPO.
d. Export the project as an MTA archive.*

Get any SAP video course – https://zarantech.teachable.com/courses/category/sap

21. 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.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
a. The objects owned by other users are dropped.*
b. The objects owned by other users are NOT dropped.
c. The objects on which other users have privileges are NOT dropped.
d. The objects on which other users have privileges are dropped.*

22. What are the characteristics of the calculation view of type “SQL Access Only”? There are 2 correct answers to this question.
a. Can be directly used as modelled data source for another view*
b. Can be directly used for multidimensional analysis
c. Can be directly exposed to all client tools
d. Can be direct y accessed via SQL*

23. 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? There are 2 correct answers to this question.
a. Installation on Linux OS*
b. Installation on Windows Server
c. Usage of virtual machine on Microsoft Windows*
d. Installation on Mac OS

24. 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. The corresponding runtime object is created in the database module of the multi-target application during runtime.
b. A descriptive representation of the object is created in Hot during runtime
c. The corresponding runtime object is created in the HDI container on deployment
d. The HDI container is created when the design-time object is saved.*

25. To perform a specific task of an XS advanced application, what does a user need? Please choose the correct answer.
a. To be assigned to a Space
b. To have directly assigned a Scope
c. To have directly assigned a Role Collection*
d. To be assigned to an Organization

26. Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question.
a. SCHEMAS*
b. ROLES
c. TABLES*
d. OBJECTS

27. Which keywords do you use to define an OData association? There are 3 correct answers to this question.
a. DEPENDENT*
b. UNION
c. JOIN
d. PRINCIPAL*
e. MULTIPLICITY*

28. In a calculation view, what are the different types of input mapping available in Table Function? There are 2 correct answers to this question.
a. Variable
b. Formula
c. Constant*
d. Data Source Column*

29. What are the main SA P HANA engines responsible for executing calculation views? There are 3 correct answers to this question.
a. Calculation Engine*
b. Join Engine*
c. Java Engine
d. XS Engine
e. OLAP Engine*

30. Which of the following information must you specify when you create a new project in SAP Web IDE for SAP HANA? There are 2 correct answers to this question.
a. Project name*
b. SAP HANA database version
c. Template
d. Namespace*

31. You configure an OData service for a transactional SAPUI5 application. What is the default data access behavior of the OData service? Please choose the correct answer.
a. Read: Yes Create: No Update: Yes Delete: No
b. Read: Yes Create: Yes Update: Yes Delete: No
c. Read: Yes Create: Yes Update: Yes Delete: Yes
d. Read: Yes Create: No Update: No Delete: No*

32. In application development with XS advanced, which of the following entities belong to a specific SPACE? There are 2 correct answers to this question.
a. Users*
b. Organizations*
c. Applications
d. Processes

33. 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.
a. Register a callback method for every sent request.*
b. Call a method directly after every send request.
c. Process the callback methods in the order in which the requests are sent by the service.
d. Process the callback methods in the order in which the requests are returned from the database.*

34. What are the characteristics of SAP HANA calculation views? There are 2 correct answers to this question.
a. Do NOT need an application server to execute
b. Need an application server to execute*
c. Do NOT need database tables to execute
d. Need database tables to execute*

35. What are the key characteristics of the calculation view’s Input Parameter? There are 3 correct answers to this question.
a. It can NOT be used to filter measure values.
b. It is passed via reserved word PLACEHOLDER.
c. It can be used in a conditional expression.
d. It can be used to pass values to table functions.
e. It is passed using a WHERE clause.

36. You need to check user input data in your OData request. Which exit type do you use? Please choose the correct answer.
a. Modification
b. Validation*
c. Verification
d. Consistency

37. 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.
a. Keep flag
b. Non-equijoin
c. Transparent filter*
d. Dynamic join*

38. Who owns the database objects created in an SAP HANA Deployment Infrastructure (HDI) container? Please choose the correct answer.
a. The generated, container-specific technical user
b. The database user with the generated database role, suffix ‘::access_role’*
c. The database user with the generated database role, suffix ‘::external_privileges_role’*
d. The SAP HANA extended application services, advanced model (XS advanced) user who deployed the CDS model*

39. 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.
a. Change the data model.
b. Modify SQL hints.
c. Re-prioritize with Workload Management.*
d. Use CE functions.*

40. 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?
Please choose the correct answer.
a. /Products*
b. /Products/$metadata
c. /Products/’
d. /Products/ALL

41. 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.
a. @sap/instance-manager*
b. @sap/hdbext
c. @sap/node-vsi
d. @sap/xsenv

42. Which of the following joins can be defined only with multi-column join in calculation views? Please choose the correct answer.
a. Dynamic join
b. Text join
c. Temporal join*
d. Multi join

43. What are the different types of graphical calculation views that can handle measures? There are 2 correct answers to this question.
a. Cube
b. Cube with star join*
c. Dimension*
d. SQL Access Only

44. Which OData service do you use to prevent changes to existing line items of the sap.test :myTable table? Please choose the correct answer.
a. service {
“sap.test::myTable” update forbidden;
)
b. service {
“sap.test::myTable” update no-authorization;
}
c. service { “sap.test::myTable” update prohibited;
)*

d. service { “sap.test::myTable” update exclude;
)

45. You need to synchronize all unsynchronized changes of the remote Git branch with a local Git branch. Which operation do you use? Please choose the correct answer.
a. Reset
b. Push*
c. Pull
d. Rebase

46. You need to consume a Node.js service in an SAPUI5 application. In which section of the mta.xml file do you define the variable for the exposed service? Please choose the correct answer.
a. In the provides section of the Node.js module
b. In the requires sect on of the HTML5 module*
c. In the properties sect on of the MTA resources
d. In the path section of the Node.js module

47. What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question.
a. Rank
b. Union
c. Star join*
d. Aggregation*

48. You create a multi-target application in SAP Web IDE for SAP HANA. Which source code management option do you use? Please choose the correct answer.
a. SAP HANA repository workspace
b. SVC-based repository
c. Git-based repository*
d. SAP HANA repository

49. In an SQL Script procedure, which feature do you use to initialize IN/OUT table parameters? Please choose the correct answer.
a. SET
b. DEFAULT EMPTY*
c. DEFAULT
d. IS_EMPTY

50. In which of the following objects can you use Commit and Rollback statements? Please choose the correct answer.
a. Scalar user-defined function
b. Table user-defined function
c. SQL Script procedure*
d. Scripted calculation view

Join SAP Learner Community on LinkedIn – https://www.linkedin.com/showcase/sap-learner-community

51. Which metadata declarations can you specify in a SQL Script procedure when you use the SAP HANA Deployment Infrastructure? There are 2 correct answers to this question.
a. Language*
b. Authorization
c. Security*
d. Default schema

52. 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.
a. Specific SQL conditions
b. Generic SQL conditions
c. Generic SQL exceptions*
d. Specific SQL error codes*

53. Which new components can you use to develop native SAP HANA applications in SAP HANA extended application services, advanced model (XS advanced)? There are 2 correct answers to this question.
a. SAP HANA studio*
b. SAP Web IDE for SAP HANA*
c. SAP HANA repository
d. Git repository

54. 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?
a. Please choose the correct answer.
b. On the SAP Fiori front-end server
c. On the SAPUI5 HTML5 module*
d. On the XS advanced application server
e. On the front-end client device

55. 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.
a. Procedures
b. Imports
c. Views
d. Synonyms*

56. You are working on an entity using Core Data Services. Which properties can you define inside the Technical Configuration section? There are 2 correct answers to this question.
a. Index*
b. Storage Type*
c. Association
d. Import

57. You use APPLY_FILTER to add a dynamic WHERE clause on SELECT statements. On which objects can you apply the filter? There are 2 correct answers to this question. Response:
a. Database tables*
b. Intermediate table variables*
c. Scalar variables
d. Virtual tables

58. Which SAP HANA extended application services, advanced model (XS advanced) tools can you use to retrieve the URL for the SAP WebIDE for SAP HANA? There are 2 correct answers to this question.
a. XS advanced Controller Start Screen
b. Runtime tool*
c. Organization and Space Management tool
d. XS Advanced command-line client tool*

59. Which rules apply to declarative logic in SQL Script? There are 2 correct answers to this question.
a. It supports the full set of SQL Script.
b. It is free of side effects.*
c. It declares the flow of data.*
d. It defines how data is processed.

60. Which join type is NOT supported by join optimization (pruning)? Please choose the correct answer.
a. Referential Join*
b. Text Join
c. Outer Join
d. Inner Join

61. Which of the following elements can be part of the UI5 application’s index.html file? There are 2 correct answers to this question.
a. Backend Connection
b. Bootstrap*
c. UI-Area*
d. Framework Reference

62. Which configuration file indicates the program that is executed upon start up when you run the Node.js module? Please choose the correct answer.
a. server.js*
b. package.json
c. mta.yaml
d. project.json

63. 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.
a. Create two entities for the user and address. Create a User Details calculation view and join the user and address information.
b. 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.
c. 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. *
d. 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.

64. 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.
a. GET*
b. READ
c. INSERT
d. POST*
e. PUT*

65. Which application runtimes are currently supported by the SAP Cloud Application Programming Model? There are 2 correct answers to this question.
a. Go
b. Node.js*
c. Java*
d. Python

66. What characterizes the Node.js environment? There are 2 correct answers to this question.
a. It uses a synchronous programming model.
b. It is built on Google’s V8 JavaScript engine.*
c. It is a client-side design-time environment for JavaScript.
d. It is single-threaded.*

67. How do you debug a Node.js module in SAP Web IDE for SAP HANA? Please choose the correct answer.
a. Add the sap.hana .xs.debugger::Debugger role to the HDI Container’s #RT User.
b. Attach the debugger to the application in the SAP Web IDE for SAP HANA.*
c. Set the enabled parameter to true in the section debugger of the xsengine.ini file.
d. Start the debugger from the XS command line interface and run the program in SAP Web IDE for SAP HANA.

68. Which services can you use in SAP HANA, express edition? There are 3 correct answers to this question.
a. Dynamic tiering
b. Columnar OLTP and OLAP*
c. Text analytics*
d. System replication
e. Multi-core and parallelization*

69. You need to view the data model exposed by an OData V2 service. What must you append to the service URL? Please choose the correct answer.
a. $service definition
b. $format
c. $metadata*
d. $schema

70. Which Node.js module do you use to run an SQL statement against the SAP HANA database? Please choose the correct answer.
a. @sap/hdbext*
b. @sap/hdi
c. @sap/xsenv
d. @sap/xssec

71. You need to combine data from different database tables within your OData service. Which capability do you use for this relationship? Please choose the correct answer.
a. Entity sets
b. Aggregations
c. Projections
d. Associations*

72. What are the different types of graphical calculation views that can handle measures? There are 2 correct answers to this question.
a. SQL Access Only
b. Cube with star join*
c. Dimension*
d. Cube

73. Which parameter do you adapt to change the file that is initially delivered by an HTML5 module? Please choose the correct answer.
a. Start parameter of the package.json file
b. Welcome file parameter of the xs-app.json file*
c. Service_url parameter of the mta.xmI file
d. Runners parameter of the projectjson file

74. What are the main SA P HANA engines responsible for executing calculation views? There are 3 correct answers to this question.
a. XS Engine
b. Join Engine*
c. OLAP Engine*
d. Calculation Engine*
e. Java Engine

75. 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.
a. Create two entities for the user and address. Create a User Details calculation view and join the user and address information.
b. 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.
c. 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.*
d. 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.

76. What key words are contained in the application descriptor file (xs-app.json)? There are 2 correct answers to this question.
a. tenant-mode
b. authentication Method*
c. role-templates
d. routes*

77. Which parameters does the APPLY_FILTER function support? There are 2 correct answers to this question.
a. Filter condition*
b. Table variable*
c. Entity set
d. Join condition

78. Which Git commands are available with the SAP Web IDE for SAP HANA? There are 3 correct answers to this question.
a. Merge changes*
b. Push code*
c. Redeploy the code
d. Clone a repository*
e. Test changes

79. Which metadata declarations can you specify in a SQL Script procedure when you use the SAP HANA Deployment Infrastructure? There are 2 correct answers to this question.
a. Security*
b. Language*
c. Default schema
d. Authorization

80. What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question.
a. Union
b. Aggregation*
c. Star join*
d. Rank

81. 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.
a. A new service is executed on the application server.
b. The required modules are downloaded based on module dependencies.*
c. The source code is compiled to create an executable binary file.*
d. A new SAP HANA Deployment Infrastructure (HDI) container is created.

82. In a calculation view, what are the different types of input mapping available in Table Function? There are 2 correct answers to this question.
a. Variable
b. Constant*
c. Data Source Column*
d. Formula

83. What are the issue categories that SQL Script Code Analyser scans for? There are 3 correct answers to this question.
a. Performance*
b. Security*
c. Business logic
d. Privileges
e. Consistency*

84. Which OData capacities are supported in SAP HANA extended application services, advanced model (XSA)? There are 3 correct answers to this question.
a. Aggregation*
b. Join
c. Union
d. Association*
e. Projection*

85. Which activities do you perform on an application in the SAP HANA XS Advanced Cockpit? There are 2 correct answers to this question.
a. Display HDI container content.
b. Deploy applications to SAP Cloud Platform.
c. Start, stop, and restart applications.*
d. Monitor applications assigned to the current space.*

86. 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.
a. Procedures
b. Imports
c. Synonyms*
d. Views

87. Which OData service do you use to prevent changes to existing line items of the sap.test :myTable table? Please choose the correct answer.
a. service { “sap.test::myTable” update prohibited;
)
b. service { “sap.test::myTable” update exclude;
)
c. service {
“sap.test::myTable” update forbidden;
)*
d. service {
“sap.test::myTable” update no-authorization;
}

88. To which SAP HANA authorization entities can you grant a role? There are 2 correct answers to this question.
a. Role*
b. User*
c. Object
d. Privilege

89. 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.
a. On the XS advanced application server
b. On the SAP Fiori front-end server
c. On the front-end client device
d. On the SAPUI5 HTML5 module*

90. You create an SAP HANA extended application services, advanced model (XS advanced) multi-target application. What does the mta.xml file contain? Please choose the correct answer.
a. The Node.js package definition with dependencies and initial run configurations
b. The application router description with the authentication methods and access routes
c. The plugin name and version for every supported file suffix
d. The application global elements, modules, resources, properties, and parameters*

Join SAP Learner Community on LinkedIn – https://www.linkedin.com/showcase/sap-learner-community

91. You are working on an entity using Core Data Services. Which properties can you define inside the Technical Configuration section? There are 2 correct answers to this question.
a. Association
b. Import
c. Index*
d. Storage Type*

92. Who owns the database objects created in an SAP HANA Deployment Infrastructure (HDI) container? Please choose the correct answer.
a. The generated, container-specific technical user*
b. The SAP HANA extended application services, advanced model (XS advanced) user who deployed the CDS model
c. The database user with the generated database role, suffix ‘::access_role’
d. The database user with the generated database role, suffix ‘::external_privileges_role’

93. What are the disadvantages when deploying Dynamic SQL? There are 2 correct answers to this question.
a. No possibility to bind the result to a SQL Script variable
b. Limited opportunities for optimization*
c. Additional SQL execution privileges are required
d. No possibility to use SQL Script variables*

94. Which keywords do you use to define an OData association? There are 3 correct answers to this question.
a. MULTIPLICITY*
b. UNION
c. DEPENDENT*
d. PRINCIPAL*
e. JOIN

95. 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? There are 2 correct answers to this question.
a. Installation on Mac OS
b. Installation on Windows Server
c. Installation on Linux OS*
d. Usage of virtual machine on Microsoft Windows*

96. 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.
a. IF condition
b. MAP_REDUCE function*
c. COMM IT statement
d. TABLE variable*

97. What are some of the advantages of SQLScript compared to plain SQL queries? There are 2 correct answers to this question.
a. It enables modular parameterized programing.*
b. It contains a well-defined ANSI standard.
c. It retrieves a high data volume from a database.
d. It increases performance by parallel execution of complex SQL statements.*

98. 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.
a. Register a callback method for every sent request.*
b. Process the callback methods in the order in which the requests are returned from the database.*
c. Call a method directly after every send request.
d. Process the callback methods in the order in which the requests are sent by the service.

99. What is the package descriptor package.json used for? There are 2 correct answers to this question.
a. To list the package dependencies*
b. To define back-end destinations*
c. To define the routes

100. You need to consume a Node.js service in an SAPUI5 application. In which section of the mta.xml file do you define the variable for the exposed service? Please choose the correct answer.
a. In the provides section of the Node.js module
b. In the path section of the Node.js module
c. In the requires sect on of the HTML5 module*
d. In the properties sect on of the MTA resources

101. Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XS advanced)? There are 2 correct answers to this question.
a. Store the source in the SAP HANA repository.*
b. Activate artifacts via _SYS_REPO.
c. Create an MTA project.
d. Export the project as an MTA archive.*

102. 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?
Please choose the correct answer.
a. A file with extension .hdbdd
b. A file with extension .hdbtable data
c. A file with extension .hdbti*
d. A fie with extension .hdbtable

103. 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.
a. Keep flag
b. Transparent filter*
c. Dynamic join*
d. Non-equijoin

104. 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? Please choose the correct answer.
a. /Products/’
b. /Products/ALL
c. /Products/$metadata
d. /Products*

105. Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question.
a. ROLES
b. TABLES*
c. OBJECTS
d. SCHEMAS*

106. 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.
a. @sap/instance-manager
b. @sap/node-vsi
c. @sap/xsenv*
d. @sap/hdbext*

107. Which Git command do you use to consolidate all changes from one branch with another branch using a single commit? Please choose the correct answer.
a. Merge*
b. Push
c. Rebase
d. Commit

108. Which functionality is provided by SAP WebIDE for SAP HANA? There are 2 correct answers to this question.
a. Build and deploy applications*
b. Organization and space management
c. User management
d. Syntax-aware editors for code*

109. 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.
a. ARRAY
b. UNNEST*
c. UNSET
d. SET

110. Which tool do you use to create a calculation view in a multi-target application? Please choose the correct answer.
a. SAP HANA studio
b. SAP Web IDE for SAP HANA*
c. SAP HANA database explorer
d. SAP HANA Web-based Development Workbench

111. Which OData capacity do you use when you need to restrict the number or selection of exposed columns? Please choose the correct answer.
a. Property projection*
b. Aggregation
c. Parameter entity sets
d. Key specification

112. 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? There are 3 correct answers to this question.
a. Create a view that refers to the table.
b. Create a synonym for the remote table object.*
c. Create a synonym that refers to the view.
d. Create a view that refers to a synonym.*
e. Create/update the .hdbgrants file providing authorizations for the remote schema.*

113. You created several database tables in a multi-target application and need to keep their names as short as possible. Which parameter of the .hdinamespace file do you set to ignore?
Please choose the correct answer.
a. Subfolder*
b. mixinTypes
c. name
d. hdbtable

114. Which elements can you specify with the SAP WebIDE for SAP HANA graphical editor for Core Data Services data models? There are 3 correct answers to this question.
a. Synonym
b. Entity*
c. Association*
d. Context *
e. Procedure

115. Which OData capacity do you use when you need to restrict the number or selection of exposed columns? Please choose the correct answer.
a. Parameter entity sets
b. Key specification
c. Property projection*
d. Aggregation

116. Which tool do you use to create a calculation view in a multi-target application? Please choose the correct answer.
a. SAP HANA Web-based Development Workbench
b. SAP HANA studio
c. SAP HANA database explorer
d. SAP Web IDE for SAP HANA*

117. Your multi-target application will use XSJS. Which module type do you create in your application project? Please choose the correct answer.
a. Node.js*
b. Java
c. HTML5
d. SAP HANA database

118. Why do you use associations in your persistence model for SAP HANA extended application services, advanced model (XS advanced)? Please choose the correct answer.
a. To define the relationships between contexts and views
b. To define multiplicity and key of an entity relation
c. To enforce database-level constraints
d. To set relationships between multiple contexts*

119. Why do you use associations in your persistence model for SAP HANA extended application services, advanced model (XS advanced)? Please choose the correct answer.
a. To set relationships between multiple contexts*
b. To define multiplicity and key of an entity relation
c. To enforce database-level constraints
d. To define the relationships between contexts and views

120. What do you reference in a role template? Please choose the correct answer.
a. Role Collections*
b. Routes
c. Scopes
d. Roles

Hope these MCQ’s will help you with your SAP certification.

Good Luck!!

Get any SAP video course – https://zarantech.teachable.com/courses/category/sap

Join SAP Learner Community on LinkedIn – https://www.linkedin.com/showcase/sap-learner-community

Visit our website – https://wwwzarantech.com

Keep learning & innovating!

Here is some other SAP Certification MCQ’s for your reference:

C_HANAIMP_17 – SAP Certified Application Associate – SAP HANA 2.0 (SPS05) (80 Questions)

C_HANADEV_18 – SAP Certified Development Associate – SAP HANA 2.0 SPS06 (136 Questions)