SAP SAP Certifications C_HANADEV_17 Questions & Answers

• Question 81:

  Which programming paradigms are supported by SQLScript? Note: There are 2 correct answers to this question.

  A. Symbolic

  B. Declarative

  C. Logic

  D. Imperative

  Correct Answer: BD

• Question 82:

  You create a multi-target application in SAP Web IDE for SAP HANA. Which source code management option do you use?

  A. SVC-based repository

  B. SAP HANA repository

  C. GIT-based repository

  D. SAP HANA repository workspace

  Correct Answer: C

• Question 83:

  Which metadata declarations can you specify in an SQLScript procedure when you use the SAP HANA Deployment Infrastructure? Note: There are 2 correct answers to this question.

  A. Authorization

  B. Default schema

  C. Security

  D. Language

  Correct Answer: CD

• Question 84:

  Which development environment does SAP recommend to develop an SAP HANA extended application services; advanced model (XS advanced) multi-target application?

  A. SAP HANA studio

  B. ASAP development tools

  C. SAP web IDE for SAP HANA

  D. SAP HANA Web-based Development Workbench

  Correct Answer: C

• Question 85:

  Why do you use associations in your persistence model for SAP HANA extended application services, advanced model (XS advanced)?

  A. To enforce database-level constraints

  B. To set relationships between multiple contexts

  C. To define multiplicity and key of an entity relation

  D. To define the relationships between contexts and views

  Correct Answer: B

• Question 86:

  You need to access a remote database table object within your HDB module in an MTA 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 MTA project YAML file.

  Which activities do you perform?

  Note: There are 3 correct answers to this question.

  A. Create a synonym that refers to the view.

  B. Create a view that refers to a synonym.

  C. Create a synonym for the remote table object.

  D. Create/update the .hdbgrants file providing authorizations for the remote schema.

  E. Create a view that refers to the table.

  Correct Answer: BCD

• Question 87:

  Your multi-target application shall use XSJS.

  Which module type do you create in your application project?

  A. HTML5

  B. Java

  C. SAP HANA database

  D. Node.js

  Correct Answer: D

• Question 88:

  You need to create a native SAP HANA application that fully leverages the SAP HANA platform. How do you implement data-intensive calculations?

  A. Push the calculations onto the database layer

  B. Push the calculations onto the application layer

  C. Push the calculations onto the presentation layer

  D. Distribute calculations between application layer and presentation layer

  Correct Answer: A

• Question 89:

  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;}

  Correct Answer: C

• Question 90:

  You create triggers using the SQL Console. Where are the triggers stored?

  A. Repository

  B. Application server

  C. Package

  D. Catalog

  Correct Answer: D