1

E_HANAAW_18
ABAP FOR SAP HANA 2.0

CERTIFICATION MCQ’S

Phone/Whatsapp: +1 (515) 309-7846 (USA)

Email: [email protected]
Website: www.zarantech.com
1 1
E_HANAAW_18
ABAP for SAP HANA 2.0
1. You analyze SQL Monitor data in transaction SQLMD. You know that
program X accesses the database table Y. You made sure that program X was
executed while the SQL Monitor collected its data. However, the relevant
database access is NOT listed in SQLMD. What could be the reason?
A. The data has NOT yet been transferred to the SQL Monitor database
tables.
B. Program X was executed in the background.
C. Database table Y is a buffered table.
D. SQL Monitor was activated with a filter that excludes database table Y.
E. SQL Monitor was activated for a specific application server.

2. Which task can you perform with the SQL Monitor (transaction SQLM)?
A. Capture the SQL profile of an application.
B. Search for problematic SELECT * statements.
C. Display the execution plan of an SQL statement.
D. Combine static and dynamic performance analysis results.

3. You are debugging in ABAP Development Tools in Eclipse. What features

are available?
A. Memory usage analysis
B. Watchpoints
C. Conditional breakpoints
D. Debugger scripting

4. You are using a calculated column COUNTS within your Dimension

Calculation View and an aggregation node. See Picture...This is the data that
goes into the aggregation node: What does the result of the aggregation look
like? See Pictures
A. Image 1
B. Image 2
C. Image 3
D. N/A

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

5. 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?
A. @it_books
B. {it_books}
C. it_books
D. :it_books

6. 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?
A. Include the client field in the WHERE condition.
B. Use the CLIENT-SPECIFIED addition.
C. Include the client field in the join condition.
D. Include the client field in the field list.

7. Which of the following are performance recommendations when using SAP

HANA?
A. Avoid transferring large result sets between database and client
applications.
B. Move data-intensive calculations from the database to an application server.
C. Filter data in lower layers.
D. Define indexes on the columns that are used in calculations.

8. What information can you specify using annotations (marked with the @
sign) when you define a Core Data Services (CDS) view in an ABAP system?
A. The name of the representation of the CDS view in the ABAP
dictionary
B. The join conditions of the CDS view
C. The logic for aggregations, grouping records, and filtering groups of the
CDS view
D. The extent to which records of the CDS view should be buffered on the
application server
E. The client's dependency on the CDS view

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

9. 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?
A. SELECT * statements on tables with more than a specified number of fields
B. SELECT * statements where fewer than a specified percentage of all fields
are effectively used
C. SELECT * statements on tables with the Column Store storage type
D. SELECT * statements on tables with more than 100,000 records

10. What are the functions of the ABAP Managed Database Procedure
(AMDP) framework?
A. It creates the database procedure when the AMDP is first activated.
B. It deletes obsolete versions of the database procedure synchronously.
C. It deletes obsolete versions of the database procedure
asynchronously
D. It creates the database procedure when the AMDP is first called.

11. 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?
A. A value that you calculate based on the number of tables
B. A higher value than on a traditional, row-store-only based database
C. The same value as on a traditional, row-store-only based database
D. A lower value than on a traditional, row-store-only based database

12. 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?
A. Combine the results of the SQL Monitor with the results of an ABAP runtime
analysis.
B. Activate the new SQL Monitor in a productive system.
C. Combine the results of the SQL Monitor with the results of a static
source code analysis.
D. Activate the new SQL Monitor in a development system.

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

13. Which features does the source code editor provide in ABAP Development
Tools for SAP NetWeaver?
A. Screen Editing
B. Content Assistance
C.Form-based class builder
D. Quickfix

14. What are the benefits of using the SQL Monitor (transaction SQLM)?
A. It displays the database execution plan for all SQL statements.
B. It collects monitoring data asynchronously without additional
database interaction.
C. It can be active in a production system with minimal performance
overhead.
D. It schedules ABAP programs to monitor and log all database accesses.

