Quiz: C_ABAPD_2309 Quiz


C_ABAPD_2309 QuizOnline version Тест на знание C_ABAPD_2309. by Pwa Abap 1 Which function call returns 0? a Count_any_of ( val - ‘ABAP ABAP abap'sub "AB" ) b Count (val - 'ABAP ABAP abap'sub - 'AB' ) c find_any_of (val = "ABAP ABAP abap'sub = "AB") d find_any_not_of( val 'ABAP ABAP abap’sub = 'AB') 2 In which products must you use the ABAP Cloud Development Model? Note: There are 2 correct answers to this question. Choose one or more answers a SAP S/4HANA Cloud, private edition b SAP BTP, ABAP environment c SAP S/4HANA on premise d SAP S/4HANA Cloud, public edition 3 Which RESTful Application Programming object can be used to organize the display of fields in an app? a Data model view b Metadata extension c Service definition d Projection view 4 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 Icl_super being superclass of Icl_sub When accessing the subclassinstance through go_super, what can you do? Note: There are 2 correct answers to this question. Choose one or more answers a Access the inherited private components. b Access the inherited public components. c Call a subclass specific public method D. d Call inherited public redefined methods. 5 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 zel_demo_class Implementation. 5 METHOD m1. 6 CALL FUNCTION 'ZF1'. 7 ENDMETHOD 8 ENDCLASS. Choose one or more answers a ZF1' can be called only if it is released for cloud development. b 'ZF1' can be called if a wrapper is created for it and the wrapper itself is released for cloud development. c "ZF1" can be called whether it is released or notfor cloud development d "ZF1" can be called if a wrapper is created for it but the wrapper itself is not released for cloud development. 6 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 Choose one or more answers a It is no longer possible to pass your own value to the parameter. b You can still override the default value with a value of your own. c The value of sy-langu will be passed to the CDS view automatically when you use the CDS view in ABAP but not when you use itin another view entity d The value ofsy-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). 7 In the assignment. data (gv_result) = 1 / 8. what will be the data type of gv_result? a TYPE I b c TYPE DEFLOAT 16 d TYPE P DECIMALS 3 8 Given the code INTERFACE if1. METHODS: m1. ENDINTERFACE. CLASS cl1 DEFINITION. ..... INTERFACES if2. ENDCLASS CLASS cl2 DEFINITION ..... DATA mo_lf1 TYPE REF TO if1. ...... ENDCLASS. What are valid statements? Note: There are 3 correct answersto this question Choose one or more answers a In class CL2, the interface method is named if1-m1. b Class CL2 uses the interface. c In class CL1, the interface method is named if-m1. d Class CL1 uses the interface. e Class CL1 implements the interface. 9 Given this code, DATA: go super TYPE REF TO 1c1 super, go_sub1 TYPE REF TO Icl_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(...). Choose one or more answers a go_sub1->sub1_meth 1(…). will work. b go sub2->sub2meth 1(...). will work c go sub1 = CAST # go super), will not work d go_sub2 = CAST # go super), will work. e go_sub1 CAST #go_super), will work f go_sub2 = CAST #(go_super). will not work 10 Setting a field to read-only in which object would make the field read-only in all applications of the RESTful Application Programming model? a Service definition b Metadata extension c Behaviour definition d Projection view 11 What are some features of a unique secondary key? Note: There are 2 correct answers to this question. Choose one or more answers a It is created with the first read access of a table. b It is created when a table is filled. c It is updated when the table is modified. d It is updated when the modified table is read again 12 Which of the following results in faster access to internal tables? Note: There are 3 correct answers to this question. Choose one or more answers a In a sorted internal table,specifying the primary key partially from the left without gaps b In a hashed internal table,specifying the primary key completely. c In a sorted internal table,specifying the primary key completely. d In a standard internal table,specifying the primary key partially from the left without gaps. e In a hashed internal table,specifying the primary key partially from the left without gaps. 13 You want to define the following CDS view entity with an input parameter: Define view entity Z_CONVERT With parameters currency : ??? Which of the following can you use to replace "???? Note: There are 2 correct answers to this question. Choose one or more answers a A built-in ABAP Dictionary type b A data element c A built-in ABAP type d A component of an ABAP Dictionary structure 14 Match the sequence of execution in the dropdown list to the operation. (1 is the highest priority and 3 is the lowest priority.) 1) Addition (+) and Subtraction (-) 2) Numeric functions. 3) Multiplication () and Division (/)Choose an item. a 1 2 3 b 2 3 1 c 3 1 2 d 3 2 1 15 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. Choose one or more answers a You add the clause REDEFINITION to the component in sub1. b You implement the redefined component in sub1. c You implement the redefined component for a second time in super1. d You add the clause REDEFINITION to the component in super1. 16 In a program you find this source code AUTHORITY-CHECK OBJECT '/DWO/TRVL ‘ ID 'CNTRY' FIELD 'DE' ID ACTVT FIELD '03". Which of the following apply? Note: There are 2 correct answers to this question. Choose one or more answers a AUTHORITY CHECK verifies whether a user is authorized for /DMO/TRVL" with the listed field values. b If the user is authorized for'CNTRY = 'DE' AND for 'ACTVT = '03 then the return code is 0. c If the user is NOT authorized for'CNTRY' = 'DE' OR for 'ACTVT' = '03 then the program will terminate. d If the user is authorized for'CNTRY = 'DE' then the return code is always 0. 17 Which of the following are valid sort operationsfor internal tables? Note: There are 3 correct answers to this question. Choose one or more answers a Sort a sorted table using - SORT itab DESCENDING. b Sort a sorted table using - SORT itab BY field1 ASCENDING field2 DESCENDING. c Sort a standard table using - SORT itab ASCENDING. d Sort a standard table using - SORT itab BY field1 field2. e Sort a standard table using - SORT itab. 18 Which statement can you use to change the contents of a row of data in an internal table? a Append table b Insert table c Update table d Modify table 19 In an Access Control Object, which clauses are used? Note: There are 3 correct answers to this question. Choose one or more answers a Where (to specify the access conditions) b Return code (to assign the retum code of the authority check) c Define role (to specify the role name) d Revoke (to remove access to the data source) e Crant (to identify the data source) 20 You are designing the following selectstatement 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 fidate > @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? a #15 b #6 c #8 d #4 21 Given the code, DATA: go super TYPE REF TO 1c1_super, go_sub1 TYPE REF TO Lel_sub1. ... go_sub1 = CAST #(go_super ). go_sub1->sub1_meth1(...). with which predicate condition can you ensure that the CAST will work? a IS BOUND b IS INSTANCE OF c IS NOT INITIAL d IS SUPPLIED 22 What is the sequence priority when evaluating a logical expression? A. NOT 1 B. OR 3 C. AND 2 a 1 2 3 b 3 2 1 c 2 3 1 d 1 3 2 23 Which of the following are parts of the definition of a new database table? Note: There are 2 correct answers to this question. Choose one or more answers a Field list b Extension c Semantic table attributes d Partitioning attribues 24 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. Choose one or more answers a Data model view b Service definition c Behavior definition d Projection view e Metadata extension 25 Which of the following are incomplete ABAP types? Note: There are 2 correct answers to this question. Choose one or more answers a P b string c C d T 26 Which of the following integration frameworks have been released for ABAP cloud development? Note: There are 3 correct answers to this question. Choose one or more answers a OData services b Business events c SOAP consumption d Business Add-ins(BAdls) e CDS Views 27 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 Choose one or more answers a Instead of go_cl1 = NEW #() you could use go_iff - NEW #(...). b go_if1may call method m2 with go if->m2(...). c Instead of go cl1 = NEW #(...) you could use go if1 = NEW cl1( ... ). d go_if1may call method m1 with go_ift->m1(). e go_cl1may call method m1 with go_d1->if1-m1(). 28 Which of the following ABAP SQL statements are valid?Note: There are 2 correct answers to this question. Choose one or more answers a SELECT FROM /dmo/connection FIELDS MAX(distance) AS dist_max MIN(distance) AS dist_min INTO TABLE @DATA(It_hits). b SELECT FROM /dmo/connection FIELDS carrid, airpfrom GROUP BY carrid, connid INTO TABLE @DATA(It_hits). c SELECT FROM /dmo/connection FIELDS carrid airpfrom, MAX(distance) AS dist_max, MIN( distance) AS dist_min GROUP BY carrid, airpfrom INTO TABLE @DATA(It_hits) d SELECT FROM /dmo/connection FIELDS carrid, airpfrom, MAX( distance) AS dist_max, MIN(distance) AS dist_min INTO TABLE @DATA(It_hits) 29 Same Question a b c d 30 In ABAP SQL, which ofthe following retrieves the association field_Airline-Name of a CDS view? a \_Airline-Name b “_Airline Name c /_Airline Name d . @_Airline-Name 31 Which internal table type allows unique and non-unique keys? a Hashed b Standard c Sorted 32 In ABAP SQL, which of the following can be assigned an alias? Note: There are 2 correct answers to this question. Choose one or more answers a field (from field list) b order criterion (from order by clause) c group criterion (from group by clause) d database table 33 Which patterns raise an exception? Note: There are 3 correct answersto this question. Choose one or more answers a DATA: gv_target TYPE d. CONSTANTS: gco_date TYPE d VALUE '20331233'. gv_target EXACT # ( geo_date). b DATA: gv_target TYPE c LENGTH 5. CONSTANTS: ECOstring TYPE string VALUE 0123456789ABCDEF". gv_target - EXACT #(gco_string+5 (6) ). c DATA: Ev target TYPE p DECIMALS 3. CONSTANTS: gco_int1 TYPE i VALUE 2. Ev_target - EXACT #(2 / gco_int1 ). d DATA: gv_target TYPE string. CONSTANTS: gco_string TYPE LENGTH 16 VALUE 0123456789ABCDEF. gv_target = EXACT # (gco_string+5 (5) ). e DATA: gv_target TYPE p DECIMALS 2. CONSTANTS: go int1 TYPE i VALUE 3. gv_target - EXACT # (2 gco_int1). 34 Which of the following are features of Core Data Services? Note: There are 3 correct answersto this question. Choose one or more answers a Associations b Inheritance c Annotations d Structured Query Language (SQL) e Delegation 35 Why would you use Access Controls with CDS Views? Note: There are 2 correct answers to this question. Choose one or more answers a The system field sy-subrc isset, giving you the result of the authorization check b You do not have to remember to implement AUTHORITY CHECK statements. c All of the data from the data sources isloaded into your application automatically and filtered there according to the user's authorization. d Only the data corresponding to the user's authorization istransferred from the database to the application layer. 36 Which ABAP SQL clause allowsthe use of inline declarations? a INTOCORRESPONDING FIELDS OF b FROM c FIELDS d INTO 37 What RESTful Application Programming object contains only the fields required for a particular app? a Database view b Metadata extension c Projection view d Data model view 38 After you created a database table in the RESTful Application Programming model, what do you create next? a A projection view b A data model view c A metadata extension d A service definition 39 In class ZCL_CLASS_A, you use the statement DATA var TYPE * What may stand in place of ? Note: There are 2 correct answersto this question. Choose one or more answers a The name of a type defined privately in another class b The name of a domain from the ABAP Dictionary c The name of a type defined privately in class ZCL_CLASS_A d The name of a data element from the ABAP Dictionary 40 Which extensibility type does SAP recommend you use to enhance the existing UI for an SAP Fiori app? a Key user b Developer c Side-by-side d Classic 41 In RESTful Application Programming, which EML statement retrieves an object? a Read entity b Get entity c Find entity d Select entity 42 What are advantages of using a field symbol for internal table row access? Note: There are 2 correct answers to this question. Choose one or more answers a A MODIFY statement to write changed contents back to the table is not required. b Using a field symbol is faster than using a work area. c The row content is copied to the field symbol instead to a work area d The field symbol can be reused for other programs. 43 What isthe purpose of a foreign key relationship between two tables in the ABAP Dictionary? a To create a corresponding foreign key relationship in the database b To ensure the integrity of data in the corresponding database tables c To document the relationship between the two tables 44 When processing an internal table with the statement LOOP AT itab... ENDLOOP, whatsystem variable contains the current row number? a sy-subrc b sy-linno c sy-index d sy-tabix 45 In what order are objects created to generate a RESTful Application Programming application? A. Database table B. Service binding Projection view C. Service definition D. Data model view a A D B C b A B C D c B A D C d C A B D 46 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. Choose one or more answers a They compute results on the application server. b They transfer computational resultsto the application server. c They avoid data transfer completely. d They implement code pushdown. 47 What RESTful Application Programming feature is used to ensure the uniqueness of a semantic key? a Validation b Determination c Action 48 < some coding > IF . RAISE EXCEPTION TYPE zcx1 EXPORTING param1 = valuel param2 = value2 previous = value3. ENDIF. What are valid statements? Note: There are 2 correct answers to this question. Choose one or more answers a "zcx1" is a dictionary structure, and "param1" and "param2" are same-named components of this structure. b "previous" expectsthe reference to a previous exception c The code creates an exception object and raises an exception. d "param1" and "param2" are predefined names. 49 target_itab= VALUE # ( FOR row IN source_itab( field1 = row-field1 field2=row-field2 fieldn=row-field)). Choose one or more answers a FOR defines a loop that runs over the content of source_itab b row is a predefined name and cannot be chosen arbitrarily. c source_itab is only visible within the loop. d row is only visible within the loop. 50 For what kind of applications would you consider using on-stack developer extensions? Note: There are 2 correct answers to this question. Choose one or more answers a Applications thatrun separate from SAP S/4HANA b Applicationsthat provide APIsforside by side SAP BTP apps c Applicationsthat access SAP S/4HANA data using complex SQL d Applicationsthatintegrate data from several differentsystems 51 You want to provide a short description of the data definition for developers that will be attached to the database view Which ofthe following annotations would do this if you inserted it on line #2 a @EndUser Textlabel b @UI.badge.title.label c @EndUserText.quickInfo d @UI headerinto description labe 52 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 answersto this question. Choose one or more answers a The pragma is not checked by the syntax checker. b ##NEEDED is checked by the syntax checker. c #EC_NEEDED is not checked by the syntax checker. d The pseudo-comment is checked by the syntax checker 53 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 classzcl_demo_classisin a software component with the language version set to "ABAP Cloud". The function module ZF1' is in the same software component. Both the class and function module are customer created. Regarding line #6, which of the following is a valid statement? a 'ZF1' must be released for cloud development to be called. b 'ZF1' can be called via a wrapper that itself has not been released for cloud development. c 'ZF1' can be called whether it has been released or not for cloud development. d 'ZF1' can be called via a wrapper that itself has been released for cloud development. 54 Given the following Core Data Services View Entity DataDefinition, 1 @AccessControl.authorizationCheck: #NOT REQUIRED 2 DEFINE VIEW ENTITY demo_rds_data_source_matrix 3 AS SELECT FROM 4 5 { 6 key field_1, 7 field_2, 8 field_c 9 } Which of the following types are permitted to be used for on line #4? Note: There are 2 correct answersto this question. Choose one or more answers a An external view from the ABAP Dictionary b A database view from the ABAP Dictionary c A CDS DDIC-based view d A database table from the ABAP Dictionary 55 Which restrictions exist for ABAP SQL arithmetic expressions? Note: There are 2 correct answersto this question. Choose one or more answers a The operator is allowed only in floating point expressions b The operator / is allowed only in floating point expressions. c Decimal types and integer types can NOT be used in the same expression. d Floating pointtypes and integer types can NOT be used in the same expression. 56 When does SAP recommend to use a sorted or a hashed table respectively? Note: There are 2 correct answersto this question. Choose one or more answers a A hashed table, when you read a single record and specify the complete key. b A sorted table, when you read a single record and specify non key fields. c A hashed table, when you read a subset in a loop and specify a part of the key from the left without gaps. d A sorted table, when you read a subset in a loop and specify a part of the key from the left without gaps. 57 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. Choose one or more answers a Code that can be redesigned as a key user extension b Code that supports a critical business process c Code that now isidentical to a standard SAP object d Code that hasless than 10% usage according to usage statistics 58 When processing a loop with the statement DO... ENDDO, what system variable contains the implicit loop counter? a sy-linno b sy-subrc c sy-labix d sy-index 59 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. Choose one or more answers a Changing the field labels of a data element that is used in the table definition. b Shortening the length of a domain used in a data element that is used in the table definition. c Renaming a field in a structure that is included in the table definition d Deleting a field from a structure that is included in the table definition. 60 Class super has subclass sub. Which rules are valid forthe sub constructor? Note: There are 2 correct answers to this question. Choose one or more answers a Import parameters can only be evaluated after calling the constructor ofsuper. b The constructor ofsupermust be called before using any components of your own instance. c Themethod signature can be changed. d Events of your own instance cannot be raised before the registration of a handler in super. 61 Which of the following string functions are predicate functions? Note: There are 2 correct answers to this question. Choose one or more answers a find_any_not_of() b contains_any_of() c matches() d count_any_of() 62 In RESTful Application Programming, a business object contains which parts? Note: There are 2 correct answers to this question. Choose one or more answers a Process definition b CDS view c Behavior definition d Authentication rules 63 Given the following code excerptthat 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 fields : abep-quan(2); 7 field4: abap.unit(2); 8 } Which field is defined incorrectly? a field 2 b field 3 c field 1 d field 4 64 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? A. Class constructor of super1. B. Instance constructor of sub1. C. Instance constructor of super1 D. Class constructor of sub1. a B C A D b A B C D c A D B C d A C D B 65 What are some properties of database tables? Note: There are 2 correct answersto this question. Choose one or more answers a They can have any number of key fields. b They store information in two dimensions. c They store information in two dimensions. d They can have relationships to other tables. 66 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 AND b~f1 = a~fl WHERE... in which way is the join evaluated? a From the left to the right in the order of the tables: 1. a is joined with b 2. b is joined with c b 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 c 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 d From the right to the left in the order of the tables: 1. b is joined with c. 2. b is joined with a. 67 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_ods_assoc_spfi data source referenced in line #4 contains a field "connid" which you would like to expose in the element list. what will be in line #08? a demo_ods_assoc_spfli.connid b spfli-connid c _spfli.connid d demo_ods_assoc_spfli-connid 68 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. a RAP BOBehavior Extension b SAP HANA database table extension c Business Service Extension d RAP BONode Extension 69 Given the following ABAP SQL statement excerptfrom an ABAP program: 1 SELECT SINGLE 2 FROM spfli 3 WHERE carrid = "LH' AND connid= "0400" 4 INTO @DATA(wa). 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. Note: There are 2 correct answers to this question. a "Load Unit to "Column Loadable" b . "Load Unit' to 'Page Loadable" c . "Storage Type" to "Row Store" d "Storage Type" to "Column Store" 70 What are some characteristics ofsecondary keysforinternal tables? Note: There are 3 correct answers to this question. Choose one or more answers a Multiple secondary keys are allowed for any kind of internal table. b Secondary keys can only be created forstandard tables. c Secondary keys must be chosen explicitly when you actually read from an internal table. d Hashed secondary keys do NOT have to be unique. e Sorted secondary keys do NOT have to be unique. 71 1 @AccessControl.authorizationCheck: #NOT_REQUIRED 2 DEFINE 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 fidate >- $parameters.p_date; Which of the following ABAP SQL snippets are syntactically correct ways to provide a value forthe parameter on line #4? Note: There are 2 correct answers to this question Choose one or more answers a …SELECT FROM demo_cds_param_view entity (p_date: $session.system_date)... b …SELECT * FROM demo_cds_param_view_entity (p_date: 20238181’)… c …SELECT * FROM deno_cds_param_view_entity (p_date = @ (cl_abap_context_info- >get_system_date ())... d …SELECT * FROM deno_cds_param_view_entity (p_date - '20230101')… 72 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 conditionsmust you insert in place of "???"? a ON Z_Source1.camer_id=7_Source2 carrier_id b ON Sprojection. Carrier Source2.carrier c ON $projection.carrier_id = _source2.carrier_id d ON Sprojection Camer=Source2 carrier_id 73 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. Choose one or more answers a Fields with the same name and the same type will be copied from itab2 to itab 1. b itab1 and itab2must have at least one field name in common. c itab1 and itab2 must have the same data type. d Fields with the same name but with different types may be copied from itab2 to itab1. 74 What would be the correct expression to change a given string value 'mr joe doe' into 'JOE' in an ABAP SQL field list? a SELECT FROM TABLE dbtab1 FIELDS f1, substring(upper('mr joe doe'), 4, 3) AS f2_sub_up, f3,... b SELECT FROM TABLE dbtab1 FIELDS f1, upper(left( 'mrjoe doe', 6)) AS f2_up_left, f3, c SELECT FROM TABLE dbtab1 FIELDS f1, substring(lower(upper( 'mrjoe doe' ) ), 4, 3) AS f2_sub_lo_up, f3, d SELECT FROM TABLE dbtab1 FIELDS f1, left(lower(substring( 'mr joe doe', 4, 3)), 3) AS f2_left_lo_sub, f3, 75 For the assignment, gv_target = gv_source. which of the following data declarations will always work withouttruncation orrounding? Note: There are 2 correct answers to this question. a DATA gv_source TYPE p LENGTH 8 DECIMALS 3. to DATA gv_target TYPE p LENGTH 16 DECIMALS 2. b DATA gv_source TYPE d. to DATA gv_target TYPE string. c DATA gv_source TYPE c. to DATA gv_target TYPE string. d DATA gv_source TYPE string. to DATA gv_target TYPE c. 76 Given the following Core Data Service View Entity Data Definition, Union between two select. when you attempt to activate the definition, what will be the response? a Activation error because the field names ofthe union do not match b Activation successful c Activation error because the field types of the union do not match d Activation error because the key fields ofthe union do not match 77 Which of the following is a generic internal table type? a SORTED TABLE b HASHED TABLE c INDEX TABLE d STANDARD TABLE 78 /DMO/I_Connection is a CDS view. What variable type is connection full based on the following code? DATA connection full TYPE /DMD/I_Connection. a Simple variable b Internal table c structure d 79 In the following ABAP SQL code, what are valid case distinctions? Note: There are 2 correct answers to this question. Choose one or more answers a SELECT FROM dbtab1 FIELDS F1, CASE WHEN F2 = '1' THEN 'Value 1 WHEN f2'2' THEN 'Value 2' ELSE "Value for the rest' END AS f case INTO TABLE @et t1. b SELECT FROM dbtab1 FIELDS F1, CASE WHEN F2 = '1' THEN "Value 1' WHEN f2 < f3 AND f2 = ‘2’ THEN "Value 2' WHEN OTHERS 'Value forthe rest' ENDCASE AS f_case INTO TABLE @gt t1. c SELECT FROM dbtab1 FIELDS f1, CASE f2 WHEN‘1’ THEN 'Value 1' WHEN '2' THEN 'Value 2' ELSE "Value for the rest' END AS f_case INTO TABLE @gt_t1. d 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 @gt t1.

