Free SAP Certified Associate – Back-End Developer – ABAP Cloud Exam C_ABAPD_2309 Exam Practice Test

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

• ##NEEDED is checked by the syntax checker.
• The pragma is not checked by the syntax checker.
• #EC_NEEDED is not checked by the syntax checker.
• The pseudo-comment is checked by the syntax checker

Which of the following ABAP SQL statements are valid? Note: There are 2 correct answers to this question.SELECT FROM /dmo/connection FIELDS carrid O airpfrom,MAX(distance) AS dist_max, MIN( distance) AS dist_min GROUP BY carrid, airpfrom INTO TABLE @DATA(It_hits)SELECT FROM /dmo/connection FIELDS \/ O carrid, airpfrom,MAX( distance) AS dist_max, MIN(distance) AS dist_min INTO TABLE @DATA(It_hits)SELECT FROM /dmo/connection FIELDS V D MAX(distance) AS dist_max MIN(distance) AS dist_min INTO TABLE @DATA(It_hits).SELECT FROM /dmo/connection FIELDS r—i carrid, airpfrom u GROUP BY carrid, connid INTO TABLE @DATA(It_hits).

• B: This statement is valid. It is similar to statement A, except that it does not specify the GROUP BY clause. This means that the aggregate functions are applied to the entire table, and the results are stored in an internal table named It_hits, which is created using the inline declaration operator @DATA.
• C: This statement is invalid. It selects the aggregate functions MAX(distance) and MIN(distance) from the table /dmo/connection, but it does not specify any grouping or non-aggregate fields. This is not allowed in ABAP SQL, as the SELECT list must contain at least one non-aggregate field or a GROUP BY clause. The statement will cause a syntax error.
• D: This statement is invalid. It selects the fields carrid and airpfrom from the table /dmo/connection, and groups the results by carrid and connid. However, the field connid is not included in the SELECT list, which is not allowed in ABAP SQL, as the GROUP BY clause must contain only fields that are also in the SELECT list. The statement will cause a syntax error.

What are some of the reasons that Core Data Services are preferable to the classical approach to data modeling? Note: There are 2 correct answers to this question.

• They implement code pushdown.
• They avoid data transfer completely.
• They transfer computational results to the application server.
• They compute results on the application server.

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

• They store information in two dimensions.
• They may have key fields.
• They can have any number of key fields.
• They can have relationships to other tables.

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

• Service definition
• Behaviour definition
• Projection view
• Metadata extension

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

• sy-index
• sy-subrc
• sy-linno
• sy-tabix

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

• A metadata extension
• A projection view
• A data model view
• A service definition

For the assignment, gv_target = gv_source.which of the following data declarations will always work without truncation or rounding? Note:Thereare 2 correct answers to this question.

• DATA gv_source TYPE string, to DATA gv_target TYPE c.
• DATA gv_source TYPE c. to DATA gv_target TYPE string.
• DATA gv_source TYPE d. to DATA gv_target TYPE string.
• DATA gv_source TYPE p LENGTH 8 DECIMALS 3. to DATA gv_target TYPE p LENGTH 16 DECIMALS 2.

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.built-in ABAP typeA built-in ABAP Dictionary typeA data elementA component of an ABAP Dictionary structure

• built-in ABAP type and C. A data element. These are the valid types that can be used to specify the data type of an input parameter in a CDS view entity. A built-in ABAP type is a predefined elementary type in the ABAP language, such as abap.char, abap.numc, abap.dec, etc. A data element is a reusable semantic element in the ABAP Dictionary that defines the technical attributes and the meaning of a field12. For example:
• The following code snippet defines a CDS view entity with an input parameter currency of type abap.cuky, which is a built-in ABAP type for currency key:
• Define view entity Z_CONVERT With parameters currency : abap.cuky as select from … { … } The following code snippet defines a CDS view entity with an input parameter currency of type waers, which is a data element for currency key:
• Define view entity Z_CONVERT With parameters currency : waers as select from … { … } You cannot do any of the following:
• A built-in ABAP Dictionary type: This is not a valid type for an input parameter in a CDS view entity. A built-in ABAP Dictionary type is a predefined elementary type in the ABAP Dictionary, such as CHAR, NUMC, DEC, etc. However, these types cannot be used directly in a CDS view entity definition. Instead, they have to be prefixed with abap. to form a built-in ABAP type, as explained above12.
• D) A component of an ABAP Dictionary structure: This is not a valid type for an input parameter in a CDS view entity. A component of an ABAP Dictionary structure is a field that belongs to a structure type, which is a complex type that consists of multiple fields. However, an input parameter in a CDS view entity can only be typed with an elementary type, which is a simple type that has no internal structure12.

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

• Append table
• Modify table
• Insert table
• Update table