What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to his question
- A . To reduce main memory consumption and to improve insert performance
- B . to keep all the loads away from the DB
- C . It is beneficial to move data-intensive calculations into the database
- D . It is beneficial for maximizing your search into database
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
Which system schema/user is the owner of all the activated objects?
- A . _SYS_XS
- B . _SYS_BI
- C . _SYS_REP0
- D . _SYS_BIC
Which of the following information is mandatory in the definition of an association in a Core Data Services (CDS) view?
- A . The filter condition for the association
- B . The cardinality of the association
- C . The alias for the association
- D . The target entity of the association
How can you enhance an existing ABAP Search Help with a type-ahead function?
- A . Use the enhanced options in transaction SE11.
- B . Use the fuzzy-search exit in transaction SE11.
- C . Modify the search help with the Native SQL command ALTER SEARCH HELP.
- D . Enhance the lookup table with an additional ACCURACY field and insert an accuracy value.
Which of the following is true? (2 correct answers)
- A . A read only procedure cannot call read-write procedure.
- B . A Read-write procedure cannot call another read-write procedure.
- C . A read-write procedure can call both read-write and read only procedures.
Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question.
- 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 ABAP Dictionary
- E . Define the type mapping between ABAP and SAP HANA
List down the three main concepts of the SAP HANA database There are 3 correct answers to this question
- A . Column Store
- B . Tools combinations
- C . Object store
- D . Partitioning
- E . Compression
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
Which of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 ans
- A . CL_SQL_EXECUTE_QUERY
- B . CL_SQL_RESULT_SET
- C . CL_SQL_STATEMENT
- D . CL_EXEC_SQL
- E . CL_ADBC_SQL_STATEMENT
What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.
- A . Automatic release of units
- B . Changes to Delta Container
- C . You need to refresh the content of the container manually
- D . Take snapshot manually before releasing of the container
AM DP can detect 3 types of syntax errors in active or inactive source code .
What are these errors? There are 3 correct answers to this question.
- A . UNION specific syntax errors
- B . Database platform syntax errors
- C . Database independent syntax errors
- D . HANA specific syntax errors
- E . SQLScript errors
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
Name the views that are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question
- A . The Landscape view
- B . The System Monitor view
- C . The Security view
- D . The Administration view
What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question
- 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
Which conditional expressions can be used in Core Data Services (CDS) views? 2 ans
- A . CASE statements in the projection list
- B . IF statements in the projection list
- C . WHILE statements in the WHERE clause
- D . COALESCE functions in the projection list
- E . CASE statements in the HAVING clause
What are the basic principles of ALV SAP HANA? There are 2 correct answers to this question.
- A . Data described declaratively instead of passing big internal tables
- B . The ALV Optimization for SAP HANA to display data on the screen
- C . Only retrieve the database data which is to be displayed on screen
- D . To ensure that the user chooses the data on the selection screen is displayed
You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings table? Why do you create a row store instead of a column store Please choose the correct answer.
- A . To allow creation of a full-text index
- B . To limit the unpacking and reconstruction of rows
- C . To limit the need of indexes
- D . To limit the data footprint
What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question.
- 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 really required
- D . Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required
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.
- A . Database Optimization
- B . Transparent Optimizations
- C . HANA Specific features
- D . Buffer system Optimization
Which of the statements are true for SQLScript? (2 answers)
- A . SQLScript is an open standard.
- B . SQLScript is used to push down data intensive logic into the database.
- C . SQLScript is a collection of extensions to SQL.
Which of the following is true?
- A . ABAP
- B . OSQL
- C . Oc#
- D . Java
You define a core data services (CDS) View.
For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question.
- A . CASTE Expression
- B . CASE expression
- C . Currency Conversion
- D . Nested CASE expression
- E . Unit conversion
What should you do to follow the code-to-data approach to programming? 2 ans
- A . Perform expensive calculations on the database
- B . Transfer all data from the database to the ABAP layer, and then aggregate the results.
- C . Perform expensive calculations on the ABAP application server.
- D . Aggregate data on the database, and transfer the results to the ABAP layer.
Graphical calculation views can later be converted to Scripted calculation view if required.
- A . Ono
- B . yes
How will you select a preference for Validation rules? Choose the correct answer
- 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
Hybrid Data Management System – Combining different paradigms in one system. Discuss capabilities associated with the
Hybrid Data Management system?
There are 3 correct answers to this question.
- A . Built-in support for planning
- B . Text analysis and search
- C . Text indexing capabilities
- D . Traditional disk-based tables
- E . Linguistic search capabilities
What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question.
- A . A set of open, language- and platform-independent APIs
- B . A brand new ABAP development experience on top of the Eclipse platform
- C . An open platform for developing new ABAP-related tools
- D . An open platform for developing powerful database view
- E . A set of Eclipse data pool and Client- Open platform
What language one should know to work in SAP HAN A?
- A . Java
- B . ABAP
- C . C#
- D . SQL
What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer.
- A . Code execution
- B . Quick Fix
- C . Debug perspective
- D . ABAP debugger
What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers)
- A . It provides access to all ABAP repository objects in an ABAP system.
- B . It represents the connection to an ABAP system
- C . It represents the connection to the SAP HANA server
- D . It is used to transport ABAP repository objects
What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers to this question.
- A . Scaling
- B . Optimize
- C . Detect
- D . Innovate
- E . Tuning
What is the full form of HANA?
- A . High-Performance Analytic Accelerator
- B . High-Performance Analytic Application
- C . High Accelerator Numeric Analytics
- D . High-Performance Analytic Appliance
What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are 3 correct answers to this question.
- A . Display diagrams
- B . Double-click on rows
- C . Search in content
- D . Edit cells
- E . Group rows
Which statement is true for SAP HANA?
- A . SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners
- B . SAP provides both hardware and software for SAP HANA.
Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? There are 2 correct answers to this question.
- A . Documented checks
- B . Enhanced distribution of results
- C . Configuration of check variants
- D . Flexible schedule of check runs
Which of the following is not an element of Analytical view? Please choose the correct answer.
- A . Currency conversion is not applicable
- B . Join fact tables
- C . Read Data from the joined database tables
- D . Used to Joined table
You developed an ABAP program using ABAP Development Tools for SAP NetWeaver .
How can you execute it? 2 ans
- A . In the Project Explorer view, right-click the program and choose Run As ― ABAP Application from the context menu.
- B . Use the Open Development Object dialog (CTRL+SHIFT+A) and enter <Program_Name>/Execute in the search field.
- C . Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8.
- D . Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl.
- E . Call transaction SRUN_ADT and enter the name of the ABAP program.
Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL? Please choose the correct answer.
- A . SAP HANA specific features
- B . Database oriented programming model
- C . New SQL parser used in model
- D . Database for sophisticated analysis
What is an attribute view and what are its practices? There are 3 correct answers to this question.
- A . May contain filters
- B . Used in diagrammatic Projections
- C . May use in calculation views
- D . Used to join tables
- E . May contains flow charts
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?
There are 2 correct answers to this question
- A . Include the client field in the field list.
- B . Include the client field in the WHERE condition.
- C . Include the client field in the join condition.
- D . Use the CLIENT SPECIFIED addition.
What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question.
- A . Sales
- B . Procurement
- C . Stock
- D . Services
- E . Product
What is the main advantage of SQLScript? (2 answers)
- A . SQLScript can be better modularized than traditional SQL
- B . SQLScript code can easily be translated into modeling view
- C . SQLScript is faster than traditional SQL
You plan a database migration to SAP HANA and want to check your ABAP coding for potential functional regressions.
Which Code Inspector check variant can you use?
- A . PREV_FUNC_REG
- B . FUNCTIONAL_DB
- C . FUNCTIONAL_CHECK
- D . PERFORMANCE DB
In which of the following situations could a row store table be more suitable than a column store table? There are 2 correct answers to this question
- 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.
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD) .
Which SELECT statement would you use in the definition? Please choose the correct answer.
- A . select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd
- B . select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd
- C . select from snwd_so {sojd, sum(net_amount) as sum_amount}
- D . select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount
ANSI SQL owns features and adds languages. These languages divided into three parts.
What are they? There are 3 correct answers to this question.
- A . Data Manipulation Language
- B . The Data Control Language
- C . The Database Language
- D . The Data Definition Language
- E . Data Transferred Language
Where can you consume associations in a Core Data Services (CDS) view? 3 ans
- A . In the projection list
- B . In the name list
- C . In the input parameter list
- D . In the FROM clause
- E . In the WHERE and HAVING clauses
What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.
- 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
Which features does the source code editor provide in ABAP Development Tools (ADT)? There are 2 correct answers to this question.
- A . Quick Fix
- B . Screen Painter
- C . Content Assist
- D . Form-based Class Builder
In order to get language-specific data, which join is used in SAP HANA?
- A . Referential Join
- B . Language join
- C . Text Join
- D . It is not possible to fetch language-specific data in HANA
Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 ans
- A . SQLM
- B . SE09
- C . SWLT
- D . ST22
- E . SE3S
What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment? There are 3 correct answers to this question.
- A . Organizing
- B . Administer
- C . Configure
- D . Monitor
- E . Selecting
Which engine is used to execute Analytic View?
- A . SQL Engine
- B . Calc Engine
- C . OLAP Engine
- D . Join Engine
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
Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question
- A . HANA Accelerators
- B . All HANA Combinations on one platform
- C . HANA Modeling
- D . All SAP applications on one SAP HANA platform
- E . Business Suite on HANA/ BW on SAP HANA
According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?
- A . Perform regular performance scans on your ABAP custom coding as part of the development process.
- B . Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process.
- C . Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5.
- D . Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion.
What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer
- A . The SAP HANA database supports 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
When are referential joins executed in analytical views? Choose the correct answer
- A . When all the tables are optimized
- B . When fields are selected
- C . When fields are optimized
- D . When fields from both the tables are requested
Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? There are 3 correct answers to this question.
- A . De-pooling and de-clustering
- B . Changes of data class
- C . Definition of full-text indexes
- D . Definition of an enhancement category
- E . Storage type for tables
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
Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?
- A . "Map to Data source"
- B . "Consume CDS view"
- C . "Relate to Business Entity"
- D . "Read from DDL source"
What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.
- 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
Which of the following are characteristics of an external view? There are 3 correct answers to this question.
- 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.
Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.
- A . Data base 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)
The source code editor in ADT provides many helpful features .
What are these helpful features? There are 2 correct answers to this question.
- 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
Which recent software innovations are applied in SAP HANA? 3 ans
- A . Columnar data storage
- B . Automated de-installation at system shutdown
- C . Improved data compression algorithms
- D . Insert Only approach
- E . Random Undefined Multi-Memory Swapping (RUMMS)
What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question.
- A . Read
- B . Create
- C . Delete/Edit Table
- D . Update
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
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