Exam4Training

SAP C_HANADEV_18 SAP Certified Development Associate – SAP HANA 2.0 SPS06 Online Training

Question #1

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

  • A . SCHEMAS
  • B . TABLES
  • C . OBJECTS
  • D . ROLES

Reveal Solution Hide Solution

Correct Answer: A, B
Question #2

You create an SAP HANA extended application services, advanced model (XS advanced) multi-target

application.

What does the mta.xml file contain? Please choose the correct answer.

  • A . The plugin name and version for every supported file suffix
  • B . The application router description with the authentication methods and access routes
  • C . The Node.js package definition with dependencies and initial run configurations
  • D . The application global elements, modules, resources, properties, and parameters

Reveal Solution Hide Solution

Correct Answer: D
Question #3

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

  • A . It enables modular parameterized programing.
  • B . It increases performance by parallel execution of complex SQL statements.
  • C . It contains a well-defined ANSI standard.
  • D . It retrieves a high data volume from a database.

Reveal Solution Hide Solution

Correct Answer: A, B
Question #4

You developed a multi-target application that contains only a database module.

Which environment are the runtime objects created in? Please choose the correct answer.

  • A . Java Runtime Environment (JRE)
  • B . SAP HANA Runtime Tools (HRTT)
  • C . SAP Web IDE for SAP HANA
  • D . HANA Deployment Infrastructure Container

Reveal Solution Hide Solution

Correct Answer: D
Question #5

You work on a multi-target application that uses the SAP HANA Deployment Infrastructure (HDI).

Which operations can you perform in the SAP Web IDE for SAP HANA? There are 2 correct answers to this question.

  • A . Create objects in the SAP HANA repository.
  • B . Deploy HTML5 modules to the SAP HANA database.
  • C . Choose the supported SAP HANA versions.
  • D . Configure the artifact namespaces.

Reveal Solution Hide Solution

Correct Answer: A, B
Question #6

You need to install SAP HANA 2.0, express edition to develop a native SAP HANA application.

Which of the following deployment options do you have? There are 2 correct answers to this question.

  • A . Installation on Windows Server
  • B . Installation on Mac OS
  • C . Installation on Linux OS
  • D . Usage of virtual machine on Microsoft Windows

Reveal Solution Hide Solution

Correct Answer: C, D
Question #7

You develop an OData service using XSODATA.

Which HTTP commands can you use to define the operations on the resources? There are 3 correct answers to this question.

  • A . DPUT
  • B . READ
  • C . INSERT
  • D . POST
  • E . DGET

Reveal Solution Hide Solution

Correct Answer: A, D, E
Question #8

You created an HDI database role, using the SAP Web IDE for SAP HANA and deployed your project.

Afterward, you made some modifications to the runtime role.

What happens when you change and re-build the design-time role? Please choose the correct answer.

  • A . The runtime modifications are overwritten.
  • B . The deployment of the role fails.
  • C . The runtime modifications are kept.
  • D . You need to confirm the runtime modifications

Reveal Solution Hide Solution

Correct Answer: A
Question #9

You are working on an entity using Core Data Services.

Which properties can you define inside the Technical Configuration section? There are 2 correct answers to this question.

  • A . Index
  • B . Import
  • C . Storage Type
  • D . Association

Reveal Solution Hide Solution

Correct Answer: A, C
Question #10

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

  • A . On the SAPUI5 HTML5 module
  • B . On the SAP Fiori front-end server
  • C . On the front-end client device
  • D . On the XS advanced application server

Reveal Solution Hide Solution

Correct Answer: C

Question #11

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

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

Reveal Solution Hide Solution

Correct Answer: B, D
Question #12

You need to combine data from different database tables within your OData service.

Which capability do you use for this relationship? Please choose the correct answer.

  • A . Aggregations
  • B . Projections
  • C . Associations
  • D . Entity sets

Reveal Solution Hide Solution

Correct Answer: C
Question #13

What key words are contained in the application descriptor file (xs-app.json)? There are 2 correct answers to this question.

  • A . routes
  • B . role-templates
  • C . tenant-mode
  • D . authentication Method

Reveal Solution Hide Solution

Correct Answer: A, D
Question #14

You create a simple data model to store user information. The model contains two tables: one for the user information, and the other for user address details.

The user can only have one address. You also need a view to show the complete information of the user including the address.

Which actions do you perform if you use CDS artifacts only? Please choose the correct answer.

  • A . Create two entities for the user and address.
    Create an association in the user entity to the address entity.
    Define a User Details view using select on the address entity and using the association to read the
    user information.
  • B . Create two entities for the user and address.
    Create an association in the user entity to the address entity.
  • C . Define a User Details view using select on the user entity and using the association to read the address information.
    Create two entities for the user and address.
    Extend the user entity with address columns.
  • D . Create a view named User Details using select on the user entity.
    x-s Create two entities for the user and address.
    Create a User Details calculation view and join the user and address information.

Reveal Solution Hide Solution

Correct Answer: B
Question #15

What are the disadvantages when deploying Dynamic SQL? There are 2 correct answers to this question.

  • A . Limited opportunities for optimization
  • B . No possibility to bind the result to a SQL Script variable
  • C . No possibility to use SQL Script variables
  • D . Additional SQL execution privileges are required

