Certified Associate - Back-End Developer - ABAP Cloud

In Object-Oriented Design, what is the main advantage of using Composition over Inheritance? Please choose the correct answer. Composition allows for more flexible code reuse and design. Composition is simpler to implement than Inheritance. Composition enhances the polymorphic behavior of objects. Composition is the only way to create complex objects.

Given this code. What are valid statements? There are 2 correct answers to this question. "param1" and "param2" are predefined names. "zcx1" is a dictionary structure, and "param1" and "param2" are same-named components of this structure. The code creates an exception object and raises an exception. "previous" expects the reference to a previous exception.

Which of the following statements about Encapsulation in ABAP OO is true? Please choose the correct answer. It is used to create multiple instances of a class. It exposes the implementation details of an object. It allows the internal state of an object to be changed directly. It protects an object's state by bundling methods and data together.

Given this code: with lcl_super being a superclass of lcl_sub. When accessing the subclass instance through go_super, what can you do?. Access the inherited public components. Access the inherited private components. Call inherited public redefined methods. Call a subclass specific public method.

In class ZCL_CLASS_A, you use the statement DATA var TYPE ***. What may stand in place of ***? There are 2 correct answers to this question. The name of a domain from the ABAP Dictionary. The name of a data element from the ABAP Dictionary. The name of a type defined privately in another class. The name of a type defined privately in class ZCL_CLASS_A.

You have defined a class containing instance attributes and static attributes. You have also declared a reference variable but not yet created an instance of the class. Please choose the correct answer. Instance components using the name of the class. Static components using the reference variable. Instance components using the reference variable. Static components using the name of the class.

How does the 'Composite' design pattern apply in ABAP OO? Please choose the correct answer. It is used for creating recursive tree structures. It allows the creation of complex objects by combining simpler ones. It is used to create a hierarchy of classes with single inheritance. It defines a one-to-one relationship between objects.

What is the purpose of the 'Decorator' pattern in ABAP OO? Please choose the correct answer. To automatically generate getters and setters. To add new responsibilities to objects dynamically. To manage memory allocation for objects. To simplify complex class hierarchies.

How does the 'Observer' pattern function in ABAP OO? Please choose the correct answer. By ensuring that objects are always in a valid state. By allowing objects to publish changes to their state to interested subscribers. By managing the lifecycle of objects. By providing a mechanism for automatic garbage collection.

Given this code. What are valid statements? There are 3 correct answers to this question. Class CL1 uses the interface. Class CL1 implements the interface. In class CL1, the interface method is named if1~m1. In class CL2, the interface method is named if1~m1. Class CL2 uses the interface.

Class super has subclass sub. Which rules are valid for the subconstructor? There are 2 correct answers to this question. The constructor of super must be called before using any components of your own instance. Import parameters can only be evaluated after calling the constructor of super. The method signature can be changed. Events of your own instance cannot be raised before the registration of a handler in super.

In ABAP OO, which keyword is used to define a method that can be overridden in a subclass? Please choose the correct answer. FINAL. ABSTRACT. REDEFINITION. STATIC.

Which kind of ABAP class is the class ZAC? Please choose the correct answer. Shared Class. Exception Class. Behavior Pool Class. Normal Class. Message Class.

Exhibit: What are valid statements? There are 3 correct answers to this question. go_cl1 may call method m1 with go_cl1->if1~m1(). go_if 1 may call method m1 with go_if1->m1(). Instead of go_cl1 = NEW #(...) you could use go_if1 = NEW #(...). Instead of go_cl1 = NEW #(...) you could use go_cl1 = NEW cl1(. ... ). go_if1 may call method m2 with go_if1->m2(...).

Which of the following is an example of the 'Singleton' design pattern in ABAP OO? Please choose the correct answer. A class that groups several related methods. A class that is used to create complex database queries. A class that has multiple instances with shared properties. A class that ensures only one instance exists at any time.

In ABAP OO, what is the purpose of a Constructor method? Please choose the correct answer. To handle exceptions in object methods. To perform database updates. To clean up resources when an object is deleted. To initialize an object when it is created.

A class “my_class” contains the public static method “my_method”. What is the correct code to call this method? Please choose the correct answer. my_class->my_method(). my_class->my_method( ). my_class=>my_method(). my_class=>my_method( ).

