Summer Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Question # 4

In the assignment, data (gv_result) = 1/8. what will be the data type of gv_result?

A.

OTYPE I

B.

TYPE DEFLOAT 16

C.

TYPE P DECIMALS 3

D.

TYPE P DECIMALS 2

Full Access
Question # 5

In which products must you use the ABAP Cloud Development Model? Note: There are 2 correct answers to this question.

A.

SAP S/4HANA Cloud, private edition

B.

SAP BTP, ABAP environment

C.

SAP S/4HANA on premise

D.

SAP S/4HANA Cloud, public edition

Full Access
Question # 6

target_itab = VALUE #( FOR row IN source_itab (

field1 = row-field1

field2 = row-field2

field3 = row-field3 )

).

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.

Full Access
Question # 7

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

A.

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

B.

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

C.

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

D.

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

E.

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

Full Access
Question # 8

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

A.

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

B.

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

C.

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

D.

Activation successful

Full Access
Question # 9

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.

Full Access
Question # 10

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.

A.

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

B.

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

C.

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

D.

itab1 and itab2 must have the same data type.

Full Access
Question # 11

What is the purpose of a foreign key relationship between two tables in the ABAP Dictionary?

A.

To document the relationship between the two tables

B.

To ensure the integrity of data in the corresponding database tables

C.

To create a corresponding foreign key relationship in the database

Full Access
Question # 12

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 13

Which restrictions exist for ABAP SQL arithmetic expressions? Note: There are 2 correct answers to this question.

A.

Floating point types and integer types can NOT be used in the same expression.

B.

The operator/is allowed only in floating point expressions.

C.

Decimal types and integer types can NOT be used in the same expression.

D.

The operator is allowed only in floating point expressions.

Full Access
Question # 14

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

A.

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

B.

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

C.

Hashed secondary keys do NOT have to be unique.

D.

Sorted secondary keys do NOT have to be unique.

E.

Secondary keys can only be created for standard tables.

Full Access
Question # 15

Which of the following are parts of answers to this question.

A.

Partitioning attributes

B.

Extension

C.

Field list

D.

Semantic table attributes

Full Access
Question # 16

In the following ABAP SQL code, what are valid case distinctions? Note: There are 2 correct answers to this question.

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 17

The "demo_ods_assoc_spfi data source referenced in line #4 contains a field "connid" which you would like to expose in the element list.

Which of the following statements would do this if inserted on line #8?

A.

demo_ods_assoc_spfli.connid,

B.

demo_ods_assoc_spfli-connid/

C.

spfli-connid,

D.

_spfli.connid/

Full Access
Question # 18

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

A.

sy-index

B.

sy-subrc

C.

sy-linno

D.

sy-tabix

Full Access
Question # 19

What RESTful Application Programming object contains only the fields required for a particular app?

A.

Database view

B.

Metadata extension

C.

Projection View

D.

Data model view

Full Access
Question # 20

In ABAP SQL, which of the following retrieves the association field_Airline-Name of a CDS view?

A.

\_Airline-Name

B.

/_Airline Name

C.

@_Airline-Name

D.

"_Airline Name

Full Access
Question # 21

When processing a loop with the statement DO... ENDDO, what system variable contains the implicit loop counter?

A.

sy-linno

B.

sy-labix

C.

sy-subrc

D.

sy-index

Full Access
Question # 22

Which function call returns 0?

A.

Count_any_of ( val - ‘ABAP ABAP abap' sub "AB" )

B.

Count (val - 'ABAP ABAP abap' sub - 'AB' )

C.

find_any_of (val = "ABAP ABAP abap' sub = "AB")

D.

find_any_not_of( val 'ABAP ABAP abap’ sub = 'AB')

Full Access
Question # 23

What are some features of a unique secondary key? Note: There are 2 correct answers to this question.

A.

It is created when a table is filled.

B.

It is updated when the modified table is read again.

C.

It is created with the first read access of a table.

D.

It is updated when the table is modified.

Full Access
Question # 24

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 type

B.

A built-in ABAP Dictionary type

C.

A data element

D.

A component of an ABAP Dictionary structure

Full Access