In an Open SQL query, you select the sum of sales order gross amounts and a CASE statement to flag sa order gross amounts below a certain value. What information has to be provided in the GROUP BY list?

• A.The CASE statement as provided in the SELECT list without its alias
• B.The alias of the CASE construct used in the SELECT list
• C.None; the GROUP BY list is added automatically
• D.The name of the gross amount column that is used in the CASE statement

Comment: *

Name: *

Email: *

Verification: *

You define and implement an AM DP. What do you have to list after the USING clause? There are 3 correct answers to this question.

• A.ABAP dictionary views used in procedure body
• B.ABAP dictionary tables used in procedure body
• C.AMDP Used in Procedure Body
• D.CE function used in procedure Body
• E.SAP HANA views used in procedure body

Comment: *

Name: *

Email: *

Verification: *

Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?

• A.Service Adaptation Description Language (SADL)
• B.Process Agent Framework (PAF)
• C.ABAP Messaging Channels (AMC)
• D.ABAP Managed Database Procedures (AMDP)

Comment: *

Name: *

Email: *

Verification: *

How can you consume a Core Data Services (CDS) view? 2 ans

• A.Use it as a data source in the FROM clause of an Open SQL query.
• B.Use the Data Preview in ABAP Development Tools for SAP NetWeaver.
• C.Use the CDS maintenance transaction (SCDSV).
• D.Use the ABAP language statement WRITE and the CDS view name as the argument.

Comment: *

Name: *

Email: *

Verification: *

The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.

• A.Avoid single network
• B.Avoid optimizing data
• C.Avoid CPU cache misses
• D.Avoid idiling CPU cores

Comment: *

Name: *

Email: *

Verification: *