15. Which of the following repository objects can you edit only in ABAP
Development tools in Eclipse and not in the Classical ABAP workbench?
A. Full-text index
B. Database procedure proxy
C. ABAP program containing new Open SQL
D. Core Data Service (CDS) view
E. External view

16. Which form of service is responsible for defining and consuming

semantically rich data models?
A. Core Data Services
B. ITe services
C. Conditional services
D. Modell-ll services

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

17. What are the components of The Enterprise Procurement Model Demo
Scenario?
A. Sales
B. Procurement
C. Stock
D. Services
E. Product

18. How to call the stored procedures in ABAP code?

A. Open SQL
B. Only SQL
C. Native SOL
D. CDS view

19. Explain the Authorization Concept and the types of privileges associated
with it.
A. Analytic privileges
B. Package privileges
C. Application privileges
D. Object privileges
E. System privileges

20. What are the steps involved in supporting a database-oriented

programming model?
A. A new and advanced Open SQL
B. Core Data services
C. Buffer system services
D. Advanced and specific models

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

21. Which of the following are characteristics of an external view?

A. It can be used as a data type in ABAP programs.
B. It defines the underlying SAP HANA information view.
C. It can be used in Open SQL statements for database updates.
D. It is an ABAP Dictionary object type.
E. It allows access to an SAP HANA information view with Open SQL.

22. What are the benefits associated with The SAP HANA real-time
Operational analytics?
A. Simplification of massive data
B. Fast insights into business activity
C. Query Speed support
D. High modeling flexibility

23. Which steps do you have to perform when defining a view using core data
services (CDS)?
A. Use the DDL statement DEFINE VIEW and SQL like Syntax
B. Create a data definition in your ABAP package
C. Create a proxy object for the defined view.
D. Specify the name of the SQL view in the ABAP Dictionary
E. Define the type mapping between ABAP and SAP HANA

24. What are the best practices when programming in ABAP for SAP HANA?
A. Calculate aggregations using ABAP code on the application server to limit
database load
B. Eliminate nested SELECT statements to reduce the overall number of
database accesses
C. Use a column list in the SELECT clause to ensure that you only read a
column if it is required
D. Use repeated SELECT SINGLE statements to ensure that you only read the
arrow if it is required

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

25. Open SQL largely standardized, three sub-languages. What are these sub-
languages?
A. Data Evaluation Language(DEL)
B. The Data Definition Language (DDL)
C. Data Transferring Language(DTL)
D. The Data Control Language (DCL)
E. Data Manipulation Language (DML)

26. What are the two main methods to add a system to the SAP HANA Studio?
A. Manually
B. By Resource console
C. By Importing a Landscape
D. Automatically

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

A. Use native SQL to access SAP HANA built-in functions.
B. Perform expensive calculations on the database.
C. C. Aggregate data on the database, and transfer the results to the
ABAP layer.
D. Perform expensive calculations on the ABAP application server.
E. Transfer all data from the database to the ABAP layer, and then aggregate
the results.

28. You use native SQL to access the SAP HANA database. What should you
do to retrieve the correct data?
A. Use the UP TO n ROWS addition
B. Use the tilde symbol (-) to separate the qualifier from the column name
C. Use a Comma-separated column list
D. Specify the database schema if it is not the user's default schema
E. Explicitly handle the client field

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

29. What is the main purpose of SAML for SAP HANA Studio?
A. The SAP HANA database supports the login of Owners only
B. To support scenarios where clients are not directly connected to the
SAP HANA Database
C. The assertion is issued by a user after the client was successfully
authenticated
D. SAML may be selected as an Owner's authentication method when creating
users in the SAP HANA Studio

30. What are the main points of SAP HANA High Availability per data center
that are available even in the event of a disaster?
A. Active clusters for all servers
B. Shared file systems for only one server
C. Services-Name and index server on all nodes
D. High availability configuration

