Which of the following ABAP SQL

aggregate functions accept an ABAP SQL

expression (e.g. f1 + f2) as input?
1
Note: There are 2 correct answers to this
question.
avg( )
sum( )
max( )
count( * )

2 Given the following ABAP code, which exception will be raised on execution?
CONSTANTS c_char TYPE c LENGTH 1 VALUE 'X'.
TRY.
result = numbers[ 2 / c_char ].
out->write( |Result: { result } | ).
CATCH cx_sy_zerodivide.
out->write( `Error: Division by zero is not defined` ).
CATCH cx_sy_conversion_no_number.
out->write( |Error: { c_char } is not a number! | ).
CATCH cx_sy_itab_line_not_found.
out->write( |Error: Itab contains less than { 2 / c_char } rows| ).
ENDTRY.

cx_sy_zerodivide
cx_sy_itab_line_not_found
cx_sy_conversion_no_number

After you created a database table in the

RESTful Application Programming
model, what do you create next?
3
A metadata extension
A data model view
A service definition
A projection view

To give authorization to users, in which

order are the artifacts being used?
4

The IAM app uses the Business Role.

The Business Role uses the Authorization Object.
 The Authorization Object uses the Business Catalog.
The Business User uses the Authorization Object.

The IAM app uses the Business Catalog.

The Business Catalog uses the Business Role.
The Business Role uses the Business User.
The Business User uses the Authorization Object.

The IAM app uses the Authorization Object.

The Business Catalog uses the IAM app.
The Business Role uses the Business Catalog.
The Business User uses the Business Role.

The IAM app uses the Business User.

The Business User uses the Business Catalog.
The Business Catalog uses the Business Role.
The Business Role uses the Authorization Object.

Which of the following custom code use

cases falls under Tier 1 extensibility
5 guidelines?

Create a wrapper class around SAP

objects that have not been released yet.
Create a custom field on a DB table or
CDS view via a released extension
include.
Implement a user or customer exits, for
example SAPMV45A.
Apply an SAP note with manual
corrections, for example a DDIC object
from SAP Basis.

Which of the following Core Data

Services built-in functions returns a
6 result of type INT4?
Note: There are 2 correct answers to this
question.

dats_days_between
dats_add_days
dats_add_months
dats_is_valid
 Which function call produces the string
7 'LORE_IPSUM_FACTUM'?

from_mixed( val = 'LoreIpsumFactum'

sep = '_' )
condense( to_upper( 'LoreIpsumFactum' )
)
to_mixed( val = 'LoreIpsumFactum' sep =
'_' )
to_upper( condense( 'LoreIpsumFactum' )
)

In a subclass sub1 you want to redefine a

component of a superclass super1. How
do you achieve this?
8
Note: There are 2 correct answers to this
question.

You add the clause REDEFINITION to the

component in sub1.
You implement the redefined
component in sub1.
You add the clause REDEFINITION to the
component in super1.

You implement the redefined

component for a second time in super1.

Which of the following are valid ABAP

9 SQL type conversions?
Note: There are 3 correct answers to this
question.

CAST( field_f2 as N( 8 ) ) AS f_n8

CAST( 34 as I ) AS f_i34
CAST( 'field_f1' as CHAR( 8 ) ) AS f_char8
CAST( 29 as INT8 ) AS f_int8
CAST( field_f5 as DEC( 15,2 ) ) AS f_dec_15_2

You want to check the behavior of an

ordinary class ZCL_ORDINARY with class
10 LTCL_TEST.
 How do you specify LTCL_TEST as a test
class?

Create a parameter in the SETUP method

of LTCL_TEST and set its value to "Test".

Use the addition "FOR TESTING" in the

class declaration of LTCL_TEST.
Use the addition "FOR TESTING:
LTCL_TEST" in the class declaration of
ZCL_ORDINARY.
Create LTCL_TEST in a special package
that is reserved for test classes.

What are some features of ABAP SQL?