Your class contains a public instance attribute attr. How could you ensure that its value can only be changed within the class? There are 2 correct answers to this question. Convert it into a constant. Move it to a different local class. Leave it in the public section but use the READ-ONLY addition. Make it a private attribute.

A functional method must have: Please choose the correct answer. Exactly one importing parameter. No changing parameters. Exactly one returning parameter. Exactly one exporting parameter.

In a subclass “subl” you want to redefine a component of a superclass “superl”. How do you achieve this? There are 2 correct answers to this question. You implement the redefined component in “subl”. You add the clause REDEFINITION to the component in “superl”. You implement the redefined component for a second time in “superl”. You add the clause REDEFINITION to the component in “subl”.

Which of the following principles is NOT a part of the four basic principles of Object-Oriented Programming? Please choose the correct answer. Inheritance. Encapsulation. Polymorphism. Recursion.

Select all that applies for ABAP OO. There are 3 correct answers to this question. Reports. Inheritance. Events. Encapsulation. OData.

With which predicate condition can you ensure that the CAST will work?. IS NOT INITIAL. IS BOUND. IS SUPPLIED. IS INSTANCE OF.

Which of the following are parts of the definition of a new database table? There are 2 correct answers to this question. Partitioning attributes. Semantic table attributes. Extension. Field list.

Match the sequence of execution in the dropdown list to the operation. (1 is the highest priority and 3 is the lowest priority). Please choose the correct answer. Multiplication (*) and Division (/). Addition (+) and Subtraction (-). Numeric functions. +,-,*,/.

Which of the following actions cause an indirect change to a database table requiring a table conversion? There are 2 correct answers to this question. Changing the field labels of a data element that is used in the table definition. 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. Shortening the length of a domain used in a data element that is used in the table definition.

In ABAP for SAP HANA, what is the significance of the 'Eclipse-based ABAP Development Tools' (ADT)? Please choose the correct answer. They are used for database administration tasks. They provide an integrated environment for ABAP development. They are used exclusively for frontend development. They replace the SAP GUI for all development tasks.

In ABAP, which of the following statements about pragmas and pseudo-comments are correct? There are 2 correct answers to this question. The pragma is not checked by the syntax checker. ##NEEDED is checked by the syntax checker. #EC_NEEDED is not checked by the syntax checker. The pseudo-comment is checked by the syntax checker.

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? There are 2 correct answers to this question. AUTHORITY CHECK verifies whether a user is authorized for /DMO/TRVL with the listed field values. If the user is authorized for ‘CNTRY’ = ‘DE’ then the return code is always 0. If the user is authorized for ‘CNTRY’ = ‘DE’ AND for ‘ACTVT’ = ‘03’ then the return code is 0. If the user is NOT authorized for ‘CNTRY’ = ‘DE’ OR for ‘ACTVT’ = ‘03’ then the program will terminate.

What are the characteristics of secondary keys for internal tablets? 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. Hashed secondary keys do NOT have to be unique. Secondary keys can only be created for standard tables. Sorted secondary keys do NOT have to be unique.

Which of the following statements are correct? There are 2 correct answers to this question. FOR defines a loop that runs over the content of source_itab. row is only visible within the loop. row is a predefined name and cannot be chosen arbitrarily. source_itab is only visible within the loop.

When does SAP recommend to use a sorted or a hashed table respectively? There are 2 correct answers to this question. A sorted table, when you read a subset in a loop and specify a part of the key from the left without gaps. A hashed table, when you read a subset in a loop and specify a part of the key from the left without gaps. A hashed table, when you read a single record and specify the complete key. A sorted table, when you read a single record and specify non key fields.

Which of the following are incomplete ABAP types? There are 2 correct answers to this question. P. String. C. T.

When processing an internal table with the statement LOOP AT itab…ENDLOOP, what system variable contains the current row number?. Sy-tabix. Sy-subrc. Sy-index. Sy-linno.

What are the effects of this annotation? @Environment.systemField: #SYSTEM_LANGUAGE There are 2 correct answers to this question. 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 CDS view in ABAP and in another CDS view entity (view on view). It is no longer possible to pass your own value to the parameter. 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.

