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

SAP E_HANAAW_17 SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Exam Practice Test

Demo: 26 questions
Total 174 questions

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Questions and Answers

Question 1

What is the language SAP HANA is developed in?

Options:

A.

Assembly

B.

O

C.

C++

D.

Java

Question 2

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.

Options:

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

Question 3

Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Choose the correct answer

Options:

A.

Create data by members and tables

B.

Insert filter components

C.

Swap axes

D.

Create Presentations

Question 4

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

Options:

A.

Bigger Data Set

B.

Better Compression

C.

Better parallel Processing

D.

Faster Data Access

Question 5

Which of the following is true?

Options:

A.

ABAP

B.

OSQL

C.

Oc#

D.

Java

Question 6

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

Options:

A.

Display diagrams

B.

Double-click on rows

C.

Search in content

D.

Edit cells

E.

Group rows

Question 7

What are the different types of Calculation View? (2 answers)

Options:

A.

OLAP Calculation View

B.

Graphical Calculation View

C.

Scripted Calculation View

D.

Text-Based Calculation

Question 8

You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes. In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer.

Options:

A.

Open the SAP HANA transport containerSelect take snapshot and Save

Activate the SAP HANA Transport Container

B.

Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit

Activate the SAP HANA transport container

C.

Open the ABAP transport request Select take snapshot and Save

Activate the SAP HANA transport container

D.

Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit

Activate the SAP HANA transport container

Question 9

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? There are 2 correct answers to this question.

Options:

A.

Create an input parameter for the ADDRESS field

B.

Exclude the ADDRESS field from the union

C.

Create a restricted column for the ADDRESS field

D.

Map the ADDRESS field to a constant value

Question 10

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

Options:

A.

SQLM

B.

SE09

C.

SWLT

D.

ST22

E.

SE3S

Question 11

How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?

Options:

A.

Use the static method use_features of class cl_abap_dbfeatures.

B.

Perform a static code check using the FUNCTIONAL_DB variant.

C.

Check the Open SQL statement in the Explain SQL Statement transaction (SDBE).

D.

Check the value of the ABAP system field sy-cdsfeatures.

Question 12

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.

Options:

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"

Question 13

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 14

You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

Options:

A.

:it_books

B.

it_books

C.

{it.books}

D.

@it_books

Question 15

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

Options:

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

Question 16

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.

Options:

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

Question 17

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

Options:

A.

Query transformation

B.

Logical joins

C.

Attributes

D.

Data foundation

E.

Unions

Question 18

You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question.

Options:

A.

By another database procedure

B.

By using Sap Analysis for Microsoft office

C.

By a script-based calculation view

D.

By a core data services view

Question 19

How can you exchange SQL Monitor data between two systems?

Options:

A.

Create a snapshot of the SQL Monitor data, export it to the file system, and then import it to the target system.

B.

Deactivate the SQL Monitor in the source system and activate the SQL Monitor in the target system.

C.

Configure a secondary database connection to the target system and query the data in the SQL Monitor.

D.

Create and release a transport request containing the SQL Monitor log files.

Question 20

You analyse 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 data. But the relevant

database access is NOT listed in SQLMD.

What could be the reason?

Note: There are 3 correct answers to this question.

Options:

A.

SQL Monitor was activated for a specific application server

B.

SQL monitor was activated with a filter that excludes database table Y

C.

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

D.

Program X was executed in the background.

E.

Database table Y is a buffered table.

Question 21

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

Options:

A.

HANAAccelerators

B.

All HANA Combinations on one platform

C.

HANA Modeling

D.

All SAP applications on one SAP HANA platform

E.

Business Suite on HANA/ BW on SAP HANA

Question 22

You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? (Choose Two)

Options:

A.

It has syntax check as compile time.

B.

It supports exception handling

C.

It supports locking and commit handling

D.

It supports where-used list.

Question 23

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

Options:

A.

Perform expensive calculations on the database

B.

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

C.

Perform expensive calculations on the ABAP application server.

D.

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

Question 24

Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA?

Note: There are 2 correct answers to this question.

Options:

A.

Keep unnecessary load away from the database.

B.

Minimize the number of database accesses

C.

Minimize the amount of transferred data

D.

Minimize the search overhead.

Question 25

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

Options:

A.

Columnar data storage

B.

Automated de-installation at system shutdown

C.

Improved data compression algorithms

D.

Insert Only approach

E.

Random Undefined Multi-Memory Swapping (RUMMS)

Question 26

You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer.

Options:

A.

Choose the debug as option in the context menu of the ABAP program

B.

Create a debug configuration for the ABAP application and run the program

C.

Set a breakpoint in the ABAP program and execute the program

D.

Choose the Run --> Debug options in the menu

Demo: 26 questions
Total 174 questions