Labour Day Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

  1. Home
  2. SAP
  3. SAP Certified Development Specialist
  4. E_HANAAW_17
  5. SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Questions and Answers
Note! The E_HANAAW_17 Exam is no longer available.

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

Questions 4

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

Options:

A.

Range

B.

Double

C.

Single Value

D.

Interval

Buy Now
Questions 5

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.

Options:

A.

Direct access to a cluster on the database

B.

Left outer joins in open SQL statements

C.

Native SQL statements

D.

Code that relies on implicit database sorting

E.

ORDER BY Clauses in Open SQL statements

Buy Now
Questions 6

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

Options:

A.

Java

B.

ABAP

C.

C#

D.

SQL

Buy Now
Questions 7

The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.

Options:

A.

Avoid idiling CPU cores

B.

Avoid CPU cache misses

C.

Avoid optimizing data

D.

Avoid single network

Buy Now
Questions 8

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.

Options:

A.

UNION specific syntax errors

B.

Database platform syntax errors

C.

Database independent syntax errors

D.

HANA specific syntax errors

E.

SQLScript errors

Buy Now
Questions 9

User STUDENT_A creates and activates a design-time Object. In which schema is the runtime object generated?

Options:

A.

SYS_BI

B.

SYSTEM

C.

_SYS_BIC

D.

STUDENT_A

Buy Now
Questions 10

What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

Options:

A.

Use Schema for the Connections

B.

Maintain, Monitor and test secondary database connection

C.

Maintain only HANA specific objects

D.

Used to access local or remote database system

Buy Now
Questions 11

In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement? Please choose the correct answer.

Options:

A.

ROW

B.

GLOBAL TEMPORARY

C.

COLUMN

D.

LOCAL TEMPORARY

Buy Now
Questions 12

HANA modeling views can be created under

Options:

A.

Catalog

B.

Schema

C.

File System

D.

Content

Buy Now
Questions 13

Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 ans

Options:

A.

FOR db (db = HDB...)

B.

LANGUAGE dbjang (dbjang = SQLSCRIPT...)

C.

BY DATABASE PROCEDURE

D.

CLIENT SPECIFIED

E.

AUTHORIZATION db_auth (db_auth = SYSTEM ...)

Buy Now
Questions 14

What is Core Data Services (CDS)?

Options:

A.

A collection of services that provide information about the data volumes of the SAP HANA core tables

B.

A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system

C.

A collection of core features and services that provide data from the ABAP application server layer to the user interface

D.

A collection of domain-specific languages and services for definition and consumption of semantically rich data models

Buy Now
Questions 15

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

Options:

A.

Only Windows 8

B.

Red Hat Enterprise Linux (RHEL)

C.

SUSE Linux Enterprise Server

D.

Both Linux and Window 8

Buy Now
Questions 16

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

Options:

A.

Currency conversion is not applicable

B.

Join fact tables

C.

Read Data from the joined database tables

D.

Used to Joined table

Buy Now
Questions 17

What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question

Options:

A.

Delimited identifiers

B.

Limited identifiers

C.

Undelimited Identifiers

D.

Numeric identifiers

Buy Now
Questions 18

Which SQL syntax is used to create a read only procedure?

Options:

A.

READS SQL DATA

B.

READS PROCEDURE

C.

NO-SIDE-EFFECT

D.

READ-ONLY

Buy Now
Questions 19

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

Buy Now
Questions 20

What is the system privilege required to drop analytic privilege?

Options:

A.

CREATE STRUCTURED PRIVILEGE

B.

STRUCTUREDPRIVILEGE ADMIN

C.

PRIVILEGE ADMIN

D.

CREATE PRIVILEGE

Buy Now
Questions 21

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

Options:

A.

Read

B.

Create

C.

Delete/Edit Table

D.

Update

Buy Now
Questions 22

What are the types of schemas in HANA? (3 correct)

Options:

A.

System Defined Schema

B.

User Defined Schema

C.

SLT Derived Schema

D.

Dynamic Schema

Buy Now
Questions 23

You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call? Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.

Options:

A.

SET_PARAM_TABLE

B.

SET_PARAM

C.

EXECUTE_QUERY

D.

NEXT_PACKAGE

Buy Now
Questions 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.

Buy Now
Questions 25

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

Options:

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

Buy Now
Questions 26

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

Options:

A.

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

B.

Integrates with SAP Solution Manager

C.

Integrated into ABAP Development Tools and ABAP Workbench

D.

ABAP source code with performance optimization potential

Buy Now
Exam Code: E_HANAAW_17
Exam Name: SAP Certified Development Specialist - ABAP for SAP HANA 2.0
Last Update: Mar 26, 2024
Questions: 174