11
Note: There are 2 correct answers to this
question.
It is only valid on the HANA database.
It is first processed by the Database
Interface.
It is directly executed on the HANA
database.
It is integrated in the ABAP
programming language.

When defining a METHOD, which

parameter type can only have 1 value?
12
RETURNING
CHANGING
EXPORTING
IMPORTING

20??? Given the following ABAP SQL statement excerpt from an ABAP program:
1 SELECT SINGLE *
2 FROM spfli
3 WHERE carrid = 'LH' AND connid= '0400'
4 INTO @DATA(wa).
You are given the following information:
The data source “spfli” on line #2 is an SAP HANA database table.
“spfli” will be a large table with over one million rows.
This program is the only one in the system that accesses the table.
 This program will run rarely.
Based on this information, which of the following general settings should you set for the spfli database ta
Note: There are 2 correct answers to this question.
"Storage Type" to "Row Store"
"Load Unit" to "Column Loadable"

"Load Unit" to "Page Loadable"

"Storage Type" to "Column Store" ?

What RESTful Application Programming

object contains only the fields required
for a particular app?
21
Projection view
Data model view
Metadata extension
Database view

22??? You want to document a global class with ABAP Doc.

What do you need to consider?
Note: There are 3 correct answers to this question.

The documentation has to be positioned

directly after the declarative statement.

The documentation may contain tags like <strong> </strong>.

The documentation can be translated.
The documentation starts with "!".

The documentation can contain links to

other repository object's documentation.

23 When you work with a test class you can set up some prerequisites before the actual testing.
In which sequence will the following fixtures be called by the test environment?
class_setup( )
setup( )
teardown( )
class_teardown( )
2->3->1->4
1->2->3->4

24 You have two database tables - ZDEPARTMENTS and ZEMPLOYEES. They are linked by a foreign key relati
 ZEMPLOYEES is the foreign key table and
ZDEPARTMENTS is the check table. A
department may have any number of
employees (including none at all).
What is the correct cardinality of the foreign key relationship?
[1,1]
[0..*,1]
[1..*,1]
[0..1,1]

25 What can be translated?

Note: There are 3 correct answers to this question.
Text symbol
Content of a String variable
Text literal
Data element texts
Message class

26 What is the purpose of a foreign key relationship between two tables in the ABAP Dictionary?
To create a corresponding foreign key relationship in the database
To ensure the integrity of data in the
corresponding database tables
None of the above
To document the relationship between the two tables

27 Which function call returns 0?

find( val = 'find Found FOUND' sub = 'F'
occ = -2 )
find( val = 'FIND FOUND FOUND' sub = 'F' )
find( val = 'FIND Found found' sub = 'F'
occ = -2 CASE = abap_true )
find( val = 'find FOUND Found' sub = 'F' occ = -2 CASE= abap_false )

32 Which of the following enforce ABAP Cloud rules?

Note: There are 2 correct answers to this question.
ABAP platform reuse services
ABAP runtime checks
ABAP release contracts
ABAP compiler

33 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.
 Shortening the length of a domain used in a data element that is used in the table definition
Renaming a field in a structure that is included in the table definition
Changing the field labels of a data element that is used in the table definition
Deleting a field from a structure that is included in the table definitio

34 Which of the following are reasons to use the side-by-side extensibility pattern?
Note: There are 3 correct answers to this question.
An extension enhances an existing SAP Fiori UI
An extension uses its own data model with occasional consumption of data in SAP S/4HANA
An extension runs in the same logical unit of work (LUW) as an SAP S/4HANA application
An extension is managed independently from SAP S/4HANA
An extension implements reactive (event based) process extensions

35??? How can you execute test classes?

Note: There are 3 correct answers to this question.
As a mass test when executing an ABAP Test Cockpit (ATC) check variant.
Interactively during the release of transport request.
As a mass test when releasing a transport request with the ABAP Transport Organizer.
Interactively by calling function "Run as a unit test" from within the test class.
Interactively by calling function "Run as a unit test" from within the tested object.

