Free SAP ABAP for HANA Certification Questions

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

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

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

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

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

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

Which views are available to administer and monitor one or several SAP HANA systems ?
There are 2 correct answers.

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

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

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

In addition to closing the result set, what else CLOSE method of the CL_SQL_RESULT_SET class in ABAP Database Connectivity (ADBC) do ?

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

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

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.

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 .

What are the basic approach of classical ABAP programming?
There are 2 correct answers.

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?

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

Which of the following options in ABAP Development Tools (ADT) in eclipse belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench?

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

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

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

Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)?

What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers.

Which of the following entries can be found under node CATALOG and not under node CONTENT ?
There are 2 correct answers.

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

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?

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

When are referential joins executed in analytical views?

Which of the following option is not the main capability of SAP Business Objects Analysis for OLAP?

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

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.

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

What are the advanced features of SAP HANA full-text search.
There are 3 correct answers.

You create a new table definition using ABAP dictionary and maintain the database specific technical setting. Why do you create a row store instead of a column store table?

Which of the following are potential functional issues when migrating ABAP code to SAP HANA ?
There are 2 correct answers.

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

What are different types of engines associated with the SAP HANA architecture?
There are 2 correct answers.

Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver? There are 2 correct answers.

What all are the advantages provides by ABAP Development Tools (ADT) in eclipse ?
There are 3 correct answers.

Which of the following feature were added to ABAP dictionary to support the SAP HANA database? There are 3 correct answers.

In an ABAP Core Data services (CDS) view, what you must do to expose an association for use in another CDS view?

What is the Limitations of ALV for SAP HANA? There are 3 correct answers.

Which of the following tasks can be you perform with SQL monitor (SQLM)?

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.

The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers.

What are the supported joins in CDS view? There are 2 correct answers.

What are the purposes of tools in SAP HANA system that is an eclipse-based integrated development environment? There are 3 correct answers.

AMDP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers.

When to use Enhanced Open SQL? There are 2 correct answers .

DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? There are 2 correct answers.

Which of the following are characteristics of an external view? There are 3 correct answers .

You have an SQLScript procedure with a table input parameter xyz. 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?

Perspectives that are available in the SAP HANA Studio? There are 3 correct answers.

What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers.

What views will be most efficient for General Modeling Principles? There are 2 correct answers.

Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers.

Which form of services is responsible for defining and consuming semantically rich data models?

What are the helpful features of source code editor in ADT ? There are 2 correct answers.

Which of the following categories of parameters can you use in the definition of an AMDP?
There are 3 correct answers.

Which is not a key factor of ALV for HANA?

You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? There are 3 correct answers.

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

Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? There are 2 correct answers.

What are the elements of ABAP Database Integration? There are 3 correct answers.

How to call the stored procedures in ABAP code?

What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers.

What are the ABAP development guidelines? There are 2 correct answers.

What output does The SAP HANA provide as a unique combination of hardware and software innovations?

Which tools can you use to provide input data for SQL performance tuning work list (transaction SWLT)?
There are 3 correct answers.

Which tools can you use to provide input data for SQL performance tuning work list (transaction SWLT)?
There are 3 correct answers.

Which code-to-data capability supports- Extended view definitions and Better SQL- 92 standard support in open SQL?

What are the main concepts of the SAP HANA database? There are 3 correct answers.

What is the central goal of using SAP HANA?

How to create a core data services (CDS) view? There are 3 correct answers.

Which of the following feature is not supported by ALV with IDA?

You want to import ABAP workbench request into SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA view CV_SCARR that belongs to package ZPKG_DEV.
Which pre-requisites are mandatory for an implicit development of the SAP HANA view onto the database?
There are 2 correct answer

What are the main capabilities of SAP Business Objects Analysis for Office? There are 2 correct answers.

Which of the following is a limitation when you create an external view?

Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers.

Which steps do you have to perform when defining a view using CDS?
There are 3 correct answers.