31. Which of the following tasks can you perform with SQL monitor (transaction
SQLM)?
A. Display the execution plan of an SQL statement
B. Capture the SQL profile of an application
C. Combine static and dynamic performance analysis results
D. Search for problematic SELECT* statements

32. Which tools can you use to provide input data for the SQL performance
tuning work list (Transaction SWLT)?
A. Database performance monitor (transaction DB50)
B. Code Inspector (transaction SCI)
C. SQL Trace (transaction ST05)
D. SQL monitor (transaction SQLM)
E. ABAP test cockpit (transaction ATC)

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

33. The source code editor in ADT provides many helpful features. What are
these helpful features?
A. Creating Method Implementations from the Method Definition
B. Creating interface from Method Calls
C. Creating Method Definitions from Implementation Parts
D. Creating Parts for Interface Methods

34. What are the purposes of tools in the SAP HANA system that is an Eclipse-
based integrated development environment?
A. Organizing
B. Administer
C. Configure
D. Monitor
E. Selecting

35. 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?
A. Direct access to a cluster on the database
B. Left outer joins in open SQL statements
C. Native SQL statements
D. Code that relies on implicit database sorting
E. ORDER BY Clauses in Open SQL statements

36. You want to debug an ABAP program using ABAP development tools
(ADT). How do you launch the debugger?
A. Choose the debug option in the context menu of the ABAP program
B. Create a debug configuration for the ABAP application and run the program
C. Set a breakpoint in the ABAP program and execute the program
D. Choose the Run --> Debug options in the menu

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

37. When would you use a column store table instead of a row store table?
A. When you require aggregation and analysis of values
B. When the table has a small number of records
C. When there are mainly distinct values in the table
D. When you want to enable a full-text-search of the table

38. When are referential joins executed in analytical views?

A. When all the tables are optimized
B. When fields are selected
C. When fields are optimized
D. When fields from both tables are requested

39. Which of the following takes advantage of the computing power of multiple
CPUs used by SAP HANA?
A. Partitioning
B. Database table compression
C. Column data storage
D. Parallel processing

40. Which is the new concept that is introduced and improved by using SAP
HANA Specific Features?
A. Programming model
B. Table buffering
C. New advanced SQL syntax Procedures
D. ABAP-Managed Database Procedures

41. What made SAP HANA possible?

A. There are 2 correct answers to this question.
B. Improved hardware technology
C. CPU with single-core network
D. RAM limitation
E. Technology and innovations

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

42. When to use Enhanced Open SQL?

A. To view scalar components
B. At the time of Dictionary Views
C. Need the query in one piece of code only
D. To access system fields

43. Name the views that are available to administer and monitor one or several
SAP HANA systems.
A. The Landscape view
B. The System Monitor view
C. The Security view
D. The Administration's view

44. You use the ABAP trace (SAT) to measure the run time of a program. In a
class, method X checks the validity of its importing parameters and calls
method Y. What pattern of gross and net run time would you expect to see in
the ABAP trace results for method X?
A. The gross and net run times are identical
B. The net run time is less than the gross run time
C. The net run time is equal to Zero
D. The net run time is greater than the gross run time

45. Which of the following are view annotations for a CDS view?
A. Semantics
B. Client handling
C. Buffering type
D. Environment
E. Access control

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

46. What are the Parameters for the Analytical and Calculation view?
A. Specifying unit of measurement
B. Passing other values to be used in calculations
C. Create a copy of a report
D. To store data for critical analysis
E. Setting a filter for columns

47. Discuss the basic approach of classical ABAP programming.

A. Get all the data you need on the application server and do your
processing in ABAP
B. Creating and consuming all the contents from the network
C. Keep load from the database
D. Collect all the data and perform Parallel processing in ABAP

48. Which code-to-data capability is responsible for the optimization and

translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native
SQL?
A. Database Optimization
B. Transparent Optimizations
C. HANA Specific features
D. Buffer System Optimization

