C_ABAPD_2309_FINAL 85%.pdf

ABAP Core Data Services (CDS) and data modelling Question. 1 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. A data element B. A built-in ABAP Dictionary type C. A component of an ABAP dictionary structure D. A built-in ABAP type Answers A B Question. 2 A. EndUserText.quickinfo B. Ul.badge.title.label C. EndUserText.label D. Ul.headerInfo.description.label Answers C Question. 3 Which extensibility type does SAP recommend you enhance the existing Ul for an SAP Fiori app? A. Classic B. Developer C. Side-by-side D. Key user Answers B Question. 4 Which of the following integration frameworks have been released for ABAP cloud development? Note:There are 3 correct answers to this question. A. SOAP consumption B. Business Add-ins (BAdIs) C. Business events D. CDS Views E. OData services Answers A C E Each of these processes requires connectivity across several different SAP products and solutions, including SAP S/4HANA Cloud. As a result, connectivity options continue to be necessary and are provided as part of the ABAP Cloud development model. Deprecated integration technologies can no longer be used in the ABAP Cloud development model (for example, IDoc) – only released frameworks are available. The following connectivity frameworks are available:  OData services  Business Events  HTTP services  RFC via cloud enabled WebSocket RFC  SOAP consumption (SOAP service provider planned)  SQL service for external ODBC Clients  SAP information access (InA) for analytical clients Question. 5 What RESTful Application Programming feature is used to ensure the uniqueness of a semantic key? A. Action B. Determination C. Validation Answers C Question. 6 Which of the following are incomplete ABAP types? Note: There are 2 correct answers to this question. A. C B. P C. String D. T Answers A B Question. 7 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. A. Renaming a field in a structure that is included in the table definition. B. Shortening the length of a domain used in a data element that is used in the table definition. C. Changing the field labels of a data element that is used in the table definition. D. Deleting a field from a structure that is included in the table definition. Answers A D Question. 8 “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? A. spfli-connid, B. demo_cds_assoc_spfli-connid, C. demo_cds_assoc_spfli.connid, D. _spfli.connid, Answers D Question. 9 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 cxf1l = befl AND c~f2 = bef2 | ON befl = a-fl | WHERE... in which way is the join evaluated? 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. B. 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. C. From the left to the right in the order of the tables: 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. Answers A Question. 10 Given the following code,what are valid statements? Note: There are 2 correct answers to this question. A. #EC_NEEDED is not checked by the syntax checker. B. ##NEEDED is checked by the syntax checker. C. The pragma is not checked by the syntax checker. D. The pseudo-comment is checked by the syntax checker. Answers A B Question. 11 Image A. ‘ZF1’ can be called via a wrapper that itself has not been released for cloud development. B. ‘ZF’1 can be called whether it has been released or not for cloud development. C. ‘ZF1' must be released for cloud development to be called. D. ‘ZF1' can be called via a wrapper that itself has been released for cloud development. Answers All objects created in a software component of the type ABAP Cloud must follow the ABAP cloud development model. By contrast, objects in software components of the type ABAP classic can be of any type. Objects in ABAP cloud software components have unrestricted access to any and all objects in the same software component. However, to access objects in ABAP classic software components, those objects must be specifically released. As always, public released local SAP APIs are accessible. Objects in ABAP classic software components have unrestricted access to ABAP cloud-based development objects. Similar to ABAP cloud, they also have access to any and all objects in the same software component. However, they are allowed to use all SAP APIs, whether released or not. Question. 12 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. A. itab1 and itab2 must have at least one field name B. Fields with the same name but with different types may be copied from itab2 to itab1. C. jtab1 and itab2 must have the same data type. D. Fields with the same name and the same type will be copied from itab2 to itab1. Answers A D Question. 13 A. DATA gv_source TYPE string.to DATA gv_target TYPE c. B. DATA gv_source TYPE d.to DATA gv_target TYPE string. C. DATA gv_source TYPE p LENGTH 8 DECIMALS 3.to DATA gv_target TYPE p LENGTH 16 DECIMALS 2. D. DATA gv_source TYPE c.to DATA gv_target TYPE string. Answers BD Question. 14 Which patterns raise an exception? Note: There are 3 correct answers to this question. A. DATA: gv_target TYPE c LENGTH 5. CONSTANTS: gco_string TYPE string VALUE '0123456789ABCDEF'. gv_target = EXACT #( gco_string+5(6) ). B. DATA: gv_target TYPE p DECIMALS 2. CONSTANTS: gco_intl TYPE i VALUE 3. gv_target = EXACT #( 2 / gco_intl ). C. DATA: gv_target TYPE d. CONSTANTS: gco_date TYPE d VALUE ‘20331233'. gv_target = EXACT #( gco_date ). D. DATA: gv_target TYPE p DECIMALS 3. CONSTANTS: gco_intl TYPE i VALUE 2. gv_target = EXACT #( 2 / gco_intl ). E. DATA: gv_target TYPE string. CONSTANTS: gco_string TYPE c LENGTH 16 VALUE '@123456789ABCDEF". gv_target = EXACT #( gco_string+5(5) ). Answers C D E Question. 15 Which function call returns 0? A. count_any_of( val = ‘'ABAP ABAP abap' sub = ‘AB’ ) B. find_any_not_of( val = 'ABAP ABAP abap" sub = ‘AB' ) C. count( val = "ABAP ABAP abap" sub = ‘AB’ ) D. find_any_of( val = 'ABAP ABAP abap" sub = ‘AB' ) Answers D Question. 16 Which of the following results in faster access to internal tables? Note: There are 3 correct answers to this question. A. In a sorted internal table, specifying the primary key completely. B. In a hashed internal table, specifying the primary key partially from the left without gaps. C. In a standard internal table, specifying the primary key partially from the left without gaps. D. In a sorted internal table, specifying the primary key partially from the left without gaps. E. In a hashed internal table, specifying the primary key completely. Answers A D E Question. 17 When does SAP recommend to use a sorted or a hashed table respectively? Note: There are 2 correct answers to this question. A. A hashed table, when you read a subset in a loop and specify a part of the key from the left without gaps. B. A hashed table, when you read a single record and specify the complete key. C. sorted table, when you read a single record and specify non-key fields. D. A sorted table, when you read a subset in a loop and specify a part of the key from the left without gaps. Answers B D Question. 18 Which restrictions exist for ABAP SQL arithmetic expressions? Note: There are 2 correct answers to this question. A. Floating point types and integer types can NOT be used in the same expression. 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. The operator / is allowed only in floating point expressions. Answers A D Question. 19 Class super has subclass sub.Which rules are valid for the sub constructor? Note: There are 2 correct answers to this question. A. The method signature can be changed. B. Events of your own instance cannot be raised before the registration of a handler in super. C. Import parameters can only be evaluated after calling the constructor of super. D. The constructor of super must be called before using any components of your own instance. Answers B D Question. 20 What are advantages of using a field symbol for internal table row access? Note: There are 2 correct answers to this question. A. AMODIFY statement to write changed contents back to the table is not required. B. The field symbol can be reused for other programs. C. The row content is copied to the field symbol instead to a work area. D. Using a field symbol is faster than using a work area. Answers A D Question. 21 In an Access Control Object, which clauses are used?Note: There are 3 correct answers to this question. A. Grant (to identify the data source) B. Define role (to specify the role name) C. Revoke (to remove access to the data source) D. Return code (to assign the return code of the authority check) E. Where (to specify the access conditions) Answers A B E Question. 22 In RESTful Application Programming, a business object contains which parts?Note: There are 2 correct answers to this question. A. Authentication rules B. Behavior definition C. CDS view D. Process definition Answers Question. 23 Image Answers ACE Question. 24 Image A. Image A B. Image B C. Image C Answers Question. 25 Which of the following are parts of the definition of a new database table?Note: There are 2 correct answers to this question. A. Partitioning attribues B. Extension C. Semantic table attributes D. Field list Answers C D Question. 26 A. #8 B. #6 C. #15 D. #4 Answers Question. 27 Image A. ZF1' must be released for cloud development to be called. B. ‘ZF 1’ can be called whether it has been released or not for cloud development. C. ‘ZF 1’ can be called via a wrapper that itself has not been released for cloud development. D. ‘ZF1’ can be called via a wrapper that itself has been released for cloud development. Answers All objects created in a software component of the type ABAP Cloud must follow the ABAP cloud development model. By contrast, objects in software components of the type ABAP classic can be of any type. Objects in ABAP cloud software components have unrestricted access to any and all objects in the same software component. However, to access objects in ABAP classic software components, those objects must be specifically released. As always, public released local SAP APIs are accessible. Objects in ABAP classic software components have unrestricted access to ABAP cloud-based development objects. Similar to ABAP cloud, they also have access to any and all objects in the same software component. However, they are allowed to use all SAP APIs, whether released or not. Question. 28 What is the sequence priority when evaluating a logical expression? A. OR B. NOT C. AND D. NOT/AND/OR Answers D Arithmetic and bitwise operators are handled before logical operators. When more than one logical operator is used in a statement, not is evaluated first, then and, and finally or. Question. 29 For what kind of applications would you consider using on-stack developer extensions? Note: There are 2 correct answers to this question. A. Applications that provide APIs for side-by-side SAP BTP apps B. Applications that integrate data from several different systems C. Applications that access SAP S/4HANA data using complex SQL D. Applications that run separate from SAP S/4HANA Answers A C Question. 30 What is the purpose of a foreign key relationship between two tables in the ABAP Dictionary? A. To document the relationship between the two tables B. To ensure the integrity of data in the corresponding database tables C. To create a corresponding foreign key relationship in the database Answers B Question. 31 Which ABAP SQL clause allows the use of inline declarations? A. INTO CORRESPONDING FIELDS OF B. INTO C. FROM D. FIELDS Answers B Question. 32 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. A. Behavior definition B. Projection view C. Data model view D. Service definition E. Metadata extension Answers B C E Question. 33 Which type of legacy code does SAP recommend you eliminate when you review modifications as part of an SAP S/4HANA system A. conversion?Note: There are 2 correct answers to this question. B. Code that can be redesigned as a key user extension C. Code that supports a critical business process D. Code that has less than 10% usage according to usage statistics E. Code that now is identical to a standard SAP object Answers B E Question. 34 Which of the following ABAP SQL statements are valid? Note: There are 2 correct answers to this question. A. Image 1 B. Image 2 C. Image 3 D. Image 4 Answers BC Question. 35 You have a superclass super’ 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. Instance Constructor of sub1 B. Class Constructor of sub1 C. Class Constructor of super1 D. Instance Constructor of super1 E. Sequence is 3 2 4 1 Answers E Question. 36 What would be the correct expression to change a given string value ‘mr joe doe’into ‘JOE’ in an ABAP SQL field list? A. Image 1 B. Image 2 C. Image 3 D. Image 4 Answers A Question. 37 Given the ABAP SQL statement excerpt from an ABAP program: A. ‘Load unit’ to ‘Column Loadable’ B. ‘Storage type’ to ‘Column store’ C. ‘Storage type’ to ‘Row Store’ D. ‘Load unit’ to ‘Page Loadable’ Answers CD Question. 38 Which of the following are valid sort operations for internal tables? Note: There are 3 correct answers to this question A. Image 1 B. Image 2 C. Image 3 D. Image 4 E. Image 5 Answers Question. 39 A. It is no longer possible to pass your own value to the parameter. B. 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. C. 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). D. You can still override the default value with a value of your own. Answers CD Question. 40 A. Class CL1 implements the interface B. In class CL2, the interface method is named if1~m1 C. In class CL1, the interface method is named if1~m1. D. Class CL2 uses the interface. E. Class CL1 uses the interface. Answers Question. 41 In the assignment, data(gv_result)-1/8.what will be the datatype of gv_result? A. TYPE P DECIMALS 2 B. TYPE l C. TYPE P DECIMALS 3 D. TYPE DEFLOAT16 Answers Question. 42 After you created a database table in the RESTful Application Programming model, what do you create next? A. A data model view B. A projection views. C. A metadata extension D. A service definition Answers A Question. 43 A. Access the inherited private components. B. Call a subclass-specific public method C. Call inherited public redefined methods. D. Access the inherited public components. Answers Question. 44 In RESTful Application Programming, which EML statement retrieves an object? A. Read entity B. Find entity C. Select entity D. Get entity Answers A Question. 45 When processing an internal table with the statement LOOP AT itab... ENDLOOP, what system vanable contains the current row number? A. sy-subre B. sy-index C. sy-inno D. sy-tabix Answers D Question. 46 Why would you use Access Controls with CDS Views? Note: There are 2 correct answers to this question A. All of the data from the data sources Is loaded into your application automatically and filtered there according to the user's authorization. B. The system field sy-subre is set, giving you the result of the automation check C. You do not have to remember to implement AUTHORITY-CHECK statements D. Only the data corresponding to the user's automation is transferred from the database to the application layer. Answers A D Question. 47 Which of the following string functions are predicate functions? Note: There are 2 correct answers to this question. A. maches ( ) B. contains_any_of ( ) C. find_any_not_of ( ) D. count_any_of ( ) Answers A B Question. 48 A. A database table from the ABAP Dictionary B. A CDS DDIC-based view C. A database view from the ABAP Dictionary D. An external view from the ABAP Dictionary Answers AB Question. 49 A. Answer A B. Answer B C. Answer C D. Answer D Answers Question. 50 A.... SELECT mat FROM demo_sales_cds_matenal_ve... B.... SELECT mat FROM _Material… C. …SELECT mat FROM demo_sales_so_i… D....SELECT mat FROM demo_sales_cds_so_i_ve... Answers Question. 51 Which internal table type allows unique and non-unique keys? A. Hashed B. Standard C. Sorted Answers Question. 52 A. Structure B. Internal table C. Simple variable Answers Question. 53 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. Projection view C. Metadata extension D. Behavior definition Answers D Question. 54 A. IS SUPPLIED B. IS BOUND C. IS NOT INITIAL D. IS INSTANCE OF Answers Question. 55 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. A. The name of a type defined privately in another class B. The name of a data element from the ABAP Dictionary C. The name of a type defined privately in class ZCL_CLASS_A D. The name of a domain from the ABAP Dictionary Answers BD Question. 56 In ABAP SQL, which of the following retrieves the association field _Airline-Name of a CDS view? A. \_ Airnline-Name B. @_Airline-Name C. /_Anine-Name D. *_Airline-Name Answers B Question. 57 A. "param1” and "param2" are predefined names. B. “zcx1" is a dictionary structure, and “param1" and "param2” are same-named components of this structure C. The code creates an exception object and raises an exception D. “previous” expects the reference to a previous exception Answers CD Question. 58 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 Fion 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? A. SAP HANA database table extension B. RAP BO Behavior Extension C. RAP BO Node Extension D. Business Service Extension Answers C Question. 59 What are some properties of database tablets? Note there are 2 correct ans for this question. A. They store information in two dimensions B. They may have key fields C. They can have relationships to other tables D. They can have any number of key fields Answers B C Question. 60 When processing the loop with the statement DO….ENDDO,what system variable contains the implicit loop counter? A. sy-subrc B. sy-linno C. sy-tabix D. sy-index Answers C Question. 61 What are characteristics of secondary keys for internal tablets?Note there are 3 correct ans for this question. A. Multiple secondary keys are allowed for any kind of internal table B. Hashed secondary keys do NOT have to be unique C. Secondary keys can only be created for standard tables D. Secondary keys must be chosen explicitly when you actually read from an internal table. E. Sorted secondary keys do NOT have to be uniques Answers B D Question. 62 Which RESTful Apllication programming object can be used to organize the display of fields in an app? A. Metadata extension B. Data model view C. Service definition D. Projection view Answers A Question. 63 Which statement can you use to change the contents of a row of data in an internal table? A. Insert table B. Update table C. Modify table D. Append table Answers C Question. 64 Which of the following is a generic internal table type? A. HASHED TABLE B. INDEX TABLE C. SORTED TABLE D. STANDARD TABE Answers B Question. 65 A. Answer B. Answer C. Answer D. Answer Answers Question. 66 In which products must you use the ABAP Cloud Development Model?Note: There are 2 correct answers to this question A. SAP S/4HANA Cloud, private edition B. SAP BTP, ABAP environment C. SAP S/4HANA Cloud, public edition D. SAP S/4HANA on premise Answers B C Question. 67 In the following ABAP SQL code, what are valid case distinctions? Note: There are 2 correct answers to this question A. Image 1 B. Image 2 C. Image 3 E. Image 4 F. Answers Question. 68 A. If the user is NOT authorized for ‘CNTRY = ‘DE’ OR for 'ACTVT' = '03 then the program wall terminate. B. If the user to authorized for 'CNTRY’ = 'DE' then the return code is always 0 C. AUTHORITY-CHECK verifies whether a user is authorized for '/DMO/TRVL' with the listed field values. D. If the user is authorized for 'CNTRY' = 'DE’ AND for 'ACTVT' = '03 then the return code is 0 Answers Question. 69 What RESTful Application Programming object contains only the fields required for a particular app? A. Data model view B. Database view C. projection view D. Metadata extension Answers C Question. 70 A. ‘ZF1' can be called if a wrapper is created for it but the wrapper itself is not 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 not for cloud development. D. ZF1' can be called only if it is released for cloud development. Answers B D All objects created in a software component of the type ABAP Cloud must follow the ABAP cloud development model. By contrast, objects in software components of the type ABAP classic can be of any type. Objects in ABAP cloud software components have unrestricted access to any and all objects in the same software component. However, to access objects in ABAP classic software components, those objects must be specifically released. As always, public released local SAP APIs are accessible. Objects in ABAP classic software components have unrestricted access to ABAP cloud-based development objects. Similar to ABAP cloud, they also have access to any and all objects in the same software component. However, they are allowed to use all SAP APIs, whether released or not. Question. 71 A. ON Sprojection.carnier_id = Z_Source2.carrier_id B. ON $projection Carner = _Source2.carrier_id C. ON Sprojection.Carner = _ Source? carrier D. ON Z_Source1.camier_id = Z_Source2.carner_id Answers Question. 72 Which of the following are features of Core Data Services ? Note There are 3 correct answers to this question A. Delegation B. Annotations C. Inheritance D. Structured Query Language (SQL) E. Associations Answers Question. 73 A. field2 B. field4 C. field3 D. field1 Answers Question. 74 In a subclass sub1 you want to redefine a component of a superclass super. How do you achieve this? Note: There are 2 correct answers to this question A. You implement the redefined component in sub1 B. You implement the redefined component for a second time in super1. C. You add the clause REDEFINITION to the component in sub1. D. You add the clause REDEFINITION to the component in super1 Answers A C Question. 75 A. source_itab is only visible within the loop. B. FOR defines a loop that runs over the content of source_itab C. row is only visible within the loop D. row is a predefined name and cannot be chosen arbitrarily. Answers Question. 76 What are some features of a unique secondary key?Note: There are 2 correct answers to this question A. It is updated when the modified table is read again. B. It is created with the first read access of a table. C. It is created when a fable is filled D. It is updated when the table is modified. Answers Question. 77 In what order are objects created to generate a RESTful Application Programming application? A. Projection view B. Service binding C. Service definition D. Database table E. Data model view Answers D -> E -> A -> C-> B. Question. 78 In ABAP SQL, which of the following can be assigned an alias? Note: There are 2 correct answers to this question. A. order criterion (from order by clause) B. group criterion (from group by clause) C. database table D. field (from field list) Answers A D Question. 79 A. Activation error because the field names of the 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 field of the union do not match Answers Question. 80 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. A. They implement code pushdown. B. They transfer computational results to the application server. C. They compute results on the application server. D. They avoid data transfer completely. Answers A C

C_ABAPD_2309_FINAL 85%.pdf

Document Details

Tags

Related

Full Transcript

Upgrade to continue