Exit demo E_HANAAW_17 Certified Development Specialist - ABAP for SAP HANA 2.0 PDF format · free preview

SAP E_HANAAW_17 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/e-hanaaw-17.html

Question 1
Single choice

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

Question 2
Multiple choice

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.

Question 3
Multiple choice

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

Question 4
Single choice

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

Question 5
Multiple choice

SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANAhas to meet.
What are these goals?

There are 2 correct answers to this question.

A.

Analytical DBMS features

B.

Support for system tables

C.

High Performance and Scalability

D.

Hybrid data and management system

Question 6
Single choice

How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?

A.

Use the static method use_features of class cl_abap_dbfeatures.

B.

Perform a static code check using the FUNCTIONAL_DB variant.

C.

Check the Open SQL statement in the Explain SQL Statement transaction (SDBE).

D.

Check the value of the ABAP system field sy-cdsfeatures.

Question 7
Single choice

You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call.

Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.

A.

SET_PARAM_TABLE

B.

SET_PARAM

C.

EXECUTE_QUERY

D.

NEXT_PACKAGE

Question 8
Multiple choice

What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.

A.

Automatic release of units

B.

Changes to Delta Container

C.

You need to refresh the content of the container manually

D.

Take snapshot manually before releasing of the container

Question 9
Single choice

You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statement check. What does this check report? Please choose the correct answer.

A.

SELECT * statements where fewer than a specified percentage of all fields are effectively used

B.

SELECT * statements on tables with more than a specified number of fields

C.

SELECT * statements on tables with more than 100,000 records

D.

SELECT * statements on tables with the Column Store storage type

Question 10
Single choice

What is the central goal of using SAP HANA? Please choose the correct answer

A.

Positive Impact on Business

B.

Accelerate Performance

C.

To set Priorities for system

D.

Monitor database for record keeping

Showing 10 of 174 questions · Unlock the full set