49. What are the two types of editors available in ADT?

A. Eclipse (native)
B. Client (native)
C. SAP (GUI)
D. ABAP (native)

50. Which rules does SAP recommend to improve the performance of ABAP
report on SAP HANA?
A. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement
B. Use array variants of INSERT UPDATE MODIFY and DELETE
C. Use a nested SELECT statement instead of SELECT FOR ALL
ENTRIES
D. Perform all calculations and aggregations in the ABAP layer

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

51. The new bottlenecks are avoided by addressing two challenges, what are
they?
A. Avoid idling CPU cores
B. Avoid CPU cache misses
C. Avoid optimizing data
D. Avoid single-network

52. Discuss the conditions required to ensure the Referential Integrity.

A. There are three joins in the table
B. Referential integrity holds in both directions
C. There is at least one join in the other table
D. There are two joins in the table

53. What are the steps to perform -To enable type-ahead for an input field on a
screen?
A. Process on all the input fields
B. Automatic updates of all the input fields
C. Check Pre-Requisites
D. Identify Elementary Search Help
E. Switch on proposal search for input fields

54. Which task can you perform with the SQL Performance Tuning Worklist
tool (SWLT)?
A. Combine information from static ABAP code scans with runtime data
from the SQL Monitor.
B. Create a graph comparing the runtimes of ABAP code before and after
optimization.
C. Estimate the new total runtime of optimized code.
D. Combine information from static ABAP code scans with runtime data from
the SQL Trace tool.

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

55. ABAP 7.4 provides support for optimizing ABAP applications running on
SAP HANA. What are these transparent optimizations?
A. Performance analysis tools have been improved
B. Do all the data processing in the Application server
C. The consumption of SAP HANA artifacts was simplified
D. Re-use components have been extended or optimized for SAP HANA
E. The ABAP language and the Open SQL language have been extended

56. Which of the following is a limitation when you create an external view?
A. You must include the name of the SAP HANA view in the name of the
external view.
B. You can only use native SQL to consume the external view
C. You must know the underlying tables and join conditions of the SAP HANA
view.
D. You must use the ABAP Development Tools (ADT) TO CREATE the
external view

57. What are the benefits included with SAP HANA Full Text Search? There
are 2 correct answers to this question
A. Fewer data duplication and movement
B. Exploit structured contents in SQL
C. Easy-to-use modeling tool
D. Large number of toolkits are available

58. You use ABAP database connectivity (ADBC) to issue native SQL calls to
the database, the native SQL call? Which of the following methods of class
CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call?
A. SET_PARAM_TABLE
B. SET_PARAM
C. EXECUTE_QUERY
D. NEXT_PACKAGE

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

59. You made changes to an object (X) used by an ABAP-managed database

procedure (AMDP). You did NOT change the AMDP itself. Now you execute a
program that calls this. In which cases does the call trigger the creation of the
database procedure in SAP HANA?
A. X is a stored procedure.
B. X is an SAP HANA view
C. X is an ABAP Dictionary table
D. X is an AMDP method

60. How to create a core data services view?

A. Use SQL capabilities for Netweaver
B. Use data services tools for updates
C. Use the DDL statement DEFINE VIEW and SQL-like syntax to define
the view
D. Use the ABAP Development Tools for SAP Netweaver
E. Use additional annotations - marked with the @sign

61. What are the elements of ABAP Database Integration?

A. Client database handling
B. Application server
C. DB client-server
D. Other DB
E. DB For ABAP

62. You define a core data services (CDS) View. For which of the following
expressions and built-in functions must you provide an alias?
A. CASTE Expression
B. CASE expression
C. Currency Conversion
D. Nested CASE expression
E. Unit conversion

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

63. What all are the factors involved in Working with ADT. If the search options
are enabled, you can set the search parameters for an attribute of a view,
which parameters will be available?
A. ABAP interface
B. Module interface
C. Workbench programs
D. ABAP programs
E. ABAP Class

