SAP ABAP ON HANA MCQ with answer

Hello friends in this article we are going to discuss about SAP ABAP on HANA MCQs with Answer | SAP ABAP ON HANA Multiple Choice Questions with answer | SAP ABAP ON HANA Dump 2021-2022 | ABAP on Hana Certification dump 2022 | ABAP on HANA Practise Multiple choice questions

Q1.What are the Parameters for Analytical and Calculation view? There are 3 correct
answers.

A Passing other values to be used in calculations
B To store data for critical analysis
C Create a copy of a report
D Specifying unit of measurement
E Setting a filter for columns

Show Answer

Q2.You want to define an ABAP Core Data Services (CDS) view that totals the
NET_AMOUNT column for each sales order (column SO_ID). Which SELECT
statement would you use in the definition?

ANS – select from tab_so
{
so_id,
sum(net_amount) as sum_amount
}
group by sojd

Q3.What are the steps involved in supporting a database oriented programming
model? There are 2 correct answers.

A. A new and advanced Open SQL

B. Buffer system servieces

C. Core data services

D. Advanced and specific models

Show Answer

Q4.Which of the following new repository objects belongs to code push down
approach?
There are 2 correct answers.

A CDS views
B ABAP managed database procedure
C database procedure proxy
D external view

Show Answer

Q5.What are the basic principles of SAP ALV IDA ?
There are 2 correct answers.

A The ALV Optimization for SAP HANA to display data on the screen
B To ensure that the user chooses the data on the selection screen is
displayed
C Only retrieve the database data which is to be displayed on
screen
D Data described declaratively instead of passing big internal table

Show Answer

Q6.In ABAP Managed database procedure (AMDP), what do you have to list after the
USING clause? There are 3 correct answers

A AMDP used in the procedure body
B CE function used in the procedure body
C ABAP Dictionary views used in the procedure body
D ABAP Dictionary table used in the procedure body.

Show Answer

Q7.Which are the features added to the ABAP Dictionary to support the SAP HANA
database?
There are 3 correct answers.

A Changes of data class
B De-pooling and de-clustering
C Storage type for tables
D Definition of full-text indexes

Show Answer

Q8.Which of the following objects must you create if you want to allow the
enhancement of AMDP using business add-in (BADI).
There are 3 correct answers .

A A BADI definition
B A database procedure
C A BADI simple implementation
D A BADI fallback implementation
E An enhancement spot

Show Answer

Q9.What are the benefits includes with SAP HANA Full Text Search? There are 2
correct answers.

ANS – Fewer data duplication and movement,Easy to use modeling tool

Q10.Which is the new concept that is introduced and improved by using SAP HANA
specific features?

ans – ABAP-Managed Database Procedures

Q11.In static code check using the Code Inspector (SCI) variant, you select the “search
problematic SELECT * statements check. What does this check report?

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

Q12.ABAP 7.4 provides support for optimizing ABAP applications running on SAP
HANA. What are these Transparent Optimizations? There are 3 correct answers.

A The consumption of SAP HANA artifacts was simplified (Correct)
B The ABAP language and the OpenSQL language have been
extended
C Performance analysis tools have been improved (Correct)
D Re- use components have been extended or optimized for SAP HANA
E Do all the data processing in Application server

Show Answer

Q13.What are the conditions required to ensure the Referential Integrity? There are 2
correct answers.

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

Show Answer

Q14.What are the two different kinds of Identifiers used to represent names used in
SQL statement? There are 2 correct answers.

A Limited identifiers
B Undelimited Identifiers
C Numeric identifiers
D Delimited identifiers

Show Answer

Q15.Which of the following folder is essential to relate to Smart Data Access (SDA) and
also combines data from remote sources?

ANS – Provisioning folder

Q16.What are the benefits associated with The SAP HANA real-time operational
analytics? There are 2 correct answers.

A High modeling flexibility (Correct)
B Fast insights into business activity (Correct)
C Query Speed support
D Simplification of massive data

Show Answer

Q17.List down the elements involved in User Management and Security in SAP HANA?
There are 3 correct answers.

A Work management
B Assign security
C Manage users
D Create users
E Assign job security

Show Answer

Q18.Which of the following repository object can you edit only in ABAP Development
tools in Eclipse and not in the Classical ABAP workbench?
There are 3 correct answers to this question.

A ABAP program containing new Open SQL
B Database procedure proxy
C Full-text index
D External view
E Core Data service (CDS) view

Show Answer

Q19.Which data provisioning methods can you use when you need real time
replications? There are 3 correct answers.

A SAP Replication server
B SAP Landscape transformation Replication server (SAP SLT)
C SAP HANA Direct extractor connection (SAP DXC)
D SAP Data services

Show Answer

Q20.When your customer wants to migrate to SAP HANA, Which of the following steps
you must perform to get the information about the business processes that
should be optimized ?
There are 2 correct answers.

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. (Correct)
C Activate the new SQL Monitor in a development system.
D Combine the results of the SQL Monitor with the results of a
static source code analysis.

Show Answer

Q21.Which of the following SAP HANA based scenarios involve ABAP applications?
There are 2 correct answers.

A SAP HANA as business accelerator
B Data mart based on SAP HANA
C AS ABAP with SAP HANA as primary database
D Native SAP HANA applications

Show Answer

Q22.What must you do when you define and implement an ABAP Managed Database
Procedure (AMDP)?
There are 3 correct answers.

A Mark the AMDP method as a READ-ONLY database procedure.
B Specify the database system and the language.
C List all ABAP Dictionary tables used in the procedure body in the
USING clause.
D Define all method parameters to be passed by value.
E Use scalar types for all AMDP method parameters.

Show Answer

Q23.Which are the best practices when programming in ABAP for SAP HANA?
There are 2 correct answers.

A Use the column list in the SELECT clause to ensure that you only
read a column if it is really required
B Eliminate nested SELECT statements to reduce the overall
number of database accesses
C Use repeated SELECT SINGLE statements to ensure that you only read a row
if it is really required
D Calculate aggregations using ABAP code on the applications server to limit
database load

Show Answer

Q24.Approach use to follow the code-to-data programming?
There are 3 correct answers.

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

Show Answer

Q25.When are referential joins executed in analytical views?

A When fields are selected
B When fields from both the tables are requested (Correct)
C When all the tables are optimized
D When fields are optimized

Show Answer Next »