[Jun-2022] Dumps Practice Exam Questions Study Guide for the E_HANAAW_17 Exam [Q14-Q31]

Rate this post

[Jun-2022] Dumps Practice Exam Questions Study Guide for the E_HANAAW_17 Exam

E_HANAAW_17 Dumps with Practice Exam Questions Answers

NEW QUESTION 14
Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)?
There are 3 correct answers to this question.

Returning

Receiving

Exporting

Changing

Importing

NEW QUESTION 15
Which of the following is true? (2 correct answers)

A read only procedure cannot call read-write procedure.

A Read-write procedure cannot call another read-write procedure.

A read-write procedure can call both read-write and read only procedures.

NEW QUESTION 16
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.

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

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

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

SELECT * statements on tables with the Column Store storage type

NEW QUESTION 17
One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.

Direct access to a cluster on the database

Left outer joins in open SQL statements

Native SQL statements

Code that relies on implicit database sorting

ORDER BY Clauses in Open SQL statements

NEW QUESTION 18
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.

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

SUM( revenue ) AS total_revenue

Crtdby AS created_by

CASE order type WHEN ‘A’ THEN 1 ELSE 0 END AS Order_type

ASSOCIATION TO sflight AS_flights

NEW QUESTION 19
What are functions of the ABAP Managed Database Procedure (AMDP) framework? (2 right answers)

It deletes obsolete versions of the database procedure synchronously

It deletes obsolete versions of the database procedure asynchronously

It creates the database procedure when the AMDP is first called.

It creates the database procedure when the AMDP is first activated.

NEW QUESTION 20
What language one should know to work in SAP HAN A?

Java

ABAP

SQL

NEW QUESTION 21
You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench?

Code completion options

Code formatting options

Statement template options

Editor shortcut key options

NEW QUESTION 22
Which SAP HANA engine executes Calculation view? (2 answers)

OLAP Engine

Calculation Engine

SQL Engine

JOIN Engine

NEW QUESTION 23
Which character is used to escape host variables in the new Open SQL syntax?

* (asterisk)

@ (at)

: (colon)

~ (tilde)

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

Eclipse (native)

Client (native)

SAP (GUI)

ABAP (native)

NEW QUESTION 25
Which system schema/user is the owner of all the activated objects?

_SYS_XS

_SYS_BI

_SYS_REP0

_SYS_BIC

NEW QUESTION 26
Which code-to-data capability is responsible for the Optimizations & Translation of “Open SQL SELECT FOR ALL ENTRIES clauses into native SQL?. Please choose the correct answer.

Database Optimization

Transparent Optimizations

HANA Specific features

Buffer system Optimization

NEW QUESTION 27
What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question.

Calculate aggregations using ABAP code on the application server to limit database load

Eliminate nested SELECT statements to reduce the overall number of database accesses

Use a column list in the SELECT clause to ensure that you only read a column if it is really required

Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required

NEW QUESTION 28
What do you understand by the SAP HANA Software Optimization? Please choose the correct answer.

Speed up the processing within the database

Bring logic to where the data is calculated first then only move to results

Provide combinations of objects and partitioning

Huge potential for hybrid database

NEW QUESTION 29
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.

Read-write

Read only

Write only

Read-update

NEW QUESTION 30
What output does the SAP HANA provide as a unique combination of hardware and software innovations? Please choose the correct answer.

Huge potential to optimize business applications that are running on SAP HANA

The ability to create new complex processes with ABAP application cloud

Huge potential to optimize AMDP application DATA Tables

Huge potential to maximize the number of disk blocks in the application

NEW QUESTION 31
Which of the following is a limitation when you create an external view? Please choose the correct answer.

You must include the name of the SAP HANA view in the name of the external view.

You can only use native SQL to consume the external view

You must know the underlying tables and join conditions of the SAP HANA view.

You must use the ABAP Development tools (ADT) TO CREATE the external view

Loading …