64. You are implementing an ABAP Managed Database Procedures (AMDP)

for SAP HANA. What do you have to do in the corresponding ABAP class?
A. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
B. Implement the interface IF_AMDP_MARKER_HDB.
C. Set the visibility of the corresponding class method in the declaration
section to PUBLIC.
D. Implement the ABAP AMDPJHDB Event Handler.

65. How many result sets are returned when an SAP HANA database
procedure is called using the CALL WITH OVERVIEW statement?
A. As many result sets as there are input parameters in the procedure
B. Two result sets
C. One result set
D. As many result sets as there are table output parameters in the procedure

66. What are the key points that should be kept in mind while performing the
Non-automatic update in SAP HANA Tr.Cont.?
A. Automatic release of units
B. Changes to Delta Container
C. You need to refresh the content of the container manually
D. Take a snapshot manually before releasing the container

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

67. Which of the following tools and programming techniques use the SQL
data definition language?
A. ABAP Dictionary
B. Open SQL
C. Core data services (CDS) data definition
D. Core data service (CDS) access control

68. DB-Specific Properties that allow switching between storage types when
running on an SAP HANA database. What are these storage types?
A. Column store
B. Development Store
C. Row store
D. Technology store
E. Re-use component store

69. What are the Possible Approaches with AS ABAP < 7.4 SP02?
A. SQL units
B. Consume using native SQL
C. Stored Procedures
D. Interaction with Database

70. What do you have to consider if you want to use Native SQL in your ABAP
programs to access an SAP HANA DB?
A. The ABAP system checks the syntax of the Native SQL statements
B. Client handling needs to be done explicitly in the Native SQL
statement
C. The database independence of your report can be lost
D. Hashed or sorted tables must be used with the INTO CORRESPONDING
FIELDS keyword

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

71. Discuss the basic approach of classical ABAP programming.

A. Collect all the data and perform parallel processing in ABAP
B. Creating and consuming all the contents from the network
C. Get all the data you need on the application server and do your
processing in ABAP
D. Keep load from the database

72. Which of the following features were added to the ABAP Dictionary to
support the SAP HANA database?
A. De-pooling and de-clustering
B. Changes in data class
C. Definition of full-text indexes
D. Definition of an enhancement category
E. Storage type for tables

73. What is the main function of Static Code Analysis?

A. To detect code that would lead to functional or performance issues
When migrating to SAP HANA
B. Integrates with SAP Solution Manager
C. Integrated into ABAP Development Tools and ABAP Workbench
D. ABAP source code with performance optimization potential

74. 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?
A. Database user- also different from your ABAP user
B. By using Open Catalog look
C. Password for the database user
D. By using SQL application

75. What allows you to resolve errors quickly or warnings reported about the
code?
A. Code Execution
B. Quick Fix
C. Debug perspective
D. ABAP debugger

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

76. What are some of the features available in SAP List Viewer with integrated
data access (SALV IDA)?
A. Display diagrams
B. Double-click on rows
C. Search in content
D. Edit cells
E. Group rows

77. What are the Limitations of ALV for SAP HANA?

A. No unit/ currency split if aggregating amounts/ currency values
B. Restricted to 5000 records/unit
C. Restricted to 10,000 records
D. Without currency/unit consideration
E. All units/ currency restricted to 10,000,00 records

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

schema is the run object generated?
A. _SYS_BI
B. STUDENT_A
C. SYSTEM
D. _SYS_BIC

79. ANSI SQL owns features and adds languages. These languages are
divided into three parts. What are they?
A. Data Manipulation Language
B. The Data Control Language
C. The Database Language
D. The Data Definition Language
E. Data Transferred Language

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

80. What are the features of New Open SQL?

A. Supports arithmetic and string expressions
B. Supports Code adjustment model
C. Supports specific units of database
D. Supports conditional expressions

