Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

You want to use the UNION between 2 SELECT statements in aCDS view. What must both statements have in common?

There are 2 correct answers to this question.

A.

Identical name or alias for elements in the same position

B.

Same number of key elements

C.

Identical data types for elements in the same position

D.

Same number of elements

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

There are 2 correct answers to this question.

A.

The AMDP method has at least one exporting parameter.

B.

The AMDP method is defined as a a static method.

C.

The class implements interface if_amdp_marker_hdb.

D.

All parameters of the AMDP method are passed by value.

Which of the following Open SQL statements are syntactically correct in release 7.50?

There are 3 correct answers to this question.

A.

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

B.

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

C.

SELECT carrid connid loccuram loccurkey. FROM sbook. INTOTABLE lt_booking . WHERE customid = lv_customer.

D.

SELECT carrid connid loccuram loccurkey . FROM sbook . WHERE customid = lv_customer. INTOTABLE lt_booking.

E.

SELECT FROM sbook. FIELDS carrid, connid, loccuram, loccurkey . WHERE customid =@lv_customer. INTOTABLE @lt_booking.

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

There are 2 correct answers to this question.

A.

Host variables are escaped with an at symbol (@)

B.

Statements are ended with a period (.)

C.

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

D.

Key words can be upper-case or lower-case

You implement an ABAP Managed Database Procedure (AMDP). You want to access some other objects from within your script code. Which of the following objects must you list after the USING addition?

There are 2 correct answers to this question.

A.

AMDP Functions

B.

Database Views

C.

Calculation Views

D.

Stored Procedures

What is the result of calling the static class method CL_ABAP_CONTEXT_INFO=>get_user_Alias()?

A.

Nickname of the current user

B.

Name of the current session user

C.

UUID of the current user

D.

Link to the userprofileof the current user

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

There are 3 correct answers to this question.

A.

Aggregations and grouping

B.

Enhancement with custom fields

C.

Combining queries as inner join

D.

Nested views (View-on-View)

E.

Expressions in the field list

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?

There are 2 correct answers to this question.

A.

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

B.

Register the OData service based on your Custom Business Object in SAP Gateway

C.

Activate the UI Generation checkbox in the Custom Business Objects app

D.

Activate the Service Generation checkbox in the Custom BusinessObjects app

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?

Please choose the correct answer.

A.

gs_flight is initialized. The system triggers an exception.

B.

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

C.

gs_flight retains its previous contents. The system sets sy-subrc to 4.

D.

gs_flight is initialized. The systemsetssy-subrc to 4.

In your system landscape, there is a development system DEV and a central check system CHK. Which of the following describes the developer scenario of remote checks with ABAP Test Cockpit (ATC)?

Please choose the correct answer.

A.

A developer logs on to system CHK and invokes a check in system DEV.

B.

A developer logs on to system CHK and checks objects from system DEV.

C.

A developer logs on to system DEV and invokes a check in system CHK.

D.

A developer logs on to system DEV and checks objects from system CHK.