E_HANAAW_17｜受かる!SAP認定試験対策【過去問】

SAP認定コンサルタント試験過去問題集です。

✅合格のポイント
実際に試験合格者が添削していますので、合格再現性の高い過去問題集です。
一発合格を目指す方はぜひご活用下さい！

問題が多いため反復して試験対策することができます。

受験費用でも高額ですのでペイは十分可能かと存じます。
合格目的だけでなく、純粋に勉強にも役立ちます。

✅対象試験
SAP Certified Development Specialist-ABAP for SAP HANA 2.0 E_HANAAW_17

⚠本試験は日本語でも受けることが可能ですが、
英語の方が資料が多く間違いも少ないため必ず【英語】で受けることをおすすめします。

✅【公式サイト】SAP勉強サイトも開設
https://sapnavi.com/

✅関連SAP過去問題集

サンプル問題👇
＊ご購入後、全ての問題を見ることができます

1. Where can you consume associations in a Core Data Services (CDS) view? 3 ans
In the projection list✔
In the name list
In the input parameter list
In the FROM clause✔
In the WHERE and HAVING clauses✔

2. What are the types of schemas in HANA? (3 ✔)
System Defined Schema✔
User Defined Schema✔
SLT Derived Schema✔
Dynamic Schema

3. 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?
The CASE statement as provided in the SELECT list without its alias✔
The alias of the CASE construct used in the SELECT list
None; the GROUP BY list is added automatically
The name of the gross amount column that is used in the CASE statement

4. Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 ✔ answers to this question.
Create a new version of the database when the AMDP is first activated
Delete the obsolete versions of the database procedure synchronously
Delete the obsolete versions of the database procedure asynchronously✔
Create a new version of the database when the AMDP is first called✔

5. Which conditional expressions can be used in Core Data Services (CDS) views? 2 ans
CASE statements in the projection list✔
IF statements in the projection list
WHILE statements in the WHERE clause
COALESCE functions in the projection list✔
CASE statements in the HAVING clause

6. 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 ✔ answers to this question.
All arithmetic expressions can be used for all type of variables
All ABAP variables must be escaped with a proceeding @ sign.✔
All Keywords are case sensitive.
All fields in the GROUP BY clause must be separated by commas.✔

7. What allows you to resolve errors quickly or warnings reported about the code? Please choose the ✔ answer.
Code execution
Quick Fix✔
Debug perspective
ABAP debugger

8. You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 ✔ answers to this question.
CAST( 'USO' AS abap.cuky) AS currency_key✔
SUM( revenue ) AS total_revenue✔
Crtdby AS created_by
CASE order type WHEN 'A' THEN 1 ELSE 0 END AS Order_type✔
ASSOCIATION TO sflight AS_flights

9. What do you understand by the SAP HANA Software Optimization? Please choose the ✔ answer.
Speed up the processing within the database
Bring logic to where the data is calculated first then only move to results✔
Provide combinations of objects and partitioning
Huge potential for hybrid database

10. What are best practices when programming in ABAP for SAP HANA? There are 2 ✔ answers to this question.
Calculate aggregations using ABAP code on the application server to limit database load
Eliminate nested SELECT statements to reduce the overall number of database accesses✔
Use a column list in the SELECT clause to ensure that you only read a column if it is really required✔
Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required