36 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.
The name of a domain from the ABAP Dictionary
The name of a type defined privately in another class
The name of a data element from the ABAP Dictionary
The name of a type defined privately in class ZCL_CLASS_A

37??? Which of the following integration frameworks have been released for ABAP cloud development?
Note: There are 3 correct answers to this question.
Business Add-ins (BAdIs)
CDS Views
OData services
Business events
SOAP consumption

38???? Given the following code excerpt that defines an SAP HANA database table:
1 DEFINE TABLE demo_table
2{

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

 4 KEY field2 : abap.char(1332);
5 @Semantics.quantity.unitOfMeasure : 'demo_table.field4'
6 field3 : abap.quan(2);
7 field4 : abap.unit(2);
8}
Which field is defined incorrectly?
field1 ?
field2
field4
field3

39 Which of the following are reasons that SAP recommends developing Core Data Services view entities as
Note: There are 2 correct answers to this question.
Elimination of the need for a database view
Simplified syntax check
Automated client handling
Simpler and stricter syntax

40 Which statements apply to the TRY-ENDTRY construct?

Note: There are 3 correct answers to this question.
CATCH clauses should be organized ascending from most specific to most general.
A CLEANUP clause catches remaining exceptions.
A CATCH clause can be used as a handler for several exception classes.
A superclass in a CATCH clause catches exceptions of itself and of its subclasses.
All matching CATCH clauses are always executed.

41 What describes multi-column internal tables?

They are based on a structured row type.
They use one incomplete data type.

They must contain nested components.

They use one complete data type.

How do you make class sub1 a subclass

42 of class super1?
In sub1 use clause "INHERITING FROM super1" in the IMPLEMENTATION part.
In super1 use clause "sub1 REDEFINITION" in the DEFINITION part.
In super1 use clause "sub1 REDEFINITION" in the IMPLEMENTATION part.
In sub1 use clause "INHERITING FROM super1" in the DEFINITION part.

43 When you join two database tables, which of the following rules applies to the database fields you use in
They must be compared with an ON condition.
They must have the same name, e.g. col1 = col1.
They must be at the same position in their table, for example left_table-col1 = right_table-col1.
 They must always have an alias name.

44 Which of the following types of Core Data Services Views can be used at the consumption layer?
Note: There are 3 correct answers to this question.
Hierarchy
Transactional Interface
Transactional Query
Analytical Query
Table Function

45 DATA(structure_variable) = REDUCE structure_type(

INIT
h_structure_variable TYPE structure_type
FOR ROW IN source_itab
NEXT
h_structure_variable-f1 += row-f1
h_structure_variable-f2 += row-f2
).
Which of the following statements are correct?
Note: There are 2 correct answers to this question.
Row is a predefined name and cannot be changed
This REDUCE expression may produce a result of multiple rows
Components of h_structure_variable will be copied to same-named components of structure_variable
The REDUCE expression creates a loop over source_itab

46 Which of the following are rules that extensions in SAP S/4HANA Cloud, public edition must adhere to?
Note: There are 3 correct answers to this question.
Use cloud-enabled and released technologies.
Extend SAP objects through predefined extension points.
Use tier 2 wrappers to enable access to non-released SAP APIs.
Use released remote or local SAP APIs
Modify SAP objects in exceptional cases only.

47 You select a field flight_date with type DATS in the field list of a CDS view.
Which of the following expressions returns the 2-digit month from the field?
Note: There are 2 correct answers to this question.
substring( flight_date, 5, 2 )
substring( flight_date, 4, 2 )
right( left( flight_date, 6 ), 2 )
left( right( flight_date, 6 ), 2 )

48 Which language is used to add or change data of a business object in RESTful Application Programming?
Data manipulation language
Entity manipulation language
 Data modification language
RAP editing language