Which patterns raise an exception? There are 3 correct answers to this question. DATA: gv_target TYPE d. CONSTANTS: gco_date TYPE d VALUE '20331233*'. gv_target EXACT (geo_date). DATA: gv_target TYPE c LENGTH 5. V CONSTANTS: gco_string string TYPE string VALUE '0123456789ABCDEF'. gv_target - EXACT (gco_string + 5 (6) ). DATA: gv_target TYPE p DECIMALS 2. CONSTANTS: go intl TYPE i VALUE 3. gv_target - U EXACT (2 gcojntl). DATA: Ev target TYPE p DECIMALS 3. CONSTANTS: gcojntl TYPE i VALUE 2. Ev_target - U EXACT #2 / gcojntl ). DATA: gv_target TYPE string. CONSTANTS: gco_string TYPE LENGTH 16 VALUE '0123456789ABCDEF*'. gv_target = EXACT # gco_string+5 (5) ).

You have two internal tables itab1 and itab2.What is true for using the expression itab1 = corresponding #( itab2 )? 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 but with different types may be copied from itab2 to itab1. itab1 and itab2 must have the same data type. Fields with the same name and the same type will be copied from itab2 to itab1.

In ABAP, what is the purpose of the 'Field-Symbols' keyword? Please choose the correct answer. To create a reference to a memory area. To define a new data structure. To declare a constant. To initialize a global variable.

Which internal table type allows unique and non-unique keys? Please choose the correct answer. Standard. Hashed. Sorted.

In ABAP for SAP HANA, how does 'Parallel Processing' improve application performance? Please choose the correct answer. By delaying non-critical tasks until the system is idle. By allocating all system resources to a single task at a time. By processing all tasks in a single thread for consistency. By dividing tasks into smaller sub-tasks that are executed simultaneously.

Given the following code excerpt that defines an SAP HANA database table: Which field is defined incorrectly? (2 correct). Field4. Field3. Field2. Field1.