What is the main purpose of SAML for SAP HANA Studio?

What do you understand by The SAP HANA Software Optimization?

Which of the following tools and programming techniques use the SQL Data Definition Language?
There 2 correct answers.

How will you select a preference for Validation rules?

In SAP HANA SQL, you want to create a table whose definition should not be visible in the catalog? Which of the following table types fulfill this requirement?

What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers.

Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers.

what are the types of privileges associated with the authorization concept ? There are 3 correct answers

What information can you specify using annotations (@) when you define a Core Data Services (CDS) view in an ABAP system? There are 3 correct answers.

What are the two main factors of SAP HANA Innovations and Challenges? There are 2 correct answers.

Hybrid Data Management System combining different paradigms in one system. What are the capabilities associated with the Hybrid Data Management system? There are 3 correct answers.

How will you launch the debugger? If you want to debug an ABAP program using ABAP development tools (ADT).

Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does not offer?
There are 2 correct answers.

What are the uses of SQL Trace (ST05)? There are 3 correct answers.

What all are the factors involved in working with ADT ?. There are 3 correct answers.

What are the different views provided by the ABAP Profiling? There are 2 correct answers.

You use the ABAP trace (SAT) to measure the run time of a program. In a class, method A checks the validity of its importing parameters and calls method B. What pattern of gross and net run time would you expect to see the in the ABAP trace results for method A?

Which of the following are View Annotations?
There are 3 correct answers.

What are the two types of editors available in ADT? There are 2 correct answers.

User XYZ creates and activates a design-time object. In which schema is the run object generated?

How SAP HANA supports SQL? There are 3 correct answers.

What is the main function of Static Code Analysis?

When using ABAP Database Connectivity (ADBC) to issue native SQL calls to the database, which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call ?

For which of the following expressions and built in functions in core data services (CDS) View you must provide alias? There are 3 correct answers.

What are some of the features available in SAP List Viewer with integrated data access (SALV IDA)? There are 3 correct answers.

What are the important features offers by SAP HANA to upload data from flat files? There are 2 correct answers.

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? There are 2 correct answers.

When would you use a column store table instead of a row store table? There are 2 correct answers.

What is an attribute view and what are its practices? There are 3 correct answers.

Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment?

An analytic privilege consists of several restrictions. What are they? There 3 correct answers.

The SAP HANA database is a hybrid in-memory database that combines few technologies within. What are these technologies? There are 3 correct answers.

You made changes to an object B used by an ABAP managed database procedure (AMDP). You did not changes the AMDP itself. Now you execute a program that calls this AMDP. In which cases does the call trigger the creation of the database procedure in SAP HANA? There are 2 correct answers.

Which of the following is a limitation when you create an external view?

Which of the following is not a Golden Rule for Open SQL?

ANSI SQL owns features and adds languages, these languages divided into three parts. What are they? There are 3 correct answers.

What are the key points that should be kept in mind while performing the non automatic update in SAP HANA Transport Container? There are 2 correct answers.

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.

What helps you to resolve errors or warnings reported about the code?

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? There are 2 correct answers.

Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data?
There 2 correct answers.

You created and activated database procedure. How can you call this procedure? There are 2 correct answers.

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?

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

Which code-to-data capability is responsible for the Optimizations & Translation of ?Open SQL SELECT FOR ALL ENTRIES ?clauses into native SQL? Please choose the correct answer.

An access control (DCL source) defines access restrictions for a given CDS view. These resctrictions are implicitly evaluated when the CDS view is accessed in the following places?
There are 2 correct answers.

What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers.

Which of the following tasks can you perform with SQL monitor transaction SQLM ?

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

SAP HANA delivers Across 5 Dimensions. These five dimensions lead to certain goals HANA has to meet. What are these goals? There are 2 correct answers.

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?

What are the guidelines for optimizing ABAP code running on HANA? There are 3 correct answers.