1

Which function call returns 0?

a

Count_any_of ( val - ‘ABAP ABAP abap'sub "AB" )

b

Count (val - 'ABAP ABAP abap'sub - 'AB' )

c

find_any_of (val = "ABAP ABAP abap'sub = "AB")

d

find_any_not_of( val 'ABAP ABAP abap’sub = 'AB')

2

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

Choose one or more answers

a

SAP S/4HANA Cloud, private edition

b

SAP BTP, ABAP environment

c

SAP S/4HANA on premise

d

SAP S/4HANA Cloud, public edition

3

Which RESTful Application Programming object can be used to organize the display of fields in an app?

a

Data model view

b

Metadata extension

c

Service definition

d

Projection view

4

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 Icl_super being superclass of Icl_sub When accessing the subclassinstance through go_super, what can you do? Note: There are 2 correct answers to this question.

Choose one or more answers

a

Access the inherited private components.

b

Access the inherited public components.

c

Call a subclass specific public method D.

d

Call inherited public redefined methods.

5

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 zel_demo_class Implementation. 5 METHOD m1. 6 CALL FUNCTION 'ZF1'. 7 ENDMETHOD 8 ENDCLASS.

Choose one or more answers

a

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

b

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

c

"ZF1" can be called whether it is released or notfor cloud development

d

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

6

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

Choose one or more answers

a

It is no longer possible to pass your own value to the parameter.

b

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

c

The value of sy-langu will be passed to the CDS view automatically when you use the CDS view in ABAP but not when you use itin another view entity

d

The value ofsy-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).

7

In the assignment. data (gv_result) = 1 / 8. what will be the data type of gv_result?

a

TYPE I

b

c

TYPE DEFLOAT 16

d

TYPE P DECIMALS 3

8

Given the code INTERFACE if1. METHODS: m1. ENDINTERFACE. CLASS cl1 DEFINITION. ..... INTERFACES if2. ENDCLASS CLASS cl2 DEFINITION ..... DATA mo_lf1 TYPE REF TO if1. ...... ENDCLASS. What are valid statements? Note: There are 3 correct answersto this question

Choose one or more answers

a

In class CL2, the interface method is named if1-m1.

b

Class CL2 uses the interface.

c

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

d

Class CL1 uses the interface.

e

Class CL1 implements the interface.

9

Given this code, DATA: go super TYPE REF TO 1c1 super, go_sub1 TYPE REF TO Icl_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(...).

Choose one or more answers

a

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

b

go sub2->sub2meth 1(...). will work

c

go sub1 = CAST # go super), will not work

d

go_sub2 = CAST # go super), will work.

e

go_sub1 CAST #go_super), will work

f

go_sub2 = CAST #(go_super). will not work

10

Setting a field to read-only in which object would make the field read-only in all applications of the RESTful Application Programming model?

a

Service definition

b

Metadata extension

c

Behaviour definition

d

Projection view

11

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

Choose one or more answers

a

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

b

It is created when a table is filled.

c

It is updated when the table is modified.

d

It is updated when the modified table is read again

12

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

Choose one or more answers

a

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

b

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

c

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

d

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

e

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

13

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

Choose one or more answers

a

A built-in ABAP Dictionary type

b

A data element

c

A built-in ABAP type

d

A component of an ABAP Dictionary structure

14

Match the sequence of execution in the dropdown list to the operation. (1 is the highest priority and 3 is the lowest priority.) 1) Addition (+) and Subtraction (-) 2) Numeric functions. 3) Multiplication (*) and Division (/)Choose an item.

