SAP Activate Project Manager Sample Questions:
QUESTIONS
01. 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
02. To which SAP HANA authorization entities can you grant a role?
There are 2 correct answers to this question.
a) User
b) Role
c) Privilege
d) Object
03. 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) READ
b) GET
c) PUT
d) INSERT
e) POST
04. Which of the following are characteristics of SAPUI5?
There are 3 correct answers to this question.
a) Provides an extensibility concept
b) Supports customer-specific theming
c) Enables responsive application design
d) Renders the UI on the server side
e) Provides a device-specific user experience
05. 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) Process the callback methods in the order in which the requests are sent by the service.
b) Call a method directly after every send request.
c) Process the callback methods in the order in which the requests are returned from the database.
d) Register a callback method for every sent request.
06. Which tool do you use to create a calculation view in a multi-target application?
Please choose the correct answer.
a) SAP Web IDE for SAP HANA
b) SAP HANA studio
c) SAP HANA Web-based Development Workbench
d) SAP HANA database explorer
07. You need to access a remote database table object within your HDB module in a Multi-target application 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 Multi-target application 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/update the .hdbgrants file providing authorizations for the remote schema.
e) Create a view that refers to a synonym.
08. What are some of the advantages of SQLScript compared to plain SQL queries?
There are 2 correct answers to this question.
a) It contains a well-defined ANSI standard.
b) It enables modular parameterized programing.
c) It retrieves a high data volume from a database.
d) It increases performance by parallel execution of complex SQL statements.
09. You need to manage an exception in a SQLScript. Which SQLScript features can you use?
There are 2 correct answers to this question.
a) DEFINE RESIGNAL
b) CREATE EXIT HANDLER
c) SIGNAL
d) DECLARE EXIT HANDLER
10. What characterizes the Node.js environment?
There are 2 correct answers to this question.
a) It is a client-side design-time environment for JavaScript.
b) It is built on Google’s V8 JavaScript engine.
c) It uses a synchronous programming model.
d) It is single-threaded.
If you have any feedback, pl send us on [email protected]