Which engine is used to execute Analytic View?

• A.Join Engine
• B.SQL Engine
• C.Calc Engine
• D.OLAP Engine

Comment: *

Name: *

Email: *

Verification: *

Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 ans

• A.SE09
• B.SE3S
• C.ST22
• D.SQLM
• E.SWLT

Comment: *

Name: *

Email: *

Verification: *

Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement. Which of the following changes to the SELECT statement can you use to retrieve the same data as before?
There are 2 correct answers to this question

• A.Include the client field in the join condition.
• B.Use the CLIENT SPECIFIED addition.
• C.Include the client field in the field list.
• D.Include the client field in the WHERE condition.

Comment: *

Name: *

Email: *

Verification: *

Which code-to-data capability is responsible for the Optimizations & Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL?. Please choose the correct answer.

• A.Buffer system Optimization
• B.Transparent Optimizations
• C.HANA Specific features
• D.Database Optimization

Comment: *

Name: *

Email: *

Verification: *

What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

• A.All fields in the GROUP BY clause must be separated by commas.
• B.All Keywords are case sensitive.
• C.All arithmetic expressions can be used for all type of variables
• D.All ABAP variables must be escaped with a proceeding @ sign.

Comment: *

Name: *

Email: *

Verification: *