Which function call returns 0? Please choose the correct answer. count( val - 'ABAP ABAP abap' sub - 'AB’ ). count_any_of( val - 'ABAP ABAP abap' sub “AB” ). find_any_of( val = 'ABAP ABAP abap' sub = 'AB' ). find_any_not_of( val - 'ABAP ABAP abap' sub = 'AB' ).

Which type of legacy code does SAP recommend you eliminate when you review modifications as part of an SAP S/4HANA system conversion? There are 2 correct answers to this question. Code that supports a critical business process. Code that has less than 10% usage according to usage statistics. Code that now is identical to a standard SAP object. Code that can be redesigned as a key user extension.

Which of the following is a feature of the ABAP programming language? Please choose the correct answer. Integrated exception handling. Garbage collection. Direct file system access. Pointer arithmetic.

Which of the following are valid sort operations for internal tables? There are 3 correct answers to this question. Sort a sorted table using SORT itab DESCENDING. Sort a standard table using SORT itab BY field1 field2. Sort a standard table using SORT itab ASCENDING. Sort a standard table using SORT itab. Sort a sorted table using SORT itab BY fieldl ASCENDING field2 DESCENDING.

Which of the following string functions are predicate functions? There are 2 correct answers to this question. Matches(). Find_any_not_of(). Count_any_of(). Contains_any_of().

What are some characteristics of secondary keys for internal tables? There are 3 correct answers to this question. Multiple secondary keys are allowed for any kind of internal table. Secondary keys must be chosen explicitly when you actually read from an internal table. Secondary keys automatically update themselves based on table changes. Sorted secondary keys do NOT have to be unique. Hashed secondary keys do NOT have to be unique.

Which statement can you use to change the contents of a row of data in an internal table? Please choose the correct answer. Insert table. Modify table. Append table. Update table.

Which of the following is a generic internal table type? Please choose the correct answer. STANDARD TABLE. INDEX TABLE. HASHED TABLE. SORTED TABLE.

What are the advantages of using a field symbol for internal table row access? There are 2 correct answers to this question. Using a field symbol is faster than using a work area. The row content is copied to the field symbol instead to a work area. MODIFY statement to write changed contents back to the table is not required. The field symbol can be reused for other programs.

For the assignment, gv_target = gv_source. Which of the following data declarations will always work without truncation or rounding? There are 2 correct answers to this question. DATA gv_source TYPE d. to DATA gv_target TYPE string. DATA gv_source TYPE c. 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. DATA gv_source TYPE string, to DATA gv_target TYPE c.

How does the 'Entity Manipulation Language' (EML) enhance the ABAP RAP? Please choose the correct answer. By enabling complex mathematical calculations. By supporting multi-language applications. By providing a syntax for directly manipulating database entities. By allowing the creation of custom UI elements.

What is the significance of 'Behavior Definitions' in the ABAP RAP? Please choose the correct answer. They define the UI behavior of Fiori apps. They specify the operations allowed on business objects. They manage the deployment of applications to different environments. They are used to define database triggers.

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

Which protocol is primarily used for data exchange in the ABAP RESTful Application Programming Model? Please choose the correct answer. HTTP. MQTT. SOAP. OData.

In a RESTful Application Programming application, in which objects do you bind a CDS view to create a value help? There are 3 correct answers to this question. Projection view. Service definition. Behavior definition. Data model view. Metadata extension.

What is the main goal of the ABAP RESTful Application Programming Model (RAP)? Please choose the correct answer. To facilitate communication between different SAP systems. To enable the creation of RESTful services in ABAP. To provide a framework for building scalable web applications. To manage user sessions and authentication.

Setting a field to read-only in which object would make the field read-only in all applications of the RESTful Application Programming model? Please choose the correct answer. Projection view. Metadata extension. Behavior definition. Service definition.

What elements can you add to enhance a business object in the ABAP RESTful application programming model? There are 2 correct answers to this question. Action. Private methods. State management routines. Field.

In RAP, what is the advantage of using 'Managed Transactional Processing'? Please choose the correct answer. It allows direct access to the database. It automates CRUD operations and ensures data consistency. It provides a mechanism for offline data synchronization. It enables the use of custom SQL queries.

In the ABAP RESTful Application Programming Model, what role does the Service Definition play? Please choose the correct answer. It specifies the underlying database structure. It manages user authentication. It defines the UI layout. It exposes a CDS view as an OData service.

How does the 'Optimistic Locking' mechanism work in the ABAP RAP? Please choose the correct answer. By preventing any access to data during updates. By allowing concurrent access and resolving conflicts during save. By using timestamps to order transactions.

What RESTful Application Programming object contains only the fields required for a particular app?. Database view. Metadata extension. Data model view. Projection View.

Setting a field to read-only in which object would make the field read-only in all applications of the RESTfuI Application Programming model?. Behavior definition. Service definition. Metadata extension. Projection view.

In RESTful Application Programming, a business object contains which parts? There are 2 correct answers to this question. Process definition. Authentication rules. Behavior definition. CDS view.

After you have defined a database table in the ABAP RESTful Application Programming model, what is typically created next to expose the data? Please choose the correct answer. A projection view. A metadata extension. A service definition. A data model view.

How does the 'Unmanaged Scenario' in the ABAP RAP differ from the 'Managed Scenario'? Please choose the correct answer. It requires manual implementation of business logic. It supports only synchronous processing. It provides automatic handling of CRUD operations. It is used only for non-relational databases.

In RESTful Application Programming, which EML statement retrieves an object? Please choose the correct answer. Get entity. Read entity. Find entity. Select entity.

After you created a database table in the RESTful Application Programming model, what do you create next?. A metadata extension. A projection view. A service definition. A data model view.

What RESTful Application Programming object contains only the fields required for a particular app? Please choose the correct answer. Database view. Projection View. Metadata extension. Data model view.

Which RESTful Application Programming object can be used to organize the display of fields in an app?. Metadata extension. Data model view. Projection view. Service definition.

In RAP, what is the purpose of a 'Service Definition'? Please choose the correct answer. To manage database connections. To expose a business object as a service. To define the UI components. To specify the business logic.

You have the following CDS definition: Which of the following ON conditions must you insert in place of "???"? Please choose the correct answer. ON _Source1.carrier_id = _Source2.carrier_id. ON $projection.Carrier = Source2.carrier. ON $projection.carrier_id = _Source2.carrier_id. ON $projection Carrier = Source2.carrier_id.

What is the purpose of using Associations in ABAP CDS Views? Please choose the correct answer. To encrypt data within CDS views. To link CDS views with external databases. To define relationships between different CDS views. To optimize the performance of CDS views.

How do CDS Table Functions enhance the capabilities of ABAP CDSViews? Please choose the correct answer. By enabling real-time data replication. By providing a graphical interface for data modeling. By allowing direct SQL scripting within CDS views. By supporting complex joins and unions.

What are some of the benefits that Core Data Services (CDS) offer overclassical approaches to data modeling in ABAP? There are 2 correct answers to this question. CDS views reduce the need for ABAP coding. They compute results on the application server. They transfer computational results to the application server. They implement code pushdown.

In the ABAP RAP, what is the role of 'Value Help' in CDS Views? Please choose the correct answer. To offer input assistance and value suggestions. To optimize query execution plans. To provide default values for fields. To assist with data encryption.

What is the significance of using Path Expressions in ABAP CDS Views? Please choose the correct answer. To define the execution path of the view. To specify backup paths for data recovery. To navigate relationships between associated views. To encrypt sensitive data paths.

Scenario: An ABAP application on SAP HANA needs to perform complex calculations on large datasets. Which approach should be used to achieve optimal performance? Please choose the correct answer. Leverage SAP HANA's in-memory capabilities using CDS views or AMDPs. Implement calculations in the application layer. Store data in temporary tables for processing. Use classical ABAP processing techniques.

Why would you use Access Controls with CDS Views? There are 2 correct answers to this question. The system field sy-subrc is set, giving you the result of the authorization check. All of the data from the data sources is loaded into your application automatically and filtered there according to the user's authorization. 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.

When you attempt to activate the definition, what will be the response? Please choose the correct answer. 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. Activation successful.

In the context of ABAP on HANA, what is the advantage of using Advanced ViewBuilding techniques in CDS? Please choose the correct answer. To enable direct update of database tables. To manage database transactions. To create complex UI designs. To build sophisticated data models leveraging database capabilities.

What is the primary use of ABAP Core Data Services (CDS)? Please choose the correct answer. Data modeling and definition. Front-end application development. User authentication. Network configuration.

Refer to the Exhibit. When you attempt to activate the definition, what will be the response? Please choose the correct answer. Activation successful. Activation error because the key fields of the union do not match. Activation error because the field types of the union do not match. Activation error because the field names of the union do not match.

/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. Please choose the correct answer. Internal Table. Simple variable. Structure.

Given the following Core Data Services View Entity Data Definition, which of the following types are permitted to be used for <source> on line #4? There are 2 correct answers to this question. A database table from the ABAP Dictionary. A CDS DDIC-based view. A database view from the ABAP Dictionary. An external view from the ABAP Dictionary.

In an Access Control Object, which clauses are used? There are 3 correct answers to this question. Grant (to identify the data source). Revoke (to remove access to the data source). Return code (to assign the return code of the authority check). Where (to specify the access conditions). Define role (to specify the role name).

BAdIs are classified under which of the following extension types in SAP S/4HANA Cloud? Please choose the correct answer. Key User Extension. Side-By-Side Extension. Developer Extension. Classical user exit.

Which of the following are challenges with trying to use classical extensibility in SAP S/4HANA Cloud? There are 2 correct answers to this question. Classical extensibility does not enable customers to have competitive advantage. In SAP S/4HANA Cloud, all software updates run simultaneously. Classical extensibility does not enable customers to have flexible processes. In SAP S/4HANA Cloud, there are no customer-specific customer update projects.

Which tool is primarily used for building In-App Extensions in S/4HANACloud? Please choose the correct answer. SAP Web IDE. ABAP Workbench. SAP Fiori. SAP Cloud Platform Business Rules.

Which of the following are essential aspects of ABAP Cloud? There are 3 correct answers to this question. ABAP development tools for Eclipse. ABAP Cloud language. .NET & SOAP. ABAP RESTful application programming model.

Which of the following is a benefit of using SAP BTP for extendingS/4HANA Cloud? Please choose the correct answer. Reduced need for system upgrades. Elimination of the need for testing. Direct access to modify core SAP code. Ability to build and run custom applications.

In ABAP Cloud, how is the concept of 'Multitenancy' handled for custom developments? Please choose the correct answer. By allowing each tenant to have its own custom code. By restricting custom development to specific tenants. By sharing custom code across all tenants. By isolating custom code in a separate database.

Which extensibility type does SAP recommend you use to enhance the existing UI for an SAP Fiori app?. Classic. Side-by-side. Developer. Key user.

How does 'SAP Fiori Elements' support extensibility in SAP S/4HANACloud? Please choose the correct answer. By creating standalone mobile applications. By allowing direct modification of SAP Fiori apps. By providing a set of reusable UI patterns and templates. By managing backend services for Fiori apps.

What is the purpose of the 'In-App Extensibility' framework in SAPS/4HANA Cloud? Please choose the correct answer. To enable users to extend and personalize applications within the SAP system. To allow modifications to the SAP core. To create standalone applications separate from the SAP system. To manage the integration of third-party applications.

In which products must you use the ABAP Cloud Development Model? There are 2 correct answers to this question. SAP S/4HANA on premise. SAP S/4HANA Cloud, private edition. SAP BTP, ABAP environment. SAP S/4HANA Cloud, public edition.

Why are Side-by-Side Extensions preferred over In-App Extensions inS/4HANA Cloud for complex integrations? Please choose the correct answer. Greater flexibility and reduced impact on core upgrades. No need for external systems or platforms. Direct access to modify core SAP code. Simpler development process.

How does the Side-by-Side Extensibility model benefit SAP S/4HANACloud customers? Please choose the correct answer. By allowing direct modifications to the SAP core. By reducing the need for any kind of system extensions. By enabling extensions to be built in separate systems, such as SAP BTP. By automating the extension development process.

For what kind of applications would you consider using on-stack developer extensions? 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 integrate data from several different systems. Applications that run separate from SAP S/4HANA.

What is the significance of 'Service Extensions' in the context of SAPS/4HANA Cloud? Please choose the correct answer. To integrate third-party services into the SAP core. To extend existing SAP services or create new ones without impacting the core. To replace standard SAP services with custom ones. To modify core SAP services directly.

You are given the following information: 1.The data source "spfli" 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. Based on this information, which of the following general settings should you set for the spfli database table? There are 2 correct answers to this question. "Storage Type" to "Row Store". "Storage Type" to "Column Store". "Load Unit to "Column Loadable". "Load Unit' to 'Page Loadable".

What would be the correct expression to change a given string value 'mr joe doe' into 'JOE' in an ABAP SQL field list? Please choose the correct answer. 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, upper(left( 'mr joe doe', 6)) AS f2_up_left, 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, …….

In ABAP SQL, which of the following retrieves the association field _Airline-Name of a CDS view? Please choose the correct answer. \_Airline-Name. “_Airline-Name. /_Airline-Name. @_Airline-Name.

In the context of ABAP development, what does 'SQL pushdown' refer to? Please choose the correct answer. Transferring all database operations to a secondary database. Moving SQL statements from the application server to the client side. Pushing SQL code to the application layer for processing. Executing data-intensive logic directly in the database layer.

In ABAP SQL, which of the following can be assigned an alias? There are 2 correct answers to this question. group criterion (from group by clause). order criterion (from order by clause). field (from field list). database table.

In ABAP, what is the purpose of the 'GROUP BY' clause in an Open SQLSELECT statement? Please choose the correct answer. To sort the result set. To combine rows that have the same values in specified columns. To limit the number of rows returned. To specify the columns to be returned.

You want to read data from two database tables so that the SELECTstatement returns a single result set that contains no duplicate entries. Which of the following techniques would you use? Please choose the correct answer. INNER JOIN. UNION ALL. LEFT OUTER JOIN. UNION.

What is the significance of 'ALV IDA' (ALV with Integrated DataAccess) in ABAP for SAP HANA? Please choose the correct answer. It provides a framework for building web applications. It is used for legacy system migration. It enables efficient data display by leveraging the power of the HANA database. It is a tool for database administration.

Which restrictions exist for ABAP SQL arithmetic expressions? There are 2 correct answers to this question. Floating point types and integer types can NOT be used in the same expression. Decimal types and integer types can NOT be used in the same expression. The operator is allowed only in floating point expressions. The operator/is allowed only in floating point expressions.

How does the 'AMDP (ABAP Managed Database Procedures)'framework benefit ABAP developers? Please choose the correct answer. By eliminating the need for database procedures. By providing a graphical interface for SQL programming. By allowing the use of native SQL and database-specific features. By automatically converting Open SQL to native SQL.

In this nested join below in which way is the join evaluated?. 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. From the right to the left in the order of the tables: 1.b is joined with c. 2.b is joined with 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. From the left to the right in the order of the tables: 1.a is joined with b 2. b is joined with c.

What is the primary benefit of code pushdown in ABAP for SAP HANA? Please choose the correct answer. To simplify the syntax of ABAP code. To increase the size of the codebase. To enhance the user interface experience. To improve performance by executing data-intensive operations in the database.

Which of the following ABAP SQL statements are valid? There are 2 correct answers to this question. 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). SELECT FROM /dmo/connection FIELDS MAX( distance ) AS dist_max, MIN( distance ) AS dist_min INTO TABLE @DATA(It_hits). SELECT FROM /dmo/connection FIELDS carrid, airpfrom, MAX( distance ) AS dist_max, MIN( distance ) AS dist_min INTO TABLE @DATA(It_hits). SELECT FROM /dmo/connection FIELDS carrid, airpfrom GROUP BY carrid, Connid INTO TABLE @DATA(It_hits).

