CREATE TEST

ERASED TEST, YOU MAY BE INTERESTED ON C__2309

COMMENTS	STATISTICS	RECORDS

TAKE THE TEST

Title of test: C__2309 Description: Test ABAPD Author: PandA Other tests from this author Creation Date: 14/01/2025 Category: Others Number of questions: 80

Share the Test:

New Comment

No comments about this test.

Content:

In a subclass sub1 you want to redefine a component of a superclass super1 How do you achieve this? Note: There are 2 correct answers to this question You add the clause REDEFINITION to the component in sub1 You implement the redefined component in sub1 You implement the redefined component for a second time in super1. You add the clause REDEFINITION to the component in super1. Why would you use Access Controls with CDS Views? Note: There are 2 correct answers to this question The system field sy-subrc is set, giving you the result of the authorization ch Only the data corresponding to the user's authorization is transferred from the database to the application layer All of the data from the data sources is loaded into your application automatically and filtered there according to the user's authorization You do not have to remember to implement AUTHORITY-CHECK statements. Given the following Core Data Service View Entity Data Definition 1 @AccessControl.authorizationCheck: #NOT_REQUIRED 2 DEFINE VIEW ENTITY demo_flight_info_union AS 3 SELECT FROM scustom 4 { 5 KEY id, 6 KEY ‘Customer’ AS partner, 7 name, 8 city, 9 country 10 } 11 UNION 12 SELECT FROM stravelag 13 { 14 KEY agencynum AS id, 15 ‘Agency’ AS partner, 16 name, 18 city, 19 country 20 } When you attempt to activate the definition, what will be the responde? Activation error because the field names of the union do not match Activation successful Activation error because the field types of the union do not match Activation error because the key fields of the union do not match. Which of the following are valid sort operations for internal tables? Note: There are 3 correct answers to this question. Sort a standard table using SORT itab BY field1 field2 Sort a standard table using SORT itab Sort a sorted table using SORT itab DESCENDING Sort a standard table using SORT itab ASCENDING Sort a sorted table using SORT itab BY field1 ASCENDING field2 DESCENDING. Which of the following are incomplete ABAP types? Note: There are 2 correct answers to this question C P T String. 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. 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 FUNTION ‘ZF1’. 7 ENDMETHOD 8 ENDCLASS. The class zcl_demo_class is in a software component with the lenguage version set to “Standard ABAP”. The function module ‘ZF1’ is in a software component with the language version set to “ABAP Cloud”. Both the class and function module are customer created. Regarding line #6, which of the following is a valid statement ? ‘ZF1’ must be released for cloud development to be called. ‘ZF1’ can be called whether it has been released or not for cloud development. ‘ZF1’ can be called via a wrapper that itself has been released for cloud development ‘ZF1’ can be called via a wrapper that itself has not been released for cloud development. 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 } (The data sources are joined by the field carrier_id. The name of corresponding field in Z_SOURCE2 is carrier_id.) Which of the following ON conditions must you insert in place of “???”? ON $projection.carrier_id = Z_Source2.carrier_id ON $projection.Carrier = _Source2.carrier_id ON Z_Source1.carrier_id = Z_Source2.carrier_id ON $projection.Carrier = _Source2.carrier. 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? Note: There are 2 correct answers to this question. 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 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. 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. Which statemant can you use to change the contents of a raw of data in an internal table ? MODIFY UPDATE APPEND INSERT. 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, substring( upper( 'mr joe doe’ ), 4, 3 ) AS f2_sub_up, f3... SELECT FROM TABLE dbtab1 FIELDS f1, left( lower( substring( 'mr joe doe’ , 4, 3 )) AS f2_left_to_sub, f3... SELECT FROM TABLE dbtab1 FIELDS f1, upper(left( 'mr joe doe’, 6 )) AS f2_up_left, f3... SELECT FROM TABLE dbtab1 FIELDS f1, substring(lower( upper( 'mr joe doe’ )), 4, 3 ) AS f2_sub_lo_up, f3... 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, 7 field_2, 8 field_3 9 } 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 CDS DDIC-based view A database table from the ABAP Dictionary A database view from the ABAP Dictionary An external view from the ABAP Dictionary. Given the following Core Data Service View Entity Data Definition: 1 @AccessControl.authorizationCheck: #NOT_REQUIRED 2 DEFINE VIEW ENTITY demo_sales_cds_so_i_ve 3 AS SELECT FROM demo_sales_so_i 4 ASSOCIATION TO PARENT demo_sales_cds_so_ve AS _SalesOrder 5 ON $projection.parent_key = _SalesOrder.so_key 6 COMPOSITION [0..*] OF demo_sales_cds_i_sl_ve AS _ScheduleLine 7 ASSOCIATION [0..1] TO demo_sales_cds_material_ve AS _Material 8 ON $projection.material = _Material.material 9 { 10 11 key so_item_key, 12 parent_key, 13 posnr, 14 15 _SalesOrder, 16 _ScheduleLine, 17 _Material.material as mat 18 } Using ABAP SQL, which select statement selects the mat field on line #17? … SELECT mat FROM _Material … … SELECT mat FROM demo_sales_cds_material_ve … … SELECT mat FROM demo_sales_so_i … … SELECT mat FROM demo_sales_cds_so_i_ve …. As a consultant you are posed the following question from a Clent 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 Ul which will perform an on-the-fly calculation and display the result in a quick popup for the enduser. We havebeen 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 Behavior Extension SAP HANA database table extension RAP BO Node Extension Business Service Extension. What are some features of a unique secondary key? Note: There are 2 correct answers to this question. It is updated when the table is modified It is created when a table is filled. It is updated when the modified table is read again. It is created with the first read access of a table. Given this code. INTERFACE if1. METHODS m1. ENDINTERFACE. CLASS cl1 DEFINITION. … INTERFACES if1. ENDCLASS. … CLASS cl2 DEFINITION. … DATA mo_if1 TYPE REF TO if1. … ENDCLASS. … 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 In class CL2, the interface method is named if1~m1. Class CL1 uses the interface Class CL2 uses the interface. Which type of legacy code does SAP recommend you eliminate when you review modifications as part of an SAP S/4HANA system conversion ? Note: There are 2 correct answers to this question. Code that supports a critical business process Code that has less than 10% usage according to usage statistics Code that now is identical to a standard SAP object Code that can be redesigned as a key user extension. Given the following Core Data Services View Entity Data Definition: 1 @AccessControl.authorizationCheck: #NOT_REQUIRED 2 ? 3 DEFINE VIEW ENTITY demo_sales_cds_so_ve_simple 4 AS SELECT FROM demo_sales_order AS SalesOrder 5 { 6 KEY so_key, 7 buyer_id AS BuyerID, 8 currency_sum AS currencySum 9 } 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 annotation would do this if you inserted it on line #2? @EndUserTextLabel @UI.headerInfo.description.label @UI.badge.title.label @EndUserText.quickInfo. Which of the following are parts of the definition of a new database table? Note: There are 2 correct answers to this question. Field list Partitioning attribues Extension Semantic table attributes. Which of the following are features of Core Data Services? Note: There are 3 correct answers to this question. Associations Structured Query Language (SQL) Delegation Annotations Inheritance. Given the following code DATA gv_text1 TYPE string. “#EC_NEEDED DATA gv_text2 TYPE string ##NEEDED. What are valid statements ? Note: there are 2 correct answers to this question. The pragma is not checked by the syntax checker. ##NEEDED is checked by the syntax checker. The pseudo-comment is checked by syntax checker #EC_NEEDED is not checked by the syntax checker. In which products must you use the ABAP Cloud Development Model? Note: There are 2 correct answers to this question SAP BTP ABAP environment SAP S/4HANA Cloud, public edition SAP S/4HANA on premise SAP S/4HANA Cloud, private edition. What RESTful Application Programming object contains only the fields required for a particular app? Database view Data model view Metadata extension Projection view. What is the purpose of a foreign key relationship between two tables in the ABAP Dictionary? To ensure the integrity of data in the corresponding database tables To document the relationship between the two tables To create a corresponding foreign key relationship in the database. 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 FUNTION ‘ZF1’. 7 ENDMETHOD 8 ENDCLASS. The class zcl_demo_class is in a software component with the lenguage version set to “ABAP Cloud”. The function module ‘ZF1’ is in the same software component. Both the class and funtion module are customer created. Regarding line #6, which of the following is a valid statement ? ‘ZF1’ can be called via a wrapper that itself has not been released for cloud development ‘ZF1’ can be called whether it has been released or not for cloud development. ‘ZF1’ can be called via a wrapper that itself has been released for cloud development. ‘ZF1’ must be released for cloud development to be called. Which internal table type allows unique and non-unique keys ? Sorted Standard Hashed. In class ZCL_CLASS_A, you use the statement DATA var TYPE *** What may stand in place of ***? Note: There are 2 correct answers to this question The name ofa type defined privately in another class The name of a type defined privately in class ZCL_CLASS_A The name of a data element from the ABAP Dictionary The name of a domain from the ABAP Dictionary. 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. Metadata extension Data model view Service definition Behavior definition Projection view. What are some of the reasons that Core Data Services are preferable to the classical approach to data modeling? Note: There are 2 correct answers to this question. They avoid data transfer completely. They transfer computational results to the application server They compute results on the application server They implement code pushdown. 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 FUNTION ‘ZF1’. 7 ENDMETHOD 8 ENDCLASS. The class zcl_demo_class is in a software component with the lenguage version set to “ABAP Cloud”. The function module ‘ZF1’ is in a different software component with the lenguage versione set to “Standard ABAP”. Both the class and funtion module are customer created. Regarding line #6, which of the following is a valid statement ? Note: There are 2 correct answers to this question ‘ZF1’ can be called if a wrapper is created for it and the wrapper itself is released for cloud development ‘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. Which ABAP SQL clause allows the use of inline declaration INTO FIELD FROM INTO CORRESPONDING FIELDS OF. Which extensibility type does SAP recommend you use to enhance the existing UI for an SAP Fiori app? Developer Side-by-side Key user Classic. Which of the following actions cause an indirect change to a database table requiring a table conversion? Note: There are 2 correct answers to this question. Shortening the length of a domain used in a data element that is used in the table definition. 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 Renaming a field in a structure that is included in the table definition. Give th 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? Note: There are 2 correct answers to this question. … SELECT * FROM demo_cds_param_view_entity (p_date : $session.system_date )… … 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 = @(cl_abap_context_info=>get_system_date() )…. You have two internal tables itab1 and itab2 What is true for using the expression itab1 = corresponding #( itab2 )? Note: There are 2 correct answers to this question itab1 and itab2 must have the same data type. Fields with the same name but with different types may be copied from itab2 to itab1 Fields with the same name andthe same type will be copied from itab2 to itab1 itab1 and itab2 must have at least one field name in common. Given this code DATA: go_super TYPE REF TO lcl_super, 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 = CAST #( go_super ) go_sub1->sub1_meth1(…) go_sub2 = CAST #( go_super ) go_sub2->sub2_meth1( … ) with Icl_super being superclass for lcl_sub1 and Icl_sub2 and with methods sub1_meth1 and sub2_meth1 being subclass-specific methods oflcl_sub1 or Icl_sub2, respectively. What will happen when executing these casts? Note: There are 2 correct answers to this question. go_sub1 = CAST #( go_super ) will not work, go_sub2 = CAST #( go_super ) will work go_sub1->sub1_meth1(…) will work go_sub2->sub2_meth1( … ) will work go_sub1 = CAST #( go_super ) will work, go_sub2 = CAST #( go_super ) will not work. In the assignment: data(gv_result) = 1 / 8 what wil be the data type of gv_result? TYPE I TYPE P DECIMALS 2 TYPE DEFLOAT16 TYPE P DECIMALS 3. Which of the following string functions are predicate functions? Note: There are 2 correct answers to this question contains_any_of( ) matches( ) count_any_of( ) find_any not_of( ). Given this code DATA: go_super TYPE REF TO lcl_super, go_sub1 TYPE REF TO lcl_sub1. … go_sub1 = CAST #( go_super ). go_sub1->sub1_meth1(…). With which predicate condition can you ensure that the CAST will work ? IS INSTANCE OF IS NOT INITIAL IS SUPPLIED IS BOUND. For the assignment Gv_target = gv_source. Wich of the following data declaration will always work without truncation or rounding ? Note: There are 2 correct answers to this question DATA gv_source TYPE d. To DATA gv_target TYPE string. DATA gv_source TYPE c. To DATA gv_target TYPE string. DATA gv_source TYPE p LENGHT 18 DECIMALS 3. To DATA gv_target TYPE p LENGHT 16 DECIMALS 3. DATA gv_source TYPE string. To DATA gv_target TYPE c. In the following ABAP SQL code, what are valid case distinctions ? Note: There are 2 correct answers to this question SELECT FROM dbtab1 FIELD f1, CASE f2 WHEN ‘1’ THEN ‘Value 1’ WHEN ‘2’ THEN ‘Value 2’ ELSE ‘Value for the rest’ END AS f_case INTO TABLE @gt_t1. SELECT FROM dbtab1 FIELD f1, CASE f2, WHEN ‘1’ THEN ‘Value 1’, WHEN ‘2’ THEN ‘Value 2’, ELSE ‘Value for the rest’, ENDCASE AS f_case INTO TABLE @gt_t1. SELECT FROM dbtab1 FIELD f1, CASE WHEN f2 = ‘1’ THEN ‘Value 1’ WHEN f2 < f3 AND f2 = ‘2’ THEN ‘Value 2’ WHEN OTHERS ‘Value for the rest’ ENDCASE AS f_case INTO TABLE @gt_t1. SELECT FROM dbtab1 FIELD f1, CASE WHEN f2 = ‘1’ THEN ‘Value 1’ WHEN f2 = ‘2’ THEN ‘Value 2’ ELSE ‘Value for the rest’ END AS f_case INTO TABLE @gt_t1. 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 top to the bottom in the order of the on conditions 1. B is joined with c 2. A is joined with b From the left to the right in the order of the table 1. a is joined with b 2. b is joined with c From the right to the left in the order of table 1. B is joined with c 2. b is joined with a From the bottom to the top in the order of the on conditions 1. a is joined with b 2. b is joined with c. Which restrictions exist for ABAP SQL arithmetic expressions? Note: There are 2 correct answers to this question The operator * is allowed only in floating point expressions Decimal types and integer types can NOT be used in the same expression Floating point types and integer types can NOT be used in the same expression The operator / is allowed only in tloating point expressions. Given the following Core Data Services View Entity Data Definition: 1 @AccessControl.authorizationCheck: #NOT_REQUIRED 2 DEFINE VIEW ENTITY demo_cds_assoc_element 3 AS SELECT FROM scarr 4 ASSOCIATION OF ONE TO MANY demo_cds_assoc_spfli AS _spfli 5 ON scarr.carrid = _spfli.carrid 6 { 7 KEY carrid, 8 ? 9 carrname 10 } The “demo_cds_assoc_spfli” data souce 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. _spfli.connid. Demo_cds_assoc_spfli.connid. Demo_cds_assoc_spfli-connid. Which RESTful Application Programming object can be used to organize the display of fields in an app? Service definition Projection view Metadata extension Data model view. Setting a field to read-only in which object would make the field read-only in all applications of the RESTful Application Programming model? Projection view Service definition Behavior definition Metadata extenslon . What RESTful Application Programming feature is used to ensure the uniqueness of a semantic key? Action Determination Validation. For what kind of applications would you consider using on-stack developer extensions? Note: There are 2 correct answers to this question Applications that provide APIs for side-by-side SAP BTP apps Applications that access SAP S/4HANA data using complex SQL Applications that integrate data from several different systems Applications that run separate from SAP S/4HANA. Which patterns raise an exception ? Note: There are 3 correct answers to this question. DATA: gv_target TYPE d. CONSTANTS: gco_date TYPE d VALUE ‘20331233’. Gv_target = EXACT #( gco_date). DATA: gv_target TYPE c LENGHT 5. CONSTANTS: gco_string TYPE string VALUE ‘0123456789ABCDEF’. Gv_target = EXACT #( gco_string+5(6) ). DATA: gv_target TYPE p DECIMALS 3. CONSTANTS: gco_int1 TYPE i VALUE 2. Gv_target = EXACT #( 2 / gco_int1). DATA: gv_target TYPE string. CONSTANTS: gco_string TYPE c LENGHT 16 VALUE ‘0123456789ABCDEF’. Gv_target = EXACT #( gco_string+5(5) ). DATA: gv_target TYPE p DECIMALS 2. CONSTANTS: gco_int1 TYPE i VALUE 3. Gv_target = EXACT #( 2 / gco_int1 ). Which function call returns 0? find_any_not_of( val = "ABAP ABAP abap’ sub = 'AB' ) find_any_of( val = ‘ABAP ABAP abap’ sub = 'AB' ) count_ any_of( val = АВАРАВАР abар’ sub = 'AB’ ) count( val = ‘ABAP ABAP abap’ sub = ‘AB’ ). In RESTful Application Programming, which EML statement retrieves an object? Find entity Read entity Select entity Get entity. In an Access Control Object, which clauses are used? Note: There are 3 correct answers to this question WHERE (to specify the access conditions) DEFINE ROLE (to specify the role name) REVOKE (to remove access to the data source) GRANT (to identify the data source) RETURN CODE (to assign the return code of the authority check). When processing an internal table with the statement LOOP AT itab ... ENDLOOP, what system variable contains the current row number? sy-index sy-subrc sy-linno sy-tabix. You are designing the following select statement in ABAP OpenSQL: 1 DATA gt_flights type standard table of demo_cds_flights 2 3 SELECT 4 5 FROM demo_cds_flights 6 7 FIELD 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 15 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 ? #6 #8 #15 #4. When does SAP recommend to use a sorted or a hashed table respectively? Note: There are 2 correct answers to this question, A hashed table, when you read a subset in a loop and specify a part of the key from the left without gaps. A hashed table, when you read a single record and specify the complete key. A sorted table, when you read a single record and specify non-key fields. A sorted table, when you read a subset in a loop and specify a part of the key from the left without gaps. 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 ? Note: There are 2 correct answers to this question Row is only visible within the loop Source_itab 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. What are advantages of using a field symbol for internal table row access? Note: There are 2 correct answers to this question. Using a field symbol is faster than using a work area A MODIFY statement to write changed contents back to the table is not required. The field symbol can be reused for other programs The row content is copied to the field symbol instead to a work area. Which of the following integration frameworks have been released for ABAP cloud development? Note: There are 3 correct answers to this question CDS Views OData services Business events SOAP consumption Business Add-ins (BAdIs). Given this code DATA: go_super TYPE REF TO lcl_super, go_sub TYPE REF 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. Access the inherited public components Call inherited public redifined methods. Access the inherited private components Call a subclass-specific method. What are some properties of database tables? Note: There are 2 correct answers to this question. They can have any number of key fields. They can have relationships to other tables They store information in two dimensions. They may have key fields. Which of the following results in faster access to internal tables? Note: There are 3 correct answers to this question In a hashed internal table, specifying the primary key completely In a standard internal table, specifying the primary key partially from the left without gaps. In a sorted internal table, specifying the primary key completely In a hashed internal table, specifying the primary key partially from the left without gaps. In a sorted internal table, specifying the primary key partially from the left without gaps. Which of the following ABAP SQL statements are valid ? Note: There are 2 correct answers to this question SELECT FROM /dmo/connection FIELD Carrid, airpfrom, MAX( distance ) AS dist_max, MIN( distance ) AS dist_min, INTO TABLE @DATA(lt_hits). SELECT FROM /dmo/connection FIELD MAX( distance ) AS dist_max, MIN( distance ) AS dist_min, INTO TABLE @DATA(lt_hits). SELECT FROM /dmo/connection FIELD Carrid, airpfrom, MAX( distance ) AS dist_max, MIN( distance ) AS dist_min GROUP BY carrid,airpfrom INTO TABLE @DATA(lt_hits). SELECT FROM /dmo/connection FIELD Carrid, airpfrom, GROUP BY carrid,connid INTO TABLE @DATA(lt_hits). You want to define the following CDS view entity with an input parameter: define view entity Z_CONVERT with parameters i currency : ??? Which of the following can you use to replace "???" ? Note: There are 2 correct answers to this question A built-in ABAP Dictionary type A component of an ABAP Dictionary structure Abuilt-in ABAP type A data element. /DMO/I_Connection is a CDS vlew. What variable type is connection_full based on the following code? DATA connection _full TYPE /DMO/I_Connection Simple variable Structure Internal table. 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? Field2 Field1 Field4 Field3. What are some characteristics of secondary keys for internal tables? Note: There are 3 correct answers to this question Secondary keys must be chosen explicitly when you actually read from an internal table. Secondary keys can only be created for standard tables. Hashed secondary keys do NOT have to be unique. Multiple secondary keys are allowed for any kind of internal table Sorted secondary keys do NOT have to be unique. Class super has subclass sub. Which rules are valid for the sub constructor? Note: There are 2 correct answers to this question The constructor of super must be called before using any components of your own instance Events of your own instance cannot be raised before the registration of a handler in super. The method signature can be changed. Import parameters can only be evaluated after calling the constructor of super. Given this code < some coding > IF <condition>. RAISE EXCEPTION TYPE zcx1 EXPORTING Param1 = value1 Param2 = value2 Previous = value3. ENDIF. What are valid statements ? Note: There are 2 correct answers to this question. “param1” and “param2” are predefined names. “previous” expects the reference to a previous exception The code creates an exception object and raises an exception. “zcx1” is a dictionary structure, and “param1” and “param2” are same-named components of this structure. In RESTful Application Programming, a business object contains which parts? Note: There are 2 correct answers to this question. Behavior definition Process definition Authentication rules CDS view. In ABAP SQL, which of the following can be assigned an alias? Note: There are 2 correct answers to this question. order criterion (from order by clause) group criterion (from group by clause) database table field (from field list). Given this code INTERFACE if1. METHODS m1. ENDINTERFACE. CLASS cl1 DEFINITION. PUBLIC SECTION. INTERFACES if1. METHODS m2. ENDCLASS. … * in a method of another class DATA go_if1 TYPE REF TO if1. DATA go_cl1 TYPE REF TO cl1. Go_cl1 = NEW #( … ) Go_if1 = go_cl1. What are valid statements ? Note: There are 3 correct answers to this question. Go_cl1 may call method m1 with go_cl1->if1~m1(…) Instead of go_cl1 = NEW #(…) you could use go_if1 = NEW #(…). Go_if1 may call method m2 with go_if->m2(…) Instead of go_cl1 = NEW #(…) you could use go_if1 = NEW cl1(…). Go_if1 may call method m1 with go_if1->m1(…). In a program you find this source code: AUTHORITY-CHECK OBJECT ‘/DMO/TRVL’ ID ‘CNTRY’ FIELD ‘DE’ ID ‘ACTVT’ FIELD ‘03’. Which of the following apply ? Note: There are 2 correct answers to this question. If the user is authorized for ‘CNTRY’ = ‘DE’ AND for ‘ACTCT’ = ‘03’ then the return code is 0. AUTHORITY-CHECK verifies whether a user is authorized for ‘/DMO/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 NOT authorized for ‘CNTRY’ = ‘DE’ OR for ‘ACTVT’ = ‘03’ then the program will terminate. Which of the following is a generic internal table type? STANDARD TABLE HASHED TABLE INDEX TABLE SORTED TABLE. 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 ? Note: There are 2 correct answers to this question. “Load Unit” to “Column Loadable” “Load Unit” to “Page Loadable” “Storage Type” to “Row Store” “Storage Type” to “Column Store”. When processing a loop with the statement DO ... ENDDO, what system variable contains the implicit loop counter? sy-index sy-tabix sy-linno sy-subrc. After you created a database table in the RESTful Application Programming model, what do you create next? A service definition A metadata extension A data model view A projection view. Match_ the sequence of execution in the dropdown list to the operation. (1 is the highest priority and 3 is the lowest priority.) Addition (+) and Subtraction (-) Multiplication (*) and Division ( /) Numeric functions . 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? Instance constructor of sub1. Class constructor of super1 Instance constructor of super1. Class constructor of sub1. What is the sequence priority when evaluating a logical expression ? OR AND NOT . In what order are objects created to generate a RESTful Application Programming application? Service binding Data model view Service definition Projection view Database table .

Report abuse