SAP SAP Certifications E_HANAAW_18 Questions & Answers

• Question 171:

  In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? Please choose the correct answer.

  A. Include all fields used in the ON condition in projection list

  B. Specify an alias for the target entity

  C. Define the cardinality for the target entity

  D. Specify the other views in which the association can be used

  Correct Answer: A

• Question 172:

  Where can you consume associations in a Core Data Services (CDS) view? 3 answers

  A. In the projection list

  B. In the name list

  C. In the input parameter list

  D. In the FROM clause

  E. In the WHERE and HAVING clauses

  Correct Answer: ADE

• Question 173:

  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.

  Correct Answer: AD

• Question 174:

  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

  Correct Answer: B