SAP C_HANADEV_17 Online Practice Questions and Exam Preparation

SAP C_HANADEV_17 Online Questions & Answers

• Question 1:

  Your team develops an application using SAP Web IDE for SAP HAN

  A. How can you share the application source code with other team users?
  B. Share the project in the application project settings.
  C. Assign a shared workspace to users in XS Advanced Administration.
  D. Store the source code in a shared Git repository.
  E. Store the project in a shared package within the SAP HANA repository.
  C. Assign a shared workspace to users in XS Advanced Administration.

• Question 2:

  Which application runtimes are currently supported by the SAP Cloud Application Programming Model? There are 2 correct answers to this question.

  A. Python
  B. Java
  C. Node.js
  D. Go
  B. Java
  C. Node.js

• Question 3:

  Which elements can you specify with the SAP Web IDE for SAP HANA graphical editor for Core Data Services data models? Note: There are 3 correct answers to this question.

  A. Context
  B. Association
  C. Synonym
  D. Entities
  E. Procedure
  A. Context
  B. Association
  D. Entities

  ---

  Explanation/Reference:

• Question 4:

  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
  C. $metadata

• Question 5:

  Which rules apply to declarative logic in SQL Script? There are 2 correct answers to this question.

  A. It supports the full set of SQL Script.
  B. It defines how data is processed.
  C. It is free of side effects.
  D. lt declares the flow of data.
  C. It is free of side effects.
  D. lt declares the flow of data.

• Question 6:

  An OData service contains an entity set called Products. Which resource path do you add to the OData service URL to view all available products?

  A. /Products
  B. /Products/"
  C. /Products/ALL
  D. /Products/$metadata
  A. /Products

• Question 7:

  Which join type is NOT supported by join optimization (pruning)? Please choose the correct answer.

  A. Text Join
  B. Referential Join
  C. Outer Join
  D. Inner Join
  D. Inner Join

• Question 8:

  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;}
  C. service {"sap.test::myTable" update forbidden;}

• Question 9:

  What are the different types of graphical calculation views that can handle measures? There are 2 correct answers to this question.

  A. Cube
  B. Dimension
  C. SQL Access Only
  D. Cube with star join
  B. Dimension
  D. Cube with star join

• Question 10:

  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
  D. UNNEST