49 What is a class defined as part of an ABAP program called?

Global class
Global variable
Local class
Local variable

50 @EndUserText.label : 'Draft table for entity /DMO/R_AGENCY'

@AbapCatalog.tableCategory : #TRANSPARENT
@AbapCatalog.deliveryClass : #A
@AbapCatalog.dataMaintenance : #RESTRICTED
define table /dmo/agency_d
{
key mandt : mandt not null;
key agencyid : /dmo/agency_id not null;
key draftuuid : sdraft_uuid not null;
name : /dmo/agency_name;
street : /dmo/street;
postalcode : /dmo/postal_code;
city : /dmo/city;

}
You are a consultant and the client wants you to extend this SAP database table with a new field called "z
Which of the following is the correct response?
The database table can be extended once it has been extensibility enabled by the customer.
The database table can be extended whether extensibility enabled or not if it is assigned to a software com
The database table can be extended whether extensibility enabled or not if it is assigned to a software com
The database table cannot be extended since it has not been extensibility enabled by SAP.

51 While debugging an ABAP program, you want the program to stop whenever the value of a variable chan
Which of the following do you use?
Conditional breakpoint
Watchpoint
Exception breakpoint

52 Which statement can you use to change the contents of a row of data in an internal table?
INSERT
APPEND
UPDATE
MODIFY

53 Given the following data definitions:

 DATA: text TYPE string VALUE 'Date 1972-04-01 is in ISO format'.
DATA: regex TYPE string VALUE '[0-9]{4}(-[0-9]{2}){2}'.
In which of the following functions can
you use regular expressions?
Note: There are 3 correct answers to this question.

matches( val = text pcre = regex )

find( val = text pcre = regex )

match( val = text pcre = regex )

reverse( val = text pcre = regex )
condense( val = text pcre = regex )

54 You have a superclass super1 and a subclass sub1 of super1. Each class has an instance constructor and a
In which sequence will the constructors be executed?
1. Class constructor of super1
2. Class constructor of sub1
3. Instance constructor of super1
4. Instance constructor of sub1
Your answer is correct
1->2->3->4
4->3->2->1

55 In a CDS view, where can a value help be defined?

In an association
In the SQL console
In an annotation
In a view definition