81. In which of the following situations could a row store table be more suitable
than a column store table?
A. The table contains data that you want to aggregate.
B. The table contains mainly distinct values per column across rows.
C. The table contains text that you want to search.
D. The table contains only a small number of records.

82. How does SAP HANA support SQL?

A. Transferring data
B. As a means to define
C. Manipulate data
D. Read
E. As a Data Calculator

83. Which repository objects can you edit only in the ABAP development tools
in Eclipse and not in the classical ABAP workbench?
A. Core data services view
B. Database procedure proxy
C. Full-text index
D. External view
E. ABAP program containing new open SQL

84. Which repository objects can you edit only in the ABAP development tools
in Eclipse and not in the classical ABAP workbench?
A. Core data services view
B. Database procedure proxy
C. Full-text index
D. External view
E. ABAP program containing new open SQL

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

85. What are the two main factors of SAP HANA Innovations and Challenges?
A. HW technology and innovations
B. DBMS technology and innovations
C. SAP BW innovations
D. SAP SW technology and innovations

86. 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?
A. Read-write
B. Read only
C. Write only
D. Read-update

87. What are the steps involved in SAP HANA Evolution?

A. ABAP as an accelerator on SAP HANA
B. ABAP applications on SAP HANA
C. ABAP can access SAP HANA
D. ABAP can run on SAP HANA
E. Optimized ABAP on SAP HANA

88. 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?
A. Release resources
B. Update resources
C. Update resources
D. Update packages

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

89. You define and implement an AM DP. What do you have to list after the
USING clause?
A. ABAP dictionary tables used in the procedure body
B. ABAP dictionary views used in the procedure body
C. CE function used in procedure Body
D. AMDP Used in Procedure Body
E. SAP HANA views used in the procedure body

90. 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?
A. Create an input parameter for the ADDRESS field
B. Exclude the ADDRESS field from the union
C. Create a restricted column for the ADDRESS field
D. Map the ADDRESS field to a constant value

91. How will you select a preference for Validation rules?

A. Windows- SAP HANA-Modeler-Preferences-Validation Rules
B. Windows- Preferences-SAP HANA-Modeler-Validation Rules
C. Windows- Modeler- Preferences-SAP HANA-Validation Rules
D. Windows- SAP HANA-Preferences-Modeler-Validation Rules

92. Which tasks does the ABAP managed database (AMDP) framework
perform?
A. Create a new version of the database when the AMDP is first activated
B. Delete the obsolete versions of the database procedure synchronously
C. Delete the obsolete versions of the database procedure
asynchronously
D. Create a new version of the database when the AMDP is first called

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

93. Why is a security concept in SAP HANA required?

A. Need to have selected users in SAP HANA for Information Management
B. Access to ERP tables must be restricted
C. Editing of SAP HANA data models should only be possible for "Users" of
the model
D. Database administration should be restricted to skilled

94. What are the three best approaches for Transitioning and optimizing ABAP
applications to SAP HANA?
A. Scaling
B. Optimize
C. Detect
D. Innovate
E. Tuning

95. List down the three main concepts of the SAP HANA database
A. Column Store
B. Tools combinations
C. Object store
D. Partitioning
E. Compression

96. You follow the Code-to-Data paradigm in your ABAP coding. Which of the
following scenarios conflicts with the SQL performance guideline "Keep
unnecessary load away from the database"?
A. Then in-memory architecture of SAP HANA prevents the transfer of large
datasets between the database layer and the application layer
B. The transfer of coding to the database reduces the memory consumption of
the associated ABAP Dictionary tables in the application layer
C. The data-intensive calculations can be performed on SAP Netweaver
Application Server ABAP when code-to-data mode is switched on
D. The in-memory capabilities of SAP HANA allow calculations to be
performed on the database layer, which helps to avoid unnecessary
movement of data

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

