You are given the following information: 1.The data source 'spfli' on line #2 is an SAP HANAdatabase table2.'spfli' will be a large table with over one million rows.3.This program is the only one in the system that accesses the table.4.This program will run rarely.Based on this information, which of the following general settings should you set for the spfli database table? Note:There are 2 correct answers to this question.

'Storage Type' to 'Column Store'

'Load Unit to 'Column Loadable'

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.

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

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

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

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

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

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

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

They store information in two dimensions.

They can have relationships to other tables.

They store information in two dimensions.

They can have any number of key fields.

They can have relationships to other tables.

Exhibit:With Icl_super being superclass for Icl_subl and Icl_sub2 and with methods subl_methl and sub2_methl being subclass-specific methods of Id_subl or Icl_sub2, respectivel. What will happen when executing these casts? Note:There are 2 correct answers to this question

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

go_subl->subl_meth !(...)* w'll work.

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

go_sub2 = CAST # go super), will work. go_subl CAST #go_super), will work

go_sub2 = CAST #(go_super). will not work. ] go sub2->sub2 meth 1(...). will work

go_subl->subl_meth !(...)* w'll work.

Which type of legacy code does SAP recommend you eliminate when you review modifications as part of an SAP S/4HANA system conversion? Note: There are 2 correct answers to this question.

Code that now is identical to a standard SAP object

Code that can be redesigned as a key user extension

Code that supports a critical business process

Code that now is identical to a standard SAP object

Code that has less than 10% usage according to usage statistics

Code that can be redesigned as a key user extension

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

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

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

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

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

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

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

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

The name of a data element from the ABAP Dictionary

The name of a domain from the ABAP Dictionary

The name of a type defined privately in class ZCL_CLASS_A

The name of a data element from the ABAP Dictionary

The name of a type defined privately in another class

The name of a domain from the ABAP Dictionary

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

Applications that provide APIs for side by side SAP BTP apps

Applications that access SAP S/4HANA data using complex SQL

Applications that provide APIs for side by side SAP BTP apps

Applications that access SAP S/4HANA data using complex SQL

Applications that integrate data from several different systems

Applications that run separate from SAP S/4HANA

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

SELECT mat FROM demo_sales_cds_so_i_ve...

SELECT mat FROM demo_sales_so_i...

SELECT mat FROM demo sales cds material ve...

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

order criterion (from order by clause)

group criterion (from group by clause)

ExhibitWhich of the following ABAP SQL snippets are syntactically correct ways to provide a value for the parameter on line #4? Note: There are 2 correct answers to this question

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

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

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

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

