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
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
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:
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
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
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.
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
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
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
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
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
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.
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
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.
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
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