SAP Certified Development Specialist - ABAP for SAP

HANA - Full

You got 39 of 40 possible points.

Your score was: 98 %

Question Results

Question: Score 1 of 1

What are the different views provided by the ABAP Profiling?

There are 2 correct answers to this question.

Response:

Performance Check methods

Database accesses

Metadata accesses

A Hitlist of the most time-consuming programs or methods

Question: Score 1 of 1

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

Response:

Include all fields used in the ON condition in projection list

 SPECIFY THE OTHER VIEWS IN WHICH THE ASSOCIATION CAN BE USED

define the cardinality for the target entity

specify an alias for the target entity

Question: Score 1 of 1

You define a core data services (CDS) view to merge the results of queries
using the UNION keyword. What must the column list of this queries
contain?
There are 2 correct answers to this question.

Response:

Columns of compatible types

The same number of columns

Columns of identical types

All key fields

Question: Score 1 of 1

DB-Specific Properties that allows switching between storage types when

running on an SAP HANA database. What are these storage types?

There are 2 correct answers to this question.

Response:

Column store

Re-use component store

Technology store
 Development Store

ROW store

Question: Score 1 of 1

What are the principles of Using HANA Transport Containers properly?

There are 3 correct answers to this question.

Response:

Takes a ‘snapshot’ of all SAP HANA objects of delivery unit

To create Transport container of delivery unit

Release of Transport request

Import of Transport Request

Automatic update for all export methods

Question: Score 1 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 allow creation of a full-text index

To limit the need of indexes

To limit the unpacking and reconstruction of rows

To limit the data footprint

Question: Score 1 of 1

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.

Response:

{it_books}

@it_books

:it_books

it_books

Question: Score 1 of 1

You define and implement an ABAP Managed database procedure (AMDP).

What do you have to list after the USING clause?
There are 3 correct answers to this question.

Response:

AMDP used in the procedure body

ABAP Dictionary views used in the procedure body

SAP HANA views used in the procedure body

ABAP Dictionary table used in the procedure body

CE function used in the procedure body

Question: Score 1 of 1

What must you take into consideration when you use the new open SQL
syntax (available as of SAP Net weaver 7.4 SP05)?
There are 2 correct answers to this question.

Response:

All ABAP variables must be escaped with a proceeding @ sign.

All arithmetic expressions can be used for all type of variables.

All fields in the GROUP BY clause must be separated by commas.

All Keywords are case sensitive.

Question: Score 1 of 1

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.

Response:

Text analysis and search

Text indexing capabilities

Built-in support for planning

Traditional disk-based tables

Linguistic search capabilities

Question: Score 1 of 1
Discuss the main capabilities of SAP BusinessObjects Analysis for Office?

There are 2 correct answers to this question

Response:

Convert crosstab cells to formula

Sort data by characteristics

Suggests style sets for crosstabs

Analyze data with the design panel

Question: Score 0 of 1

What are the steps that supported several tools, which in total result in a
Guided Performance Optimization?

There are 2 correct answers to this question.

Response:

A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate
potential functional and performance issues.

The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and
compare runtime consumption

A new tool called SQL Monitor to determine the priority if different programs
access the database intensively

Tools analyzing performance at run-time, to determine if critical constructs

Question: Score 1 of 1

What are the elements of ABAP Database Integration?

There are 3 correct answers to this question.

Response:

DB client-server

DB For ABAP

Other DB

Application server

Client database handling

Question: Score 1 of 1

The SAP HANA state-of-the-art search experience includes full-text search

with advanced features like...

There are 3 correct answers to this question.

Response:

Fuzzy search

linguistic search

Isolation search

freestyle search

ACID search

Question: Score 1 of 1

What are the Guidelines for optimizing ABAP code running on HANA?

There are 3 correct answers to this question.

Response:
 Column store

High-speed data analysis

Open SQL settings

Technical settings

DB specific properties

Question: Score 1 of 1

Explain Transitioning ABAP Code to SAP HANA – Performance

Considerations?

There are 3 correct answers to this question.

Response:

Classical performances recommendations for open SQL remain valid

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

Some codes transferred to other systems

Some codes immediately run faster

Some codes impacted positively and should be priorities

Question: Score 1 of 1

What allows you to resolve errors quickly or warnings reported about the
code?

Please choose the correct answer.

Response:
 Code execution

Debug perspective

ABAP debugger

Quick Fix

Question: Score 1 of 1

What are the benefits associated with The SAP HANA real-time Operational
analytics?

There are 2 correct answers to this question

Response:

Simplification of massive data

High modeling flexibility

Fast insights into business activity

Query Speed support

Question: Score 1 of 1

User STUDENT_A create and activates a design-time object. In which