56??? Given the following Core Data Service view entity data definition:
1 @AccessControl.authorizationCheck: #NOT_REQUIRED
2 DEFINE VIEW ENTITY demo_cds_param_view_entity
3 WITH PARAMETERS
4 p_date : abap.dats
5 AS SELECT FROM
6 sflight
7{
8 KEY carrid,
9 KEY connid,
10 KEY fldate,
11 price,
 12 seatsmax,
13 seatsocc
14 }
15 WHERE fldate >= $parameters.p_date;
Which of the following ABAP SQL snippets are syntactically correct ways to provide a value for the param
Note: There are 2 correct answers to this question.
...SELECT * FROM demo_cds_param_view_entity( p_date : '20230101' )...
...SELECT * FROM demo_cds_param_view_entity( p_date = '20230101' )...
...SELECT * FROM demo_cds_param_view_entity( p_date : $session.system_date )...
...SELECT * FROM demo_cds_param_view_entity( p_date = @( cl_abap_context_infc )...

57 @AccessControl.authorizationCheck: #NOT_REQUIRED
DEFINE VIEW ENTITY demo_flight_info_union AS
SELECT FROM scustom
{
KEY id,
KEY 'Customer' AS partner,
name,
city,
country
}
UNION
SELECT FROM stravelag
{
KEY agencynum AS id,
'Agency' AS partner,
name,
city,
country
}
When you attempt to activate the definition, what will be the response?
Activation error because the field types of the union do not match
Activation error because the key fields of the union do not match
Activation successful
Activation error because the field names of the union do not match

58 Which internal table type allows unique and non-unique keys?

Hashed
Standard
Sorted

59 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?
Note: There are 3 correct answers to this question.
go_cl1->m2( )
go_cl1->m1( )
go_cl1->if1( )
go_if1->m1( )
go_if1->m2( )

60 You want to join two database tables, T_CARRIER, and T_CONNECTIONS, to retrieve all carriers, whether t
Which statements would achieve this?
Note: There are 2 correct answers to this question.
SELECT FROM t_carrier LEFT OUTER JOIN t_connections ON ...
SELECT FROM t_carrier LEFT INNER JOIN t_connections ON ...
SELECT FROM t_carrier INNER JOIN t_connections ON ...
SELECT FROM t_connections RIGHT OUTER JOIN t_carrier ON ...

61 In RESTful Application Programming, a business object contains which parts?

Note: There are 2 correct answers to this question.
Process definition
Behavior definition
CDS view
Authentication rules

62 Constructors have which of the following properties?

Note: There are 2 correct answers to this question.
The constructor must be the first method called by the client.
The constructor can have returning parameters.
The constructor is automatically called during instantiation.
The constructor can have importing parameters.

63 In what order are objects created to generate a RESTful Application Programming application?
1. Database table
 2. Data model view
3. Projection view
4. Service definition
5. Service binding
4->5->3->2->1
2->3->1->5->4
5->4->3->2->1
1->2->3->4->5

64??? Which of the following rules apply for dividing with ABAP SQL?
Note: There are 3 correct answers to this question.

Numeric function division( nominator,

denominator, decimal places ) accepts
decimal input.
SELECT FROM TABLE dbtab1 FIELDS f1, division( f2,f3 ,2 )

Numeric function division( nominator, denominator, decimal places ) accepts floating point input.
SELECT FROM TABLE dbtab1 FIELDS f1, division( f2, f3, 2 ) ...

The division operator / accepts decimal input.

SELECT FROM TABLE dbtab1 FIELDS f1, f2 / f3 ...

The division operator / accepts floating

point input.
SELECT FROM TABLE dbtab1 FIELDS f1,f2 /f3 ...

Numeric function div( nominator, denominator ) expects only integer input.

SELECT FROM TABLE dbtab1 FIELDS f1, div( f2, f3 ) ...

65 Which of the following are personas under the SAP S/4HANA Cloud Extensibility Framework?
Note: There are 2 correct answers to this question.
Workflow Administrator
Report Writer
Business Expert
Citizen Developer

66 What are some principles of encapsulation?

Note: There are 2 correct answers to this question.
Attributes can only be changed by the class.
Attributes can be changed by the client program directly.
Attributes cannot be changed.
Attributes can be changed through public class methods.
67 When you create an exception class, what does SAP recommend you do?
Note: There are 3 correct answers to this question.
Inherit from cx_static_check, if you want a warning at design time that the exception will not be caught.
Inherit from cx_no_check, if you want to reuse messages from a system exception class.
Define corresponding public attributes, if you want to pass context-specific values to placeholders of a m
Implement interface if_t100_message, if you want to reuse messages from a message class.
Inherit from cx_static_check, if you want a warning at design time that the exception can never be raised.

68 Which of the following models must you use to develop artifacts that expose ABAP-based backend servic
Note: There are 2 correct answers to this question.
ABAP Cloud Development Model
Cloud Application Programming Model
ABAP Programming Model for SAP Fiori
ABAP RESTful application programming model

69 What are some necessary parts of the singleton pattern?

Note: There are 3 correct answers to this question.
Static attribute to store address of the singleton instance must exist.
Class method to create the singleton instance is set to private.
Class method to create the singleton instance must exist.
Class creation is set to "create private".
Constructor visibility is set to private.

70 Which of the following are features of Core Data Services?

Note: There are 3 correct answers to this question.
Delegation
Associations
Inheritance
Structured Query Language (SQL)
Annotations

71 What are some features of the current ABAP programming language?

Note: There are 2 correct answers to this question.
The code is expression-based
Keywords are case-sensitive
It has built-in database access
A data object’s type can change at runtime

72 How can you control data access of a business user?

Note: There are 3 correct answers to this question.
To control the "Create, Update, and Delete access" via explicit check using AUTHORITY-CHECK.
To control the "Create, Update, and Delete access" implicitly via an Access Control object (define role).
 To control the "Read access" via explicit check using AUTHORITY-CHECK.
To control the general access implicitly via an Access Control object (define role).

To control the "Read access" implicitly

via an Access Control object (define role).

73 Which of the following results in faster access to internal tables?

Note: There are 3 correct answers to this question.
In a sorted internal table, specifying the primary key partially from the left without gaps
In a hashed internal table, specifying the primary key partially from the left without gaps
In a sorted internal table, specifying the primary key completely
In a standard internal table, specifying the primary key partially from the left without gaps
In a hashed internal table, specifying the primary key completely

74 Given the following Core Data Services View Entity Data Definition:
DEFINE VIEW ENTITY demo_cds_view_entity
2 AS SELECT FROM spfli
3{
4 cityfrom,
5 cityto,
6 carrid,
7 connid
8}
When you attempt to activate the definition, what will be the response?
Activation error due to no key defined
Activation will be successful
Activation error due to missing annotation "@AbapCatalog.sqlViewName"
Activation error due to missing annotation "@AccessControl.authorizationCheck"

75 Which of the following is a technique for defining access controls?

Casting
Inheritance
Singleton
Redefinition

What is the syntax to access component

carrier_name of structure connection?
76
connection=>carrier_name
connection-carrier_name
connection->carrier name
connection/carrier_name
 Which RESTful Application Programming
object can be used to organize the
display of fields in an app?
77
Service definition
Projection view
Metadata extension
Data model view

78 You want to define the following CDS view entity with an input parameter:
define view entity Z_CONVERT
with parameters i_currency : ???
Which of the following can you use to replace "???"?
Note: There are 2 correct answers to this question.
A data element
A built-in ABAP Dictionary type
A component of an ABAP Dictionary structure
A built-in ABAP type

To which of the following rules must

extensions in SAP S/4HANA, public cloud
79 edition adhere?
Note: There are 2 correct answers to this
question.
Build at the UX layer
Use released APIs
Use predefined extension points
Use CI / CD pipelines

In a RESTful Application Programming

object, where is the validation
implementation code contained?
80
Subroutine
Function
Global class
Local class

Which of the following rules apply for

81 dividing with ABAP SQL?
Note: There are 3 correct answers to this
question.
 The division operator "/" accepts decimal input.
Numeric function division( numerator,
denominator, decimal places ) accepts
decimal input.

Numeric function div( numerator,

denominator ) expects only integer input.
The division operator "/" accepts floating point
input
Numeric function division( numerator,
denominator, decimal places ) accepts
floating point input.

Which of the following string functions are

predicate functions? Note: There are 2
82 correct answers to this question.
find_any_not_of()
contains_any_of()
count_any_of()
matchesQ

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
83 button?
A. Business Service Extension
B. RAP BO Node Extension
C. SAP HANA database table extension
D. RAP BO Behavior Extension
Which extensibility type does SAP
recommend you use to enhance the existing
84 UI for an SAP Fiori app?
 A. Key user
B. Classic
C. Side-by-side
D. Developer

You have two internal tables itab1 and

itab2.What is true for using the expression
itab1 = corresponding #( itab2 )? Note: There
85 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.
eption will be raised on execution?

2 / c_char } rows| ).
(Tách chuỗi AB => A_B )

