[Q98-Q114] Best Quality E_HANAAW_17 Exam Questions SAP Test To Gain Brilliante Result! : Free Exam Dumps Collection : http://free.examcollectionpass.com

Q98. You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.

Replace UP TO n ROWS additions

Specify the schema for every table

Replace ORDER BY additions

Replace CORRESPONDING FIELDS additions

Add explicit client handling

Q99. Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.

ABAP Dictionary

Open SQL

Core data services (CDS) data definition

Core data services (CDS) access control

Q100. 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.

Q101. What is the operating system supported by HANA? (2 correct answers)

Only Windows 8

Red Hat Enterprise Linux (RHEL)

SUSE Linux Enterprise Server

Both Linux and Window 8

Q102. What are the features of New Open SQL? There are 2 correct answers to this question.

Supports arithmetic and string expressions

Supports Code adjustment model

Supports specific units of database

Supports conditional expressions

Q103. What is the full form of HANA?

High-Performance Analytic Accelerator

High-Performance Analytic Application

High Accelerator Numeric Analytics

High-Performance Analytic Appliance

Q104. You follow the Code-to-Data paradigm in your ABAP coding.
Which of the following scenarios conflicts with the SQL performance guideline “Keep unnecessary load away from the database”?

Perform business logic and aggregations on database table content, then transfer the results to the application layer.

Perform join operations on database tables, then transfer the results to the application layer.

Perform calculations on data transferred to the database layer, then transfer the results back to the application layer.

Perform text search operations on database table content, then transfer the results to the application layer.

Q105. What can you include in the projection list of a Core Data Services (CDS) view? 3 ans

ABAP system fields such as sy-langu or sy-mandt / CI String constants and literal values

Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause

A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause

A field from the projection list of another CDS view used in the FROM clause

Q106. Which is not a Golden Rule for Open SQL? Please choose the correct answer.

Minimize the Number of Database Accesses

Reduce the Database Load

Minimize the Amount of Data Transferred

Keep the result set large

Q107. 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.

Analytical DBMS features

Support for system tables

High Performance and Scalability

Hybrid data and management system

Q108. 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

Q109. In ABAP Development Tools for SAP NetWeaver, you execute the ABAP Test Cockpit on an ABAP program to find performance optimization potential.
Where can you find the result of the static code checks?

In the Problems view

In the Project Explorer view

In the Performance Analysis view

In the Outline view of the ABAP Performance perspective

Q110. What are the different types of Variables in HANA? (3 right answers)

Range

Double

Single Value

Interval

Q111. Which system schema contains the information about Time data and Schema Mapping?

_SYS_REPO

_SYS_BIC

_SYS_BI

_SYS_XS

Q112. 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.

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

In the projection list

In the name list

In the input parameter list

In the FROM clause

In the WHERE and HAVING clauses

Q114. What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

All arithmetic expressions can be used for all type of variables

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

All Keywords are case sensitive.

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