Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

C_ABAPD_2309 > C_ABAPD_2309 actual4test > Flashcards

C_ABAPD_2309 actual4test Flashcards

1
Q

QUESTION NO: 1
/DMO/I_Connection is a CDS view.
What variable type is connection full based on the following code? DATA connection full TYPE
/DMD/I_Connection.

A. Simple variable

B. Structure

C. Internal Table

A

Structure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

QUESTION NO: 2
In this nested join below in which way is the join evaluated?
SELECT FROM t a AS a
LEFT OUTER JOIN t b AS b
LEFT OUTER JOIN t C AS C
ON c~f1 = b~f1 AND c~f2 = b~f2
ON b~fl = a~f1
WHERE

A. From the left to the right in the order of the tables:
1.
a is joined with b

b is joined with c

B. From the right to the left in the order of the tables:
1.
b is joined with c.
2
b is joined with a.

C. From the top to the bottom in the order of the on conditions
1.
b is joined with c
2
a is joined with b

D. From the bottom to the top in the order of the on conditions:
1.
a is joined with b
2.
b is joined with c

A

From the top to the bottom in the order of the on conditions
1.
b is joined with c
2
a is joined with b

die Antzwort mit Top to Bottom

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

QUESTION NO: 3
Which of the following are valid sort operations for internal tables? Note: There are 3 correct answers to this question.

A. SORT itab DESCENDING.

B. Sort a standard table using
SORT itab ASCENDING.
Sort a sorted table using

C. SORT itab.

Sort a sorted table using

D. SORT itab BY field1 field2.
Sort a standard table using

E. SORT itab BY fieldl ASCENDING field2 DESCENDING.
Sort a standard table using

A

SORT itab ASCENDING.

SORT itab BY field1 field2.

SORT itab.

(die Antworten ohne DESCENDING)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

The “demo_ods_assoc_spfi data source referenced in line #4 contains a field “connid” which you would like to expose in
the element list.
Which of the following statements would do this if inserted on line #8?

A. demo_ods_assoc_spfli.connid,

B. demo_ods_assoc_spfli-connid/

C. spfli-connid,

D. _spfli.connid/

A

_spfli.connid,

die kurze Antwort mit “.” vor connid

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

QUESTION NO: 5
In an Access Control Object, which clauses are used? Note: There are 3 correct answers to this question.

A. Where (to specify the access conditions)

B. Grant (to identify the data source)

C. Return code (to assign the return code of the authority check)

D. Define role (to specify the role name)

E. Revoke (to remove access to the data source)

A

Where (to specify the access conditions)

Define role (to specify the role name)

Grant (to identify the data source)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

