E_HANAAW_18 Practice Questions Preview

Question 1

Single choice

You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer.

A
Choose the debug as 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

Reveal answer details Close answer details

Correct answerC

Question 2

Single choice

For which purpose can you use literal values in an Open SQL statement?

A
To perform a generic existence check
B
To provide a default value for a database table column
C
To alias the result of an arithmetic expression
D
To comment your development directly in the coding

Reveal answer details Close answer details

Correct answerA

Question 3

Multiple choice

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

What do you have to list after the USING clause? (3 answers)

A
ABAP Dictionary views used in the procedure body
B
ABAP Dictionary table used in the procedure body
C
AMDP used in the procedure body
D
function used in the procedure body
E
SAP HANA views used in the procedure body

Reveal answer details Close answer details

Correct answersA, B, C

Question 4

Single choice

What is Core Data Services (CDS)?

A
A collection of services that provide information about the data volumes of the SAP HANA core tables
B
A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system
C
A collection of core features and services that provide data from the ABAP application server layer to the user interface
D
A collection of domain-specific languages and services for definition and consumption of semantically rich data models

Reveal answer details Close answer details

Correct answerD

Question 5

Multiple choice

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? There are 3 correct answers to this question.

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

Reveal answer details Close answer details

Correct answersA, C, D

Question 6

Single choice

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? Please choose the correct answer.

A
SET_PARAM_TABLE
B
SET_PARAM
C
EXECUTE_QUERY
D
NEXT_PACKAGE

Reveal answer details Close answer details

Correct answerD

Question 7

Multiple choice

Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question

A
Convert crosstab cells to formula
B
Analyze data with the design pane
C
Suggests style sets for crosstabs
D
Sort data by characteristics

Reveal answer details Close answer details

Correct answersA, B

Question 8

Single choice

User STUDENT_A creates and activates a design-time Object.
In which schema is the runtime object generated?

A
SYS_BI
B
SYSTEM
C
_SYS_BIC
D
STUDENT_A

Reveal answer details Close answer details

Correct answerC

Question 9

Multiple choice

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 2HA400_00. WHICH
PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database?
There are 2 correct answers to this question.

A
View CA_CUSTOMER has deployment mode A.
B
Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK
C
SYSTEM P81 has SAP HANA has primary database
D
PACKAGE ZHA400J30 HAS deployment Mode A

Reveal answer details Close answer details

Correct answersB, C

Question 10

Multiple choice

Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.

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

Reveal answer details Close answer details

Correct answersC, D

Question 11

Multiple choice

Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question.

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 network
C
Keep load from the database
D
Collect all the data and perform Parallel processing in ABAP

Reveal answer details Close answer details

Correct answersA, C

Question 12

Single choice

Which of the following is latest release of SAP HANA?

A
SAP HANA 1.0 SP06
B
SAP HANA 1.0
C
SAP HANA 1.6 SP03
D
SAP HANA 2.0 SPS 04

Reveal answer details Close answer details

Correct answerD

Question 13

Multiple choice

What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.

A
Open system properties
B
Administration console
C
Development properties
D
System Properties

Reveal answer details Close answer details

Correct answersA, B

Question 14

Single choice

What output does the SAP HANA provide as a unique combination of hardware and software innovations?
Please choose the correct answer.

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

Reveal answer details Close answer details

Correct answerA

Question 15

Multiple choice

Which of the following can be part of an analytic view? (3 answers)

A
Query transformation
B
Logical joins
C
Attributes
D
Data foundation
E
Unions

Reveal answer details Close answer details

Correct answersB, C, D

Question 16

Single choice

You plan a database migration to SAP HANA and want to check your ABAP coding for performance optimization potential.

Which Code Inspector check variant can you use?

A
PERFORMANCE_OPT
B
CHECK_PERFORMANCE
C
FUNCTIONAL_DB
D
PERFORMANCE_DB

Reveal answer details Close answer details

Correct answerD

Question 17

Multiple choice

What are the features of New Open SQL? There are 2 correct answers to this question.

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

Reveal answer details Close answer details

Correct answersA, D

Question 18

Single choice

Which TADIR object type is used for the definition of a Core Data Services (CDS) view?

A
R3TR TABL
B
R3TR VIEW
C
R3TR DDLS
D
R3TR DDIC

Reveal answer details Close answer details

Correct answerC

Question 19

Multiple choice

Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)?

There are 3 correct answers to this question.

A
Returning
B
Receiving
C
Exporting
D
Changing
E
Importing

Reveal answer details Close answer details

Correct answersC, D, E

Question 20

Multiple choice

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.

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

Reveal answer details Close answer details

Correct answersB, C

Question 21

Multiple choice

Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 answers

A
SQLM
B
SE09
C
SWLT
D
ST22
E
SE3S

Reveal answer details Close answer details

Correct answersA, C

Question 22

Multiple choice

How can you consume a Core Data Services (CDS) view? 2 answers

A
Use the Data Preview in ABAP Development Tools for SAP NetWeaver.
B
Use it as a data source in the FROM clause of an Open SQL query.
C
Use the ABAP language statement WRITE and the CDS view name as the argument.
D
Use the CDS maintenance transaction (SCDSV).

Reveal answer details Close answer details

Correct answersA, B

Question 23

Multiple choice

What are the advantages of column based tables? (3 correct answers)

A
Bigger Data Set
B
Better Compression
C
Better parallel Processing
D
Faster Data Access

Reveal answer details Close answer details

Correct answersB, C, D

Question 24

Single choice

What is the main function of Static Code Analysis? Please choose the correct answer.

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

Reveal answer details Close answer details

Correct answerA

Question 25

Multiple choice

Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 answers

A
LEFT OUTER JOIN
B
CROSS JOIN
C
FULL OUTER JOIN
D
RIGHT OUTER JOIN
E
REFERENTIAL JOIN

Reveal answer details Close answer details

Correct answersA, D

Question 26

Single choice

How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement?

Please choose the correct answer.

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

Reveal answer details Close answer details

Correct answerC

Question 27

Single choice

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? Please choose the correct answer.

A
Release resources
B
Update resources
C
Update resources
D
Update packages

Reveal answer details Close answer details

Correct answerA