n what order are objects created to generate a RESTful Application Programming application?
1. Database table
2. Service binding
3. Service definition
4. Data model view
1, 4, 3, 2
1, 2, 3, 4
3, 2, 1, 4
2, 3, 4, 1
Which statement is used in EML to read data from a business object?
UPDATE ENTITIES.
DELETE ENTITIES.
READ ENTITIES.
MODIFY ENTITIES.
Which RESTful Application Programming object can be used to organize the display of fields in an app?
Data model view
Projection view
Service definition
Metadata extension
What is the purpose of the MODIFY ENTITIES statement in EML?
To update or create data.
To read and delete data.
To read data.
Both read and update data.
What are characteristics of secondary keys for internal tablets? (3 correct)
Secondary keys must be chosen explicitly when you actually read from an internal table.
Sorted secondary keys do NOT have to be unique
Hashed secondary keys do NOT have to be unique
Secondary keys can only be created for standard tables
Multiple secondary keys are allowed for any kind of internal table
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?
RAP BO Node Extension
RAP BO Behavior Extension
Business Service Extension
SAP HANA database table extension
What are some properties of database tables? (2 correct)
They can have relationships to other tables
They store information in two dimensions
They may have key fields
They can have any number of key fields
In class ZCL_CLASS_A, you use the statement DATA var TYPE ***
What may stand in place of ***? (2 correct)
The name of a domain from the ABAP Dictionary
The name of a type defined privately in class ZCL_CLASS_A
The name of a type defined privately in another class
The name of a data element from the ABAP Dictionary
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' ).
What is the purpose of a foreign key relationship between two tables in the ABAP Dictionary?
To document the relationship between the two tables
To create a corresponding foreign key relationship in the database
To ensure the integrity of data in the corresponding database tables
Given this code,
target_itab = VALUE #( FOR row IN source_itab(
field1 = row-field1
field2 = row-field2
fieldn = row-fieldn ) ) .
Which of the following statements are correct? (2 correct)
row is only visible within the loop.
FOR defines a loop that runs over the content of source_itab.
row is a predefined name and cannot be chosen arbitrarily.
source_itab is only visible within the loop.
Given the following Core Data Services View Entity Data Definition,
1 @AccessControl.authorizationCheck: #NOT_REQUIRED
2 DEFINE VIEW ENTITY demo_cds_data_source_matrix
3 AS SELECT FROM
4 <source>
5 {
6 KEY field_1,
8 field_2,
9 field_3
}
which of the following types are permitted to be used for <source> on line #4?
Note: There are 2 correct answers to this question.
A database table from the ABAP Dictionary
An external view from the ABAP Dictionary
A CDS DDIC-based view
A database view from the ABAP Dictionary
INTERFACE if1.
METHODS m1.
ENDINTERFACE.
CLASS cl1 DEFINITION
...
INTERFACES if1.
ENDCLASS.
CLASS cl2 DEFINITION.
DATA mo_if1 TYPE REF TO if1.
ENDCLAS.
What are valid statements? Note: There are 3 correct answers to this question
Class CL1 implements the interface.
In class CL1, the interface method is named if1~m1.
Class CL2 uses the interface.
In class CL2, the interface method is named if1~m1.
Class CL1 uses the interface.
Which part of the business object's definition defines its structure or the fields it contains?
Behavior definition.
Actions.
CDS view.
Validations.
What are the special data types of the internal tables in EML called?
EML operation types.
Derived behavior operation types.
Derived behavior definition types.
Internal behavior types.
In RESTful Application Programming, a business object contains which parts? (2 correct)
Process definition
Authentication rules
Behavior definition
CDS view
< some coding >
IF <condition>.
RAISE EXCEPTION TYPE zcx1
EXPORTING
param1 = valuel
param2 = value2
previous = value3.
ENDIF.
What are valid statements? (2 correct)
"previous" expects the reference to a previous exception
"zcx1" is a dictionary structure, and "param1" and "param2" are same-named components of this structure.
The code creates an exception object and raises an exception.
"param1" and "param2" are predefined names.
Setting a field to read-only in which object would make the field read-only in all applications of the RESTfuI Application Programming model?
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. Instance constructor of sub1.
3. Instance constructor of super1.
4. Class constructor of sub1.
4, 1, 2, 3
4, 1, 3, 2
1, 4, 2, 3
When processing a loop with the statement DO... ENDDO, what system variable contains the implicit loop counter?
sy-subrc
sy-linno
sy-tabix
sy-index
To check whether data is found when reading data from a database table, which system variable will contain 0?
SY-INDEX
SY-UNAME
SY-SUBRC
SY-DATUM
What does a business object in the ABAP RAP model define?
A travel agency.
A behavior definition.
A CDS view.
An entity such as a travel agency.
In RESTful Application Programming, which EML statement retrieves an object?
Get entity
Find entity
Read entity
Select entity
In ABAP SQL, which of the following retrieves the association field _Airline-Name of a CDS view?
/_Airline-Name
*_Airline-Name
@_Airline-Name
\_Airline-Name
For what kind of applications would you consider using on-stack developer extensions? (2 correct)
Applications that access SAP S/4HANA data using complex SQL
Applications that run separate from SAP S/4HANA
Applications that integrate data from several different systems
Applications that provide APIs for side-by-side SAP BTP apps
Class super has subclass sub. Which rules are valid for the sub constructor? (2 correct)
Events of your own instance cannot be raised before the registration of a handler in super.
The method signature can be changed.
The constructor of super must be called before using any components of your own instance.
Import parameters can only be evaluated after calling the constructor of super.
In an Access Control Object, which clauses are used? (3 correct)
Return code (to assign the return code of the authority check)
Revoke (to remove access to the data source)
Grant (to identify the data source)
Define role (to specify the role name)
Where (to specify the access conditions)
In which products must you use the ABAP Cloud Development Model? Note: There are 2 correct answers to this question.
SAP S/4HANA Cloud, private edition
SAP S/4HANA on premise
SAP BTP, ABAP environment
SAP S/4HANA Cloud, public edition
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
Given this code:
DATA: go_super TYPE REF TO lcl_super,
go_sub TYPE RFF TO lcl_sub.
go_sub = NEW #( ... ).
go_super = go_sub.
with lcl_super being superclass of lcl_sub.
When accessing the subclass instance through go_super, what can you do? Note: There are 2 correct answers to this question.
Call inherited public redefined methods.
Access the inherited private components.
Access the inherited public components.
Call a subclass specific public method.
When are derived behavior definition types created?
When a business object is read.
When a developer creates a behavior definition.
When the system processes a request.
When the EML is initialized.
In ABAP SQL, which of the following can be assigned an alias? (2 correct)
field (from field list)
database table
group criterion (from group by clause)
order criterion (from order by clause)
For the assignment,
gv_target = gv_source.
Which of the following data declarations will always work without truncation or rounding? (2 correct)
DATA gv_source TYPE string.
to
DATA gv_target TYPE c.
DATA gv_source TYPE c.
DATA gv_target TYPE string.
DATA gv_source TYPE d.
DATA gv_source TYPE p LENGTH 8 DECIMALS 3.
DATA gv_target TYPE p LENGTH 16 DECIMALS 2.
CLASS cl1 DEFINITION.
PUBLIC SECTION.
METHODS m2.
*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(...).
What are some features of a unique secondary key? Note: There are 2 correct answers to this question.
It is updated when the modified table is read again.
It is created with the first read access of a table.
It is created when a table is filled.
It is updated when the table is modified.
In a RESTful 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.
Which of the following is a generic internal table type?
SORTED TABLE
STANDARD TABLE
HASHED TABLE
INDEX TABLE
After you created a database table in the RESTful Application Programming model, what do you create next?
A data model view
A service definition
A projection view
A metadata extension
/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.
Structure
Internal table
Simple variable
Which of the following are parts of the definition of a new database table? (2 correct)
Field list
Extension
Partitioning attributes
Semantic table attributes
Given the following code in an SAP S/4HANA Cloud private edition tenant:
1. CLASS zcl_demo_class DEFINITION.
2. METHODS: m1.
3. ENDCLASS.
4. CLASS zcl_demo_class IMPLEMENTATION.
5. METHOD m1.
6. CALL FUNCTION 'ZF1'.
7. ENDMETHOD.
8. ENDCLASS.
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.
ZF1" can be called if a wrapper is created for it but the wrapper itself is not released for cloud development.
"ZF1" can be called whether it is released or not for cloud development
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.
What is the sequence priority when evaluating a logical expression?
NOT / BETWEEN / AND
NOT / AND / OR
OR / NOT / AND
AND / OR / NOT
What are advantages of using a field symbol for internal table row access? (2 correct)
The row content is copied to the field symbol instead to a work area.
Using a field symbol is faster than using a work area.
MODIFY statement to write changed contents back to the table is not required.
The field symbol can be reused for other programs.
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
Given the following Core Data Services View Entity Data Definition:
The “demo_cds_assoc_spfli” 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?
_spfli.connid
demo_cds_assoc_spfli.connid,
demo_cds_assoc_spfli-connid,
spfli-connid,
In a subclass sub1 you want to redefine a component of a superclass super. How do you achieve this? (2 correct)
You implement the redefined component in sub1
You add the clause REDEFINITION to the component in super1
You add the clause REDEFINITION to the component in sub1.
You implement the redefined component for a second time in super1.
What are some of the reasons that Core Data Services are preferable to the classical approach to data modeling? (2 correct)
They compute results on the application server
They avoid data transfer completely
They implement code pushdown
They transfer computational results to the application server
In the assignment.
DATA(gv result) = 1 / 8. What will be the data type of gv result?
TYPE DEFLOAT16
TYPE I
TYPE P DECIMALS 3
TYPE P DECIMALS 2
@AccessControl.authorizationCheck: #NOT_REQUIRED
DEFINE VIEW ENTITY demo_sales_cds_so_simple
AS SELECT FROM demo_sales_order AS SalesOrder
KEY so_key,
buyer_id AS BuyerID,
currency_sum AS currencySum
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?
@EndUser.Text.label
@UI.headerinto.description.label
@UI.badge.title.label
@EndUserText.quickInfo
What RESTful Application Programming feature is used to ensure the uniqueness of a semantic key?
Validation
Determination
Action
You need to display an error text. Where do you create it?
In a message class.
In a text pool.
In a global class.
Which of the following parts of a behavior definition are generated automatically? Note: There are 2 correct answers to this question.
Draft enabling
Create, update, and delete operations
Validations
Determinations
Which of the following integration frameworks have been released for ABAP cloud development? (3 correct)
CDS Views
SOAP consumption
OData services
Business Add-ins (BAdIs)
Business events
When you create a database table to generate a RAP application, you must create a client field. Which data type must it have?
The built-in ABAP Dictionary type abap.clnt.
The data element MANDT.
The built-in ABAP Dictionary type abap.char(3)
When you create a validation, what does the system generate automatically?
A fully-implemented method in the global class of the behavior implementation.
A fully-implemented method in the local class of the behavior implementation.
An empty method in the local class of the behavior implementation.
An empty method in the global class of the behavior implementation.
What does the annotation @Consumption.ValueHelpDefiniton specify? Note: There are 2 correct answers to this question.
The field that provides the selected value
A CDS view that provides the hit list
A list of possible entries
A list of fields in the hit list
You want to calculate the ratio of two numeric values in ABAP SQL. The result should be rounded to exactly 1 decimal. What do you use to calculate the division?
Numeric function DIV( )
Operator /
Numeric function DIVISION( )
When are you forced to define alias names for the data sources of a join?
Always, alias names for data sources are always mandatory.
If a field name is used in several data sources.
Never, alias names for data sources are always optional.
If the same data sources is used more than once.
In the validation, you use the READ ENTITIES statement to read the data entered by the user. Which parameter of the validation method do you use to ensure that the correct data is retrieved?
REPORTED
FAILED
KEYS
Which internal table type allows unique and non-unique keys?
Standard
Sorted
Hashed
After profiling an ABAP application you want to analyze the sequence in which procedural units were called. Which of the following trace analysis tools do you go to?
Condensed Hit List
Database Accesses
Aggregated Call Tree
ABAP Stack
You are using the DELETE ADJACENT DUPLICATES statement. Which of the following statements about the COMPARING addition are true? Note: There are 2 correct answers to this question.
If you leave it out, the entire line must be the same in order to be considered a duplicate
If you leave it out, the key fields of the table row must be the same in order to be considered a duplicate.
It will only work properly if the table has been sorted according to the same columns as are listed after COMPARING.
It is mandatory.
The following techniques can avoid runtime errors. (2 corrects)
Use program logic to avoid errors
Trap errors with Case statements
Check program for syntax errors
Trap error with Try statements
You check a user's authorization to view data using an AUTHORITY-CHECK statement. What happens if the user does not have the requisite authorization?
sy-subrc is set to a value unequal to 0. The developer must ensure him or herself that the user cannot see the data.
sy-subrc is set to a value unequal to 0. The user is prevented from seeing the data automatically.
sy-subrc is set to 0. The developer must ensure him or herself that the user cannot see the data.
sy-subrc is set to 0. The user is prevented from seeing the data automatically.
Your ATC check finds a variable text that is not used statically. You want to suppress this finding using either a pseudo-comment or a pragma. Which of the following options are syntactically correct?
DATA text TYPE string. ##needed
DATA text TYPE string. "#EC NEEDED
DATA text TYPE string "#EC NEEDED .
DATA text TYPE string ##needed .
What may you not do in a subclass?
Change the signature of an inherited method
Add new elements
Add a new constructor with its own signature
How do you specify table-specific properties when creating a database table in ADT?
In transaction SE16
Using appropriate annotations before the DEFINE TABLE statement
In the Properties view of the database table
Using annotations in the projection list
Which of the following expressions can you use to force a type conversion?
COND #( )
EXACT #( )
REDUCE #( )
CONV #( )
Which of the following uses of SQL function SUBSTRING( ) returns the same result as LEFT( text_field, 1)?
SUBSTRING(text_field, 0, 1)
SUBSTRING(text_field, 1, 0)
SUBSTRING(text_field, 1, 1)
For which of the following analysis tools does ABAP Development Tools provides a dedicated perspective? Note: There are 2 correct answers to this question.
ABAP Unit
ABAP Test Cockpit
ABAP Debugger
ABAP Profiling
When you address an object using an interface reference, which elements can you address?
All of the public elements in the class
All of the elements in the interface
All of the elements in the class
All of the elements in the method
Which of the following data types is a numeric type? Note: There are 3 correct answers to this question.
P
DECFLOAT16
N
I
Match the sequence of execution in the dropdown list to the operation. (1 is the highest priority and 3 is the lowest priority.)
1,2,3
2,3,1
3,1,2
2,1,3
1,3,2
You are designing the following select statement in ABAP Open SQL:
1. DATA gt_flights type standard table of demo_cds_flights.
2.
3. SELECT
4.
5. FROM demo_cds_flights
6.
7. FIELDS carrid, connid, fldate, SUM(payment_sum), currency
8.
9. WHERE fldate › @sy-datum
10.
11. GROUP BY carrid, connid, fldate
12.
13. ORDER BY carrid, connid.
14.
To adhere to the most recent ABAP SQL syntax conventions from SAP, on which line must you insert the "INTO TABLE @gt_flights" clause to complete the SQL statement?
#4
#6
#14
#8
Your class lcl_class has a factory method factory. Which of the following are properties of factory? Note: There are 2 correct answers to this question.
It may not have any importing parameters
It is a public method
It is an instance method
Its returning parameter has the type REF TO lcl_class
You analyze ABAP code with an ABAP SQL SELECT. The FROM clause contains a nested joins but there are no brackets. What do you look at to find out in which sequence the joins are evaluated?
The sequence of selection criteria
The sequence of ON conditions
The sequence of selected fields
The sequence of data sources
EXTRACT_MONTH( ) is a generic SQL function which can handle input of different types. Which of the following built-in types are allowed for this function? Note: There are 3 correct answers to this question.
UTCLONG
TIMS
DATS
DATN
TIMESTAMPL
The most important views in the ABAP Development Tools perspective include? Note: There are 2 correct answers.
Project Explorer View
History View
Source Code Editor View
Local View
You can use one of the following statements to divide a character string into several substrings.
WRITE
CONCATENATE
REPLACE
SPLIT
In our scenario, what is coded in a behavior implementation? Note: There are 2 correct answers to this question.
Update
You want to read data from an internal table using some, but not all, of its key fields. The fields you want to use are at the beginning of the key with no gaps. What kind of internal table is suitable?
Standard table
Sorted table
Hashed table
An ABAP built-in function xyz( ) is called in the following way: IF xyz( …. ) . … ENDIF. What does this tell you about the nature of the function?
xyz( ) is a processing function.
xyz( ) is a description function.
xyz( ) is a predicate function.
xyz() is a standard function.
Which of the following are features of Core Data Services? (3 correct)
Delegation
Associations
Inheritance
Annotations
Structured Query Language (SQL)
A class lcl_plane has the subclasses lcl_passenger and lcl_cargo. Which of the following statements is true?
You can assign an instance of lcl_passenger to a reference variable with type lcl_plane.
You can only assign an instance of lcl_passenger to a reference variable with type lcl_passenger
You can assign an instance of lcl_passenger to a reference variable with type lcl_cargo.
Which of the following can you use to copy data from one internal table to another? Note: There are 2 correct answers to this question.
The CORRESPONDING #( ) operator
The UPDATE statement
The SELECT statement.
A table comprehension with VALUE #( )
Which of the following are subject to translation in ABAP? Note: There are 3 correct answers to this question.
The value of a text symbol in an ABAP class
The value of a text literal in the source code of an ABAP class
The value of annotation @enduserText.Label in a data definition
The result of a selection criteria
The short text of a message text in a message class
Which of the following are incomplete ABAP types? (2 correct)
String
T
C
our ABAP SQL SELECT statement contains the following FIELDS list: field1, field2, sum( field4 ). Only one of the following GROUP BY clauses causes a syntax error. Which one?
GROUP BY field1
GROUP BY field1, field2, field3
GROUP BY field1, field2
Which of the following can you use to specify the data type of a column in a database table?
Local type
Domain
Data element
You subtract one field with type D from another field with type D. What is the data type of the result?
D
Which of the following data types is complete?
Which of the following assignments between variables of different data types is guaranteed to be free of rounding, truncation, field overflow, or type mismatches? Note: There are 2 correct answers to this question.
TYPE P LENGTH 3 DECIMALS 2 to TYPE P LENGTH 6 DECIMALS 3
TYPE DECFLOAT16 TO TYPE DECFLOAT34
TYPE C LENGTH 10 to TYPE C LENGTH 3
TYPE STRING to TYPE I
In which object do you assign values to authorization fields?
IAM App
Business Role
Business Catalog
Authorization object
Which of the following are use cases for side-by-side extensions? (2 correct)
Creating custom fields in an SAP S/4HANA Cloud table
Creating custom applications integrating data from SAP S/4HANA Cloud and SAP Ariba
Adding additional business logic to an SAP S/4HANA Cloud Business Object
A custom solution needing to be developed by a partner
In the READ ENTITIES statement, you use an internal table with a special type (TYPE TABLE FOR READ RESULT). How is this type created?
The system creates it automatically.
The developer of the business object creates it in the behavior implementation.
The developer of the business object creates it as a global type.
You have a result field result with TYPE P LENGTH 3 DECIMALS 2. Which of the following statements leads to an exception?
result = 1 / 16.
result = EXACT #( 1 / 8 ).
result = 8 / 16.
result = EXACT #( 1 / 2 ).
Which of the following method calls in a RAP validation create messages which are translatable? Note: There are 2 correct answers to this question.
DATA(msg) = me->new_message_with_text( severity = ms-error text = 'Airport does not exist'(ane) ).
DATA(msg) = me->new_message_with_text( severity = ms-error text = |{ 'Airport does not exist'(ane) } | ).
DATA(msg) = me->new_message_with_text( severity = ms-error text = |Airport does not exist| ).
DATA(msg) = me->new_message_with_text( severity = ms-error text = 'Airport does not exist ' ).
Which of the following actions cause an indirect change to a database table requiring a table conversion? (2 correct)
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.
In a loop that processes an internal table and modifies the contents, you replace a work area with a field symbol. What do you expect to happen to the performance of the loop?
The field symbol is faster than the work area.
The performance of both techniques is equal.
The work area is faster than the field symbol.
Which of the following statements is true for a standard internal table?
The key is always non-unique
The key is always unique
You can choose whether the key should be unique or non-unique
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...
Which of the following SQL techniques is available in ABAP SQL but NOT supported in ABAP CDS?
DISTINCT
GROUP BY
ORDER BY
UNION
What would be the correct expression to change a given string value 'mr joe doe' into 'JOE' in an ABAP SQL field list?
SELECT FROM TABLE dbtab1
FIELDS
f1,
upper(left( 'mr joe doe', 6)) AS f2_up_left,
f3,
FIELDSf1,
left(lower(substring( 'mr joe doe', 4, 3)), 3) AS f2_left_lo_sub,
(Falsch)
substring(lower(upper( 'mr joe doe' ) ), 4, 3) AS f2_sub_lo_up,
substring(upper('mr joe doe'), 4, 3) AS f2_sub_up,
f3,...
Which restrictions exist for ABAP SQL arithmetic expressions? (2 correct)
The operator * is allowed only in floating point expressions.
Decimal types and integer types can NOT be used in the same expression.
The operator / is allowed only in floating point expressions.
Floating point types and integer types can NOT be used in the same expression.
Which of the following are building blocks of the SAP Fiori design approach?
Note: There are 3 correct answers.
Python
SAPUI5
SAP Business Application Studio
(Richtig)
SAP Fiori elements
SAP HANA Cloud
You define a dictionary table type with a dictionary type as row type. When does the resulting internal table have columns that you can address with column names? Note: There are 2 correct answers to this question.
When the row type is a data element
When the row type is a structure
When the row type is a database table
When the row type is a table type
Which of the following are tasks of the ABAP Core Data Services? Note: There are 2 correct answers to this question.
Define Business Objects in the ABAP RESTful application programming model.
Provide services for classical ABAP user interfaces.
Define tables on the database
Define views on the database.
What sequence of characters introduces an ABAP Doc comment?
"%
"@
"!
"#
Which of the following are reasons why a consumer-grade UX is important? Note: There are 3 correct answers to this question.
Productivity gains
Reduction in user errors
Training cost savings
Increase system performance
Strengthening of customer and partner relationships
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? (2 correct
If the user is NOT authorized for 'CNTRY' = 'DE' OR for 'ACTVT' = '03 then the program will terminate.
AUTHORITY CHECK verifies whether a user is authorized for /DWO/TRVL" with the listed field values.
If the user is authorized for 'CNTRY = 'DE' then the return code is always 0.
If the user is authorized for 'CNTRY = 'DE' AND for 'ACTVT = '03 then the return code is 0.
During the Preparation phase of a system conversion, which of the following tasks are done? Note: There are 3 correct answers to this question.
Perform manual testing
Utilize maintenance planning
Perform custom code analysis
Perform custom code adaptation
Determine system requirements
Which of the following are tools that can be used to adapt custom code manually or automatically? Note: There are 2 correct answers to this question.
Custom Code Migration app
SAP Readiness Check Tool
SAP Notes
ABAP development tools for Eclipse Quick Fix
Which of the following are ABAP RESTful application programming model layers? Note: There are 3 correct answers to this question.
Business Service Exposure
Domain Model and Implementation
Data Access
CDS Annotations
Which of the following are principles of cloud native? Note: There are 3 correct answers to this question.
REST and CRUD
Infrastructure Independent
Application Programming Interfaces (APIs)
Microservices
Total control of infrastructure
Which of the following is the default cardinality of an association if no cardinality is specified?
[0..1]
[0..*]
none
[1..1]
You have a superclass super that has three subclasses sub1, sub2, and sub3. In a TRY...CATCH block, you want to catch sub1 explicitly and sub2 and sub3 via their superclass. You also want to catch any other exceptions using cx_root. What is the correct sequence of CATCH statements?
CATCH super. CATCH sub1. CATCH cx_root.
CATCH cx_root. CATCH sub1. CATCH super.
CATCH sub1. CATCH super. CATCH cx_root.
CATCH cx_root. CATCH super. CATCH sub1.
Which of the following are essential aspects of ABAP Cloud? Note: There are 3 correct answers to this question.
ABAP development tools for Eclipse
JAVA
.NET & SOAP
ABAP RESTful application programming model
ABAP Cloud language
Which of the following are recommended clean core workstreams? Note: There are 3 correct answers to this question.
Manual testing
Review of copies
Custom code evaluation
Custom code adaptation
Simplification item checks
The term "Local Platform APIs" is directly associated with which of the following? (2 corrects)
SAP HANA
SAP S/4HANA Cloud, ABAP environment
Which of the following extensions are allowed on a CDS view that does not contain the annotation, ABAPCatalog.viewEnhancementCategory? Note: There are 3 correct answers to this question.
Additional fields in the extension list
Additional associations in the element list
Additional fields in the element list
Additional fields in the GROUP BY - clause
Additional expressions in the element list
You define a CDS view entity with an association. When is the association translated into a join on database level?
As soon as you define the association.
When you add the association to the element list.
When you use the association in a path expression.
Where do you create translatable texts for your exception classes?
As a message in a message class
As a text element in the text pool of the class
As a constant in the class definition
Which of the following dictionary types are mapped to ABAP data type P (packed number)? Note: There are 2 correct answers to this question.
CLNT
CUKY
CURR
DEC
Which of the following results in faster access to internal tables? (3 correct)
In a hashed internal table, specifying the primary key partially from the left without gaps.
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.
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.
You change the definition of a database table. In which of the following scenarios do you have to manually adjust the database table?
The database table contains data and you deleted a table field.
The database table is empty and you added a table field
The database table is empty and you deleted a table field.
The database table contains data and you added a table field.
Which type of legacy code does SAP recommend you eliminate when you review modifications as part of an SAP S/4HANA systemconversion? (2 correct)
Code that can be redesigned as a key user extension
Code that now is identical to a standard SAP object
Code that has less than 10% usage according to usage statistics
Code that supports a critical business process
An ABAP class defines an attribute with the following statement: DATA the_attribute TYPE /DMO/AGENCY. Dictionary object /DMO/AGENCY is a database table definition. What kind of data object is the_attribute?
Elementary field
In an ABAP class, you work with a structured data object struct. The structure type of struct contains a named include %tky and the included structure contains a component airlineid. Which of the following statements leads to a syntax error?
both
struct-%tky-airlineid = 'UA'.
struct-airlineid = 'LH'.
You define a foreign key dependency in the ABAP dictionary. What effect does it have? Note: There are 2 correct answers to this question.
Generated input checks in classical user dialogues.
Generated input checks in a SAP Fiori application.
The relationship is documented on ABAP dictionary level.
Enforced data consistency on database level.
Which of the following are factors to consider when choosing between system conversions and new implementations? Note: There are 3 correct answers to this question.
Costs
Transactional Data
Sponsorship
Interfaces
Which of the following are types of indirect modifications? Note: There are 3 correct answers to this question.
Creation of Interfaces
Implicit enhancements
Changes pursuant to an SAP Note
Clones of SAP objects
Class method overwrites
Which of the following are principles of REST architecture? Note: There are 3 correct answers to this question.
Stateless
Layered system
Serializable
Virtualization
Cacheable
Which statement can you use to change the contents of a row of data in an internal table?
Modify table
Update table
Append table
Insert table
You define a database table in the ABAP Dictionary. What is needed to make the database table client dependent?
Annotation @ABAPCatalog.clientDependent: true
A corresponding setting in the Technical Table Properties.
A key field of type CLNT
Which of the following ABAP Dictionary objects can you use as data types in ABAP code? Note: There are 3 correct answers to this question.
Database Table
Search help
Data Element
DATA: go_super TYPE REF to lcl_super,
go_sub1 TYPE REF TO lcl_sub1.
go_sub1 = CAST #( go_super ).
go_sub1->subl_meth1(...).
with which predicate condition can you ensure that the CAST will work?
IS SUPPLIED
IS BOUND
IS NOT INITIAL
IS INSTANCE OF
You want to extend a dictionary database table with a field ZZMYFIELD. The dictionary database table definition contains annotation @ABAPCatalog.enhancement.category. For which of the following annotation values can field ZZMYFIELD have built-in type INT4? Note: There are 2 correct answers to this question.
#EXTENSIBLE_CHARACTER_NUMERIC
#NOT_EXTENSIBLE
#EXTENSIBLE_ANY
#EXTENSIBLE_CHARACTER
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.
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) ).
Which of the following statements may an interface contain? Note: There are 2 correct answers to this question.
PUBLIC SECTION
METHODS
METHOD... ENDMETHOD
CLASS DEFINITION
TYPES
You define a CDS view entity with an input parameter. In which operand positions can you use the input parameter? Note: There are 2 correct answers to this question.
As value for the input parameter of another CDS view entity.
Filter value in the WHERE clause.
Filter using CASE condition
Filter value using LIKE%
Which of the following features of SAP Build is oriented towards a citizen developer?
Intuitive graphical tools utilizing code generation
Integrated debugger
Advanced testing capabilities
Utilization of a particular language and/or programming model
Which of the following are reasons why software extensions are needed? Note: There are 3 correct answers to this question.
Fix standard issues
Desired customer outcomes
Customized business processes
Flexibility
Performance optimization
Which of the following are key parts of the clean core concept? Note: There are 3 correct answers to this question.
Usage of released APIs
Copying (that is, cloning) of standard code in lieu of modifications
Elimination of modifications
Deletion old versions
Strict separation between extensions and the underlying application
Which of the following are the three possibilities for a customer to implement SAP S/4HANA? Note: There are 3 correct answers to this question
External migration
Third-party cloud
System conversion
System landscape transformation
New implementation
Which of the following are the stack layers that classical extensibility refers to? Note: There are 3 correct answers to this question.
Middle
Visual
Data
Key User
End User
Which of the following are part of SAP’s LCNC toolset? Note: There are 3 correct answers to this question.
SAP Build Apps
SAP Build Work Zone
SAP Build Process Automation
S/4 HANA on premise
Which of the following are correct ways to add a comment in a data definition? Note: There are 2 correct answers to this question.
/*…/*
//
/*...*/
"
Which of the following annotations can be mandatory in the definition of a CDS view entity?
@AccessControl.authorizationCheck
AbapCatalog.buffering.numberOfKeyFields
@Semantics.quantity.unitofMeasure
@EndUserText.label
Which of the following string functions are predicate functions? (2 correct)
matches ( )
find_any_not_of ( )
count_any_of ( )
contains_any_of ( )
You have written a program that uses inline declarations and assigns values using expressions. The global data declarations contain the following statement: DATA o TYPE REF TO cl_class. Which of the following are valid statements? Note: There are 3 correct answers to this question.
DATA(p) = NEW cl_class( ).
o = NEW string( ).
o = NEW( ).
DATA(p) = NEW( ).
o = NEW cl_class( ).
BAdIs are classified under which of the following extension types in SAP S/4HANA Cloud?
Developer Extension
Classical user exit
Side-By-Side Extension
Key User Extension
Which of the following repository objects offer a preview function? Note: There are 2 correct Answers to this question.
Behavior Definition
Data Definition
Service Binding
Service Definition
Which of the following ways can you use to address input parameter X in the CDS view definition? Note: There are 2 correct answers to this question.
:X.
$parameters.X.
@X
@parameters.X
Which of the following are key user extensibility tools? Note: There are 3 correct answers to this question.
Custom Business Objects
Custom reports
Custom Fields
Custom CDS Views
Custom Database Tables
Which of the following are essential rules of the SAP S/4HANA Cloud extensibility model? Note: There are 3 correct answers to this question.
No modifications of SAP objects
Customer upgrade projects are to be done once per year
Standard modifications
Usage of released objects only
Clear separation of extensions and SAP code
Which of the following are valid ways to insert a comment in a Data Definition (DDL source)? Note: There are 2 correct Answers to this question.
* comment
-- comment
// comment
/* comment */
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:
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? (2 correct)
"Load Unit to "Column Loadable"
"Storage Type" to "Row Store"
"Storage Type" to "Column Store"
"Load Unit" to "Page Loadable"
Which of the following does the tier 2 extensibility model apply to? Note: There are 2 correct answers to this question.
SAP S/4HANA
Which of the following are valid sort operations for internal tables? (3 correct)
Sort a standard table using
SORT itab BY field1 field2.
Sort a sorted table using
SORT itab DESCENDING.
SORT itab BY field1 ASCENDING field2 DESCENDING.
SORT itab ASCENDING.
SORT itab.
In this nested join below,
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~f1 = a~f1 WHERE...
in which way is the join evaluated?
From the left to the right in the order of the tables:
1. a is joined with b
2. b is joined with c
From the bottom to the top in the order of the on conditions:
From the right to the left in the order of the tables:
1. b is joined with c.
2. b is joined with 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
You develop a transactional application with the ABAP RESTful Application Programming Model(RAP). Not all field names in the data model view are identical to the field names in the database table. Where do you define the field name mapping?
You want to replace statements in a program with expressions
In the Behavior Definition
In the Behavior Projection
In the field mapping view
In the Behavior Implementation
Which of the following do you use as a separator between a table and field name in a CDS view definition?
Pointer(->)
Minus (-)
Period (.)
Tilde (~)
Which of the following are ABAP RESTful application programming model extensibility options? Note: There are 3 correct answers to this question.
Behavior
Data Model
Field
What are possible values for the annotation @AccessControl.authorizationCheck? Choose the 3 correct answers.
#NOT_ALLOWED
#PFCG_AUTH
#NOT_REQUIRED
#FULL_ACCESS
#GRANT_SELECT
#CHECK
Where do you distinguish between OData V2 or OData V4?
Projection View
Behavior Projection
The Entity Manipulation Language (EML) is an extension of which of the following?
The Behavior Definition Language
The ABAP Programming Language
The Structured Query Language
The Service Definition Language
ou are creating an enhancement implementation using key user extensibility. Which of the following can you do in the web-based ABAP editor? Note: There are 3 correct Answers to this question.
Test your custom logic.
Assign your implementation to a transport request.
Create lter conditions
Modularize your code using custom libraries.
Directly access SAP database tables.
Which of the following features are part of the new syntax for Open SQL? Note: There are 2 correct Answers to this question.
ABAP variables escaped with :
Blank-separated column list
ABAP variables escaped with @
Comma-separated column list
Which of the following does the term "Cloud Extensibility Model" refer to?
Tier 2
Tier 4
Tier 1
Tier 3
Which of the following are challenges with trying to use classical extensibility in SAP S/4HANA Cloud? Note: There are 2 correct answers to this question.
Classical extensibility does not enable customers to have flexible processes
In SAP S/4HANA Cloud, there are no customer-specific customer update projects
Classical extensibility does not enable customers to have competitive advantage
In SAP S/4HANA Cloud, all software updates run simultaneously
Which of the following new features are supported by the CDS Views but not by the ABAP Dictionary Views?
Note: There are 3 correct answers to this question.
Combining queries as inner join
Aggregations and grouping
Nested views (View-on-View)
Expressions in the field list
Enhancement with custom fields
Which of the following would a custom wrapper fall under?
Given the following code,
DATA gv_text1 TYPE string."#EC_NEEDED
DATA gv_text2 TYPE string ##NEEDED.
The pragma is not checked by the syntax checker.
The pseudo-comment is checked by the syntax checker
#EC_NEEDED is not checked by the syntax checker.
##NEEDED is checked by the syntax checker.
How could you replace the statement CONCATENATE a b INTO c.? Note: There are 2 correct Answers to this question.
c = a && b.
c = |{ a }{ b }|.
c = a & b.
c = |a && b|.
You want to use the extensibility app, Custom Fields and Logic, to define custom fields for an SAP Fiori app. Which of the following conditions is a prerequisite for this activity?
Custom fields can only be created for SAP Fiori apps that have been enabled by SAP for this type of extension.
You must release the SAP Fiori app for extensibility using the Enable Fields for Use transaction in the Custom Fields and Logic (SCFD_EUI) app.
There is no specific requirement. Custom fields can basically be created for any SAP Fiori app.
You must release the SAP Fiori app for extensibility via Transaction Setup Adaptation Transport Organizer for Key User Tools (S_ATO_SETUP).
You have a field currcode in a CDS view definition. You want to annotate the field with a label.
Which of the following are syntactically correct? Note: There are 2 correct answers to this question.
@<EndUserText.label: 'Currency Code' currcode,
currcode @<EndUserText.label: 'Currency Code' ,
@EndUserText.label: 'Currency Code' currcode,
currcode, @>EndUserText.label: 'Currency Code'
You use the following expression to address the internal table gt_flights: gs_flight = gt_flights[ carrid = 'XX' connid = '9999' ]. There is NO table entry with the specified key. What is the result of the statement?
gs_flight is initialized. The system sets sy-subrc to 4.
gs_flight retains its previous contents. The system triggers an exception.
gs_flight retains its previous contents. The system sets sy-subrc to 4.
gs_flight is initialized. The system triggers an exception.
Which of the following new repository object types were introduced with ABAP CDS? Note: There are 3 correct Answers to this question.
Access Control
External View
Metadata Extension
Business Object
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 "???? (2 correct)
A data element
A built-in ABAP type
A component of an ABAP dictionary structure
A built-in ABAP Dictionary type
You have attached a system field to an input parameter of a CDS view entity as follows:
define view entity Z_ENTITY with parameters
@Environment SystemField: #SYSTEM LANGUAGE
language: spras...
What are the effects of this annotation? (2 correct)
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
It is no longer possible to pass your own value to the parameter.
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).
You can still override the default value with a value of your own.
You define a core data services (CDS) view to merge the results of queries using the UNION keyword. What must the column list of this queries contain? There are 2 correct answers to this question.
Columns of identical types
The same number of columns
All key fields
Columns of compatible types
You have two internal tables itab1 and itab2. What is true for using the expression itab1 = corresponding #( itab2 )? (3 corrects)
Fields with the same name but with different types may be copied from itab2 to itab1.
itab1 and itab2 must have the same data type.
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.
Which of the following are currently available ABAP platform reuse services? Note: There are 3 correct answers to this question.
Knowledge Transfer Documents
Change Documents
Email Service
Smartforms
Sapscript
Which objects are created when a Data Definition is activated? Choose the 2 correct answers.
SQL View
Data Definition View
Role View
CDS View
Activation View
Which building blocks of the ABAP RESTful Programming Model (RAP) are part of the Core Data Services (CDS)? Note: There are 2 correct answers to this question.
Behavior Implementation
You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question.
Nested CASE expression
CASTE Expression
CASE expression
Currency Conversion
Unit conversion
You maintain a transactional application for flight travels that was developed with the ABAP RESTful Application Model (RAP Model). You want to offer an additional button for cancelling a travel. Which of the following building blocks need to be edited? Note: There are 3 correct answers to this question.
Data Model Projection
Which of the following rules apply to the naming of CDS Views? Note: There are 2 correct Answers to this question.
The SQL view name can be up to 30 characters long.
The CDS view and the SQL view must have different names.
The data definition name can be up to 30 characters long.
The data definition and the SQL view must have the same name.
go_sub1 TYPE REF TO lcl_sub1,
go_sub2 TYPE REF TO lcl_sub2.
go_super = NEW go_sub2(...).
go_super = NEW go_sub1(...).
go_sub1->sub1_meth1(...).
go_sub2 = CAST #( go_super).
go_sub2->sub2_meth1(...).
With Icl_super being superclass for Icl_sub1 and Icl_sub2 and with methods sub1_meth1 and sub2_meth1 being subclass-specific methods of Ic_sub1 or Icl_sub2, respectively.
What will happen when executing these casts? (2 correct)
go_sub1 = CAST #( go_super ), will not work
go_sub2 = CAST #( go_super ), will work.
go_sub1->sub1_meth 1(…). will work.
go_sub2->sub2_meth 1(...). will work
go_sub1 = CAST #( go_super ), will work
go_sub2 = CAST #( go_super ). will not work.
Which of the following are factors to consider in deciding what extensibility option to use? Note: There are 3 correct answers to this question.
Extension use case
Extension architecture
Extension testing
Extension scope and size
Extension uniqueness
You implement a SELECT statement in ABAP. When do you use the key word FIELDS?
When the position of the fields list is after the GROUP BY clause.
When the position of the fields list is after the UNION clause.
When the position of the fields list is after the FROM clause.
When the position of the fields list is after the ORDER BY clause.
Which of the following are "public released interfaces" under the SAP S/4HANA Cloud extensibility model? Note: There are 3 correct answers to this question.
Extension Points
Classical user exits
BAPI
Remote APIs
Local APIs
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD). Which SELECT statement would you use in the definition? Please choose the correct answer.
select from snwd_so {sojd, sum(net_amount) as sum_amount}
select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd
select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd
select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount
You have written the following code: START-OF-SELECTION. LOOP AT itab INTO DATA(line). * ENDLOOP. The system creates a variable called Line. When is it created and when can you address it?
It is created at the beginning of the program. You can access it only within the loop.
It is created at the beginning of the program. You can access it any time after the declaration.
It is created when the LOOP statement is processed. You can access it only within the loop.
It is created when the LOOP statement is processed. You can access it any time after the declaration.
Give 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 fidate,
11 price,
12 seatsmax,
13 seatsocc
14 }
15 WHERE fidate >= $parameters.p_date;
Which of the following ABAP SQL snippets are syntactically correct ways to provide a value for the parameter on line #4? (2 correct)
…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')…
…SELECT * FROM demo_cds_param_view_entity (p_date: '20238181')…
…SELECT * FROM demo_cds_param_view entity (p_date: $session.system_date)...
Which of the following tasks are typically done in a Projection view of the ABAP RESTful Application Programming Model (RAP)? Note: There are 2 correct Answers to this question.
Define the components of the service
Define the Business Object composition
Define a value help for an input field
Enable full-text search in the application
Why would you use Access Controls with CDS Views? (2 correct)
The system field sy-subrc is set, giving you the result of the authorization check
You do not have to remember to implement AUTHORITY-CHECK statements
All of the data from the data sources Is loaded into your application automatically and filtered there according to the user's authorization.
Only the data corresponding to the user's authorization is transferred from the database to the application layer.
Which of the following ABAP SQL statements are valid? (2 correct)
SELECT FROM /dmo/connection FIELDS carrid, airpfrom GROUP BY carrid, connid INTO TABLE @DATA(It_hits).
SELECT FROM /dmo/connection FIELDS carrid, airpfrom, MAX( distance ) AS dist_max, MIN( distance ) AS dist_min INTO TABLE @DATA(It_hits).
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).
SELECT FROM /dmo/connection FIELDS MAX( distance ) AS dist_max, MIN( distance ) AS dist_min INTO TABLE @DATA(It_hits).
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).
FIELDS f1,
CASE f2
WHEN '1' THEN 'Value 1'
WHEN '2' THEN 'Value 2'
ELSE 'Value for the rest'
END AS f_case
FIELDS F1,
CASE WHEN F2 = '1' THEN 'Value 1
WHEN F2 = '2' THEN 'Value 2'
CASE WHEN F2 = '1' THEN 'Value 1'
WHEN f2 < f3 AND f2 = '2' THEN 'Value 2'
WHEN OTHERS 'Value for the rest'
Which extensibility type does SAP recommend you to enhance the existing Ul for an SAP Fiori app?
Developer
Classic
Side-by-side
Key user
The SQL statement used to read data from a database table is which of the following?
READ
SELECT
GET
FIND
In the ABAP source code, how do you navigate to the definition of a development object?
Position the cursor on the name of the object and press F3
Double-click on the name of the object
Position the cursor on the name of the object and press F2
Your class contains a public instance attribute attr. How could you ensure that its value can only be changed within the class? Note: There are 2 correct answers to this question.
Convert it into a constant.
Make it a private attribute.
Leave it in the public section but use the READ-ONLY addition.
Move it to a different local class.
Which of the following can you use to denote a comment in ABAP? Note: There are 2 correct answers to this question.
" anywhere in the line
-- anywhere in the line
// at the beginning of a line
* at the beginning of a line
You have shortened the length of a field in a database table. The table already contains data.
What happens when you try to activate the table?
The table is not activated.
The table is activated with a warning that you may lose data.
The table is activated.
An ABAP Cloud Project in ABAP Development Tools (ADT) allows you to connect to what kinds of system? Note: There are 2 correct answers to this question
SAP BTP ABAP instance
On-Premise ABAP system
Embedded ABAP instance in SAP S/4HANA Cloud
2 DEFINE VIEW ENTITY demo_flight_info_join
3 AS SELECT
4 FROM scarr AS a
5 LEFT OUTER JOIN scounter AS c
6 LEFT OUTER JOIN sairport AS p
7 ON p.id = c.airport
8 ON a.carrid = c.carrid
9 {
10 a.carrid AS carrier_id,
11 p.id AS airport_id,
12 c.countnum AS counter_number
13 }
In what order will the join statements be executed?
scarr will be joined with scounter first and the result will be joined with sairport.
scarr will be joined with sairport first and the result will be joined with scounter.
sairport will be joined to scounter first and the result will be joined with scarr.
scounter will be joined to sairport first and the result will be joined with scarr.
You are writing a SELECT statement that reads data using a CDS view entity. In the field list, you want to read a field from an associated table. What do you use?
A regular expression
A logical expression
A path expression
In the RESTful Application Programming model where do you implement non-standard operations for customized business-logic behavior?
In a validation
In an action
In a determination
Which of the following signature elements may an instance constructor have? Note: There are 2 correct answers to this question.
Changing parameters
Importing parameters
Exceptions
Exporting parameters
When processing an internal table with the statement LOOP AT itab ... ENDLOOP, what system variable contains the current row number?
You declare a variable as follows: DATA var TYPE I VALUE 100. Subsequently, you use the statement CLEAR var. What is the value of var after the CLEAR statement?
0
INITIAL
NULL
100
What is the work area of an internal table?
The first row of the internal table
A variable with the same type as the row type of the internal table
The current row of the internal table
Which of the following can you use to fill an internal table? Note: There are 2 correct answers to this question.
VALUE #( )
LOOP...ENDLOOP
APPEND
In a test method you call method cl_abap_unit_assert=>assert_equals( ..) in the following way:
CLASS ltcl1 DEFINITION FOR TESTING RISK LEVEL HARMLESS DURATION SHORT.
PRIVATE SECTION.
METHODS m1 FOR TESTING.
CLASS ltcl1 IMPLEMENTATION.
METHOD m1.
DATA: go_test_object TYPE REF TO zcl_to_be_tested.
CONSTANTS: lco_exp TYPE string VALUE 'test2'.
CREATE OBJECT go_test_object.
cl_abap_unit_assert=>assert_equals(
act = go_class->mv_attribute
exp = lco_exp
msg = `assert equals failed ` && go_test_object->mv_attribute && ` ` && lco_exp
).
ENDMETHOD.
What will happen if method parameters act and exp are not equal?
The tested unit will automatically be appended to a default ABAP Test Cockpit Variant.
The tested unit cannot be transported.
The test will be aborted.
There will be a message in the test log.
Which of the following are valid operators that can be used in arithmetic operators in ABAP? Note: There 2 correct answers.
!
*
/
x
In which order do you define the visibility sections of a class?
PRIVATE SECTION. PROTECTED SECTION. PUBLIC SECTION.
It doesn't matter.
PUBLIC SECTION. PROTECTED SECTION. PRIVATE SECTION.
Which part of SQL is represented by ABAP SQL?
Data Manipulation Language
Data Definition Language
Data Control Language
Given the following Core Data Service View Entity Data Definition,
@AccessControl.authorizationCheck: #NOT REQUIRED
DEFINE VIEW demo_flight_info_union AS
SELECT FROM Scustom {
KEY id,
KEY 'Customer' AS partner,
name,
city,
country
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 field names of the union do not match
Activation successful
Activation error because the key fields of the union do not match
You declare a variable using the statement DATA struct TYPE <type>. Which of the following can you use to declare a structure? Note: There are 2 correct answers to this question.
A CDS view
A predefined ABAP type
A database table
A structure struct contains a component comp. How do you address the component?
struct->comp
struct=>comp
struct-comp
struct.comp
What RESTful Application Programming object contains only the fields required for a particular app?
Database view
For the full signature of a method call when using keyword completion, you must select the method name and press which of the following?
Alt + space
Ctrl + enter
Shift + space
Shift + enter
Which of the following statements about exceptions are true? Note: There are 2 correct answers to this question
All uncaught exceptions lead to runtime errors.
A TRY...ENDTRY block must contain at least two CATCH statements.
Some exceptions are catchable, others are uncatchable.
All execptions are catchable.
You want to read data from two database tables so that the SELECT statement returns a single result set that contains no duplicate entries. Which of the following techniques would you use?
INNER JOIN
LEFT OUTER JOIN
UNION ALL
When does SAP recommend to use a sorted or a hashed table respectively? (2 correct)
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.
A sorted table, when you read a single record and specify non-key fields.
A hashed table, when you read a subset in a loop and specify a part of the key from the left without gaps.
You have defined a class containing instance attributes and static attributes. You have also declared a reference variable but not yet created a new instance of the class. Which components of the class can you access at this point, and how?
Static components using the name of the class.
Static components using the reference variable.
Instance components using the name of the class.
Instance components using the reference variable.
You want to concatenate two strings. Which is the correct operator?
&&
&
+
++
Which statement reads a single row from a database table?
READ TABLE <tablename> ...
SELECT SINGLE <tablename> ...
READ TABLE <tablename> WITH TABLE KEY ...
SELECT <tablename> ...
With the following class definition, what is the correct syntax for calling method b?
(Note: lo_a is a reference variable for class ZCL_A.)
CLASS zcl_a DEFINITION PUBLIC.
CLASS-METHODS b.
zcl_a->b( ).
lo_a=>b( ).
zcl_a=>b( ).
lo_a->b( ).
What can you add to a business object in the ABAP RESTful application programming model? Note: There are 2 correct answers to this question.
Method overwrite
Implicit enhancement
Which ABAP SQL clause allows the use of inline declarations?
INTO CORRESPONDING FIELDS OF
INTO
FROM
What information do you see when you position the mouse pointer over a variable in the debugger?
The current memory consumption of the variable
The current contents of the variable
The data type of the variable
When you press F8 (Continue) in the debugger, where could the program processing next stop? Note: There are 2 correct answers to this question
At the end of the program
At the next ENDMETHOD statement.
At a subsequent breakpoint
In the next line
Which of the following functions can you perform both in the ADT ABAP editor and ADT debugger?
Create a breakpoint for a specific line
Start the debugger using a system command like ‘/h’
Create a watchpoint for a specific variable
A functional method must have
Exactly one exporting parameter
Exactly one importing parameter
Exactly one returning parameter
What do you have to consider when working with interfaces? Note: There are 3 correct answers to this question
Instance methods are not implemented in an interface.
Static methods can be implemented in an interface.
Static methods, instance methods, static events, and instance events are possible interface components.
Implementing classes must declare the interface in their public section.
Implementing classes may declare the interface in any visibility section.
Which of the following are ABAP Cloud Development Model rules?
Build ABAP reports with either ABAP List Viewer (ALV) or SAP Fiori.
Reverse modifications when a suitable public SAP API becomes available.
Use public SAP APIs and SAP extension points.
Build ABAP RESTful application programming model-based services.
A class my_class contains the public static method my_method. What is the correct code to call this method?
Choose the correct answer.
my_class=>my_method.
my_class=>my_method( ).
my_class->my_method( ).
my_class->my_method.
Which of the following are valid data sources for a CDS view entity? Note: There are 2 correct answers to this question.
A structure
An internal table
Another CDS view entity
What must you do when you create an ABAP package? Note: There are 2 correct answers to this question
Use the letter Z or Y as the first character in the name
Assign the package to a software component
Assign the package to an application component
Declare what other packages can use the contents of the package.
The IF condition IF a > 10. is followed by the ELSEIF condition ELSEIF a = 25.The variable a has the value 25. Which code branch or branches are executed?
The branch introduced by ELSEIF a = 25.
Both branches.
The branch introduced by IF a > 10.
The result of the expression result = var MOD 2. is 1. What does this tell you about the value of variable var?
var is an odd number.
var is an even number.
Which of the following predefined ABAP types are complete? Note: There are 2 correct answers to this question.
The type tt_table is defined as follows: TYPES tt_table TYPE STANDARD TABLE OF st_connection WITH NON-UNIQUE KEY carrier_id connection_id. Which DATA statement would you use to create an internal table with this type?
DATA table TYPE tt_table.
DATA table TYPE TABLE OF tt_table.
DATA table TYPE REF TO tt_table.
DATA table TYPE TABLE tt_table.
What is the correct sequence of clauses in the SELECT SINGLE statement?
SELECT SINGLE FROM... FIELDS... WHERE... INTO
SELECT SINGLE FROM... FIELDS... INTO... WHERE...
SELECT SINGLE FIELDS... FROM... INTO... WHERE...
You want to enhance a business object to retrieve a default company code that is selected from the database. Which extension type must you use?
Association
Which of the following characters is not allowed in the name of an ABAP class?
8
$
_
he static constructor is executed when the class is addressed for the first time. When might this be? Note: There are 2 correct answers to this question.
At the beginning of the program.
When you call a static method of the class.
When you instantiate the class.
Last changed7 months ago
