March Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

E_HANAAW_17 Questions and Answers

Question # 6

Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.

A.

CDS View

B.

Database procedure

C.

External view

D.

Database Table

E.

Internal table

Full Access
Question # 7

ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question.

A.

Data Manipulation Language

B.

The Data Control Language

C.

The Database Language

D.

The Data Definition Language

E.

Data Transferred Language

Full Access
Question # 8

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

A.

SQLScript can be better modularized than traditional SQL

B.

SQLScript code can easily be translated into modeling view

C.

SQLScript is faster than traditional SQL

Full Access
Question # 9

Which system schema contains the list of Activated and inactive Objects?

A.

Used to access local or remote database system

B.

Maintain, Monitor and test secondary database connection

C.

Use Schema for the Connections

D.

Maintain only HANA specific objects

Full Access
Question # 10

You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP

HANA is used as the db

In the check parameters, which value would you use for the percentage of fields that are effectively used?

Please choose the correct answer.

A.

A value that you calculate based on the number of tables

B.

A higher value than on a traditional, row-store only based database

C.

A lower value than on a traditional, row-store only based database

D.

The same value as on a traditional, row-store only based database

Full Access
Question # 11

You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.

A.

View CA_CUSTOMER has deployment mode A.

B.

Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK

C.

SYSTEM P81 has SAP HANA has primary database

D.

PACKAGE ZHA400J30 HAS deployment Mode A

Full Access
Question # 12

You define and implement an AM DP. What do you have to list after the USING clause? There are 3 correct answers to this question.

A.

ABAP dictionary tables used in procedure body

B.

ABAP dictionary views used in procedure body

C.

CE function used in procedure Body

D.

AMDP Used in Procedure Body

E.

SAP HANA views used in procedure body

Full Access
Question # 13

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

A.

Display diagrams

B.

Double-click on rows

C.

Search in content

D.

Edit cells

E.

Group rows

Full Access
Question # 14

Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?

A.

Standard Web Dynpro checks

B.

Search for DB operations across modularization units

C.

SELECT statements that bypass the table buffer

D.

Use of the ADBC interface

Full Access
Question # 15

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?

A.

Code completion options

B.

Code formatting options

C.

Statement template options

D.

Editor shortcut key options

Full Access
Question # 16

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

A.

Supports arithmetic and string expressions

B.

Supports Code adjustment model

C.

Supports specific units of database

D.

Supports conditional expressions

Full Access
Question # 17

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

A.

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

B.

It represents the connection to an ABAP system

C.

It represents the connection to the SAP HANA server

D.

It is used to transport ABAP repository objects

Full Access
Question # 18

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

A.

May contain filters

B.

Used in diagrammatic Projections

C.

May use in calculation views

D.

Used to join tables

E.

May contains flow charts

Full Access
Question # 19

You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon Web Service (AWS) trial system. Which plug-ins do you need to add to the existing Eclipse installation?

A.

All plug-ins provided by SAP Development Tools for Eclipse

B.

SAP HANA Tools

C.

ABAP Development Tools for SAP NetWeaver

D.

None; everything is preconfigured

Full Access
Question # 20

You implement an ABAP-managed database procedure (AMDP). You want to query data from Calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb.

How can you address the calculation view?

Note; There are 2 correct answers to this questions.

A.

"ha400.primdb/CA_BOOKINGS_COUNT"

B.

_SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT"

C.

"ha400.primdb::CA_BOOKINGS_COUNT"

D.

_SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT"

Full Access
Question # 21

Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question.

A.

Get all the data you need on the application server and do your processing in ABAP

B.

Creating and consuming all the contents from network

C.

Keep load from the database

D.

Collect all the data and perform Parallel processing in ABAP

Full Access
Question # 22

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

A.

It deletes obsolete versions of the database procedure synchronously

B.

It deletes obsolete versions of the database procedure asynchronously

C.

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

D.

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

Full Access
Question # 23

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 24

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

A.

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

B.

The ability to create new complex processes with ABAP application cloud

C.

Huge potential to optimize AMDP application DATA Tables

D.

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

Full Access
Question # 25

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.

A.

Database Optimization

B.

Transparent Optimizations

C.

HANA Specific features

D.

Buffer system Optimization

Full Access
Question # 26

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

A.

Use the enhanced options in transaction SE11.

B.

Use the fuzzy-search exit in transaction SE11.

C.

Modify the search help with the Native SQL command ALTER SEARCH HELP.

D.

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

Full Access