schema is the run object generated?
Please choose the correct answer.

Response:

_SYS_BI

STUDENT_A

SYSTEM
 _SYS_BIC

Question: Score 1 of 1

To connect with the SAP HANA system and see the corresponding catalog
content etc., use the Systems view. How will you add a system to this
view?

There are 2 correct answers to this question.

Response:

By using Open Catalog look

By using SQL application

Database user – also different from your ABAP user

Password for the database user

Question: Score 1 of 1

Which tasks does the ABAP managed database (AMDP) framework

perform?
There are 2 correct answers to this question.

Response:

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

Delete the obsolete versions of the database procedure synchronously

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

Delete the obsolete versions of the database procedure asynchronously

Question: Score 1 of 1

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.

Response:

The table contains mainly distinct values per column across rows.

The table contains only a small number of records.

The table contains text that you want to search.

The table contains data that you want to aggregate.

Question: Score 1 of 1

You create a check variant in the Code Inspector which includes the check
'Search problematic Select * statements'. SAP HANA is used as the
database.

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

Please choose the correct answer.

Response:

A value that you calculate based on the number of tables

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

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

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

Question: Score 1 of 1
You have defined the following SQLScript procedure:
CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL
DATA

Which type of database procedures can be called in this SQLScript

procedure?
Please choose the correct answer.

Response:

Read-update

Write only

Read only

Read-write

Question: Score 1 of 1

List down the elements involved in User Management and Security in SAP
HANA?

There are 3 correct answers to this question

Response:

Create users

Assign security

Manage users

Work management

Assign job security

Question: Score 1 of 1
When to use Enhanced Open SQL?

There are 2 correct answers to this question.

Response:

To access system fields

To view scalar components

Need the query in one piece of code only

At the time of Dictionary Views

Question: Score 1 of 1

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

Response:

Database Table

Internal table

CDS View

External view

Database Procedure

Question: Score 1 of 1

Which of the following is not involved in database table of “The New ABAP
SQL Monitor – Architecture”?

Choose the correct answer

Response:

Selection data table

Performance data table

Critical data table

Runtime monitor data

Question: Score 1 of 1

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.

Response:

Include the client field in the field list.

Include the client field in the join condition.

Include the client field in the WHERE condition.

Use the CLIENT SPECIFIED addition.

Question: Score 1 of 1

What are the supported joins in CDS view?

There are 2 correct answers to this question.

Response:

Left outer join

 Upper join

Inner join

Operators joint

Question: Score 1 of 1

If the Search Options are enabled, you can set the Search Parameters for
an attribute of a view. The following parameters are available?

There are 3 correct answers to this question

Response:

Fuzzy search

Freestyle search

Index search

Point base ranking

Weights for ranking

Question: Score 1 of 1

What are the Performance Rules and Guidelines for ABAP on SAP HANA?

There are 2 correct answers to this question.

Response:

To Keep all the loads away from the DB

To reduce main memory consumption and to improve insert performance

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

 It is beneficial for maximizing your search into database

Question: Score 1 of 1

What are the Possible Approaches with AS ABAP < 7.4 SP02?

There are 2 correct answers to this question.

Response:

Stored Procedures

SQL units

Interaction with Database

Consume using native SQL

Question: Score 1 of 1

What do you understand by The SAP HANA Software Optimization?

Choose the correct answer

Response:

Huge potential for hybrid database

Speed up the processing within the database

Bring logic to where the data is calculated first, then only move to results

Provide combinations of Objects and Partitioning

Question: Score 1 of 1
Discuss the basic approach of classical ABAP programming?

There are 2 correct answers to this question.

Response:

Keep load from the database

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

Creating and consuming all the contents from network

Collect all the data and perform Parallel processing in ABAP

Question: Score 1 of 1

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

Response:

Group rows

Edit cells

Double-click on rows

Display diagrams

Search in content

Question: Score 1 of 1

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.

Response:

ROW

GLOBAL TEMPORARY

COLUMN

LOCAL TEMPORARY

Question: Score 1 of 1

What are the Perspectives and Views of SAP HANA Studio?

There are 2 correct answers to this question.

Response:

System and Properties

Development properties

Open system properties

Administration console

Question: Score 1 of 1

What are the steps involved in SAP HANA Evolution?

There are 3 correct answers to this question.

Response:

ABAP can access SAP HANA

 ABAP can run on SAP HANA

Optimized ABAP on SAP HANA

ABAP applications on SAP HANA

ABAP as accelerator on SAP HANA

Question: Score 1 of 1

Discuss different types of engines associated with The SAP HANA

architecture?

There are 2 correct answers to this question

Response:

Analytic engine

Join engine

OLAP engine

OPAX engine

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