a

1 2 3

b

2 3 1

c

3 1 2

d

3 2 1

15

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.

Choose one or more answers

a

You add the clause REDEFINITION to the component in sub1.

b

You implement the redefined component in sub1.

c

You implement the redefined component for a second time in super1.

d

You add the clause REDEFINITION to the component in super1.

16

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

Choose one or more answers

a

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

b

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

c

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

d

If the user is authorized for'CNTRY = 'DE' then the return code is always 0.

17

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

Choose one or more answers

a

Sort a sorted table using - SORT itab DESCENDING.

b

Sort a sorted table using - SORT itab BY field1 ASCENDING field2 DESCENDING.

c

Sort a standard table using - SORT itab ASCENDING.

d

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

e

Sort a standard table using - SORT itab.

18

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

a

Append table

b

Insert table

c

Update table

d

Modify table

19

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

Choose one or more answers

a

Where (to specify the access conditions)

b

Return code (to assign the retum code of the authority check)

c

Define role (to specify the role name)

d

Revoke (to remove access to the data source)

e

Crant (to identify the data source)

20

You are designing the following selectstatement 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 fidate > @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?

a

#15

b

#6

c

#8

d

#4

21

Given the code, DATA: go super TYPE REF TO 1c1_super, go_sub1 TYPE REF TO Lel_sub1. ... go_sub1 = CAST #(go_super ). go_sub1->sub1_meth1(...). with which predicate condition can you ensure that the CAST will work?

