SAP SAP Certifications C_ABAPD_2309 Questions & Answers

• Question 61:

  

  (Sorry, we do not have a more clear image. If we have a better resource for the image, we will update this one immediately.)

  Using ABAP SQL, which select statement selects the mat field on line #17?

  A. SELECT mat FROM Material...

  B. SELECT mat FROM demo_sales_cds_so_i_ve...

  C. SELECT mat FROM demo_sales_so_i...

  D. SELECT mat FROM demo sales cds material ve...

  Correct Answer: B

  Using ABAP SQL, the select statement that selects the mat field on line #17 is:

  SELECT mat FROM demo_sales_cds_so_i_ve...

  This statement selects the mat field from the CDS view demo_sales_cds_so_i_ve, which is defined on line #1. The CDS view demo_sales_cds_so_i_ve is a projection view that projects the fields of the CDS view demo_sales_cds_so_i, which

  is defined on line #2. The CDS view demo_sales_cds_so_i is a join view that joins the fields of the database table demo_sales_so_i, which is defined on line #3, and the CDS view demo_sales_cds_material_ve, which is defined on line #4.

  The CDS view demo_sales_cds_material_ve is a value help view that provides value help for the material field of the database table demo_sales_so_i. The mat field is an alias for the material field of the database table demo_sales_so_i,

  which is defined on line #91.

  The other options are not valid because:

  A. SELECT mat FROM Material... is not valid because Material is not a valid data source in the given code. There is no CDS view or database table named Material. C. SELECT mat FROM demo_sales_so_i... is not valid because demo_sales_so_i is not a valid data source in the given code. There is no CDS view named demo_sales_so_i, only a database table. To access a database table, the keyword TABLE must be used, such as SELECT mat FROM TABLE demo_sales_so_i... D. SELECT mat FROM demo sales cds material ve... is not valid because demo sales cds material ve is not a valid data source in the given code. There is no CDS view or database table named demo sales cds material ve. The correct name of the CDS view is demo_sales_cds_material_ve, with underscores instead of spaces. References: 1: Projection Views - ABAP Keyword Documentation

• Question 62:

  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 avoid data transfer completely.

  C. They transfer computational results to the application server.

  D. They compute results on the application server.

  Correct Answer: AC

  Core Data Services (CDS) are preferable to the classical approach to data modeling for several reasons, but two of them are: They implement code pushdown. Code pushdown is the principle of moving data- intensive logic from the application server to the database server, where the data resides. This reduces the data transfer between the application server and the database server, which improves the performance and scalability of the application. CDS enable code pushdown by allowing the definition of semantic data models and business logic in the database layer, using SQL and SQL-based expressions1. They transfer computational results to the application server. CDS allow the application server to access the data and the logic defined in the database layer by using Open SQL statements. Open SQL is a standardized and simplified subset of SQL that can be used across different database platforms. Open SQL statements are translated into native SQL statements by the ABAP runtime environment and executed on the database server. The results of the computation are then transferred to the application server, where they can be further processed or displayed2. References: 1: ABAP - Core Data Services (ABAP CDS) - ABAP Keyword Documentation 2: Open SQL - ABAP Keyword Documentation

• Question 63:

  What are valid statements? Note: There are 2 correct answers to this question.

  A. ##NEEDED is checked by the syntax checker.

  B. The pragma is not 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

  Correct Answer: AB

  Both statements are valid in ABAP, but they have different effects on the program. ##NEEDED is a pragma that can be used to hide warnings from the ABAP compiler syntax check. It tells the check tools that a variable or a parameter is needed for further processing, even if it is not used in the current statement. For example, if you declare a variable without assigning any value to it, you can use ##NEEDED to suppress the warning about unused variables12. The pragma is not checked by the syntax checker means that you can use any pragma to hide any warning from the ABAP compiler syntax check, regardless of its effect on the program logic or performance. For example, if you use ##SHADOW to hide a warning about an obscured function, you can also use it to hide a warning about an invalid character in a string12. You cannot do any of the following: #EC_NEEDED is not checked by the syntax checker: This is not a valid statement in ABAP. There is no pseudo-comment with #EC_NEEDED in ABAP3. The pseudo-comment is checked by the syntax checker: This is false. Pseudo-comments are obsolete and should no longer be used in ABAP. They were replaced by pragmas since SAP NW 7.0 EhP2 (Enhancement Package)4. References: 1: Pragmas - ABAP Keyword Documentation - SAP Online Help 2: [What are pragmas and pseudo comments in ABAP? | SAP Blogs - SAP Community] 3: ABAP Keyword Documentation - SAP Online Help 4: What are PRAGMAS and Pseudo comments in SAP ABAP

