SAP SAP Certifications C_HANADEV_17 Questions & Answers

• Question 1:

  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

  Correct Answer: D

• Question 2:

  Which of the following can be used when implementing transaction management logic in SQLScript using savepoints? Note: There are 3 correct answers to this question.

  A. Release savepoint

  B. Rollback to savepoint

  C. Savepoint

  D. Reverse savepoint

  E. Alter system savepoint

  Correct Answer: ABC

• Question 3:

  What types of user-defined functions are supported by SAP HANA? Note: There are 2 correct answers to this question.

  A. Table

  B. Scalar

  C. Aggregate

  D. Hierarchy

  Correct Answer: AB

• Question 4:

  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.

  Correct Answer: B

• Question 5:

  You need to synchronize all unsynchronized changes in your local Git branch to a remote Git branch.Which operation do you use?

  A. Pull

  B. Rebase

  C. Push

  D. Reset

  Correct Answer: C

• Question 6:

  You need to edit a database procedure. You are concerned that the version of the database procedure file you have in your local Git repository may not be synchronized with the latest version in the remote Git repository, but at this time, you do NOT want to sync the file. You only want to see the commits applied to the file in the remote repository.Which command must you use?

  A. Git stash

  B. Git fetch

  C. Git merge

  D. Git pull

  Correct Answer: A

• Question 7:

  Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question.

  A. ROLES

  B. TABLES

  C. SCHEMAS

  D. OBJECTS

  Correct Answer: BC

• Question 8:

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

  A. To have directly assigned a Scope

  B. To have directly assigned a Role Collection

  C. To be assigned to a Space

  D. To be assigned to an Organization

  Correct Answer: B

• Question 9:

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

  C. UNSET

  D. UNNEST

  Correct Answer: D

• Question 10:

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

  C. authentication Method

  D. role-templates

  Correct Answer: BC