SAP E_HANAAW_16 SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Online Training

Passing SAP E_HANAAW_16 exam can effectively help you entrench yourself and enhance your status in this competitive IT area. In our Exam4Training you can get the related SAP E_HANAAW_16 SAP Certified Development Specialist – ABAP for SAP HANA 2.0 Online Training. Our Exam4Training IT experts team will timely provide you the accurate and detailed training materials about SAP Certified Development Specialist E_HANAAW_16 exam. Through the SAP E_HANAAW_16 SAP Certified Development Specialist – ABAP for SAP HANA 2.0 Online Training provided by Exam4Training, we can ensure you have a successful challenge when you are the first time to participate in the SAP Certified Development Specialist – ABAP for SAP HANA 2.0 exam.

Page 1 of 7

1. What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to his question

To reduce main memory consumption and to improve insert performance

to keep all the loads away from the DB

It is beneficial to move data-intensive calculations into the database

It is beneficial for maximizing your search into database

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

3. Which system schema/user is the owner of all the activated objects?

_SYS_XS

_SYS_BI

_SYS_REP0

_SYS_BIC

4. Which of the following information is mandatory in the definition of an association in a Core Data Services (CDS) view?

The filter condition for the association

The cardinality of the association

The alias for the association

The target entity of the association

5. How can you enhance an existing ABAP Search Help with a type-ahead function?

Use the enhanced options in transaction SE11.

Use the fuzzy-search exit in transaction SE11.

Modify the search help with the Native SQL command ALTER SEARCH HEL

Enhance the lookup table with an additional ACCURACY field and insert an accuracy value.

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

7. Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question.

Use the DDL statement DEFINE VIEW and SQL like Syntax

Create a data definition in your ABAP package

Create a proxy object for the defined view.

Specify the name of the SQL view in ABAP Dictionary

Define the type mapping between ABAP and SAP HANA

8. List down the three main concepts of the SAP HANA database There are 3 correct answers to this question

Column Store

Tools combinations

Object store

Partitioning

Compression

9. Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.

Create a new version of the database when the AMDP is first activated

Delete the obsolete versions of the database procedure synchronously

Delete the obsolete versions of the database procedure asynchronously

Create a new version of the database when the AMDP is first called

10. Which of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 ans

CL_SQL_EXECUTE_QUERY

CL_SQL_RESULT_SET

CL_SQL_STATEMENT

CL_EXEC_SQL

CL_ADBC_SQL_STATEMENT

Page 2 of 7

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

Automatic release of units

Changes to Delta Container

You need to refresh the content of the container manually

Take snapshot manually before releasing of the container

12. AM DP can detect 3 types of syntax errors in active or inactive source code .

What are these errors? There are 3 correct answers to this question.

UNION specific syntax errors

Database platform syntax errors

Database independent syntax errors

HANA specific syntax errors

SQLScript errors

13. What are the advantages of column based tables? (3 correct answers)

Bigger Data Set

Better Compression

Better parallel Processing

Faster Data Access

14. Name the views that are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question

The Landscape view

The System Monitor view

The Security view

The Administration view

15. What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question

Active clusters for all servers

Shared file systems for only one server

Services-Name and index server on all nodes

High availability configuration

16. Which conditional expressions can be used in Core Data Services (CDS) views? 2 ans

CASE statements in the projection list

IF statements in the projection list

WHILE statements in the WHERE clause

COALESCE functions in the projection list

CASE statements in the HAVING clause

17. What are the basic principles of ALV SAP HANA? There are 2 correct answers to this question.

Data described declaratively instead of passing big internal tables

The ALV Optimization for SAP HANA to display data on the screen

Only retrieve the database data which is to be displayed on screen

To ensure that the user chooses the data on the selection screen is displayed

18. You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings table? Why do you create a row store instead of a column store Please choose the correct answer.

To allow creation of a full-text index

To limit the unpacking and reconstruction of rows

To limit the need of indexes

To limit the data footprint

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

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

Page 3 of 7

21. Which of the statements are true for SQLScript? (2 answers)

SQLScript is an open standard.

SQLScript is used to push down data intensive logic into the database.

SQLScript is a collection of extensions to SQ