• Question 64:

  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. Import parameters can only be evaluated after calling the constructor of super.

  C. The constructor of super must be called before using any components of your own instance.

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

  Correct Answer: AC

  The sub constructor is the instance constructor of the subclass sub that inherits from the superclass super. The sub constructor has some rules that it must follow when it is defined and implemented12. Some of the valid rules are:

  The method signature can be changed: This is true. The sub constructor can have a different method signature than the super constructor, which means that it can have different input parameters, output parameters, or exceptions. However,

  the sub constructor must still call the super constructor with appropriate actual parameters that match its interface12.

  The constructor of super must be called before using any components of your own instance: This is true. The sub constructor must ensure that the super constructor is called explicitly using super->constructor before accessing any instance

  components of its own class, such as attributes or methods. This is because the super constructor initializes the inherited components of the subclass and sets the self-reference me-> to the current instance12.

  You cannot do any of the following:

  Import parameters can only be evaluated after calling the constructor of super:

  This is false. The sub constructor can evaluate its own import parameters before calling the constructor of super, as long as it does not access any instance components of its own class. For example, the sub constructor can use its import

  parameters to calculate some values or check some conditions that are needed for calling the super constructor12.

  Events of your own instance cannot be raised before the registration of a handler in super: This is false. The sub constructor can raise events of its own instance before calling the constructor of super, as long as it does not access any

  instance components of its own class. For example, the sub constructor can raise an event to notify the consumers of the subclass about some status or error that occurred during the initialization of the subclass12.

  References: 1: Inheritance and Constructors - ABAP Keyword Documentation - SAP Online Help 2: Using Static and Instance constructor methods | SAP Blogs