a

IS BOUND

b

IS INSTANCE OF

c

IS NOT INITIAL

d

IS SUPPLIED

22

What is the sequence priority when evaluating a logical expression? A. NOT 1 B. OR 3 C. AND 2

a

1 2 3

b

3 2 1

c

2 3 1

d

1 3 2

23

Which of the following are parts of the definition of a new database table? Note: There are 2 correct answers to this question.

Choose one or more answers

a

Field list

b

Extension

c

Semantic table attributes

d

Partitioning attribues

24

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.

Choose one or more answers

a

Data model view

b

Service definition

c

Behavior definition

d

Projection view

e

Metadata extension

25

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

Choose one or more answers

a

P

b

string

c

C

d

T

26

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

Choose one or more answers

a

OData services

b

Business events

c

SOAP consumption

d

Business Add-ins(BAdls)

e

CDS Views

27

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

Choose one or more answers

a

Instead of go_cl1 = NEW #() you could use go_iff - NEW #(...).

b

go_if1may call method m2 with go if->m2(...).

c

Instead of go cl1 = NEW #(...) you could use go if1 = NEW cl1( ... ).

d

go_if1may call method m1 with go_ift->m1().

e

go_cl1may call method m1 with go_d1->if1-m1().

28

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

Choose one or more answers