97. Explain how and when to create calculated columns - Using graphical
Modeling Tools.
A. The calculation could be an arithmetic of character manipulation
B. It is possible to nest so that one calculated column, in turn, is based
on other calculated columns
C. Calculated column also supports non-measure attributes as a part of
the calculation
D. Time calculation will be opened in a read-only mode ] Time characteristics-
based calculation columns

98. Why is it not a key factor of ALV for HANA?

A. The data display is restricted to a maximum of 2 billion cell
B. To supply suitable values for any input parameters
C. To activate and execute the program in the application
D. Derived column headings from the data element

99. Which of the following folders is essential to relate to Smart Data Access
and also combines data from remote sources?
A. Administration folder
B. Content folder
C. Security folder
D. Provisioning folder

100. Which of the following tools is introduced as a holistic quality assurance

tool?
A. BW system
B. DBA Cockpit
C. ABAP Test Cockpit (ATC)
D. DBMS Cockpit

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

101. What is the central goal of using SAP HANA?

A. Positive Impact on Business
B. Accelerate Performance
C. To set Priorities for the system
D. Monitor database for record-keeping

102. Which of the following options is not the main capability of SAP Business
Objects Analysis for OLAP?
A. Create data by members and tables
B. Insert filter components
C. Swap axes
D. Create Presentations

103. You define a core data services (CDS) view to merge the results of
queries using the UNION keyword. What must the column list of these queries
contain?
A. The same number of columns
B. All key fields
C. Columns of compatible types
D. Columns of identical types

104. What are the principles of Using HANA Transport Containers properly?
A. Import of Transport Request
B. To create a Transport container for a delivery unit
C. Automatic update for all export methods
D. Release of Transport request
E. Takes a 'snapshot' of all SAP HANA objects of delivery unit

105. You have an SQLScript procedure with a table input parameter it_books.
You want to use the parameter on the righthand side of an assignment
operator within the procedure. How do you refer to the parameter?
A. :it_books
B. it_books
C. {it.books}
D. @it_books

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

106. Which code-to-data capability supports- Extended view definitions and

Better SQL-92 standard support in open SQL?
A. SAP HANA specific features
B. Database-oriented programming model
C. New SQL parser used in the model
D. Database for sophisticated analysis

107. What are the two layers of the ABAP system that interact with its
database?
A. The Data Storage interface
B. The Database specific library
C. The database-independent interface
D. The Client database interface

108. Which of the following is not an element of the Analytical view?

A. Currency conversion is not applicable
B. Join fact tables
C. Read Data from the joined database tables
D. Used to join table

109. Which of the following are performance recommendations when using

SAP HANA?
A. Define indexes on the columns that are used in calculations.
B. Move data-intensive calculations from the database to an application server.
C. Filter data in lower layers.
D. Avoid transferring large result sets between database and client
applications.

110. What are the Types of Applications based on SAP HANA?

A. Server based on SAP HANA
B. Innovation based on SAP HANA
C. New or Native SAP HANA
D. Data Mart based on SAP HANA

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

111. What are the two different kinds of Identifiers used to represent names
used in SQL statements?
A. Delimited identifiers
B. Limited identifiers
C. Undelimited Identifiers
D. Numeric identifiers

112. What are the features associated with ABAP CDS?

A. Read
B. Create
C. Delete/Edit Table
D. Update

113. What are the features associated with ABAP CDS?

A. Create
B. Export
C. Update
D. Read
E. Distribution

114. What are the steps that supported several tools, which in total result in a
Guided Performance Optimization?
A. Tools analyzing performance at run-time, to determine if critical
constructs
B. A new tool called SQL Monitor to determine the priority if different
programs access the database intensively
C. A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate
potential functional and performance issues.
D. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and
compare runtime consumption

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

115. What output does the SAP HANA provide as a unique combination of
hardware and software innovations?
A. Huge potential to optimize business applications that are running on
SAP HANA
B. The ability to create new complex processes with ABAP application cloud
C. Huge potential to optimize AMDP application DATA Tables
D. Huge potential to maximize the number of disk blocks in the application

