ABAP for SAP HANA 2.

0 - Test 1 - Results

Return to review

Attempt 1
All questions
Question 1: Incorrect
What all are the steps to perform -To enable type-ahead for an input field on a
screen? (3 correct)

Check Pre-Requisites
(Correct)


Identify Elementary Search Help
(Correct)


Automatic updates of all the input fields
(Incorrect)


Process on all the input fields
(Incorrect)


Switch on proposal search for input fields
(Correct)

Question 2: Incorrect
Explain The Authorization Concept and the types of privileges associated with
it? (3 correct)

Object privileges
(Correct)


Analytic privileges
(Correct)


System privileges
(Correct)


 Delta privileges
(Incorrect)


Application privileges
(Incorrect)

Question 3: Correct
Which is not a Golden Rule for Open SQL?

Minimize the Amount of Data Transferred


Reduce the Database Load


Keep the result set large
(Correct)


Minimize the Number of Database Accesses

Question 4: Incorrect
Which of the following is not involved in database table of “The New ABAP SQL
Monitor – Architecture”?

Selection data table


Critical data table
(Correct)


Performance data table


Runtime monitor data
(Incorrect)

Question 5: Correct
Explain how and when to create calculated columns - Using Graphical Modeling
Tools? (3 correct)

The calculation will be opened in a read-only mode


 The calculation could be an arithmetic or character manipulation.
(Correct)


It is possible to nest so that one calculated column, in turn, is based on other
calculated columns
(Correct)


Time characteristics based calculation columns


Calculated columns also support non-measure attributes as part of the
calculation.
(Correct)

Question 6: Correct
What are the Guidelines for optimizing ABAP code running on HANA? (3
correct)

DB specific properties
(Correct)


Column store
(Correct)


Technical settings
(Correct)


High-speed data analysis


Open SQL settings

Question 7: Incorrect
ABAP 7.4 provides support for optimizing ABAP applications running on SAP
HANA. What are these Transparent Optimizations? (3 correct)

Re- use components have been extended or optimized for SAP HANA
(Incorrect)


The consumption of SAP HANA artifacts was simplified
(Correct)
 
The ABAP language and the OpenSQL language have been extended
(Correct)


Performance analysis tools have been improved
(Correct)


Do all the data processing in Application server

Question 8: Incorrect
What are the two layers of ABAP system interacts with its database? (2 correct)

The Client database interface
(Incorrect)


The Data Storage interface


The Database independent interface
(Correct)


The Database specific library
(Correct)

Question 9: Incorrect
Which data sources can you use for SAP list viewer with integrated data access?
(3 correct)

Database Table
(Correct)


External view
(Incorrect)


Internal table
(Correct)


Database Procedure
(Incorrect)
 
CDS View
(Correct)

Question 10: Incorrect

You import an ABAP workbench request into a 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? (2 correct)

SYSTEM P81 has SAP HANA has primary database
(Correct)


View CA_CUSTOMER has deployment mode A.


Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK
(Correct)


PACKAGE ZHA400_00 HAS deployment Mode A
(Incorrect)

Question 11: Incorrect

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? (3 correct)

Direct access to a cluster on the database
(Correct)


Native SQL statements
(Correct)


ORDER BY Clauses in Open SQL statements


Left outer joins in open SQL statements
(Incorrect)


Code that relies on implicit database sorting
 (Correct)

Question 12: Incorrect

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? (3 correct)

A BADI simple implementation


A BADI definition
(Correct)


AN enhancement spot
(Correct)


A database procedure
(Incorrect)


A BADI fallback implementation
(Correct)

Question 13: Incorrect

When to use Enhanced Open SQL? (2 correct)

Need the query in one piece of code only
(Correct)


To access system fields
(Correct)


To view scalar components
(Incorrect)


At the time of Dictionary Views
(Incorrect)

Question 14: Incorrect

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? (2
correct)
 
Columns of identical types
(Incorrect)


The same number of columns
(Correct)


All key fields


Columns of compatible types
(Correct)

Question 15: Incorrect

In a Graphical calculation view you want to implement a union between two
result sets that differ only in the fact that one of the two has one additional
field named ADDRESS. How can you achieve this in a union node? (2 correct)

Exclude the ADDRESS field from the union
(Correct)


Create an input parameter for the ADDRESS field
(Incorrect)


Map the ADDRESS field to a constant value
(Correct)


Create a restricted column for the ADDRESS field
(Incorrect)

Question 16: Incorrect

Which of the following is a limitation when you create an external view?

You must include the name of the SAP HANA view in the name of the external
view.
(Incorrect)


You can only use native SQL to consume the external view

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

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

Question 17: Incorrect

What are the three best approach for Transitioning and optimizing ABAP
applications to SAP HANA? (3 correct)

Scaling
(Incorrect)


Innovate
(Correct)


Optimize
(Correct)


Tuning
(Incorrect)


Detect
(Correct)

Question 18: Incorrect

Which task can you perform with the SQL Performance Tuning Worklist tool
(SWLT)?

Combine information from static ABAP code scans with runtime data from the
SQL Trace tool.
(Incorrect)


Create a graph comparing the runtimes of ABAP code before and after
optimization.


Combine information from static ABAP code scans with runtime data from the
SQL Monitor.
(Correct)


 Estimate the new total runtime of optimized code.

Question 19: Incorrect

What are the basic principles of ALV SAP HANA? (2 correct)

Data described declaratively instead of passing big internal tables
(Correct)


To ensure that the user chooses the data on the selection screen is displayed
(Incorrect)


The ALV Optimization for SAP HANA to display data on the screen
(Incorrect)


Only retrieve the database data which is to be displayed on screen
(Correct)

Question 20: Correct