( Gép chuỗi A_B => AB )

Việc "redefine" chỉ xảy ra trong subclass.

excerpt from an ABAP program:

P HANA database table.

million rows.
that accesses the table.
 lowing general settings should you set for the spfli database table?

?
<strong> </strong>.

et up some prerequisites before the actual testing.

es be called by the test environment?

MENTS and ZEMPLOYEES. They are linked by a foreign key relationship:

gn key relationship?

onship between two tables in the ABAP Dictionary?

tionship in the database

e two tables

cc = -2 CASE= abap_false )

direct change to a database table requiring a table conversion?

 a data element that is used in the table definition
uded in the table definition
t that is used in the table definition
luded in the table definitio

the side-by-side extensibility pattern?

h occasional consumption of data in SAP S/4HANA

of work (LUW) as an SAP S/4HANA application
om SAP S/4HANA
ased) process extensions

st Cockpit (ATC) check variant.

request with the ABAP Transport Organizer.

unit test" from within the test class.
unit test" from within the tested object. ??

nt DATA var TYPE ***.

P Dictionary
ss ZCL_CLASS_A

works have been released for ABAP cloud development?

nes an SAP HANA database table:

emo_table.field4'

AP recommends developing Core Data Services view entities as opposed to classic Core Data Services DDIC-based views?

