SAP E_HANAAW_17 SAP Certified Development Specialist – ABAP for SAP HANA 2.0 Online Training
SAP E_HANAAW_17 Online Training
The questions for E_HANAAW_17 were last updated at Nov 15,2024.
- Exam Code: E_HANAAW_17
- Exam Name: SAP Certified Development Specialist - ABAP for SAP HANA 2.0
- Certification Provider: SAP
- Latest update: Nov 15,2024
Which is better from performance point of view?
- A . SQLScript Procedure
- B . Modeling Views
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD).
Which SELECT statement would you use in the definition? Please choose the correct answer.
- A . select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd
- B . select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd
- C . select from snwd_so {sojd, sum(net_amount) as sum_amount}
- D . select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount
You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method.
Which additional steps are necessary to retrieve the result set into an internal table? 2 ans
- A . Close the CL_SQL_STATEMENT object to release the resources.
- B . Use an Open SQL query that uses the JOIN between the result set and the internal table as a data source.
- C . Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance.
- D . Fetch the result using the next_package method of class CL_SQL_RESULT_SET.
- E . Fetch the result using the fetch method of class CL_SQL_EXECUTE.
Which of the statements are true for SQLScript? (2 answers)
- A . SQLScript is an open standard.
- B . SQLScript is used to push down data intensive logic into the database.
- C . SQLScript is a collection of extensions to SQL.
In addition to closing the result set. what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer.
- A . Release resources
- B . Update resources
- C . Update resources
- D . Update packages
You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA.
Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer.
- A . Read-write
- B . Read only
- C . Write only
- D . Read-update
You analyse SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its data. But the relevant database access is NOT listed in SQLMD.
What could be the reason?
Note: There are 3 correct answers to this question.
- A . SQL Monitor was activated for a specific application server
- B . SQL monitor was activated with a filter that excludes database table Y
- C . The data has NOT yet been transferred to the SQL monitor database tables
- D . Program X was executed in the background.
- E . Database table Y is a buffered table.
What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.
- A . Process on all the input fields
- B . Automatic updates of all the input fields
- C . Check Pre-Requisites
- D . Identify Elementary Search Help
- E . Switch on proposal search for input fields
Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA) and NOT the SAP HANA Transport Container (HTC).
Why would you choose HTA? Note: There are 2 correct answers to this question.
- A . Because you can manually re-deploy objects after a failed import
- B . Because you always transport entire SAP HANA content packages
- C . Because you use the technique that is recommended by SAP
- D . Because you automatically add changed objects to the transport request
Why is a security concept in SAP HANA required? There are 2 correct answers to this question
- A . Need to have selected users in SAP HANA for Information Management
- B . Access to ERP tables must be restricted
- C . Editing of SAP HANA data models should only be possible for "Users" of the model
- D . Database administration should be restricted to skilled
Latest E_HANAAW_17 Dumps Valid Version with 174 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
