Certification Test 1 Flashcards by Edgar Woode

You are defining a variant in the ABAP Trace tool (SAT). Which trace restrictions can you set?

Restrict trace to specific program parts

Restrict trace to specific statements

How well did you know this?

Not at all

Perfectly

For performance optimization, you want to combine the results of ABAP Test Cockpit ad the SQL Monitor runtime data. What tool do you use for this?

SQL Performance Tuning Worklist (SWLT)

How well did you know this?

Not at all

Perfectly

You want to define an ABAP Managed Database Procedure (AMDP) . Which are requirements in the definition part of the class?

The class implements interface if_amdp_marker_hdb

All parameters of the AMDP method are passed by value

How well did you know this?

Not at all

Perfectly

You want to search for custom code that needs to be adjusted. What tool can you use?

ABAP Call Monitor (SCMON)

How well did you know this?

Not at all

Perfectly

You define an SAPUI5 application as the target in a target mapping. What is mandatory?

Application ID
Component ID
ICF Path

How well did you know this?

Not at all

Perfectly

Where does the SAP system organize the SAP Gateway services?

Internet Communication Framework (ICF)

How well did you know this?

Not at all

Perfectly

How could you replace the statement CONCATENATE ab INTO c?

c = |{a}{b}|
c = a && b

How well did you know this?

Not at all

Perfectly

What are the dimensions of the SAP Fiori definition?

Design
Technology
Concept

How well did you know this?

Not at all

Perfectly

What can you use as a data source for an SAP Fiori App launched-Dynamic?

OData Service

How well did you know this?

Not at all

Perfectly

Which are valid ways to insert a comment in a Data Definition (DDL source)?

/* comment */
// comment

How well did you know this?

Not at all

Perfectly

You plan to migrate an SAP ERP system to SAP S/4HANA. Which tasks are recommended but NOT mandatory?

Custom code evaluation

Performance tuning

How well did you know this?

Not at all

Perfectly

You use the Code Inspector to Search for Potential Functional Issue. Which checks are presets in FUNCTIONAL_DB variant of the Code Inspector?

Search DB Operations in Pool and Cluster tables

Search problematic statements for result of SELECT or OPEN CURSOR without ORDER BY

How well did you know this?

Not at all

Perfectly

Which features are part of the new syntax for OpenSQL?

Comma-separated by column list

ABAP variables escaped with @

How well did you know this?

Not at all

Perfectly

You maintain a transactional application for flight travels that was developed with the ABAP RESTful Application Model (RAP Model). You want to offer an additional button for cancelling a travel.

Data Model Projection

Behavior Projection

Behavior Definition

How well did you know this?

Not at all

Perfectly

You create a project in the Custom Code Migration app to analyze the readiness of custom code for SAP S/4 HANA. How does the app supply the check results?

It executes a check run in a remote system

How well did you know this?

Not at all

Perfectly

Which Open SQL statements are syntactically correct in release 7.50?

SELECT FROM sbook. FIELDS carrid,connid,loccuram,loccurkey. INTO TABLE @It_booking. WHERE customid=@lv_customer

SELECT carrid,connid,loccuram,loccurkey.FROM sbook. INTO TABLE @LT_BOOKING. WHERE customid=@lv_customer

SELECT FROM sbook. FIELDS carrid,connid,loccuram,loccurkey. WHERE customid=@lv_customer. INTO TABLE @It_booking.

How well did you know this?

Not at all

Perfectly

There are many syntax differences between SAP HANA SQLScript and Open SQL. Which rules are common ground between the two languages?

Key words can be upper-case or lower-case

Comments can be marked by an asterisk(*) at position 1

How well did you know this?

Not at all

Perfectly

Which expression can you use in Open SQL release 7.50?

CASE

How well did you know this?

Not at all

Perfectly

Which are benefits of draft-enabling an application?

Support for device switching

Support for continuous work

Early feedback from validations

How well did you know this?

Not at all

Perfectly

You use remote client proxy in ABAP. You create an Exception Class for errors related to proxy consumption. Which do you use as a superclass?

CX_RAP_QUERY_PROVIDER

How well did you know this?

Not at all

Perfectly

Where do you distinguish between OData V2 or OData V4?

Service binding

How well did you know this?

Not at all

Perfectly

What are CRUD operations?

Create, Read, Update and Delete

How well did you know this?

Not at all

Perfectly

You implement the behavior of a CDS-based BOPF Business Object. For which tasks can you reuse the implementation from the BOPF public library?

Auto-fill semantic key fields

How well did you know this?

Not at all

Perfectly

Which rules apply to the naming of CDS Views?

The CDS view and the SQL view must have different names

The data definition name can be up to 30 characters long

How well did you know this?

Not at all

Perfectly

Which repository objects offer a preview function?

Service binding Data definition

You implement the Behavior of a CDS-based BOPF Business Object. You call method update( ) of the BOPF data modifier to update instance data of node ZMY_NODE. How do you type the actual parameter of import parameter IS_DATA?

TYPE REF TO zs_my_node

Which ways can you use to address input parameter X in the CDS view definition?

$parameters.X | :X

Which building blocks of the ABAP RESTful Programming Model(RAP) are part of the Core Data Services(CDS)?

Service definition Behavior definition

In your system landscape, you create a Custom Business Object in the SAP S/4HANA On-Premise edition. Which steps are necessary to use the Custom Business Object as the basis for an SAP Fiori app?

