SAP SAP Certifications C_HANADEV_16 Questions & Answers

• Question 91:

  You need to restrict the selected columns exposed to the client. Which OData capability do you use?

  A. Parameter entity sets

  B. Key specification

  C. Aggregation

  D. Property projection

  Correct Answer: D

• Question 92:

  Which services can you use in SAP HANA 2.0, express edition? Note: There are 3 correct answers to this question.

  A. Text analytics

  B. Dynamic tiering

  C. System replication

  D. Columnar OLTP and OLAP

  E. Multi-core and parallelization

  Correct Answer: ADE

• Question 93:

  You create an isolated block of code which runs as an independent transaction. Which of the following SQLScript features do you use?

  A. Autonomous transactions

  B. Blocked transactions

  C. Anonymous transactions

  D. Anonymous transaction block

  Correct Answer: A

• Question 94:

  You define exception handling in a SQLScript procedure. What can you use declare exit handlers for? Note: There are 2 correct answers to this question.

  A. Specific SQL error codes

  B. Specific SQL conditions

  C. Generic SQL conditions

  D. Generic SQL exceptions

  Correct Answer: AB

• Question 95:

  What are some of the advantages of SQLScript compared to plain SQL queries? Note: There are 2 correct answers to this question.

  A. It retrieves a high data volume from a database.

  B. It increases performance by parallel execution of complex SQL statements.

  C. It contains a well-defined ANSI standard.

  D. It enables modular parameterized programing.

  Correct Answer: BD

• Question 96:

  You need to consume a Node.js service in an SAPUI5 application. In which section of the mta.yaml file do you define the variable for the exposed service?

  A. In the properties section of the MTA resources

  B. In the requires section of the HTML5 module

  C. In the provides section of the Node.js module

  D. In the path section of the Node.js module

  Correct Answer: A

• Question 97:

  Who owns the database objects created in an SAP HANA Deployment Infrastructure container?

  A. The generated, container-specific technical user

  B. The database user with the generated database role, suffix ';;external_privileges_role'

  C. The SAP HANA extended application services, advanced model (XS advanced) user who deployed the CDS model

  D. The database user with the generated database role, suffix ';;access_role!

  Correct Answer: A

• Question 98:

  You need to bind UI5 controls to a data source.

  Between which parts of the SAPUI5 application must you create data binding?

  A. Model and Controller

  B. Controller and View

  C. View and Model

  D. Application Descriptor and View

  Correct Answer: C

• Question 99:

  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?

  A. subfolder

  B. mixinTypes

  C. hdbtable

  D. name

  Correct Answer: A

• Question 100:

  Please review the JSON model in the screenshot. Which of the following absolute binding paths are valid?

  Note: There are 3 correct answers to this question.

  {company: {name: "ACME", info: {employees:3}, contacts: [{name: "Barbara", phone: "873"},{name:

  "Gerry", phone: '"734"}]}}

  A. /contacts/0/name

  B. /company/name

  C. /company/contacts/2/phone

  D. /company/info/employees

  E. /company/contacts/1/name

  Correct Answer: BDE