116. What are the Guidelines for optimizing ABAP code running on HANA?
A. Open SQL settings
B. Technical settings
C. High-speed data analysis
D. DB-specific properties
E. Column store

117. What are the two Profitability Analyses available with CO-PA scenarios in
SAP HANA Modeling?
A. Account-based Profitability
B. Costing-based Profitability
C. Product-based Profitability
D. Service-based profitability

118. List down the elements involved in User Management and Security in
SAP Hana?
A. Manage users
B. Assign Job security
C. Assign security
D. Work Management
E. Create users

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

119. Which data sources can you use for the SAP list viewer with integrated
data access?
A. CDS View
B. Database procedure
C. External view
D. Database Table
E. Internal table

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

A. View restrictions
B. Analytic restrictions
C. Validity restrictions
D. Activity restrictions
E. Cube restrictions

121. You perform a static code check using the Code Inspector (SCI). In your
SCI variant, you select the Search problematic SELECT * statement check.
What does this check report?
A. SELECT * statements where fewer than a specified percentage of all
fields are effectively used
B. SELECT * statements on tables with more than a specified number of fields
C. SELECT * statements on tables with more than 100,000 records
D. SELECT * statements on tables with the Column Store storage type

122. Discuss different types of engines associated with The SAP HANA
architecture.
A. OLAP engine
B. Analytic engine
C. OPAX engine
D. Join engine

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

123. Which of the following options provides access to the views and database
procedures that you can consume in the ABAP environment?
A. Please choose the correct answer.
B. Catalogue outlook
C. Modeler Perspective
D. System Perspective
E. Open Content outlook

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

A. Use native SQL to access SAP HANA built-in functions.
B. Perform expensive calculations on the database.
C. Aggregate data on the database, and transfer the results to the ABAP
layer.
D. Perform expensive calculations on the ABAP application server.
E. Transfer all data from the database to the ABAP layer, and then aggregate
the results.

125. You use native SQL to access the SAP HANA database. What should
you do to retrieve the correct data?
A. Use the UP TO n ROWS addition
B. Use the tilde symbol (-) to separate the qualifier from the column name
C. Use a Comma-separated column list
D. Specify the database schema if it is not the user's default schema
E. Explicitly handle the client field

126. Which of the following tasks can you perform with SQL monitor
(transaction SQLM)?
A. Display the execution plan of an SQL statement
B. Capture the SQL profile of an application
C. Combine static and dynamic performance analysis results
D. Search for problematic SELECT* statements

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
1 1

127. What must you do when you define and implement an ABAP Managed
Database Procedure (>VWOP)?
A. Use scalar types for all AMDP method parameters.
B. Define all method parameters to be passed by value.
C. List all ABAP Dictionary tables used in the procedure body in the
USING clause.
D. Mark the AMDP method as a READ-ONLY database procedure.
E. Specify the database system and the language.

128. What information can you specify using annotations (marked with the @
sign) when you define a Core Data Services (CDS) view in a system?
A. The extent to which records of the CDS view should be buffered on the
application server
B. The name of the SQL View created in the database
C. The logic for aggregations, grouping records, and filtering groups of the
CDS view
D. The link between an amount field and the relevant currency code
E. TTie join conditions of the CDS view

129. Which of the following objects can you use in the ABAP layer when using
the top-down approach for code-lo-data?
A. Calculation views
B. Stored procedures
C. Core Data Services views
D. ABAP Managed Database Procedures

Phone/Whatsapp: +1 (515) 309-7846 (USA) Email: [email protected]

www.zarantech.com
THANK YOU

Corporate Training Course Catalog

https://bit.ly/SAP-course-catalog

SAP Learner Community

https://www.linkedin.com/showcase/sap-learner-community/

Get any SAP Video Training

https://zarantech.teachable.com/courses/category/sap

Phone/Whatsapp: +1 (515) 309-7846

Email: [email protected]
www.zarantech.com