Which is the new concept that is introduced and improved by using SAP HANA
Specific Features?

New advanced SQL syntax Procedures


Table buffering


ABAP-Managed Database Procedures
(Correct)


Programming model

Question 21: Correct

What are the uses of SQL Trace (ST05)? (3 correct)

Display record of all database access
(Correct)


Applying Code inspector


 Locate work base issues


Detect redundant or identical select statements
(Correct)


Locate database performance issues
(Correct)

Question 22: Incorrect

Why is a security concept in SAP HANA required? (2 correct)

Need to have selected users in SAP HANA for Information Management
(Incorrect)


Access to ERP tables must be restricted
(Correct)


Editing of SAP HANA data models should only be possible for “Users.” of the
model
(Incorrect)


Database administration should be restricted to skilled
(Correct)

Question 23: Incorrect

You use native SQL to access the SAP HANA database. What should you do to
retrieve the correct data? (3 correct)

Specify the database schema if it is not the user's default schema
(Correct)


Use a Comma-separated column list
(Correct)


Use the UP TO n ROWS addition


Use the tilde symbol (~) to separate qualifier from column name
(Incorrect)
 
Explicitly handle the client field
(Correct)

Question 24: Incorrect

What are the different views provided by the ABAP Profiling? (2 correct)

Metadata accesses


A Hitlist of the most time-consuming programs or methods
(Correct)


Database accesses
(Correct)


Performance Check methods
(Incorrect)

Question 25: Incorrect

List down the four main concepts of the SAP HANA database? (3 correct)

Partitioning
(Correct)


Column Store
(Correct)


Compression
(Correct)


Tools combinations


Object store
(Incorrect)

Question 26: Correct

You are implementing an ABAP Managed Database Procedures (AMDP) for SAP
HANA. What do you have to do in the corresponding ABAP class?

 Implement the interface IF_AMDP_MARKER_HDB.
(Correct)


Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.


Set the visibility of the corresponding class method in the declaration section to
PUBLIC.


Implement the ABAP AMDP_HDB Event Handler.

Question 27: Incorrect

If the Search Options are enabled, you can set the Search Parameters for an
attribute of a view. The following parameters are available? (3 correct)

Point base ranking


Freestyle search
(Correct)


Fuzzy search
(Correct)


Index search
(Incorrect)


Weights for ranking
(Correct)

Question 28: Correct

Hybrid Data Management System – Combining different paradigms in one
system. Discuss capabilities associated with the Hybrid Data Management
system? (3 correct)

Built-in support for planning
(Correct)


Text analysis and search
(Correct)
 
Text indexing capabilities


Traditional disk-based tables
(Correct)


Linguistic search capabilities

Question 29: Incorrect

What are the Performance Rules and Guidelines for ABAP on SAP HANA? (2
correct)

To reduce main memory consumption and to improve insert performance
(Correct)


It is beneficial for maximizing your search into database
(Incorrect)


To Keep all the loads away from the DB


It is beneficial to move data-intensive calculations into the database
(Correct)

Question 30: Correct

What are the two types of editors available in ADT? (2 correct)

SAP (GUI)
(Correct)


Client (native)


ABAP (native)


Eclipse (native)
(Correct)

Question 31: Correct

What is the main function of Static Code Analysis?
 
Integrates with SAP Solution Manager


ABAP source code with performance optimization potential


To detect code that would lead to functional or performance issues When
migrating to SAP HANA
(Correct)


Integrated into ABAP Development Tools and ABAP Workbench

Question 32: Incorrect

Which of the following tools and programming techniques use the SQL data
definition language? (2 correct)

Core data service (CDS) access control
(Incorrect)


Core data services (CDS) data definition
(Correct)


ABAP Dictionary
(Correct)


Open SQL

Question 33: Correct

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? How do you refer to
the parameter?

{it_books}


:it_books
(Correct)


[it_books]
 
it_books

Question 34: Incorrect

Which of the following tasks can you perform with SQL monitor (transaction
SQLM)?

Combine static and dynamic performance analysis results
(Incorrect)


Display the execution plan of an SQL statement
(Incorrect)


Capture the SQL profile of an application
(Correct)


Search for problematic SELECT* statements

Question 35: Incorrect

What are the benefits associated with The SAP HANA real-time Operational
analytics? (2 correct)

High modeling flexibility
(Correct)


Query Speed support


Simplification of massive data
(Incorrect)


Fast insights into business activity
(Correct)

Question 36: Incorrect

What are the steps involved in SAP HANA Evolution? (3 correct)

ABAP as accelerator on SAP HANA
(Incorrect)


 ABAP applications on SAP HANA
(Incorrect)


ABAP can access SAP HANA
(Correct)


ABAP can run on SAP HANA
(Correct)


Optimized ABAP on SAP HANA
(Correct)

Question 37: Incorrect

What is an attribute view and what are its practices? (3 correct)

May contain filters
(Correct)


May contains flow charts
(Incorrect)


Used in diagrammatic Projections
(Incorrect)


May use in calculation views
(Correct)


Used to join tables
(Correct)

Question 38: Incorrect

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


Debug perspective
(Incorrect)


 ABAP debugger


Quick Fix
(Correct)

Question 39: Correct

How will you hide the attributes that are not required for client consumption?

By setting the hidden property flag of the attribute in the View


By setting the hidden property flag of the attribute in the Semantics screen
(Correct)


By setting the hidden property flag of the attribute column


y setting the hidden property flag of the attribute provider

Question 40: Correct

What are the features of New Open SQL? (2 correct)

Supports specific units of database


Supports arithmetic and string expressions
(Correct)


Supports conditional expressions
(Correct)


Supports Code adjustment model

Retake test
Continue
Fullscreen