a

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

b

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

c

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

d

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

29

Same Question

a

b

c

d

30

In ABAP SQL, which ofthe following retrieves the association field_Airline-Name of a CDS view?

a

\_Airline-Name

b

“_Airline Name

c

/_Airline Name

d

. @_Airline-Name

31

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

a

Hashed

b

Standard

c

Sorted

32

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

Choose one or more answers

a

field (from field list)

b

order criterion (from order by clause)

c

group criterion (from group by clause)

d

database table

33

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

Choose one or more answers

a

DATA: gv_target TYPE d. CONSTANTS: gco_date TYPE d VALUE '20331233'. gv_target EXACT # ( geo_date).

b

DATA: gv_target TYPE c LENGTH 5. CONSTANTS: ECOstring TYPE string VALUE 0123456789ABCDEF". gv_target - EXACT #(gco_string+5 (6) ).

c

DATA: Ev target TYPE p DECIMALS 3. CONSTANTS: gco_int1 TYPE i VALUE 2. Ev_target - EXACT #(2 / gco_int1 ).

d

DATA: gv_target TYPE string. CONSTANTS: gco_string TYPE LENGTH 16 VALUE 0123456789ABCDEF*. gv_target = EXACT # (gco_string+5 (5) ).

e

DATA: gv_target TYPE p DECIMALS 2. CONSTANTS: go int1 TYPE i VALUE 3. gv_target - EXACT # (2 gco_int1).