RY construct?

ding from most specific to most general.

or several exception classes.

ceptions of itself and of its subclasses.

er1" in the IMPLEMENTATION part.

in the DEFINITION part.
in the IMPLEMENTATION part.
er1" in the DEFINITION part.

of the following rules applies to the database fields you use in the join?

table, for example left_table-col1 = right_table-col1.

 Services Views can be used at the consumption layer?

sult of multiple rows

e copied to same-named components of structure_variable
r source_itab

nsions in SAP S/4HANA Cloud, public edition must adhere to?

tension points.
n-released SAP APIs.

TS in the field list of a CDS view.

s the 2-digit month from the field?

20230202

data of a business object in RESTful Application Programming?

 program called?

y /DMO/R_AGENCY'

you to extend this SAP database table with a new field called "zz_countrycode" on line #14.

t has been extensibility enabled by the customer.

her extensibility enabled or not if it is assigned to a software component of type "Standard ABAP".
her extensibility enabled or not if it is assigned to a software component of type "ABAP Cloud".
nce it has not been extensibility enabled by SAP.

want the program to stop whenever the value of a variable changes.

he contents of a row of data in an internal table?

04-01 is in ISO format'.

Chuỗi này chứa mẫu ngày, nhưng không

Kiểm tra toàn bộ chuỗi text có phù hợp hoàn hoàn toàn khớp 100% (vì còn chữ "Date" và
toàn với mẫu regex hay không. "is in ISO format").

Tìm phần chuỗi đầu tiên trong text khớp với

mẫu regex và trả về chính chuỗi khớp đó. Mẫu regex tìm thấy "1972-04-01"
Tìm vị trí (chỉ số) nơi mẫu regex xuất hiện lần Chuỗi con "1972-04-01" bắt đầu tại vị trí thứ
đầu tiên trong chuỗi. 6 (nếu tính từ 1).

ss sub1 of super1. Each class has an instance constructor and a static constructor. The first statement of your program creates a

w entity data definition:

OT_REQUIRED
 are syntactically correct ways to provide a value for the parameter on line #4?

ntity( p_date : '20230101' )...

ntity( p_date = '20230101' )...
ntity( p_date : $session.system_date )...
ntity( p_date = @( cl_abap_context_infc )...

T_REQUIRED

on, what will be the response?

the union do not match
he union do not match

f the union do not match

nd non-unique keys?
ARRIER, and T_CONNECTIONS, to retrieve all carriers, whether they have corresponding connections or not.

_connections ON ...
connections ON ...
ections ON ...
R JOIN t_carrier ON ...

siness object contains which parts?

called by the client.

ing instantiation.

ate a RESTful Application Programming application?

ding with ABAP SQL?

ision( f2,f3 ,2 )

ominator, decimal places ) accepts floating point input.

ision( f2, f3, 2 ) ...

nator ) expects only integer input.

r the SAP S/4HANA Cloud Extensibility Framework?

ogram directly.

class methods.
does SAP recommend you do?

warning at design time that the exception will not be caught.

use messages from a system exception class.
you want to pass context-specific values to placeholders of a message.
ou want to reuse messages from a message class.
warning at design time that the exception can never be raised.

se to develop artifacts that expose ABAP-based backend services based on semantic data models?

leton pattern?

gleton instance must exist.

nce is set to private.
nce must exist.

e Data Services?

AP programming language?

access" via explicit check using AUTHORITY-CHECK. trực tiếp

access" implicitly via an Access Control object (define role). ngầm
 eck using AUTHORITY-CHECK.
an Access Control object (define role).

ngầm

ess to internal tables?

imary key partially from the left without gaps

rimary key partially from the left without gaps
imary key completely
primary key partially from the left without gaps
rimary key completely

w Entity Data Definition:

on, what will be the response?

n "@AbapCatalog.sqlViewName"
n "@AccessControl.authorizationCheck"

defining access controls?

entity with an input parameter:

1⃣ Use released APIs ✅

Chỉ được phép truy cập dữ liệu hoặc chức năng chuẩn của SAP
Ví dụ:

Mục tiêu: đảm bảo không ảnh hưởng lõi hệ thống

1
2

Câu này anh có check l

Tại cái as N( 8 ) l
6
Page Loadable Tốt cho bảng lớn và ít truy cập
Column Loadable Tốt cho bảng truy cập thường xuyên
Truy cập nhanh với SELECT SINGLE hoặc thay
Row Store đổi dữ liệu thường xuyên
Rất hiệu quả cho truy vấn đọc nhiều bản ghi,
Column Store bảng lớn, tổng hợp, phân tích
 8

11
need check 12
ices DDIC-based views?
13
ment of your program creates an instance of sub1.
14

15
16
17
 18

Khác với đáp án tr

Udemy chọn đáp án A v

2⃣ Use predefined extension points

oặc chức năng chuẩn của SAP thông qua API đã được SAP “released” (phát hành
SAPcông
cungkhai)
cấp các điểm mở rộng chuẩn (predefined extens
Custom fields
OData APIs Custom logic (BAdI or key user
CDS Views with annotation In-app extensibility
@OData.publish: true Side-by-side extensions (BTP)
Remote APIs (REST / SOAP) Bạn chỉ được mở rộng ở những điểm mà SAP cho phép
hưởng lõi hệ thống và có thể cập nhật hệ thống an toàn.
Câu này anh có check lại đáp án anh chọn là C D E nha trên Udemy đáp án là A D E

ại cái as N( 8 ) là sai nó phải là as NUMC( 8 ) mới đúng

3
 7

học thuộc thứ tự theo dạng chữ nha mọi người vì lúc thi nó bắt chọn thứ tự bằng drop down
Này đáp án Udemy là A C D còn anh nghỉ là A D E
Học thuộc thứ tự theo chữ nha vì thi nó bắt chọn dropdown
 Câu này trong đề hơi khác tý Đáp án nó giống dưới đây nè
What are valid statements? (Chọn 3 đáp án đúng)
A.Instead of go_cl1 = NEW #(...) you could use go_if1 = NEW cl1(...).
B. go_if1 may call method m1 with go_if1->m1().
C. Instead of go_cl1 = NEW #() you could use go_iff - NEW #(...).
D. go_cl1 may call method m1 with go_cl1->if1~m1()
E. go_if1 may call method m2 with go_if1->m2(...).

Học thuộc theo dạng chữ nha

Này anh test lại rồi nha đáp án đúng là A D E Udemy chọn A C E
 ới đáp án trên udemy
ọn đáp án A và B

nsion points ✅

rộng chuẩn (predefined extension points) như:

Custom fields
Custom logic (BAdI or key user extensions)
In-app extensibility
Side-by-side extensions (BTP)
những điểm mà SAP cho phép, chứ không được chèn code tùy ý.
hứ tự bằng drop down