SAP Certified Development Specialist - ABAP for SAP HANA - Full

You got 19 of 40 possible points.

Your score was: 48 %

Question Results

Question: Score 0 of 1

What are the two layers of ABAP system interacts with its database?
There are 2 correct answers to this question.

Response:

The Database independent interface

The Client database interface

The Data Storage interface

The Database specific library

Question: Score 1 of 1

You have created a CDS view and used aias names for some of its elements. In which of the following
cases is the alias name mandatory?
There are 3 correct answers to this question.

Response:

SUM(revenue) AS total_revenue

CAST('USO' AS abap.cuky) AS currency_key

CASE order type WHEN 'A' THEN 1 ELSE 0 END AS order_type

ASSOCIATION TO sflight AS _flights

 crtdby AS created_by

Question: Score 0 of 1

Your customer wants to migrate to SAP HANA and you want to identify which business processes should
be optimized.

Which of the following steps must you perform to get this information?
There are 2 correct answers to this question.

Response:

Activate the new SQL Monitor in a productive system.

Combine the results of the SQL Monitor with the results of a static source code analysis.

Combine the results of the SQL Monitor with the results of an ABAP runtime analysis.

Activate the new SQL Monitor in a development system.

Question: Score 1 of 1

Which of the following are view annotations for a CDS view?

There are 3 correct answers to this question.

Response:

Access control

Buffering type

Semantics

Client handling

Environment

Question: Score 0 of 1
What are the Guidelines for optimizing ABAP code running on HANA?
There are 3 correct answers to this question.

Response:

Column store

DB specific properties

Open SQL settings

Technical settings

High-speed data analysis

Question: Score 1 of 1

What are the key points that should be kept in mind while performing the Nonautomatic update in SAP
HANA Transport Container?
There are 2 correct answers to this question.

Response:

You need to refresh the content of the container manually

Changes to Delta Container

Take snapshot manually before releasing of the container

Automatic release of units

Question: Score 1 of 1

Which SAP HANA engine executes Calculation view?

There are 2 correct answers to this question.

Response:

OLAP Engine

Calculation Engine
 JOIN Engine

SQL Engine

Question: Score 0 of 1

What are the ABAP development guidelines?

There are 2 correct answers to this question.

Response:

Improved tools for performance analysis

Extensions to ABAP Language

Improved hybrid components for SAP HANA

Consuming Only ABAP contents for SAP HANA

Question: Score 1 of 1

You want to implement business logic on the database layer. Which approach do you follow when
implementing an ABAP Managed Database Procedure?
Please choose the correct answer.

Response:

The Inside-Out approach

The Top-Down approach

The Near-Far approach

The Left-Right approach

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

Response:

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

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

Huge potential to optimize AMDP application DATA Tables

The ability to create new complex processes with ABAP application cloud

Question: Score 1 of 1

Which SAP HANA engine executes Calculation view by default?

Please choose the correct answer.

Response:

Calc Engine

Join Engine

OLAP Engine

SQL Engine

Question: Score 0 of 1

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

There are 3 correct answers to this question.

Response:

Perform expensive calculations on the database.

Perform expensive calculations on the ABAP application server.

Transfer all data from the database to the ABAP layer, and then aggregate the results.
 Use native SQL to access SAP HANA built-in functions.

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

Question: Score 0 of 1

Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?
There are 2 correct answers to this question.

Response:

Content assistance

Screen editing

Quickfix

Form-based class builder

Question: Score 0 of 1

Which system schema contains the list of Activated and inactive Objects?
Please choose the correct answer.

Response:

_SYS_REPO

_SYS_BI

_SYS_XS

_SYS_BIC

Question: Score 0 of 1

What are the different types of Variables in HANA?

There are 3 correct answers to this question.
Response:

Double

Single Value

Interval

Range

Question: Score 1 of 1

What is an attribute view and what are its practices?

There are 3 correct answers to this question.

Response:

May contain filters

Used in diagrammatic Projections

Used to join tables

May use in calculation views

May contains flow charts

Question: Score 1 of 1

You implement an ABAP-managed database procedure (AMDP). Within this 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?

There are 2 correct answers to this question.

Response:

_SYS_ BIC."ha400.primdb::CA_BOOKINGS_COUNT"

"ha400.pr mdb/CA_BOOKINGS_COUNT"
 "ha400.primdb::CA_BOOKINGS_COUNT"

_SYS_ BIC."ha400.prirndb/CA_BOOKINGS_COUNT"

Question: Score 0 of 1

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?

There are 3 correct answers to this question.

Response:

Add explicit client handling.

Specify the schema for every table.

Replace UP TO n ROWS additions.

Replace ORDER BY additions.

Replace CORRESPOND ING FIELDS additions.

Question: Score 0 of 1

An Analytic Privilege consists of several restrictions. What are they?

There are 3 correct answers to this question.

Response:

Activity restrictions

View restrictions

Analytic restrictions

Validity restrictions

Cube restrictions
Question: Score 1 of 1

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.

Response:

Nested CASE expression

