[Feb 09, 2024] E_HANAAW_18 Exam Dumps, E_HANAAW_18 Practice Test Questions [Q17-Q37]

NEW QUESTION 17
You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause? Note: There are 3 correct answers to this question.

SAP HANA views used in the procedure body

functions used in the procedure body

AMDPs used in the procedure body

ABAP Dictionary tables used in the procedure body

ABAP Dictionary views used in the procedure body

NEW QUESTION 18
Which of the following repository objects can you edit only in ABAP Development Tools in Eclipse, and NOT in the classical ABAP Workbench? Note: There are 3 correct answers to this question.

Data Definition

ABAP class with new Open SQL Syntax

Full-text index

Database Procedure Proxy

ABAP class with SQL script coding

NEW QUESTION 19
What is the purpose of an ABAP project in ABAP Development Tools for Eclipse? Note: There are 2 correct answers to this question.

It represents the connection to an ABAP system.

It represents the connection to the SAP HANA server.

It is used to transport ABAP repository objects.

It provides access to all ABAP repository objects in an ABAP system.

NEW QUESTION 20
In a graphical calculation view, you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? Note: There are 2 correct answers to this question.

Create an input parameter for the ADDRESS field.

Exclude the ADDRESS field from the union.

Create a restricted column for the ADDRESS field.

Map the ADDRESS field to a constant value.

NEW QUESTION 21
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?

carrid and planetype

carrid and _flights.planetype

_flights.carrid and planetype

_flights.carrid and_flights.planetype

NEW QUESTION 22
You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement? Note: There are 2 correct answers to this question.

You have to use native SQL when reading data from the secondary DB.

You have to specify the DB connection explicitly in your statement.

You have to specify the DB schema explicitly in your statement.

All tables and fields you are using must exist in the ABAP Dictionary of the secondary DB.

NEW QUESTION 23
You analyze 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 dat a. But the relevant database access is NOT listed in SQLMD. What could be the reason? Note: There are 3 correct answers to this question.

SQL Monitor was activated with a filter that excludes database table Y.

SQL Monitor was activated for a specific application server.

Database table Y is a buffered table.

The data has NOT yet been transferred to the SQL Monitor database tables.

Program X was executed in the background.

NEW QUESTION 24
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 correct answers to this question.

CASE ordertype WHEN ‘A’ THEN 1 ELSE 0 END AS order_type

CAST( ‘USD’ AS abap.cuky ) AS currency_key

crtdby AS created_by

SUM( revenue ) AS total_revenue

ASSOCIATION TO sflight AS .flights

NEW QUESTION 25
You are using ABAP Development Tools, and you have placed your cursor on a method name in a class. What key do you use to navigate between a method definition and its implementation?

NEW QUESTION 26
You define a Core Data Services (CDS) view to merge the results of queries using the UNION keyword. What must the column lists of these queries contain? Note: There are 2 correct answers to this question.

Columns of compatible types

The same number of columns

All key fields

Columns of identical types

NEW QUESTION 27
What are some of the features available for SAP List Viewer with Integrated Data Access (ALV IDA)? Note: There are 3 correct answers to this question.

Group rows

Edit cells

Search in content

Display diagrams

Double-click on rows

NEW QUESTION 28
Which step of the Guided Performance Analysis should you perform in the production system?

Executing a check run with ABAP Test Cockpit (ATC)

Collecting data with SQL Monitor (SQLM)

Performing an inspection with Code Inspector (SCI)

Building a work list with SQL Performance Tuning Worklist (SWLT)

NEW QUESTION 29
You created and activated a database procedure. From where can you call this procedure? Note: There are 2 correct answers to this question.

From a Script-based calculation view

From a Core Data Services view

From a graphical calculation view

From another database procedure

NEW QUESTION 30
You developed an ABAP Managed Database Procedure (AMDP). You want to allow the enhancement of this AMDP using a Business Add-In (BAdI). Which of the following objects must you create? Note: There are 3 correct answers to this question.

A BAdI fallback implementation

A BAdI definition

A database procedure

An enhancement spot

A BAdI sample implementation

NEW QUESTION 31
What must you take into consideration when you use the new Open SQL syntax (available as of SAP NetWeaver 7.4 SP05)? Note: There are 2 correct answers to this question.

All classical open SQL statements in your program will become invalid.

All ABAP variables must be escaped with a preceding @ sign.

All fields in the GROUP BY clause must be separated by commas.

All arithmetic expressions can be used for all types of variables.

NEW QUESTION 32
How many result sets are returned when an SAP HANA database procedure is called using the CALL…WITH OVERVIEW statement?

Two result sets

As many result sets as there are table output parameters in the procedure

One result set

As many result sets as there are input parameters in the procedure

[Feb 09, 2024] E_HANAAW_18 Exam Dumps, E_HANAAW_18 Practice Test Questions [Q17-Q37]

Leave a Reply Cancel reply

E_HANAAW_18 Practice Tests

Related Certifications

Recent Posts

Categories

Archives