Reveal Solution Hide Solution

Correct Answer: A, D
Question #16

You need to access a remote database table object within your HDB module in a Multi-target application project.

In SAP HANA extended application services, advanced model (XS advanced) a user-provided service was created to access the external schem

a. The service is already declared in the Multi-target application project YAML file.

Which activities do you perform?

  • A . There are 3 correct answers to this question.
  • B . Create a view that refers to a synonym. n Create a synonym that refers to the view.
  • C . Create/update the .hdbgrants file providing authorizations for the remote schema.
  • D . Create a synonym for the remote table object.
  • E . Create a view that refers to the table.

Reveal Solution Hide Solution

Correct Answer: A, C, D
Question #17

From which tool can you run the XS command line? Please choose the correct answer.

  • A . Local operating system shell
  • B . SAP HANA studio
  • C . SAP WeblDE for SAP HANA
  • D . SAP HANA cockpit

Reveal Solution Hide Solution

Correct Answer: A
Question #18

You need to create a native SAP HANA application that fully leverages the SAP HANA platform.

How do you implement data-intensive calculations? Please choose the correct answer.

  • A . Push the calculations onto the application layer.
  • B . Push the calculations onto the database layer
  • C . Push the calculations onto the presentation layer.
  • D . Distribute calculations between application layer and presentation layer.

Reveal Solution Hide Solution

Correct Answer: B
Question #19

You develop a Node.js application for the SAP HANA platform that executes a SQL statement in the SAP HANA database.

Which modules do you use? There are 2 correct answers to this question.

  • A . @sap/instance-manager
  • B . @sap/xsenv
  • C . @sap/hdbext
  • D . @sap/node-vsi

Reveal Solution Hide Solution

Correct Answer: B, C
Question #20

Which activities do you perform on an application in the SAP HANA XS Advanced Cockpit? There are 2 correct answers to this question.

  • A . Monitor applications assigned to the current space.
  • B . Deploy applications to SAP Cloud Platform.
  • C . Display HDI container content.
  • D . Start, stop, and restart applications.

Reveal Solution Hide Solution

Correct Answer: A, D

Question #21

Which keywords do you use to define an OData association? There are 3 correct answers to this question.

  • A . JOIN
  • B . DEPENDENT
  • C . UNION
  • D . MULTIPLICITY
  • E . PRINCIPAL

Reveal Solution Hide Solution

Correct Answer: B, D, E
Question #22

Which of the following elements can be part of the UI5 application’s index.html file? There are 2 correct answers to this question

  • A . Framework Reference
  • B . Bootstrap
  • C . Backend Connection
  • D . UI-Area

Reveal Solution Hide Solution

Correct Answer: A, B
Question #23

In an SQL Script procedure, which feature do you use to initialize IN/OUT table parameters? Please choose the correct answer.

  • A . IS_EMPTY
  • B . DEFAULT EMPTY
  • C . DEFAULT
  • D . SET

Reveal Solution Hide Solution

Correct Answer: B
Question #24

Who owns the database objects created in an SAP HANA Deployment Infrastructure (HDI) container? Please choose the correct answer.

  • A . The generated, container-specific technical user
  • B . The SAP HANA extended application services, advanced model (XS advanced) user who deployed the CDS model
  • C . The database user with the generated database role, suffix ‘: :access_role’
  • D . The database user with the generated database role, suffix ‘: :external_privileges_role’

Reveal Solution Hide Solution

Correct Answer: A
Question #25

You want to exclusively use declarative logic in an SQL Script procedure.

Which of the following operators can you use? There are 2 correct answers to this question.

  • A . COMM IT statement
  • B . IF condition
  • C . TABLE variable
  • D . MAP_REDUCE function

Reveal Solution Hide Solution

Correct Answer: C, D
Question #26

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

  • A . Entity
  • B . Synonym
  • C . Procedure
  • D . Context
  • E . Association

Reveal Solution Hide Solution

Correct Answer: A, D, E
Question #27

You configure an OData service for a transactional SAPUI5 application.

What is the default data access behavior of the OData service? Please choose the correct answer.

  • A . Read: Yes Create: Yes Update: Yes Delete: Yes
  • B . Read: Yes Create: Yes Update: Yes Delete: No
  • C . Read: Yes, Create: No Update: Yes Delete: No
  • D . Read: Yes, Create: No Update: No Delete: No

Reveal Solution Hide Solution

Correct Answer: A
Question #28

You need to view the data model exposed by an OData V2 service.

What must you append to the service URL? Please choose the correct answer.

  • A . $schema
  • B . $service definition
  • C . $metadata
  • D . $format

Reveal Solution Hide Solution

Correct Answer: C
Question #29

Which of the following information must you specify when you create a new project in SAP Web IDE for SAP HANA? There are 2 correct answers to this question.

  • A . SAP HANA database version
  • B . Project name
  • C . Template
  • D . Namespace

Reveal Solution Hide Solution

Correct Answer: B, C
Question #30

Which Git commands are available with the SAP Web IDE for SAP HANA? There are 3 correct answers to this question.

  • A . Test changes
  • B . Push code
  • C . Clone a repository
  • D . Redeploy the code
  • E . Merge changes

Reveal Solution Hide Solution

Correct Answer: B, C, E
Exit mobile version