34

Which of the following are features of Core Data Services? Note: There are 3 correct answersto this question.

Choose one or more answers

a

Associations

b

Inheritance

c

Annotations

d

Structured Query Language (SQL)

e

Delegation

35

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

Choose one or more answers

a

The system field sy-subrc isset, giving you the result of the authorization check

b

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

c

All of the data from the data sources isloaded into your application automatically and filtered there according to the user's authorization.

d

Only the data corresponding to the user's authorization istransferred from the database to the application layer.

36

Which ABAP SQL clause allowsthe use of inline declarations?

a

INTOCORRESPONDING FIELDS OF

b

FROM

c

FIELDS

d

INTO

37

What RESTful Application Programming object contains only the fields required for a particular app?

a

Database view

b

Metadata extension

c

Projection view

d

Data model view

38

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

a

A projection view

b

A data model view

c

A metadata extension

d

A service definition

39

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

Choose one or more answers

a

The name of a type defined privately in another class

b

The name of a domain from the ABAP Dictionary

c

The name of a type defined privately in class ZCL_CLASS_A

d

The name of a data element from the ABAP Dictionary

40

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

a

Key user

b

Developer

c

Side-by-side

d

Classic

41

In RESTful Application Programming, which EML statement retrieves an object?

a

Read entity

b