• Question 65:

  In a test method you call method cl_abap_unit_assert=>assert_equals( .. ) in the following way:

  CLASS Itcl1 DEFINITION FOR TESTING RISK LEVEL HARMLESS DURATION SHORT.

  PRIVATE SECTION.

  METHODS m1 FOR TESTING.

  ENDCLASS.

  CLASS Itcl1 IMPLEMENTATION.

  METHOD m1.

  DATA: go_test_object TYPE REF TO zcl_to_be_tested.

  CONSTANTS: Ico_exp TYPE string VALUE 'test2'.

  CREATE OBJECT go_test_object.

  cl_abap_unit_assert=>assert_equals(

  EXPORTING

  act = go_class->mv_attribute

  exp = lco_exp

  msg = 'assert equals failed ' andand go_test_object->mv_attribute andand ' ' andand lco_exp

  ENDMETHOD.

  ENDCLASS.

  What will happen if method parameters act and exp are not equal?

  A. The tested unit will automatically be appended to a default ABAP Test Cockpit Variant.

  B. The tested unit cannot be transported.

  C. The test will be aborted.

  D. There will be a message in the test log.

  Correct Answer: D

• Question 66:

  Exhibit:

  

  (Sorry, we do not have a more clear image. If we have a better resource for the image, we will update this one immediately.)

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

  A. FOR defines a loop that runs over the content of source_itab

  B. source_itab is only visible within the loop.

  C. row is a predefined name and cannot be chosen arbitrarily.

  D. row is only visible within the loop.

  Correct Answer: AD

  The code snippet in the image is an example of using the FOR statement to create an internal table with a constructor expression. The FOR statement introduces an iteration expression that runs over the content of source_itab and assigns

  each row to the variable row. The variable row is then used to populate the fields of target_itab12. Some of the correct statements about the code snippet are:

  FOR defines a loop that runs over the content of source_itab: This is true. The FOR statement iterates over the rows of source_itab and assigns each row to the variable row. The iteration expression can also specify a range or a condition for

  the loop12.

  row is only visible within the loop: This is true. The variable row is a local variable that is only visible within the scope of the iteration expression. It cannot be accessed outside the loop12.

  You cannot do any of the following:

  source_itab is only visible within the loop: This is false. The variable source_itab is not a local variable that is defined by the FOR statement. It is an existing internal table that is used as the data source for the iteration expression. It can be

  accessed outside the loop12.

  row is a predefined name and cannot be chosen arbitrarily: This is false. The variable row is not a predefined name that is reserved by the FOR statement. It is a user-defined name that can be chosen arbitrarily. However, it must not conflict

  with any existing names in the program12.

  References: 1: FOR - Iteration Expressions - ABAP Keyword Documentation - SAP Online Help 2: ABAP 7.4 Syntax - FOR Loop iteration | SAP Community

• Question 67:

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

  A. They store information in two dimensions.

  B. They may have key fields.

  C. They can have any number of key fields.

  D. They can have relationships to other tables.

  Correct Answer: AD

  Database tables are data structures that store information in two dimensions, using rows and columns. Each row represents a record or an entity, and each column represents an attribute or a field. Database tables may have key fields, which are columns that uniquely identify each row or a subset of rows. Key fields can be used to enforce data integrity, perform efficient searches, and establish relationships to other tables. Database tables can have relationships to other tables, which are associations or links between the key fields of two or more tables. Relationships can be used to model the logical connections between different entities, join data from multiple tables, and enforce referential integrity12. References:

  1: Table (database) - Wikipedia 2: Database design basics - Microsoft Support

• Question 68:

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

  A. CDS view

  B. Behavior definition

  C. Authentication rules

  D. Process definition

  Correct Answer: AB

  In RESTful Application Programming, a business object contains two main parts: a CDS view and a behavior definition1.

  A. CDS view: A CDS view is a data definition that defines the structure and the data source of a business object. A CDS view can consist of one or more entities that are linked by associations or compositions. An entity is a CDS view element that represents a node or a projection of a business object. An entity can have various annotations that define the metadata and the semantics of the business object2.

  B. Behavior definition: A behavior definition is a source code artifact that defines the behavior and the validation rules of a business object. A behavior definition can specify the standard CRUD (create, read, update, delete) operations, the draft handling, the authorization checks, and the side effects for a business object. A behavior definition can also define custom actions, validations, and determinations that implement the business logic of a business object3. The following are not parts of a business object in RESTful Application Programming, because:

  C. Authentication rules: Authentication rules are not part of a business object, but part of a service binding. A service binding is a configuration artifact that defines how a business object is exposed as an OData service. A service binding can specify the authentication method, the authorization scope, the protocol version, and the service options for the OData service4.

  D. Process definition: Process definition is not part of a business object, but part of a workflow. A workflow is a business process that orchestrates the tasks and the events of a business object. A workflow can be defined using the Workflow Editor in the SAP Business Application Studio or the SAP Web IDE. A workflow can use the business object's APIs to trigger or consume events, execute actions, or read or update data5. References: 1: Business Object | SAP Help Portal 2: CDS View Entities | SAP Help Portal 3: Behavior Definition | SAP Help Portal 4: Service Binding | SAP Help Portal 5: Workflow | SAP Help Portal

• Question 69:

  For the assignment, gv_target = gv_source.

  Which of the following data declarations will always work without truncation or rounding? Note: There are 2 correct answers to this question.

  A. DATA gv_source TYPE string, to DATA gv_target TYPE c.

  B. DATA gv_source TYPE c. to DATA gv_target TYPE string.

  C. DATA gv_source TYPE d. to DATA gv_target TYPE string.

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

  Correct Answer: BC

  The data declarations that will always work without truncation or rounding for the assignment gv_target = gv_source are B and C. This is because the target data type string is a variable-length character type that can hold any character string,

  including those of data types c (fixed-length character) and d (date). The assignment of a character or date value to a string variable will not cause any loss of information or precision, as the string variable will adjust its length to match the

  source value12.

  You cannot do any of the following:

  A. DATA gv_source TYPE string, to DATA gv_target TYPE c.: This data declaration may cause truncation for the assignment gv_target = gv_source. This is because the target data type c is a fixed-length character type that has a predefined length. If the source value of type string is longer than the target length of type c, the source value will be truncated on the right to fit the target length12. D. DATA gv_source TYPE p LENGTH 8 DECIMALS 3. to DATA gv_target TYPE p LENGTH 16 DECIMALS 2.: This data declaration may cause rounding for the assignment gv_target = gv_source. This is because the target data type p is a packed decimal type that has a predefined length and number of decimal places. If the source value of type p has more decimal places than the target type p, the source value will be rounded to the target number of decimal places12. References: 1: ABAP Data Types - ABAP Keyword Documentation - SAP Online Help 2: ABAP Assignment Rules - ABAP Keyword Documentation - SAP Online Help

• Question 70:

  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.

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

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

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

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

  Correct Answer: CD