22. Which of the following is true?

ABAP

OSQL

Oc#

Java

23. You define a core data services (CDS) View.

For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question.

CASTE Expression

CASE expression

Currency Conversion

Nested CASE expression

Unit conversion

24. What should you do to follow the code-to-data approach to programming? 2 ans

Perform expensive calculations on the database

Transfer all data from the database to the ABAP layer, and then aggregate the results.

Perform expensive calculations on the ABAP application server.

Aggregate data on the database, and transfer the results to the ABAP layer.

25. Graphical calculation views can later be converted to Scripted calculation view if required.

Ono

yes

26. How will you select a preference for Validation rules? Choose the correct answer

Windows- SAP HANA-Modeler-Preferences-Validation Rules

Windows- Preferences-SAP HANA-Modeler-Validation Rules

Windows- Modeler- Preferences-SAP HANA-Validation Rules

Windows- SAP HANA-Preferences-Modeler-Validation Rules

27. Hybrid Data Management System - Combining different paradigms in one system. Discuss capabilities associated with the

Hybrid Data Management system?

There are 3 correct answers to this question.

Built-in support for planning

Text analysis and search

Text indexing capabilities

Traditional disk-based tables

Linguistic search capabilities

28. What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question.

A set of open, language- and platform-independent APIs

A brand new ABAP development experience on top of the Eclipse platform

An open platform for developing new ABAP-related tools

An open platform for developing powerful database view

A set of Eclipse data pool and Client- Open platform

29. What language one should know to work in SAP HAN A?

Java

ABAP

SQL

30. What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer.

Code execution

Quick Fix

Debug perspective

ABAP debugger

Page 4 of 7

31. What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers)

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

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

32. What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers to this question.

Scaling

Optimize

Detect

Innovate

Tuning

33. What is the full form of HANA?

High-Performance Analytic Accelerator

High-Performance Analytic Application

High Accelerator Numeric Analytics

High-Performance Analytic Appliance

34. What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are 3 correct answers to this question.

Display diagrams

Double-click on rows

Search in content

Edit cells

Group rows

35. Which statement is true for SAP HANA?

SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners

SAP provides both hardware and software for SAP HAN

36. Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? There are 2 correct answers to this question.

Documented checks

Enhanced distribution of results

Configuration of check variants

Flexible schedule of check runs

37. Which of the following is not an element of Analytical view? Please choose the correct answer.

Currency conversion is not applicable

Join fact tables

Read Data from the joined database tables

Used to Joined table

38. You developed an ABAP program using ABAP Development Tools for SAP NetWeaver .

How can you execute it? 2 ans

In the Project Explorer view, right-click the program and choose Run As ― ABAP Application from the context menu.

Use the Open Development Object dialog (CTRL+SHIFT+A) and enter <Program_Name>/Execute in the search field.

Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8.

Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl.

Call transaction SRUN_ADT and enter the name of the ABAP program.

39. Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL? Please choose the correct answer.

SAP HANA specific features

Database oriented programming model

New SQL parser used in model

Database for sophisticated analysis

40. What is an attribute view and what are its practices? There are 3 correct answers to this question.

May contain filters

Used in diagrammatic Projections

May use in calculation views

Used to join tables

May contains flow charts

Page 5 of 7

41. Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement .

Which of the following changes to the SELECT statement can you use to retrieve the same data as before?

There are 2 correct answers to this question

Include the client field in the field list.

Include the client field in the WHERE condition.

Include the client field in the join condition.

Use the CLIENT SPECIFIED addition.

42. What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question.

Sales

Procurement

Stock

Services

Product

43. What is the main advantage of SQLScript? (2 answers)

SQLScript can be better modularized than traditional SQL

SQLScript code can easily be translated into modeling view

SQLScript is faster than traditional SQL

44. You plan a database migration to SAP HANA and want to check your ABAP coding for potential functional regressions.

Which Code Inspector check variant can you use?

PREV_FUNC_REG

FUNCTIONAL_DB

FUNCTIONAL_CHECK

PERFORMANCE DB

45. In which of the following situations could a row store table be more suitable than a column store table? There are 2 correct answers to this question

The table contains data that you want to aggregate.