Register the OData service based on your Custom Business Object in SAP Gateway Create a project in the SAP Gateway Service Builder (SEGW) and reference your Custom Business Object as data source

What can you define in an SAP Fiori catalog?

Target Mappings Tiles

Which new repository object types were introduced with ABAP CDS?

Metadata Extension Data definition Access control

You want to create custom fields using the Custom Fields and Logic extensibility app. Which statements do you need to consider?

You must assign the fields to a business context You can translate the fields into different languages

Which expressions will lead to an exception?

DATA var TYPE c LENGTH 4.var = EXACT#( IA123I). DATA var TYPE c LENGTH 5.var = EXACT#( IA123I). DATA var TYPE c LENGTH 3.var = EXACT#( IA123I).

What makes up the behavior of a BOPF Business Object?

Determinations Validations Actions

You maintain a transactional app that is built with the ABAP Programming model for SAP Fiori. The BOPF Business Object consists of a single node. You want to enable the CREATE button for new instances. Which CDS objects do you have to add annotation @ObjectModel.createEnabled?

The data definition of the consumption view The data definition of the transactional view

You edit a behavior implementation class of a draft-enabled BOPF Business Object. You need to distinguish between a new draft instance and an edit draft instance. Which property of the node instance do you evaluate?

HasActiveEntity

You have written a program that uses inline declarations and assigns values using expressions. The global data declarations contain the following statement: DATA o TYPE REF TO cl_class. Which are valid statements?

o = NEW cl_class(). o = NEW(). DATA(p) = NEW cl_class().

You use the UNION in the Open SQL statement in release 7.50. What must you use?

Explicit field list. INTO clause at the end.

Which floorplans does SAP Fiori elements offer?

Overview page List Report Worklist

You want to define a CDS-based BOPF Business Object that consists of a root node (ZI_DocumentTP) and a child node (ZI_ItemTP). What annotation is mandatory in the data definition of CDS view ZI_ItemTP?

@ObjectModel.association.type:[#TO_COMPOSITION_CHILD]

In SAP S/4HANA, a replacement object is assigned to transparent table ANEA. Which uses of table ANEA do you have to correct when migrating an SAP ERP system to SAP S/4HANA?

In the FROM clause of a SELECT statement. In the FROM clause of a DELETE statement.

What do you use as a separator between a table and a field name in a CDS view definition?

Period (.)

How can you create an SAP Gateway service based on a CDS View?

Reference the CDS View as data source in an SAP Gateway project. Add annotation @OData.publish: true in the data definition

What can you do with the SQL Trace Tool (ST05)?

Locate database-related performance issues Display record of all database access Detect redundant statements

You have written the following code: START-OF-SELECTION.LOOP AT ITAB INTO DATA(LINE). ENDLOOP. The system creates a variable called LINE. When is it created and when can you address it?

It is created when the LOOP statement is processed. You can access it any time after the declaration.

What OData option do you use to access the data model of the service?

$metadata

Which CDS view definition is syntactically correct?

@AbapCatalog.sq|ViewName: IS4D430_CARRI. DEFINE VIEW S4D430_Carrier AS SELECT. FROM scar. {carrid, carname, currcode, url}

Which new features are supported by the CDS Views but not by the ABAP Dictionary Views?

Nested views (View-on-View) Aggregations and grouping Expressions in the field list

Which tasks are typically done in a Projection View of the ABAP Restful Application Programming Model RAP?

Enable full-text search in the application Define a value help for an input field

The root-node of a CDS-based business object is based on CDS View ZMY_VIEW. The persistent data is stored in the database table ZMY_TABLE. At least one key field of ZMY_TABLE has a different name in CDS View ZMY_VIEW. What kind of repository object is needed to map the fields of ZMY_VIEW to the fields of ZMY_TABLE?

Database view

You develop an SAP Fiori app in a specific solution area. Where do you define tiles and target mapping for the app?

In a Technical catalog

The class CL_CLASS contains a public static method DO_SOMETHING with an importing parameter PARAM TYPE i. Your program contains the following data declaration: DATA var TYPE string. Which method calls are syntactically correct?

cl_class=>do_something(param = CONV#(var) ). cl_class=>do_something(param = EXACT#(var) ).

What features are available in Open SQL release7.50?

RIGHT OUTER JOIN BETWEEN in ON conditions Up to 50 tables in JOINs

You develop an OData V2 service in sap Gateway. What is listed in the service document?

Entity sets

You have a field currcode in a CDS view definition. You want to annotate the field with a label. What is syntactically correct?

@EndUserText.label:'Currency Code' currcode currcode @

What are features of the ABAP Test Cockpit?

Schedule global check runs Request and approve exemptions

When creating CDS-based BOPF Business Objects, the system generates several additional repository objects. Among those objects are objects in the ABAP Dictionary. Which types of ABAP Dictionary objects are generated?

Structures Table Types

You use the following expression to address the internal table gt_flights: gs_flight = gt_flights[ carrid = IXXI connid = I9999I]. There is NO table entry with the specified key. What is the result of the statement?

gs_flight retains its previous contents. The systems triggers an exception.

You want to create a new CDS view VIEW1 that reads from CDS view VIEW2. VIEW2 has 2 input parameters, par1 and par2, with data type abap.char(10). What is the correct way to supply the input parameters?

SELECT FROM VIEW2(par1: 'TEXT1' , par2:'TEXT2')

In a Custom Business Object you want to implement a determination for a node with the ID SALESORDER. What kind of parameter is the SALESORDER parameter?

Changing