SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 31:

  What are the two types of editors available in ADT? There are 2 correct answers to this question.

  A. Eclipse (native)
  B. Client (native)
  C. SAP (GUI)
  D. ABAP (native)
  A. Eclipse (native)
  C. SAP (GUI)

• Question 32:

  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
  B. select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd

• Question 33:

  What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers to this question.

  A. It collects monitoring data asynchronously without additional database interaction.
  B. It schedules ABAP programs to monitor and log all database accesses.
  C. It displays the database execution plan for all SQL statements.
  D. It can be active in a production system with minimal performance overhead.
  A. It collects monitoring data asynchronously without additional database interaction.
  D. It can be active in a production system with minimal performance overhead.

• Question 34:

  What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question

  A. Account-based Profitability
  B. Costing-based Profitability
  C. Product-based Profitability
  D. Service-based profitability
  A. Account-based Profitability
  B. Costing-based Profitability

• Question 35:

  What are the features associated with ABAP CDS? There are 3 correct answers to this question.

  A. Read
  B. Create
  C. Delete/Edit Table
  D. Update
  A. Read
  B. Create
  D. Update

  ---

  Explanation/Reference:

• Question 36:

  Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question.

  A. Get all the data you need on the application server and do your processing in ABAP
  B. Creating and consuming all the contents from network
  C. Keep load from the database
  D. Collect all the data and perform Parallel processing in ABAP
  A. Get all the data you need on the application server and do your processing in ABAP
  C. Keep load from the database

• Question 37:

  Discuss the basic approach of classical ABAP programming. 2 answers

  A. Collect all the data and perform parallel processing in ABAP
  B. Creating and consuming all the contents from network
  C. Get all the data you need on the application server and do your processing in ABAP
  D. Keep load from the database
  C. Get all the data you need on the application server and do your processing in ABAP
  D. Keep load from the database

  ---

  Explanation/Reference:

• Question 38:

  You have created a CDS view as follows: define view zha400 as select from spfli association (*) to sflight as_flights On spfli.carrid =_flights.carrid and spfli.connid=_flights.connid

  {

  ...

  }

  Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?

  A. carrid and _flights.planetype
  B. _ flights.carrid and planetype
  C. carrid and planetype
  D. flights.carrid and _flight.s .planetype
  A. carrid and _flights.planetype

• Question 39:

  You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon Web Service (AWS) trial system. Which plug-ins do you need to add to the existing Eclipse installation?

  A. All plug-ins provided by SAP Development Tools for Eclipse
  B. SAP HANA Tools
  C. ABAP Development Tools for SAP NetWeaver
  D. None; everything is preconfigured
  D. None; everything is preconfigured

• Question 40:

  Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question

  A. Analytic privileges
  B. Package privileges
  C. Application privileges
  D. Object privileges
  E. System privileges
  A. Analytic privileges
  D. Object privileges
  E. System privileges