The table contains mainly distinct values per column across rows.

The table contains text that you want to search.

The table contains only a small number of records.

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

select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd

select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd

select from snwd_so {sojd, sum(net_amount) as sum_amount}

select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount

47. ANSI SQL owns features and adds languages. These languages divided into three parts.

What are they? There are 3 correct answers to this question.

Data Manipulation Language

The Data Control Language

The Database Language

The Data Definition Language

Data Transferred Language

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

49. What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.

Server based on SAP HANA

Innovation based on SAP HANA

New or Native SAP HANA

Data Mart based on SAP HANA

50. Which features does the source code editor provide in ABAP Development Tools (ADT)? There are 2 correct answers to this question.

Quick Fix

Screen Painter

Content Assist

Form-based Class Builder

Page 6 of 7

51. In order to get language-specific data, which join is used in SAP HANA?

Referential Join

Language join

Text Join

It is not possible to fetch language-specific data in HANA

52. Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 ans

SQLM

SE09

SWLT

ST22

SE3S

53. What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment? There are 3 correct answers to this question.

Organizing

Administer

Configure

Monitor

Selecting

54. Which engine is used to execute Analytic View?

SQL Engine

Calc Engine

OLAP Engine

Join Engine

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

56. Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question

HANA Accelerators

All HANA Combinations on one platform

HANA Modeling

All SAP applications on one SAP HANA platform

Business Suite on HANA/ BW on SAP HANA

57. According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?

Perform regular performance scans on your ABAP custom coding as part of the development process.

Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process.

Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5.

Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion.

58. What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer

The SAP HANA database supports login of Owners only

To support scenarios where clients are not directly connected to the SAP HANA Database

The assertion is issued by a user after the client was successfully authenticated

SAML may be selected as an Owner's authentication method when creating users in the SAP HANA Studio

59. When are referential joins executed in analytical views? Choose the correct answer

When all the tables are optimized

When fields are selected

When fields are optimized

When fields from both the tables are requested

60. Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? There are 3 correct answers to this question.

De-pooling and de-clustering

Changes of data class

Definition of full-text indexes

Definition of an enhancement category

Storage type for tables

Page 7 of 7

61. What is the main function of Static Code Analysis? Please choose the correct answer.

To detect code that would lead to functional or performance issues When migrating to SAP HANA

Integrates with SAP Solution Manager

Integrated into ABAP Development Tools and ABAP Workbench

ABAP source code with performance optimization potential

62. Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?

"Map to Data source"

"Consume CDS view"

"Relate to Business Entity"

"Read from DDL source"

63. What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.

Process on all the input fields

Automatic updates of all the input fields

Check Pre-Requisites

Identify Elementary Search Help

Switch on proposal search for input fields

64. Which of the following are characteristics of an external view? There are 3 correct answers to this question.

It can be used as a data type in ABAP programs.

It defines the underlying SAP HANA information view.

It can be used in Open SQL statements for database updates.

It is an ABAP Dictionary object type.

It allows access to an SAP HANA information view with Open SQ

65. Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.

Data base performance monitor (transaction DB50)

Code inspector (transaction SCI)

SQL Trace (transaction ST05)

SQL monitor (transaction SQLM)

ABAP test cockpit (transaction ATC)

66. The source code editor in ADT provides many helpful features .

What are these helpful features? There are 2 correct answers to this question.

Creating Method Implementations from the Method Definition

Creating interface from Method Calls

Creating Method Definitions from Implementation Parts

Creating Parts for Interface Methods

67. Which recent software innovations are applied in SAP HANA? 3 ans

Columnar data storage

Automated de-installation at system shutdown

Improved data compression algorithms

Insert Only approach

Random Undefined Multi-Memory Swapping (RUMMS)

68. What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question.

Read

Create

Delete/Edit Table

Update

69. Which of the following can be part of an analytic view? (3 answers)

Query transformation

Logical joins

Attributes

Data foundation

Unions

70. What made SAP HANA possible?

There are 2 correct answers to this question.

Improved hardware technology

CPU with single core network

RAM limitation

Technology and innovations

Latest E_HANAAW_16 Dumps Valid Version with 237 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Instant Download E_HANAAW_16 PDF