Currency Conversion

CASE expression

Unit conversion

CASTE Expression

Question: Score 1 of 1

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

Response:

Database oriented programming model

SAP HANA specific features

Database for sophisticated analysis

New SQL parser used in model

Question: Score 1 of 1

The SAP HANA database is a hybrid in-memory database that combines Few technologies within. What are
these technologies?
There are 3 correct answers to this question.

Response:
 Time-based database technology

Value-based database technology

Object-based database technology

Row-based database technology

Column-based database technology

Question: Score 0 of 1

What are the two main factors of SAP HANA Innovations and Challenges?
There are 2 correct answers to this question.

Response:

HW technology and innovations

SAP BW innovations

SAP SW technology and innovations

DBMS technology and innovations

Question: Score 0 of 1

How will you hide the attributes that are not required for client consumption?
Please choose the correct answer.

Response:

By setting the hidden property flag of the attribute in the Semantics screen

By setting the hidden property flag of the attribute provider

By setting the hidden property flag of the attribute in the View

By setting the hidden property flag of the attribute column

Question: Score 0 of 1

What are the basic principles of ALV SAP HANA?

There are 2 correct answers to this question.

Response:

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

Data described declaratively instead of passing big internal tables

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

Question: Score 1 of 1

You import an ABAP workbench request into an SAP SYSTEM P81. The ABAP workbench request contains
a single SAP HANA VIEW CA_CUSTOMER that belongs to package ZHA400_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.

Response:

SYSTEM P81 has SAP HANA as primary database

PACKAGE ZHA400_00 HAS deployment Mode A

Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK

View CA_CUSTOMER has deployment mode A.

Question: Score 1 of 1

What is the purpose of an ABAP project in ABAP Development tools for eclipse?
There are 2 correct answers to this question.

Response:

It is used to transport ABAP repository objects.

 It represents the connection to the SAP HANA server

It represents the connection to an ABAP system

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

Question: Score 0 of 1

You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data?
There are 3 correct answers to this question.

Response:

Use the tilde symbol (~) to separate qualifier from column name

Explicitly handle the client field

Use a Comma-separated column list

Use the UP TO n ROWS addition

Specify the database schema if it is not the user's default schema

Question: Score 0 of 1

SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANA has to meet.
What are these goals?
There are 2 correct answers to this question.

Response:

High Performance and Scalability

Analytical DBMS features

Hybrid data and management system

Support for system tables

Question: Score 0 of 1

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

Response:

To limit the data footprint

To limit the need of indexes

To limit the unpacking and reconstruction of rows

To allow creation of a full-text index

Question: Score 0 of 1

Which of the following are characteristics of an external view?

There are 3 correct answers to this question.

Response:

It allows access to an SAP HANA information view with Open SQL.

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

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

It defines the underlying SAP HANA information view.

It is an ABAP Dictionary object type.

Question: Score 0 of 1

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

Response:

Quick Fix
 Content Assist

Screen Painter

Form-based Class Builder

Question: Score 1 of 1

In addition to closing the result set, what does the CLOSE method of the CL_SQL_RESULT_SET class when
using ABAP Database Connectivity (ADBC) do?
Please choose the correct answer.

Response:

Update packages

Release resources

Update resources

Release packages

Question: Score 1 of 1

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

Response:

Create Presentations

Create data by members and tables

Swap axes

Insert filter components

Question: Score 0 of 1
Explain Transitioning ABAP Code to SAP HANA – Performance Considerations?
There are 3 correct answers to this question.

Response:

Some codes transferred to other systems

Some codes immediately run faster

Classical performances recommendations for open SQL remain valid

Some codes impacted positively and should be priorities

Some shifts in priorities, examples, nested selects(higher) indices(lower)

Question: Score 1 of 1

What is the Limitations of ALV for SAP HANA?

There are 3 correct answers to this question.

Response:

Restricted to 10,000 records

Restricted to 5000 records / unit

All unit / currency restricted to 10,00,00 records

No unit / currency split if aggregating amounts / currency values

Without currency / unit consideration

Question: Score 1 of 1

What are the steps involved in SAP HANA Evolution?

There are 3 correct answers to this question.

Response:

ABAP applications on SAP HANA

 Optimized ABAP on SAP HANA

ABAP can run on SAP HANA

ABAP can access SAP HANA

ABAP as accelerator on SAP HANA

Question: Score 0 of 1

Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA?
There are 2 correct answers to this question.

Response:

Columnar data storage

Database table compression

Parallel processing

Partitioning

Question: Score 1 of 1

In an ABAP Core Data Services (CDS) view, what must you do to expose an association for use in another
CDS view?
Please choose the correct answer.

Response:

Include all fields used in the ON condition in the project on list.

Specify an alias for the target entity.

Specify the other views in which the association can be used.

Define the cardinality for the target entity.

 Question: Score 0 of 1

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.

Response:

Administer

Configure

Selecting

Organizing

Monitor

Money Back Guarantee Testimonial FAQs Privacy Policy Terms and Conditions About Us Join Us Contact Us