SAP SAP Certifications C_HANADEV_17 Questions & Answers

• Question 111:

  Which module do you use to run an SQL statement against the SAP HANA database?

  A. @sap/xsenv

  B. @sap/hdbext

  C. @sap/xssec

  D. @sap/hdi

  Correct Answer: B

• Question 112:

  Which URL query options are available with XSOData v2.0? Note: There are 3 correct answers to this question.

  A. $top

  B. $filter

  C. $select

  D. $view

  E. $read

  Correct Answer: ABC

• Question 113:

  You must debug an existing SQLScript procedure in SAP HANA extended application services, advanced model (XS advanced). What is the valid sequence to debug the procedure?

  A. 1 Select the SQLScript procedure in the project explorer, p. 2 Open the SQLScript console. 3 Set the breakpoint in the code of your SQL procedure. 4 Generate the call to the SQL procedure and execute it.

  B. 1 Select the SQLScript procedure in the database explorer, p. 2 Set the debugger privilege. 3 Set the external breakpoint in the code of your SQL procedure. 4 Run the ABAP program where the SQL procedure is called in debugging mode.

  C. 1 Select the ABAP program where the SQLScript procedure is called in the project explorer. p. 2 Set the external debugger privilege. 3 Set the external breakpoint in the code of your ABAP program.

  4 Run the ABAP program in debugging mode.

  D. 1 Select the SQLScript procedure in the database explorer. / pv 2 Specify the SQLScript debugger settings in the SQL Debugger. 3 Set the breakpoint in the code of your stored procedure. 4 Generate the call to the SQL procedure and execute it.

  Correct Answer: D

• Question 114:

  You need to view the data model exposed by an OData V2 service. What must you append to the service URL?

  A. $servicedefinition

  B. $schema

  C. $metadata

  D. $format

  Correct Answer: C

• Question 115:

  Which of the following SQLScript elements do you use to transform a set of arrays into an intermediate table variable?

  A. SET

  B. UNSET

  C. ARRAY

  D. UNNEST

  Correct Answer: D

• Question 116:

  In an SQLScript procedure, which feature do you use to initialize IN/OUT table parameters?

  A. IS_EMPTY

  B. DEFAULT EMPTY

  C. DEFAULT

  D. SET

  Correct Answer: B

• Question 117:

  Which GIT command do you use to consolidate all changes from one branch with another branch using a single commit?

  A. Commit

  B. Push

  C. Rebase

  D. Merge

  Correct Answer: D

• Question 118:

  What happens if you define a database object in the persistence model and deploy it using the SAP HANA Deployment Infrastructure (HDI)?

  A. The corresponding runtime object is created in the database module of the multi-target application during runtime.

  B. The corresponding runtime object is created in the HDI container on deployment.

  C. A descriptive representation of the object is created in HDI during runtime.

  D. The HDI container is created when the design-time object is saved.

  Correct Answer: D

• Question 119:

  Which of the following are characteristics of SAPU15? Note; There are 3 correct answers to this question.

  A. Provides device-specific user experience

  B. Supports customer-specific theming

  C. Provides an extensibility concept

  D. Enables responsive application design

  E. Renders the UI on server side

  Correct Answer: BCD

• Question 120:

  You implement a native SAP HANA application using SAP HANA extended application services, advanced mode (XS advanced) and SAPUI5. Where is the UI rendering executed?

  A. On the XS advanced application server

  B. On the SAPUI5 HTML5 module

  C. On the front-end client device

  D. On the SAP Fiori front-end server

  Correct Answer: B