Get entity

c

Find entity

d

Select entity

42

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

Choose one or more answers

a

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

b

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

c

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

d

The field symbol can be reused for other programs.

43

What isthe purpose of a foreign key relationship between two tables in the ABAP Dictionary?

a

To create a corresponding foreign key relationship in the database

b

To ensure the integrity of data in the corresponding database tables

c

To document the relationship between the two tables

44

When processing an internal table with the statement LOOP AT itab... ENDLOOP, whatsystem variable contains the current row number?

a

sy-subrc

b

sy-linno

c

sy-index

d

sy-tabix

45

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

a

A D B C

b

A B C D

c

B A D C

d

C A B D

46

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.

Choose one or more answers

a

They compute results on the application server.

b

They transfer computational resultsto the application server.

c

They avoid data transfer completely.

d

They implement code pushdown.

47

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

a

Validation

b

Determination

c

Action

48

< some coding > IF . RAISE EXCEPTION TYPE zcx1 EXPORTING param1 = valuel param2 = value2 previous = value3. ENDIF. What are valid statements? Note: There are 2 correct answers to this question.

Choose one or more answers

a

"zcx1" is a dictionary structure, and "param1" and "param2" are same-named components of this structure.

b

"previous" expectsthe reference to a previous exception

c

The code creates an exception object and raises an exception.

d

"param1" and "param2" are predefined names.

49

target_itab= VALUE # ( FOR row IN source_itab( field1 = row-field1 field2=row-field2 fieldn=row-field)).

Choose one or more answers

a

FOR defines a loop that runs over the content of source_itab

b

row is a predefined name and cannot be chosen arbitrarily.

c

source_itab is only visible within the loop.

d

row is only visible within the loop.

50

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

Choose one or more answers

a

Applications thatrun separate from SAP S/4HANA

b

Applicationsthat provide APIsforside by side SAP BTP apps

c

Applicationsthat access SAP S/4HANA data using complex SQL

d

Applicationsthatintegrate data from several differentsystems

51

You want to provide a short description of the data definition for developers that will be attached to the database view Which ofthe following annotations would do this if you inserted it on line #2

a

@EndUser Textlabel

b

@UI.badge.title.label

c

@EndUserText.quickInfo

d

@UI headerinto description labe

52

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 answersto this question.

Choose one or more answers

a

The pragma is not checked by the syntax checker.

b

##NEEDED is checked by the syntax checker.

c

#EC_NEEDED is not checked by the syntax checker.

d

The pseudo-comment is checked by the syntax checker

53

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 classzcl_demo_classisin a software component with the language version set to "ABAP Cloud". The function module ZF1' is in the same software component. Both the class and function module are customer created. Regarding line #6, which of the following is a valid statement?

a

'ZF1' must be released for cloud development to be called.

b

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

c

'ZF1' can be called whether it has been released or not for cloud development.

d

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

54

Given the following Core Data Services View Entity DataDefinition, 1 @AccessControl.authorizationCheck: #NOT REQUIRED 2 DEFINE VIEW ENTITY demo_rds_data_source_matrix 3 AS SELECT FROM 4 5 { 6 key field_1, 7 field_2, 8 field_c 9 } Which of the following types are permitted to be used for on line #4? Note: There are 2 correct answersto this question.

Choose one or more answers

a

An external view from the ABAP Dictionary

b

A database view from the ABAP Dictionary

c

A CDS DDIC-based view

d

A database table from the ABAP Dictionary

55

Which restrictions exist for ABAP SQL arithmetic expressions? Note: There are 2 correct answersto this question.

Choose one or more answers

a

The operator is allowed only in floating point expressions

b

The operator / is allowed only in floating point expressions.

c

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

d

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

56

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

Choose one or more answers

a

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

b

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

c

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

d

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

57

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.

Choose one or more answers

a

Code that can be redesigned as a key user extension

b

Code that supports a critical business process

c

Code that now isidentical to a standard SAP object

d

Code that hasless than 10% usage according to usage statistics

58

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

a

sy-linno

b

sy-subrc

c

sy-labix

d

sy-index

59

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.

Choose one or more answers

a

Changing the field labels of a data element that is used in the table definition.

b

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

c

Renaming a field in a structure that is included in the table definition

d

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

60

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

Choose one or more answers

a

Import parameters can only be evaluated after calling the constructor ofsuper.

b

The constructor ofsupermust be called before using any components of your own instance.

c

Themethod signature can be changed.

d

Events of your own instance cannot be raised before the registration of a handler in super.

61

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

Choose one or more answers

a

find_any_not_of()

b

contains_any_of()

c

matches()

d

count_any_of()

62

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

Choose one or more answers

a

Process definition

b

CDS view

c

Behavior definition

d

Authentication rules

63

Given the following code excerptthat 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 fields : abep-quan(2); 7 field4: abap.unit(2); 8 } Which field is defined incorrectly?

a

field 2

b

field 3

c

field 1

d

field 4

64

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? A. Class constructor of super1. B. Instance constructor of sub1. C. Instance constructor of super1 D. Class constructor of sub1.