In the RESTful Application Programming model where do you implement non-standard operations for customized business-logic behavior?. In a determination. In a validation. In an action.

You want to enhance a business object to retrieve a default company code that is selected from the database. Which extension type must be used?. Action. Association. Validation. Determination.

You have shortened the length of a field in a database table. The table already contains data. What happens when you try to activate the table?. The table is activated. The table is not activated. The table is activated with a warning that you may lose data.

What do you have to consider when working with interfaces? Note: There are 3 correct answers to this question. Instance methods are not implemented in an interface. Static methods, instance methods, static events, and instance events are possible interface components. Static methods can be implemented in an interface. Implementing classes may declare the interface in any visibility section. Implementing classes must declare the interface in their public section.

With the following class definition, what is the correct syntax for calling method b? (Note: lo_a is a reference variable for class ZCL_A.) CLASS zcl_a DEFINITION PUBLIC. PUBLIC SECTION. CLASS-METHODS b. ENDCLASS. zcl_a->b( ). zcl_a=>b( ). lo_a->b( ). lo_a=>b( ).

What can you add to a business object in the ABAP RESTful application programming model? Note: There are 2 correct answers to this question. Field. Action. Implicit enhancement. Method overwrite.

Which of the following are ABAP Cloud Development Model rules. Note: There are 2 correct answers to this question. Build ABAP RESTful application programming model-based services. Build ABAP reports with either ABAP List Viewer (ALV) or SAP Fiori. Reverse modifications when a suitable public SAP API becomes available. Use public SAP APIs and SAP extension points.