QUESTION NO: 6
In a test method you call method cl_abap_unit_assert=>assert_equals( .. ) in the following way:
CLASS Itcl1 DEFINITION FOR TESTING RISK LEVEL HARMLESS DURATION SHORT.
PRIVATE SECTION.
ME THODS m1 FOR TESTING.
ENDCLASS.
CLASS Itcl1 IMPLEMENTATION.
ME THOD m1.
DATA: go_test_object TYPE REF TO zcl_to_be_tested.
CONSTANTS: Ico_exp TYPE string VALUE ‘test2’.
CREATE OBJECT go_test_object.
cl_abap_unit_assert=>assert_equals(
EXPORTING
act = go_class->mv_attribute
exp= Ico_exp
msg = ‘assert equals failed ‘ && go_test_object->mv_attribute && “’ && Ico_exp ENDMETHOD.
ENDCLASS.
What will happen if method parameters act and exp are not equal?

A. The tested unit will automatically be appended to a default ABAP Test Cockpit Variant.

B. The test will be aborted.

C. The tested unit cannot be transported.

D. There will be a message in the test log.

A

There will be a message in the test log.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

QUESTION NO: 7
When does SAP recommend to use a sorted or a hashed table respectively? Note: There are 2 correct answers to this
question.

A. A sorted table, when you read a subset in a loop and specify a part of the key from the left ^ without gaps.

B. A hashed table, when you read a single record and specify the complete key.

C. A hashed table, when you read a subset in a loop and specify a part of the key from the left without gaps.

D. A sorted table, when you read a single record and specify non key fields.

A

A hashed table, when you read a single record and specify the complete key.

A sorted table, when you read a subset in a loop and specify a part of the key from the left ^ without gaps.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which of the following are parts of the definition of a new database table? (2 correct)

Field list

Extension

Partitioning attributes

Semantic table attributes

A

Semantic table attributes

Field list

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

QUESTION NO: 9
What are valid statements? Note: There are 3 correct answers to this question

A. In class CL1, the interface method is named if-ml.

B. Class CL2 uses the interface.

C. Class CL1 uses the interface.

D. In class CL2, the interface method is named ifl-ml.

E. Class CL1 implements the interface.

A

Class CL1 implements the interface.

In class CL1, the interface method is named if1~m1.

Class CL2 uses the interface.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Given this code,

INTERFACE if1.

METHODS m1.

ENDINTERFACE.

CLASS cl1 DEFINITION.

PUBLIC SECTION.

INTERFACES if1.

METHODS m2.

ENDCLASS.

*in a method of another class

DATA go_if1 TYPE REF TO if1.

DATA go_cl1 TYPE REF to cl1.

go_cl1 = NEW #(…).

go_if1 = go_cl1.

What are valid statements? (3 correct)

go_if1 may call method m1 with go_if1->m1().

Instead of go_cl1 = NEW #() you could use go_if1 = NEW #(…).

Instead of go_cl1 = NEW #(…) you could use go_if1 = NEW cl1(….).

go_cl1 may call method m1 with go_cl1->if1~m1().

go_if1 may call method m2 with go if->m2(…).

A

go_if1 may call method m1 with go_if1->m1().

Instead of go_cl1 = NEW #(…) you could use go_if1 = NEW cl1(….).

go_cl1 may call method m1 with go_cl1->if1~m1().

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which patterns raise an exception? Note: There are 3 correct answers to this question.

DATA: gv_target TYPE p DECIMALS 3.

CONSTANTS: gco_intl TYPE i VALUE 2.

gv_target = EXACT #( 2 / gco_intl ).

DATA: gv_target TYPE d.

CONSTANTS: gco_date TYPE d VALUE ‘20331233’.

gv_target = EXACT ( gco_date ).

DATA: gv_target TYPE p DECIMALS 2.

CONSTANTS: gco_intl TYPE i VALUE 3.

gv_target = EXACT #( 2 / gco_intl ).

DATA: gv_target TYPE c LENGTH 5.

CONSTANTS: gco_string TYPE string VALUE ‘0123456789ABCDEF’.

gv_target = EXACT #( gco_string+5(6) ).

DATA: gv_target TYPE string.

CONSTANTS: gco_string TYPE c LENGTH 16 VALUE ‘@123456789ABCDEF’.

gv_target = EXACT #( gco_string+5(5) ).

A

DATA: gv_target TYPE d.

CONSTANTS: gco_date TYPE d VALUE ‘20331233’.

gv_target = EXACT ( gco_date ).

DATA: gv_target TYPE p DECIMALS 2.

CONSTANTS: gco_intl TYPE i VALUE 3.

gv_target = EXACT #( 2 / gco_intl ).

DATA: gv_target TYPE c LENGTH 5.

CONSTANTS: gco_string TYPE string VALUE ‘0123456789ABCDEF’.

gv_target = EXACT #( gco_string+5(6) ).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

QUESTION NO: 13
Which type of legacy code does SAP recommend you eliminate when you review modifications as part of an SAP S/4HANA
system conversion? Note: There are 2 correct answers to this question.

A. Code that supports a critical business process

B. Code that now is identical to a standard SAP object

C. Code that has less than 10% usage according to usage statistics

D. Code that can be redesigned as a key user extension

A

Code that now is identical to a standard SAP object

Code that can be redesigned as a key user extension

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

You have the following CDS definition:

define view entity Z_ENTITY as select from Z_SOURCE1 as _Source1

association to Z_SOURCE2 as _Source2

???

{

key carrier_id as Carrier,

key connection_id as Connection,

cityfrom as DepartureCity,

cityto as Arrivalcity,

_Source2

}

Which of the following ON conditions must you insert in place of “???”?

ON $projection.carrier_id = _Source2.carrier_id

ON _Source1.carrier_id = _Source2.carrier_id

ON $projection Camer= Source2.carrier_id

ON $projection.Carrier = Source2.carrier

A

ON _Source1.carrier_id = _Source2.carrier_id

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

QUESTION NO: 15
What is the sequence priority when evaluating a logical expression?

A. NOT

B. OR

C. AND

A

NOT, AND, OR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

QUESTION NO: 16
Given this code, with which predicate condition can you ensure that the CAST will work?

A. IS SUPPLIED

B. IS NOT INITIAL

C. IS INSTANCE OF

D. IS BOUND

A

IS INSTANCE OF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

QUESTION NO: 17
In the assignment, data (gv_result) = 1/8. what will be the data type of gv_result?

A. TYPE I

B. TYPE DEFLOAT 16

C. TYPE P DECIMALS 3

D. TYPE P DECIMALS 2

A

TYPE I

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

QUESTION NO: 19
For what kind of applications would you consider using on-stack developer extensions? Note: There are 2 correct answers
to this question.

A. Applications that provide APIs for side by side SAP BTP apps

B. Applications that access SAP S/4HANA data using complex SQL

C. Applications that integrate data from several different systems

D. Applications that run separate from SAP S/4HANA

A

Applications that provide APIs for side by side SAP BTP apps

Applications that access SAP S/4HANA data using complex SQL

(sap btp und sql)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

QUESTION NO: 20
Which of the following are features of Core Data Services? Note: There are 3 correct answers to this question.

A. Inheritance

B. Associations

C. Annotations

D. Delegation

E. Structured Query Language (SQL)

A

Associations

Annotations

Structured Query Language (SQL)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

QUESTION NO: 21
Given the following code in an SAP S/4HANA Cloud private edition tenant:

The class zcl_demo_class is in a software component with the language version set to “ABAP Cloud”. The function module
ZF1’ is in a different software component with the language version set to “Standard ABAP”.
Both the class and function module are customer created.
Regarding line #6, which of the following are valid statements? Note: There are 2 correct answers to this question.

A. ZF1’ can be called only if it is released for cloud development.

B. ‘ZF1’ can be called if a wrapper is created for it and the wrapper itself is released for cloud development.

C. “ZF1” can be called whether it is released or not for cloud development

D. ZF1” can be called if a wrapper is created for it but the wrapper itself is not released for cloud development.

A

ZF1’ can be called only if it is released for cloud development.

‘ZF1’ can be called if a wrapper is created for it and the wrapper itself is released for cloud development.

(1. cloud 2. different standard -> cloud cloud)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

QUESTION NO: 22
Which extensibility type does SAP recommend you use to enhance the existing UI for an SAP Fiori app?

A. Key user

B. Developer

C. Side-by-side

D. Classic

A

Key user

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

QUESTION NO: 23
In RESTful Application Programming, which EML statement retrieves an object?

A. Find entity

B. Select entity

C. Get entity

D. Read entity

A

Read entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

QUESTION NO: 24
Which of the following are incomplete ABAP types? Note: There are 2 correct answers to this question.

A. String

B. T

C. C

D. P

A

Die Typen C und P

(inComPlete)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

QUESTION NO: 25
What are some features of a unique secondary key? Note: There are 2 correct answers to this question.

A. It is created when a table is filled.

B. It is updated when the modified table is read again.

C. It is created with the first read access of a table.

D. It is updated when the table is modified.

A

It is created when a table is filled.

It is updated when the table is modified.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

QUESTION NO: 26
Which of the following is a generic internal table type?

A. SORTED TABLE

B. INDEX TABLE

C. STANDARD TABLE

D. HASHED TABLE

A

Index table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

QUESTION NO: 27
In which products must you use the ABAP Cloud Development Model? Note: There are 2 correct answers to this question.

A. SAP S/4HANA Cloud, private edition

B. SAP BTP, ABAP environment

C. SAP S/4HANA on premise

D. SAP S/4HANA Cloud, public edition

A

SAP S/4HANA Cloud, public edition

SAP BTP, ABAP environment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

What are valid statements? Note: There are 2 correct answers to this question.

A. ##NEEDED is checked by the syntax checker.

B. The pragma is not checked by the syntax checker.

C. #EC_NEEDED is not checked by the syntax checker.

D. The pseudo-comment is checked by the syntax checker

A

EC_NEEDED is not checked by the syntax checker.

The pragma is not checked by the syntax checker.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

QUESTION NO: 29
In ABAP SQL, which of the following retrieves the association field_Airline-Name of a CDS view?

A. _Airline-Name

B. I_Airline Name

C. @_Airline-Name

D.”_Airline Name

A

_Airline-Name

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

QUESTION NO: 30
You have a superclass superl and a subclass subl of superl. Each class has an instance constructor and a static
constructor. The first statement of your program creates an instance of subl. In which sequence will the constructors be
executed?

A

Static constructor of the superclass (super1)
Static constructor of the subclass (sub1)
Instance constructor of the superclass (super1)
Instance constructor of the subclass (sub1)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

QUESTION NO: 31
Which function call returns 0?

find_any_of( val = ‘ABAP ABAP abap’ sub = ‘AB’).

Count_any_of( val = ‘ABAP ABAP abap’ sub = ‘AB’ ).

Count( val = ‘ABAP ABAP abap’ sub = ‘AB’ ).

find_any_not_of( val = ‘ABAP ABAP abap’ sub = ‘AB’ ).

A

find_any_of( val = ‘ABAP ABAP abap’ sub = ‘AB’).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

QUESTION NO: 32
Exhibit:
With Icl_super being superclass for Icl_subl and Icl_sub2 and with methods subl_methl and sub2_methl being subclass-
specific methods of ld_subl or Icl_sub2, respectivel. What will happen when executing these casts?
Note:
There are 2 correct answers to this question

A. go_subl = CAST #(go_super), will not work

B. go_sub2 = CAST #(go_super) will work. go_subl = CAST #(go_super) will not work.

C. go_sub2 = CAST #(go_super) will work. go_sub2->sub2_meth1( … ) will not work.

D. go_subl->subl_meth1( … ) will work.

A

go_sub1->sub1_meth 1(…). will work.

go_sub1 = CAST #( go_super ), will work
go_sub2 = CAST #( go_super ). will not work.
(kurzes sub1 und 1work/2not work)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

QUESTION NO: 33
In a RES Tful Application Programming application, in which objects do you bind a CDS view to create a value help? Note:
There are 3 correct answers to this question.

A. Data model view

B. Behavior definition

C. Metadata Extension

D. Service Definition

E. Projection View

A

Projection view

Data model view

Service definition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

QUESTION NO: 34
What is the purpose of a foreign key relationship between two tables in the ABAP Dictionary?

A. To document the relationship between the two tables

B. To ensure the integrity of data in the corresponding database tables

C. To create a corresponding foreign key relationship in the database

A

Relationship A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

QUESTION NO: 35
Which of the following are ABAP Cloud Development Model rules?
Note: There are 2 correct answers to this question.

A. Use public SAP APIs and SAP extension points.

B. Build ABAP RES Tful application programming model-based services.

C. Reverse modifications when a suitable public SAP API becomes available.

D. Build ABAP reports with either ABAP List Viewer (ALV) or SAP Fiori.

A

Use public SAP APIs and SAP extension points.

Build

34
Q

QUESTION NO: 36
Which of the following string functions are predicate functions? Note: There are 2 correct answers to this question.

A. find_any_not_of()

B. contains_any_of()

C. count_any_of()

D. matchesQ

A

contains_any_of()

matches()

35
Q

QUESTION NO: 37
What RES Tful Application Programming object contains only the fields required for a particular app?

A. Database view

B. Metadata extension

C. Projection View

D. Data model view

A

Projection View

36
Q

QUESTION NO: 38
In a subclass subl you want to redefine a component of a superclass superl. How do you achieve this? Note:
There are 2 correct answers to this question.

A. You add the clause REDEFINITION to the component in subl.

B. You implement the redefined component for a second time in superl.

C. You implement the redefined component in subl.

D. You add the clause REDEFINITION to the component in superl.

A

You add the clause REDEFINITION to the component in subl.

You implement the redefined component in subl.

37
Q

QUESTION NO: 39
What are advantages of using a field symbol for internal table row access? Note: There are answers to this question.

A. The field symbol can be reused for other programs.

B. A MODIFY statement to write changed contents back to the table is not required.

C. The row content is copied to the field symbol instead to a work area

D. Using a field symbol is faster than using a work area.

A

A MODIFY statement to write changed contents back to the table is not required.

Using a field symbol is faster than using a work area.

38
Q

QUESTION NO: 40
Which RES Tful Application Programming object can be used to organize the display of fields in an app?

A. Data model view

B. Metadata extension

C. Service definition

D. Projection view

A

Metadata extension

39
Q

QUESTION NO: 41
You want to define the following CDS view entity with an input parameter:
Define view entity Z_CONVERT With parameters currency : ???
Which of the following can you use to replace “ ???? Note: There are 2 correct answers to this question.

A. built-in ABAP type

B. A built-in ABAP Dictionary type

C. A data element

D. A component of an ABAP Dictionary structure

A

A built-in ABAP Dictionary type

A data element

40
Q

QUESTION NO: 42
You have two internal tables itab1 and itab2.What is true for using the expression itab1 = corresponding #( itab2 )? Note:
There are 2 correct answers to this question.

A. Fields with the same name but with different types may be copied from itab2 to itab1.

B. itab1 and itab2 must have at least one field name in common.

C. Fields with the same name and the same type will be copied from itab2 to itab1.

D. itab1 and itab2 must have the same data type.

A

itab1 and itab2 must have at least one field name in common.

Fields with the same name and the same type will be copied from itab2 to itab1.

41
Q

QUESTION NO: 43
For the assignment, gv_target = gv_source.
which of the following data declarations will always work without truncation or rounding? Note: There are 2 correct answers
to this question.

A. DATA gv_source TYPE string, to DATA gv_target TYPE c.

B. DATA gv_source TYPE c. to DATA gv_target TYPE string.

C. DATA gv_source TYPE d. to DATA gv_target TYPE string.

D. DATA gv_source TYPE p LENGTH 8 DECIMALS 3. to DATA gv_target TYPE p LENGTH 16 DECIMALS 2.

A

DATA gv_source TYPE c. to DATA gv_target TYPE string.

DATA gv_source TYPE d. to DATA gv_target TYPE string.

42
Q

QUESTION NO: 44
As a consultant you are posed the following question from a client who is using SAP S/4HANA Cloud, public edition and
also SAP BTP, ABAP environment.
“We are currently using an SAP Fiori app based on SAP Fiori elements that analyzes open orders. We have determined that
it should be extended via a new button on the UI which will perform an on- the-fly calculation and display the result in a
quick popup for the enduser. We have been informed by SAP that all underlying stack layers for the SAP Fiori app have
been extensibility enabled.” Based on this which of the following extension types would you recommend to the customer to
add the new button?

A. Business Service Extension

B. RAP BO Node Extension

C. SAP HANA database table extension

D. RAP BO Behavior Extension

A

RAP BO Behavior Extension

43
Q

QUESTION NO: 45
Which statement can you use to change the contents of a row of data in an internal table?

A. Append table

B. Modify table

C. Insert table

D. Update table

A

Modify

44
Q

QUESTION NO: 46
Which of the following ABAP SQL statements are valid? Note: There are 2 correct answers to this question.

A. SELECT FROM /dmo/connection FIELDS carrid, airpfrom
GROUP BY carrid, connid
INTO TABLE @DATA(It_hits).

B. SELECT FROM /dmo/connection FIELDS carrid, airpfrom,
MAX( distance ) AS dist_max,
MIN( distance ) AS dist_min
INTO TABLE @DATA(It_hits).

C. SELECT FROM /dmo/connection FIELDS carrid, airpfrom,
MAX( distance ) AS dist_max,
MIN( distance ) AS dist_min
GROUP BY carrid, airpfrom
INTO TABLE @DATA(It_hits).

D. SELECT FROM /dmo/connection FIELDS
MAX( distance ) AS dist_max,
MIN( distance ) AS dist_min
INTO TABLE @DATA(It_hits).

A

C. SELECT FROM /dmo/connection FIELDS carrid, airpfrom,
MAX( distance ) AS dist_max,
MIN( distance ) AS dist_min
GROUP BY carrid, airpfrom
INTO TABLE @DATA(It_hits).

D. SELECT FROM /dmo/connection FIELDS
MAX( distance ) AS dist_max,
MIN( distance ) AS dist_min
INTO TABLE @DATA(It_hits).

(wenn hinter FIELD Worte kommen die nicht in aggregate Funktion stehen (“MAX”), muss am Ende ein GROUP BY folgen. Bei D steht sowas nicht hinter Fields und bei C wird GROUP BY verwendet)

45
Q

QUESTION NO: 47
In class ZCL_CLASS_A, you use the statement DATA var TYPE **
What may stand in place of **? Note: There are 2 correct answers to this question.

A. The name of a type defined privately in class ZCL_CLASS_A

B. The name of a data element from the ABAP Dictionary

C. The name of a type defined privately in another class

D. The name of a domain from the ABAP Dictionary

A

The name of a data element from the ABAP Dictionary

The name of a type defined privately in class ZCL_CLASS_A

46
Q

QUESTION NO: 48
In RESTful Application Programming, a business object contains which parts? Note: There are 2 correct answers to this
question.

A. CDS view

B. Behavior definition

C. Authentication rules

D. Process definition

A

CDS view

Behavior definition

47
Q

QUESTION NO: 49
The class zcl_demo_class is in a software component with the language version set to “Standard ABAP”. The function
module “ZF11 is in a software component with the language version set to “ABAP Cloud”. Both the class and function
module are customer created. Regarding line #6, which of the following is a valid statement?

A. ‘ZF1’ can be called whether it has been released or not for cloud development.

B. ‘ZF1’ can be called via a wrapper that itself has been released for cloud development.

C. ‘ZF1’ can be called via a wrapper that itself has not been released for cloud development.

D. ‘ZF1’ must be released for cloud development to be called.

A

‘ZF1’ can be called via a wrapper that itself has been released for cloud development.

(1. standard 2. cloud -> cloud wrapper)

48
Q

QUESTION NO: 50
What are valid statements? Note: There are 2 correct answers to this question.

A. “zcxl” is a dictionary structure, and “paraml” and “param2” are this structure.

B. “paraml11 and “param2” are predefined names.

C. The code creates an exception object and raises an exception.

D. “previous” expects the reference to a previous exception

A

C. The code creates an exception object and raises an exception.

D. “previous” expects the reference to a previous exception

49
Q

NO.1 After you created a database table in the RESTful Application Programming model, what do
you create next?

A. A metadata extension

B. A projection view

C. A data model view

D. A service definition

A

A data model view

50
Q

NO.3 What RESTful Application Programming feature is used to ensure the uniqueness of a semantic key?

A. Validation

B. Action

C. Determination

A

Validation

51
Q

NO.4 When processing a loop with the statement DO… ENDDO, what system variable contains the
implicit loop counter?

A. sy-linno

B. sy-labix

C. sy-subrc

D. sy-index

A

sy-index

52
Q

Given the following Core Data Service View Entity Data Definition:

AccessControl.authorizationCheck: #NOT REQUIRED

DEFINE VIEW ENTITY demo_sales_cds_so_i_ve

AS SELECT FROM demo_sales_so_i

ASSOCIATION TO PARENT demo_sales_cds_so_ve AS SalesOrder

ON $projection.parent key = SalesOrder.so_key

COMPOSITION [0..*] OF demo_sales_cds_i_sl_ve AS _ScheduleLine

ASSOCIATION [0..1] TO demo_sales_cds_material_ve AS _Material

ON Sprojection.material Material.material

{

key so_item_key,

parent_key,

posnr,

_SalesOrder,

_ScheduleLine,

_Material.material as mat

}

Using ABAP SQL, which select statement selects the mat field on line “_Material.material as mat”?

SELECT mat FROM demo_sales_cds_so_i_ve…

SELECT mat FROM Material…

SELECT mat FROM demo_sales_so_i…

SELECT mat FROM demo_sales_cds_material_ve…

A

SELECT mat FROM demo_sales_cds_so_i_ve…

53
Q

NO.8 In a program you find this source code
AUTHORITY-CHECK OBJECT ‘/DWO/TRVL ( ID ‘CNTRY’ FIELD ‘DE*
ID ACTVT FIELD ‘03”.
Which of the following apply? Note: There are 2 correct answers to this question.

A. If the user is authorized for ‘CNTRY = ‘DE’ then the return code is always 0.

B. If the user is NOT authorized for ‘CNTRY’ = ‘DE’ OR for ‘ACTVT’ = ‘03 then the program will
terminate.

C. If the user is authorized for ‘CNTRY = ‘DE’ AND for ‘ACTVT = ‘03 then the return code is 0.

D. AUTHORITY CHECK verifies whether a user is authorized for/DMO/TRVL” with the listed field
values.

A

If the user is authorized for ‘CNTRY = ‘DE’ AND for ‘ACTVT = ‘03 then the return code is 0.

AUTHORITY CHECK verifies whether a user is authorized for/DMO/TRVL” with the listed field
values.

54
Q

NO.13 Which of the following types are permitted to be used for <source></source> on line #4? Note: There are 2
correct answers to this question.
A. A database table from the ABAP Dictionary
B. A CDS DDIC-based view
C. An external view from the ABAP Dictionary
D. A database view from the ABAP Dictionary

A

A database table from the ABAP Dictionary

A CDS DDIC-based view

55
Q

NO.14 Setting a field to read-only in which object would make the field read-only in all applications
of the RESTful Application Programming model?
A. Service definition
B. Behaviour definition
C. Projection view
D. Metadata extension

A

Behaviour definition

56
Q

NO.18 In ABAP SQL, which of the following can be assigned an alias? Note: There are 2 correct
answers to this question.

A. order criterion (from order by clause)

B. field (from field list)

C. database table

D. group criterion (from group by clause)

A

field (from field list)

database table

57
Q

In the following ABAP SQL code, what are valid case distinctions? (2 correct)

SELECT FROM dbtab1

FIELDS F1,CASE f2,

WHEN ‘1’ THEN ‘Value 1’,

WHEN ‘2’ THEN ‘Value 2’,

WHEN OTHERS “Value for the rest”,

ENDCASE AS f_case

INTO TABLE @DATA(gt_t1).

SELECT FROM dbtab1

FIELDS f1,

CASE f2

WHEN ‘1’ THEN ‘Value 1’

WHEN ‘2’ THEN ‘Value 2’

ELSE ‘Value for the rest’

END AS f_case

INTO TABLE @DATA(gt_t1).

SELECT FROM dbtab1

FIELDS F1,

CASE WHEN F2 = ‘1’ THEN ‘Value 1

WHEN F2 = ‘2’ THEN ‘Value 2’

ELSE ‘Value for the rest’

END AS f_case

INTO TABLE @DATA(gt_t1).

SELECT FROM dbtab1

FIELDS F1,

CASE WHEN F2 = ‘1’ THEN ‘Value 1’

WHEN f2 < f3 AND f2 = ‘2’ THEN ‘Value 2’

WHEN OTHERS ‘Value for the rest’

ENDCASE AS f_case

INTO TABLE @DATA(gt_t1).

A

SELECT FROM dbtab1

FIELDS f1,

CASE f2

WHEN ‘1’ THEN ‘Value 1’

WHEN ‘2’ THEN ‘Value 2’

ELSE ‘Value for the rest’

END AS f_case

INTO TABLE @DATA(gt_t1).

SELECT FROM dbtab1

FIELDS F1,

CASE WHEN F2 = ‘1’ THEN ‘Value 1

WHEN F2 = ‘2’ THEN ‘Value 2’

ELSE ‘Value for the rest’

END AS f_case

INTO TABLE @DATA(gt_t1).

58
Q

NO.23 Given the following Core Data Service View Entity Data Definition:
In what order will the join statements be executed?

A. scarr will be joined with scounter first and the result will be joined with sairport.

B. sairport will be joined to scounter first and the result will be joined with scarr.

C. scarr will be joined with sairport first and the result will be joined with scounter.

D. scounter will be joined to sairport first and the result will be joined with scarr.

A

scarr will be joined with scounter first and the result will be joined with sairport.

59
Q

NO.26 when you attempt to activate the definition, what will be the response?
A. Activation error because the field names of the union do not match
B. Activation error because the field types of the union do not match
C. Activation error because the key fields of the union do not match
D. Activation successful

A

Activation error because the field names of the union do not match

60
Q

NO.27 What are some properties of database tables? Note: There are 2 correct answers to this
question.
A. They store information in two dimensions.
B. They may have key fields.
C. They can have any number of key fields.
D. They can have relationships to other tables.

A

They store information in two dimensions.

They can have relationships to other tables.

61
Q

NO.29 You are given the following information:
1.
The data source “spfli” on line #2 is an SAP HANA
database table
2.
“spfli” will be a large table with over one million rows.
3.
This program is the only one in the system that accesses
the table.
4.
This program will run rarely.
Based on this information, which of the following general
settings should you set for the spfli database table?

A. “Storage Type” to “Column Store”
B. “Load Unit to “Column Loadable”
C. “Storage Type” to “Row Store”
D. “Load Unit’ to ‘Page Loadable”

A

“Storage Type” to “Row Store”

“Load Unit’ to ‘Page Loadable”

62
Q

NO.34 Which internal table type allows unique and non-unique keys?
A. Sorted
B. Hashed
C. Standard

A

Sorted

63
Q

NO.38 Which of the following integration frameworks have been released for ABAP cloud
development? Note:
There are 3 correct answers to this question.

A. SOAP consumption
B. CDS Views
C. Business Add-ins (BAdls)
D. Business Events
E. OData services

A

CDS Views

Business Events

OData services

64
Q

NO.39 Which ABAP SQL clause allows the use of inline declarations?
A. FROM
B. INTO CORRESPONDING FIELDS OF
C. INTO
D. FIELDS

A

INTO

65
Q

NO.40 What are some of the reasons that Core Data Services are preferable to the classical
approach to data modeling? Note: There are 2 correct answers to this question.
A. They implement code pushdown.
B. They avoid data transfer completely.
C. They transfer computational results to the application server.
D. They compute results on the application server.

A

They implement code pushdown.

They transfer computational results to the application server.

66
Q

NO.42
When accessing the subclass instance through go_super, what can you do? Note: There are 2 correct
answers to this question.

A. Access the inherited private components.
B. Access the inherited public components.
C. Call a subclass specific public method
D. Call inherited public redefined methods.

A

Access the inherited public components.

Call inherited public redefined methods.

67
Q

NO.44 Which of the following statements are correct? Note: There are 2 correct answers to this question.

A. FOR defines a loop that runs over the content of source_itab
B. source_itab is only visible within the loop.
C. row is a predefined name and cannot be chosen arbitrarily.
D. row is only visible within the loop.

A

FOR defines a loop that runs over the content of source_itab

row is only visible within the loop.

68
Q

NO.51 When processing an internal table with the statement LOOP AT itab… ENDLOOP, what system variable contains the current row number?

A. sy-index
B. sy-subrc
C. sy-linno
D. sy-tabix

A

sy-tabix

69
Q

NO.52 What are the effects of this annotation?
A. The value of sy-langu will be passed to the CDS view automatically both when you use the -1 CDS
view in ABAP and in another CDS view entity (view on view).
B. You can still override the default value with a value of your own.
C. The value of sy-langu will be passed to the CDS view automatically when you use the CDS view in
ABAP but not when you use it in another view entity
D. It is no longer possible to pass your own value to the parameter.

A

The value of sy-langu will be passed to the CDS view automatically both when you use the -1 CDS
view in ABAP and in another CDS view entity (view on view).

You can still override the default value with a value of your own.

70
Q

NO.54 What are some characteristics of secondary keys for internal tables? Note: There are 3
correct answers to this question.

A. Secondary keys must be chosen explicitly when you actually read from an internal table.
B. Multiple secondary keys are allowed for any kind of internal table.
C. Hashed secondary keys do NOT have to be unique.
D. Sorted secondary keys do NOT have to be unique.
E. Secondary keys can only be created for standard tables.

A

Secondary keys must be chosen explicitly when you actually read from an internal table.

Multiple secondary keys are allowed for any kind of internal table.

Sorted secondary keys do NOT have to be unique.

71
Q

NO.55 Why would you use Access Controls with CDS Views? Note: There are 2 correct answers to
this question.

A. Only the data corresponding to the user’s authorization is transferred from the database to the
application layer.
B. The system field sy-subrc is set, giving you the result of the authorization check
C. You do not have to remember to implement AUTHORITY CHECK statements.
D. All of the data from the data sources is loaded into your application automatically and filtered
there according to the user’s authorization.

A

A. Only the data corresponding to the user’s authorization is transferred from the database to the
application layer.

C. You do not have to remember to implement AUTHORITY CHECK statements.

72
Q

NO.58 Class super has subclass sub. Which rules are valid for the sub constructor? Note: There are 2
correct answers to this question.

A. The method signature can be changed.
B. Import parameters can only be evaluated after calling the constructor of super.
C. The constructor of super must be called before using any components of your own instance.
D. Events of your own instance cannot be raised before the registration of a handler in super.

A

A. The method signature can be changed.

C. The constructor of super must be called before using any components of your own instance.

73
Q

NO.60 In what order are objects created to generate a RESTful Application Programming
application?
A. Database table
B. Service binding
C. Service definition
D. Data model view
E. Projection view

A

Database table

Data model view

Service definition

Service binding

Projection view

74
Q

NO.61 Which of the following results in faster access to internal tables? Note: There are 3 correct
answers to this question.

A. In a sorted internal table, specifying the primary key partially from the left without gaps.

B. In a sorted internal table, specifying the primary key completely.

C. In a standard internal table, specifying the primary key partially from the left without gaps.

D. In a hashed internal table, specifying the primary key partially from the left without gaps.

E. In a hashed internal table, specifying the primary key completely.

A

In a sorted internal table, specifying the primary key partially from the left without gaps.

In a sorted internal table, specifying the primary key completely.

In a hashed internal table, specifying the primary key completely.

75
Q

NO.65 Exhibit
Which of the following ABAP SQL snippets are syntactically correct ways to provide a value for the
parameter on line #4? Note: There are 2 correct answers to this question

A …SELECT * FROM demo_cds_param_view_entity (p_date = @( cl_abap_context_info->get_system_date ( ) )…

B …SELECT * FROM demo_cds_param_view_entity (p_date = ‘20230101’)…

C …SELECT * FROM demo_cds_param_view_entity (p_date: ‘20238181’)…

D …SELECT * FROM demo_cds_param_view entity (p_date: $session.system_date)…

A

…SELECT * FROM demo_cds_param_view_entity (p_date = @( cl_abap_context_info->get_system_date ( ) )…

…SELECT * FROM demo_cds_param_view_entity (p_date = ‘20230101’)…

76
Q

NO.73 You want to provide a short description of the data definition for developers that will be
attached to the database view Which of the following annotations would do this if you inserted it on
line #27
A. @UI headerinto description label
B. @UI.badge.title.label
C. @EndUserText.quickInfo
D. @EndUserText label

A

@EndUserText.quickInfo

77
Q

NO.77 What would be the correct expression to change a given string value ‘mr joe doe’ into ‘JOE’ in
an ABAP SQL field list?

A. SELECT FROM TABLE dbtabl FIELDS
Of1,
upper(left( ‘mr joe doe’, 6)) AS f2_up_left, f3,

B. SELECT FROM TABLE dbtabl FIELDS
Of1,
left(lower(substring( ‘mr joe doe’, 4, 3)), 3) AS f2_left_lo_sub, f3,

C. SELECT FROM TABLE dbtabl FIELDS
Of1,
substring(upper(‘mr joe doe’), 4, 3) AS f2_sub_up, f3,…

D. SELECT FROM TABLE dbtabl FIELDS
Of1,
substring(lower(upper( ‘mr joe doe’ ) ), 4, 3) AS f2_sub_lo_up, f3,

A

SELECT FROM TABLE dbtabl FIELDS
Of1,
substring(upper(‘mr joe doe’), 4, 3) AS f2_sub_up, f3,…

78
Q

NO.80 Which restrictions exist for ABAP SQL arithmetic expressions? Note: There are 2 correct
answers to this question.

A. Floating point types and integer types can NOT be used in the same expression.
B. The operator/is allowed only in floating point expressions.
C. Decimal types and integer types can NOT be used in the same expression.
D. The operator is allowed only in floating point expressions.

A

Floating point types and integer types can NOT be used in the same expression.

The operator “/” is allowed only in floating point expressions.

79
Q

NO.82 Which of the following actions cause an indirect change to a database table requiring a table
conversion? Note:
There are 2 correct answers to this question.

A. Renaming a field in a structure that is included in the table definition
B. Changing the field labels of a data element that is used in the table definition.
C. Deleting a field from a structure that is included in the table definition.
D. Shortening the length of a domain used in a data element that is used in the table definition

A

C. Deleting a field from a structure that is included in the table definition.

D. Shortening the length of a domain used in a data element that is used in the table definition

80
Q

Given the following code excerpt that defines an SAP HANA database table:

DEFINE TABLE demo_table {

KEY field1 : REFERENCE TO abap.clnt(3);

KEY field2 : abap.char(1332);

@Semantics.quantity.unitOfMeasure : ‘demo_table.field4’

field3 : abap.quan(2);

field4 : abap.unit(2);

}

…

Which field is defined incorrectly? (2 correct)

field3

field4

field2

field1

A

field4 : abap.unit(2);

C_ABAPD_2309 (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions