1. Which of the following ABAP SQL aggregate functions accept an ABAP SQL expression (e.g. f1 + f2) as input?
Note: There are 2 correct answers to this question.
---
Avg( )
Sum( )
Max( )
Count(*)
avg( )
sum( )
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
3. After you created a database table in the RESTful Application Programming model, what do you create next?
A metadata extension
A data model view
A service definition
A projection view
4. To give authorization to users, in which order are the artifacts being used?
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 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.
5. Which of the following custom code use cases falls under Tier 1 extensibility 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.
6. Which of the following Core Data Services built-in functions returns a result of type INT4?
dats_days_between
dats_add_days
dats_add_months
dats_is_valid
7. Which function call produces the string 'LORE_IPSUM_FACTUM'?
from_mixed( val = 'LoreIpsumFactum' sep = '_' )
condense( to_upper( 'LoreIpsumFactum' ) )
to_mixed( val = 'LoreIpsumFactum' sep = '_' )
to_upper( condense( 'LoreIpsumFactum' ) )
8. In a subclass sub1 you want to redefine a component of a superclass super1. How do you achieve this?
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.
9. Which of the following are valid ABAP 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
10. You want to check the behavior of an ordinary class ZCL_ORDINARY with class 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.
11. What are some features of ABAP SQL?
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.
12. When defining a METHOD, which parameter type can only have 1 value?
RETURNING
CHANGING
EXPORTING
IMPORTING
13. In a booking record, how can you calculate the difference in days between the order date (type D) and the flight date (type D) of a flight?
data(gv_diff_days) = gs_booking-order_date - gs_booking_flight_date
data(gv_diff_days) = gs_booking-flight_date - gs_booking-order_date.
data(gv_diff_days) = conv d( gs_booking-flight_date - gs_booking-order_date
data(gv_diff_days) = conv d( gs_booking-order_date - gs_booking-flight_date
14. You want to extract date information of a flight date (f_info) and format it like yyyy-dd-mm using the following code:
SELECT FROM TABLE dbtab1 FIELDS f1, extract_year( f_info ) && '-' && extract_month( f_info ) && '-' extract_day( f_info )
For the extract_* functions to work, what can be the data dictionary types of f_info?
TIMS
TIMN
UTCLONG
TIMESTAMP
DATS
15. In CDS views, what do joins and associations have in common?
An alias can be assigned to the data sources and to the fields in the field list.
They can expose an entire data source without listing individual fields.
The data sources are linked using an ON clause.
The field list can include fields of the linked table without specifying the name of the corresponding data source.
16. Given the following code:
DATA gv_text1 TYPE string. "#EC_NEEDED
DATA gv_text2 TYPE string ##NEEDED.
What are valid statements?
##NEEDED is checked by the syntax checker.
The pseudo-comment is checked by the syntax checker.
The pragma is not checked by the syntax checker.
#EC_NEEDED is not checked by the syntax checker.
17. Setting a field to read-only in which object would make the field read-only in all applications of the RESTful Application Programming model?
Behavior definition
Projection view
Metadata extension
Service definition
18. Which of the following pre-defined ABAP data types is a complete data type?
D
P
N
C
19. What can you do in SAP S/4HANA Cloud, public edition?
Use ABAP Development Tools in Eclipse (ADT)
Use Web Dynpros
Use SAP-released extension points
Modify SAP objects
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 table?
"Storage Type" to "Row Store"
"Load Unit" to "Column Loadable"
"Load Unit" to "Page Loadable"
"Storage Type" to "Column Store"
21. What RESTful Application Programming object contains only the fields required for a particular app?
Data model view
Database view
22. You want to document a global class with ABAP Doc.
What do you need to consider?
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?
1. class_setup( )
2. setup( )
3. teardown( )
4. 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 relationship:
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?
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 )
28. define view entity Z_ENTITY with parameters
@Environment.SystemField: #SYSTEM_LANGUAGE
language : spras ...
What are the effects of this annotation?
The value of sy-langu will be passed to the CDS view automatically both when you use the CDS view in ABAP and in another CDS view entity (view on view).
It is no longer possible to pass your own value to the parameter.
You can still override the default value with a value of your own.
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.
29. What RESTful Application Programming feature is used to ensure the uniqueness of a semantic key?
Validation
Determination
Action
30. Which statement creates a reference variable for class CL_VEHICLE?
DATA lo_vehicle TYPE REF OF cl_vehicle.
DATA lo_vehicle LIKE REF cl_vehicle.
TYPES lo_vehicle TYPE cl_vehicle.
DATA lo_vehicle TYPE REF TO cl_vehicle.
31.
define view entity Z_ENTITY as select from Z_SOURCE1 as _Source1
association to Z_SOURCE2 as _Source2
ON Z_Source1.carrier_id = Z_Source2.carrier_id
{
key carrier_id as Carrier,
key connection_id as Connection,
cityfrom as DepartureCity,
cityto as ArrivalCity,
_Source2
}
(The data sources are joined by the field carrier_id. The corresponding field in Z_SOURCE2 is also carrier_id.) Which ON condition must you insert?
ON $projection.Carrier = _Source2.carrier_id
ON $projection.Carrier = Z_Source2.carrier
ON _Source1.carrier_id = Source2.carrier_id
ON $projection.carrier_id = Z_SOURCE2.carrier_id
ON Z_SOURCE1.carrier_id = Z_SOURCE2.carrier_id
32. Which of the following enforce ABAP Cloud rules?
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?
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 definition
34. Which of the following are reasons to use the side-by-side extensibility pattern?
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?
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 ***?
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?
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 opposed to classic Core Data Services DDIC-based views?
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?
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.
42. How do you make class sub1 a subclass 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 the join?
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?
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?
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?
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?
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.
1 @EndUserText.label : 'Draft table for entity /DMO/R_AGENCY'
2 @AbapCatalog.tableCategory : #TRANSPARENT
3 @AbapCatalog.deliveryClass : #A
4 @AbapCatalog.dataMaintenance : #RESTRICTED
5 define table /dmo/agency_d
6 {
7 key mandt : mandt not null;
8 key agencyid : /dmo/agency_id not null;
9 key draftuuid : sdraft_uuid not null;
10 name : /dmo/agency_name;
11 street : /dmo/street;
12 postalcode : /dmo/postal_code;
13 city : /dmo/city;
14
15 }
You are a consultant and the client wants you to extend this SAP database table with a new field called "zz_countrycode" on line #14.
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 component of type "Standard ABAP".
The database table can be extended whether extensibility enabled or not if it is assigned to a software component of type "ABAP Cloud".
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 changes.
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?
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 static constructor. The first statement of your program creates an instance of sub1.
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
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 parameter on line #4?
...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 )...
...SELECT * FROM demo_cds_param_view_entity( p_date = '20230101' )…
...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,
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.
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(...).
60. You want to join two database tables, T_CARRIER, and T_CONNECTIONS, to retrieve all carriers, whether they have corresponding connections or not.
Which statements would achieve this?
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 ...
SELECT FROM t_carrier LEFT OUTER 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?
Process definition
CDS view
Authentication rules
62. Constructors have which of the following properties?
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?
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?
Workflow Administrator
Report Writer
Business Expert
Citizen Developer
66. What are some principles of encapsulation?
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?
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 message.
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 services based on semantic data models?
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?
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?
Delegation
Associations
Inheritance
Structured Query Language (SQL)
Annotations
71. What are some features of the current ABAP programming language?
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?
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?
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
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
Singleton
Redefinition
76. What is the syntax to access component carrier_name of structure connection?
connection=>carrier_name
connection-carrier_name
connection->carrier name
connection/carrier_name
77. Which RESTful Application Programming object can be used to organize the display of fields in an app?
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 "???"?
A data element
A built-in ABAP Dictionary type
A component of an ABAP Dictionary structure
A built-in ABAP type
79. To which of the following rules must extensions in SAP S/4HANA, public cloud edition adhere?
Build at the UX layer
Use released APIs
Use predefined extension points
Use CI / CD pipelines
80. In a RESTful Application Programming object, where is the validation implementation code contained?
Subroutine
Function
Last changeda month ago