...SELECT * FROM demo_cds_param_view_entity (p_date: 20238181')... )

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

Which of the following ON conditions must you insert in place of '???'?

ON Sprojection.carrier_id=Z_Source2.carrier_id

ON Z_Sourcel.camer_id = 7_Source2 carrier_id

ON Sprojection Camer=Source2 carrier_id

ON Sprojection. Carrier Source2.carrier

ON Sprojection.carrier_id=Z_Source2.carrier_id

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.

A built-in ABAP Dictionary type

A component of an ABAP Dictionary structure

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

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

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

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

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

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

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

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

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

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

go_if 1 may call method ml with go_ift->ml().

Instead of go ell = NEW #(...) you could use go ifl = NEW cll(. ... ).

go_ifl may call method m2 with go if->m2(...).

go_if 1 may call method ml with go_ift->ml().

Instead of go ell = NEW #(...) you could use go ifl = NEW cll(. ... ).

go_cll may call method ml with go_dl->ifl-ml().

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

go_ifl may call method m2 with go if->m2(...).

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

In class CL2, the interface method is named ifl-ml.

Class CL1 implements the interface.

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

In class CL2, the interface method is named ifl-ml.

Class CL1 implements the interface.

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

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

SELECT FROM TABLE dbtabl FIELDS Of1, upper(left( 'mr joe doe', 6)) AS f2_up_left, f3,

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

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

SELECT FROM TABLE dbtabl FIELDS Of1, substring(lower(upper( 'mr joe doe' ) ), 4, 3) AS f2_sub_lo_up, f3,

What are some characteristics of secondary keys for internal tables? Note: There are 3 correct answers to this question.

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

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

Sorted secondary keys do NOT have to be unique.

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

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

Hashed secondary keys do NOT have to be unique.

Sorted secondary keys do NOT have to be unique.

Secondary keys can only be created for standard tables.

What are the effects of this annotation? Note: There are 2 correct answers to this question.

The value of sy-langu will be passed to the CDS view automatically both when you use the -1 CDS view in ABAP and in another CDS view entity (view on view).

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

The value of sy-langu will be passed to the CDS view automatically both when you use the -1 CDS view in ABAP and in another CDS view entity (view on view).

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

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

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

In a subclass subl you want to redefine a component of a superclass superl. How do you achieve this? Note: There are 2 correct answers to this question.

You add the clause REDEFINITION to the component in subl.

You implement the redefined component in subl.

You add the clause REDEFINITION to the component in subl.

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

You implement the redefined component in subl.

You add the clause REDEFINITION to the component in superl.

when you attempt to activate the definition, what will be the response?

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

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

Activation error because the key fields of the union do not match

You have two internal tables itab1 and itab2.What is true for using the expression itab1 = corresponding #( itab2 )? Note: There are 2 correct answers to this question.

itab1 and itab2 must have at least one field name in common.

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

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

itab1 and itab2 must have at least one field name in common.

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

itab1 and itab2 must have the same data type.

Given the following Core Data Service View Entity Data Definition:1 @AccessControl.authorizationCheck: #NOT_REQUIRED2 DEFINE VIEW ENTITY demo_flight_info_join3 AS SELECT4 FROM scarr AS a5 LEFT OUTER JOIN scounter AS c6 LEFT OUTER JOIN sairport AS p7 ON p.id = c.airport8 ON a.carrid = c.carrid9 {10 a.carrid AS carrier_id,11 p.id AS airport_id,12 c.countnum AS counter_number13 }In what order will the join statements be executed?

scarr will be joined with scounter first and the result will be joined with sairport.

sairport will be joined to scounter first and the result will be joined with scarr.

scarr will be joined with sairport first and the result will be joined with scounter.

scounter will be joined to sairport first and the result will be joined with scarr.

Which of the following are ABAP Cloud Development Model rules?Note: There are 2 correct answers to this question.

Use public SAP APIs and SAP extension points.

Reverse modifications when a suitable public SAP API becomes available.

Use public SAP APIs and SAP extension points.

Build ABAP RESTful application programming model-based services.

Reverse modifications when a suitable public SAP API becomes available.

Build ABAP reports with either ABAP List Viewer (ALV) or SAP Fiori.

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(EXPORTINGact = go_class->mv_attributeexp = lco_expmsg = 'assert equals failed ' && go_test_object->mv_attribute && ' ' && lco_expENDMETHOD.ENDCLASS.What will happen if method parameters act and exp are not equal?

There will be a message in the test log.

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

The tested unit cannot be transported.

There will be a message in the test log.

SAP C_ABAPD_2309 Practice Test 2 - Free Online Exam Questions 41-80

Home / SAP / C_ABAPD_2309 / Practice Test 2

Ask Question

00:00:00

Show Answer

Training mode

Report Issue

Restart test

Question 1 / 40

You are given the following information:

SAP C_ABAPD_2309 image Question 41 63877254069734815018431

The data source 'spfli' on line #2 is an SAP HANA

database table

'spfli' will be a large table with over one million rows.

This program is the only one in the system that accesses the table.

This program will run rarely.

Based on this information, which of the following general settings should you set for the spfli database table? Note:

There are 2 correct answers to this question.

Become a Premium Member for full access

Unlock Premium Member

Score Report

Your Score: 0%
Time: 00:00:00

100

C_ABAPD_2309: SAP Certified Associate - Back-End Developer - ABAP Cloud

Vendor:

SAP

Exam Questions:

Learners

2.370

Last Updated

October - 2025

Language

English

SAP C_ABAPD_2309 Practice Test 2

Question

Drag and Drop

Hot Area

SAP C_ABAPD_2309 Practice Tests

Practice Tests