Which OData service do you use to prevent changes to existing line items of the sap.test::myTable table?

A. service {"sap.test: :myTable" update exclude;}

B. service {"sap.test: :myTable" update no-authorization;}

C. service {"sap.test::myTable" update forbidden;}

D. service {"sap.test::myTable" update prohibited;}

You need to check user input data in your OData request. Which exit type do you use?

A. Consistency

B. Modification

C. Verification

D. Validation

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?

Note: There are 2 correct answers to this question.

A. @sap/xsenv

B. @sap/hdbext

C. @sap/node-vsi

D. @sap/instance-manager

Which parameters do you need for the APPLY_FILTER function? Note: There are 2 correct answers to this question.

A. Filter condition

B. Dataset

C. Join condition

D. Entity set

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

A. It uses a synchronous programming model.

B. It is a client-side design-time environment for JavaScript.

C. It is built on Google's V8 JavaScript engine.

D. It is single-threaded.

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

B. POST

C. GET

D. READ

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. Re-prioritize with Workload Management.

B. Change the data model.

C. Use CE functions.

D. Modify SQL hints.

Which of the following are characteristics of database procedures?

A. Database procedures can have both input and output parameters; however, a parameter CANNOT be both input and output.

B. Database procedures can have several output parameters, and a mix of both scalar and table types is possible.

C. If, in the database procedure header, you use the READS SQL DATA option, then INSERT statements are prohibited; however, dynamic SQL is allowed.

D. If, in the database procedure header, you use the SQL SECURITY INVOKER option, then only the owner of the procedure can start it.

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

C. Key specification

D. Property projection

Which trace do you use to create a graphical representation of an individual SQL Statement? Please choose the correct answer.

A. Expensive statements trace

B. Performance trace

C. Plan trace

D. SQL trace