Which statement reads a single row from a database table?. SELECT <tablename>... READ TABLE <tablename> WITH TABLE KEY... SELECT SINGLE <tablename>... READ TABLE <tablename>...

Given the following Core Data Service View Entity Data Definition: @AccessControl.authorizationCheck: #NOT_RECUIRED DEFINE VIEW ENTITY demo_flight_info_join AS SELECT FROM scarr AS a LEFT OUTER JOIN scounter AS c LEFT OUTER JOIN sairport AS p ON p.id = c.airport ON a.carrid = c.carrid { a.carrid AS carrier_id, p.id AS airport_id, c.countnum AS counter_number }. scarr will be joined with sairport first and the result will be joined with scounter. 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. scounter will be joined to sairport first and the resul will be joined with scarr.

In a test method you call method cl_abap_unit_assert=>assert_equals(..) in the following way: CLASS ltcl1 DEFINITION FOR TESTING RISK LEVEL HARMLESS DURATION SHORT. PRIVATE SECTION. METHODS m1 FOR TESTING. ENDCLASS. CLASS ltcl1 IMPLEMENTATION. METHOD m1. DATA: go_test_object TYPE REF TO zcl_to_be_tested. CONSTANTS: lco_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' && go_test_object->mv_attribute && ' ' && lco_exp ). ENDMETHOD: ENDCLASS. The test will be aborted. There will be a message in the test log. The tested unit cannot be transported. The tested unit will automatically be appended to a default ABAP Test Cockpit Variant.