a

B C A D

b

A B C D

c

A D B C

d

A C D B

65

What are some properties of database tables? Note: There are 2 correct answersto this question.

Choose one or more answers

a

They can have any number of key fields.

b

They store information in two dimensions.

c

They store information in two dimensions.

d

They can have relationships to other tables.

66

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 AND b~f1 = a~fl WHERE... in which way is the join evaluated?

a

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

b

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

c

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

d

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

67

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_ods_assoc_spfi data source referenced in line #4 contains a field "connid" which you would like to expose in the element list. what will be in line #08?

a

demo_ods_assoc_spfli.connid

b

spfli-connid

c

_spfli.connid

d

demo_ods_assoc_spfli-connid

68

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.

a

RAP BOBehavior Extension

b

SAP HANA database table extension

c

Business Service Extension

d

RAP BONode Extension

69

Given the following ABAP SQL statement excerptfrom an ABAP program: 1 SELECT SINGLE 2 FROM spfli 3 WHERE carrid = "LH' AND connid= "0400" 4 INTO @DATA(wa). 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. Note: There are 2 correct answers to this question.

a

"Load Unit to "Column Loadable"

b

. "Load Unit' to 'Page Loadable"

c

. "Storage Type" to "Row Store"

d

"Storage Type" to "Column Store"

70

What are some characteristics ofsecondary keysforinternal tables? Note: There are 3 correct answers to this question.

Choose one or more answers

a

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

b

Secondary keys can only be created forstandard tables.

c

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

d

Hashed secondary keys do NOT have to be unique.

e

Sorted secondary keys do NOT have to be unique.

71

1 @AccessControl.authorizationCheck: #NOT_REQUIRED 2 DEFINE 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 fidate >- $parameters.p_date; Which of the following ABAP SQL snippets are syntactically correct ways to provide a value forthe parameter on line #4? Note: There are 2 correct answers to this question

Choose one or more answers

a

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

b

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

c

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

d

…SELECT * FROM deno_cds_param_view_entity (p_date - '20230101')…

72

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 conditionsmust you insert in place of "???"?

a

ON Z_Source1.camer_id=7_Source2 carrier_id

b

ON Sprojection. Carrier Source2.carrier

c

ON $projection.carrier_id = _source2.carrier_id

d

ON Sprojection Camer=Source2 carrier_id

73

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.

Choose one or more answers

a

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

b

itab1 and itab2must have at least one field name in common.

c

itab1 and itab2 must have the same data type.

d

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

74

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

a

SELECT FROM TABLE dbtab1 FIELDS f1, substring(upper('mr joe doe'), 4, 3) AS f2_sub_up, f3,...

b

SELECT FROM TABLE dbtab1 FIELDS f1, upper(left( 'mrjoe doe', 6)) AS f2_up_left, f3,

c

SELECT FROM TABLE dbtab1 FIELDS f1, substring(lower(upper( 'mrjoe doe' ) ), 4, 3) AS f2_sub_lo_up, f3,

d

SELECT FROM TABLE dbtab1 FIELDS f1, left(lower(substring( 'mr joe doe', 4, 3)), 3) AS f2_left_lo_sub, f3,

75

For the assignment, gv_target = gv_source. which of the following data declarations will always work withouttruncation orrounding? Note: There are 2 correct answers to this question.

a

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

b

DATA gv_source TYPE d. to DATA gv_target TYPE string.

c

DATA gv_source TYPE c. to DATA gv_target TYPE string.

d

DATA gv_source TYPE string. to DATA gv_target TYPE c.

76

Given the following Core Data Service View Entity Data Definition, Union between two select. when you attempt to activate the definition, what will be the response?

a

Activation error because the field names ofthe union do not match

b

Activation successful

c

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

d

Activation error because the key fields ofthe union do not match

77

Which of the following is a generic internal table type?

a

SORTED TABLE

b

HASHED TABLE

c

INDEX TABLE

d

STANDARD TABLE

78

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

a

Simple variable

b

Internal table

c

structure

d

79

In the following ABAP SQL code, what are valid case distinctions? Note: There are 2 correct answers to this question.

Choose one or more answers

a

SELECT FROM dbtab1 FIELDS F1, CASE WHEN F2 = '1' THEN 'Value 1 WHEN f2'2' THEN 'Value 2' ELSE "Value for the rest' END AS f case INTO TABLE @et t1.

b

SELECT FROM dbtab1 FIELDS F1, CASE WHEN F2 = '1' THEN "Value 1' WHEN f2 < f3 AND f2 = ‘2’ THEN "Value 2' WHEN OTHERS 'Value forthe rest' ENDCASE AS f_case INTO TABLE @gt t1.

c

SELECT FROM dbtab1 FIELDS f1, CASE f2 WHEN‘1’ THEN 'Value 1' WHEN '2' THEN 'Value 2' ELSE "Value for the rest' END AS f_case INTO TABLE @gt_t1.

d

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 @gt t1.

C_ABAPD_2309 Quiz

Quiz

Download the paper version to play

Created by

Top 10 results

Top Games

Quiz

Tissues - Practice Quiz

Quiz

Photosynthesis vs Cellular Respiration - Practice Quiz

Quiz

Practice Quiz - Punnett Square, Variation, and Mutations

Quiz

Spanish Alphabet Listening

Quiz

UPS 5 Seeing Habits Quiz