S/4 Hana Certification

Page 1

SAP Certified Development Specialist - ABAP for SAP HANA - Full

You got 33 of 40 possible points.

Your score: 83 %

Question Results

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

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

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

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

Question:

Score 1 of 1

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

Response: By using Sap Analysis for Microsoft office By another database procedure

By a script-based calculation view

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 1/17

Question:

Score 0 of 1

Which of the Golden Rules for Open SQL Performance have become more important with SAP HANA?

There are 2 correct answers to this question.

Response:

Minimize the number of database accesses.

Keep unnecessary load away from the database.

Minimize the search overhead

Minimize the amount of transferred data.

Question:

What benefits does SAP HANA Data Compression provide?

There are 2 correct answers to this question

Response:

Increased parallel processing

Optimized access to column store tables

Reduced memory consumption

Optimized data partitioning

Question:

What all are the advantages provides by ABAP Development Tools?

There are 3 correct answers to this question.

Response:

An open platform for developing powerful database view

Score 1 of 1

Score 1 of 1

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 2/17
services view
By a core data

A set of open, language- and platform-independent APIs

A brand new ABAP development experience on top of the Eclipse platform

A set of Eclipse data pool and Client- Open platform

An open platform for developing new ABAP-related tools

Question:

Score 1 of 1

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

Response:

Open the SAP HANA transport container

Select take snapshot and Save

Activate the SAP HANA Transport Container

Open the ABAP transport request

Select take snapshot and Save

Activate the SAP HANA transport container

Open the package

Select take snapshot and Save

Activate the SAP HANA Delivery unit

Activate the SAP HANA transport container

Open the SAP HANA delivery unit

Select take snapshot and Save

Activate the SAP HANA Delivery unit

Activate the SAP HANA transport container

Question:

Score 0 of 1

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

There are 2 correct answers to this question

Response:

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 3/17

Query Speed support

Simplification of massive data

High modeling flexibility

Fast insights into business activity

Question:

Score 0 of 1

You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement?

There are 2 correct answers to this question.

Response:

All tables and fields you are using must exist in the ABAP Dictionary of the Secondary DB.

You have to specify the DB connection explicitly in your statement.

You have to specify the DB schema explicity in your statement.

You have to use native SQL when reading data from the secondary DB.

Question:

Score 1 of 1

ANSI SQL owns features and adds languages these languages divided into three parts. What are they?

There are 3 correct answers to this question.

Response:

Data Manipulation Language

The Data Definition Language

The Database Language

Data Transferred Language

The Data Control Language

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep
4/17
https://www.erpprep.com/node/9094/take

Question:

Score 0 of 1

What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)?

There are 3 correct answers to this question.

Response:

Specify the database system and the language.

Define all method parameters to be passed by value.

Mark the AMDP method as a READ-ONLY database procedure.

Use scalar types for all AMDP method parameters.

List all ABAP Dictionary tables used in the procedure body in the USING clause.

Question:

Score 1 of 1

Name the views that are available to administer and monitor one or several SAP HANA systems?

There are 2 correct answers to this question

Response:

The System Monitor view

The Security view

The Landscape view

The Administration view

Question:

What made SAP HANA possible?

There are 2 correct answers to this question.

Response: RAM limitation

Score 1 of 1

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 5/17

Improved hardware technology

Technology and innovations

CPU with single core network

Question:

Score 1 of 1

Which of the following tool is introduced as a holistic quality assurance tool?

Choose the correct answer

Response:

ABAP Test Cockpit (ATC)

DBA Cockpit

BW system

DBMS Cockpit

Question:

Score 1 of 1

The new bottlenecks avoided by addressing two challenges, what are they?

There are 2 correct answers to this question.

Response:

Avoid optimizing data

Avoid single network

Avoid CPU cache misses

Avoid idling CPU cores

Question:

Score 1 of 1

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA?

There are 2 correct answers to this question.

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 6/17

Response:

Perform all calculations and aggregations in the ABAP layer

Use array variants of INSERT UPDATE MODIFY and DELETE

Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES

Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

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 called

Delete the obsolete versions of the database procedure asynchronously

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

Delete the obsolete versions of the database procedure synchronously

Question:

Score 1 of 1

To upload data from flat files, SAP HANA offers several features. What are these important features?

There are 2 correct answers to this question

Response:

The application suggests the column name and data type for the new tables, and it is possible to edit them

The supported file types for upload are: .cssv, .xlls, and .xlsxxx

When loading new data in the table, it gets appended to the existing data

The new table always has a 2:2 mapping between the file and table columns

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 7/17

Question:

What views will be most efficient for General Modeling Principles?

There are 2 correct answers to this question

Response:

Schema view

Attribute view

Analytical view

Column view

Question:

Score 1 of 1

Score 1 of 1

What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA database?

There are 2 correct answers to this question.

Response:

The database independency of your report can be lost.

The ABAP system checks the syntax of the Native SQL statements.

Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword

Client handling needs to be done explicitely in the the Native SQL statement.

Question:

What are the elements of ABAP Database Integration?

There are 3 correct answers to this question.

Response:

Application server

DB For ABAP

Score 1 of 1

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 8/17

Other DB DB client-server

Question:

Score 1 of 1

What are the two main methods to add a system to the SAP HANA Studio?

There are 2 correct answers to this question

Response: By Resource console

Manually Automatically By Importing a Landscape

Question:

Score 1 of 1

Explain Transitioning ABAP Code to SAP HANA – Performance Considerations?

There are 3 correct answers to this question.

Response:

Some codes immediately run faster

Some codes impacted positively and should be priorities

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

Some codes transferred to other systems

Classical performances recommendations for open SQL remain valid

Question:

What are the features associated with ABAP CDS?

Score 1 of 1

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 9/17
Client database handling

There are 3 correct answers to this question

Response: Distribution Create Export Update

Read

Question:

Score 1 of 1

What are the principles of Using HANA Transport Containers properly?

There are 3 correct answers to this question.

Response:

Import of Transport Request

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

Release of Transport request

Automatic update for all export methods

To create Transport container of delivery unit

Question:

Score 1 of 1

Which of the following is a limitation when you create an external view?

Please choose the correct answer.

Response:

You can only use native SQL to consume the external view

You must know the underlying tables and join conditions of the SAP HANA view

You must use the ABAP Development tools (ADT) TO CREATE the external view

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 10/17

You must include the name of the SAP HANA view in the name of the external view.

Question:

Score 1 of 1

You developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of this AMDP using business add-in (BADI).

Which of the following objects must you create?

There are 3 correct answers to this question.

Response:

A BADI simple implementation

A BADI fallback implementation

A BADI definition

A database procedure

AN enhancement spot

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.prirndb/CA_BOOKINGS_COUNT"

SYS_ BIC."ha400.primdb::CA_BOOKINGS_COUNT"

"ha400.pr mdb/CA_BOOKINGS_COUNT"

"ha400.primdb::CA_BOOKINGS_COUNT"

Question:

Score 0 of 1

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 11/17

What are the features of New Open SQL?

There are 2 correct answers to this question.

Response:

Supports arithmetic and string expressions

Supports specific units of database

Supports conditional expressions

Supports Code adjustment model

Question:

Score 1 of 1

You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statements check. What does this check report?

Please choose the correct answer

Response:

SELECT * statements on tables with the Column Store storage type

SELECT * statements on tables with more than a specified number of fields

SELECT * statements where fewer than a specified percentage of all fields are effectively used

SELECT * statements on tables with more than 100,000 records

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 text that you want to search.

The table contains data that you want to aggregate.

The table contains mainly distinct values per column across rows.

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 12/17

The table contains only a small number of records.

Question:

What is the Limitations of ALV for SAP HANA?

There are 3 correct answers to this question.

Response:

No unit/ currency split if aggregating amounts/ currency values

Restricted to 10,000 records

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

Restricted to 5000 records / unit

Without currency /unit consideration

Question:

Score 1 of 1

Score 1 of 1

Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)?

There are 3 correct answers to this question.

Response:

SQL monitor (transaction SQLM)

ABAP test cockpit (transaction ATC)

SQL Trace (transaction ST05)

Code inspector (transaction SCI)

Data base performance monitor (transaction DB50)

Question:

Score 0 of 1

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 13/17

What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA?

There are 3 correct answers to this question.

Response: Optimize Tuning Detect Scaling Innovate

Question:

Score 1 of 1

What output does The SAP HANA provide as a unique combination of hardware and software innovations?

Choose the correct answer

Response:

Huge potential to optimize AMDP application DATA Tables

The ability to create new complex processes with ABAP application cloud

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

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

Question:

Score 1 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: Combine the results of the SQL Monitor with the results of a static source code analysis.

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 14/17

Activate the new SQL Monitor in a development system.

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

Activate the new SQL Monitor in a productive system.

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 SQL application

Database user – also different from your ABAP user

Password for the database user

By using Open Catalog look

Question:

Score 1 of 1

Explain the Enterprise Information System of - SAP HANA Implementation Scenarios?

There are 3 correct answers to this question

Response:

All HANA Combinations on one platform

All SAP applications on one SAP HANA platform

HANA Accelerators

Business Suite on HANA / BW on SAP HANA

HANA Modeling

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 15/17

Question:

Score 1 of 1

You are debugging in ABAP Development Tools in Eclipse. What features are available?

There are 2 correct answers to this question.

Response:

Conditional breakpoints

Watch points

Memory usage analysis

Debugger scripting

Question:

Score 0 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:

Display diagrams

Edit cells

Double-click on rows

Group rows

Search in content

Question:

What all are the factors involved in Working with ADT

There are 3 correct answers to this question.

Response:

Module interface

Workbench programs

Score 1 of 1

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 16/17
5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 17/17 ABAP programs ABAP interface ABAP Class Money Back Guarantee Testimonial FAQs Privacy Policy Terms and Conditions About Us Join Us Contact Us

Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.