SAP C_HANADEV_18 Exam Questions Instant Access

Question 1

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

AIt supports the full set of SQL Script.

BIt defines how data is processed.

CIt is free of side effects.

Dlt declares the flow of data.

Answer : C, D

Question 2

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?

Please choose the correct answer.

A/Products/$metadata

B/Products/'

C/Products

D/Products/ALL

Answer : C

Question 3

You use APPLY_FILTER to add a dynamic WHERE clause on SELECT statements. On which objects can you apply the filter? There are 2 correct answers to this question.

AScalar variables

BVirtual tables

CDatabase tables

DIntermediate table variables

Answer : C, D

Question 4

Which of the following are characteristics of database procedures?

ADatabase procedures can have both input and output parameters; however, a parameter CANNOT be both input and output.

BDatabase procedures can have several output parameters, and a mix of both scalar and table types is possible.

CIf, in the database procedure header, you use the READS SQL DATA option, then INSERT statements are prohibited; however, dynamic SQL is allowed.

DIf, in the database procedure header, you use the SQL SECURITY INVOKER option, then only the owner of the procedure can start it.

Answer : B

Question 5

Which tool do you use to create a calculation view in a multi-target application? Please choose the correct answer.

ASAP Web IDE for SAP HANA

BSAP HANA database explorer

CSAP HANA Web-based Development Workbench

DSAP HANA studio

Answer : A

Question 6

To perform a specific task of an XS advanced application, what does a user need? Please choose the correct answer.

ATo have directly assigned a Role Collection

BTo have directly assigned a Scope

CTo be assigned to an Organization

DTo be assigned to a Space

Answer : A

Question 7

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

AThe generated, container-specific technical user

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

CThe database user with the generated database role, suffix ': :access_role'

DThe database user with the generated database role, suffix ': :external_privileges_role'

Answer : A

SAP Certified Development Associate - SAP HANA 2.0 SPS06 C_HANADEV_18 Exam Questions