The new bottlenecks avoided by addressing two challenges, what are they?
There are 2 correct answers to this question. Avoid CPU cache misses Avoid single network Avoid optimizing data Avoid idling CPU cores.
Where do you define a set of Code Inspector checks that you want to perform?
Please choose the correct answer. In a Code Inspector object check variant In a Code Inspector inspection In a Code Inspector object list.
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?
Please choose the correct answer. {it_books} :it_books @it_books it_books.
What are functions of the ABAP Managed Database Procedure (AMDP) framework?
There are 2 correct answers to this question. It creates the database procedure when the AMDP is first activated. It deletes obsolete versions of the database procedure synchronously. It deletes obsolete versions of the database procedure asynchronously It creates the database procedure when the AMDP is first called.
How will you hide the attributes that are not required for client consumption?
Please choose the correct answer. By setting the hidden property flag of the attribute provider By setting the hidden property flag of the attribute column By setting the hidden property flag of the attribute in the Semantics screen By setting the hidden property flag of the attribute in the View.
You created and activated a database procedure. From where can you call this procedure?
There are 2 correct answers to this question. From a Script-based calculation view From a Core Data Services view From another database procedure From a graphical calculation view.
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?
There are 2 correct answers to this question. Screen editing Form-based class builder Quickfix Content assistance.
Discuss the basic approach of classical ABAP programming?
There are 2 correct answers to this question. Keep load from the database Collect all the data and perform Parallel processing in ABAP Get all the data you need on the application server and do your processing in ABAP Creating and consuming all the contents from network.
Which of the following SAP HANA-based scenarios involve ABAP applications?
There are 2 correct answers to this question. AS ABAP with SAP HANA as primary database SAP HANA as Business Accelerator Native SAP HANA applications Data marts based on SAP HANA.
Which SQL syntax is used to create a read only procedure?
Please choose the correct answer. READS PROCEDURE NO-SIDE-EFFECT READS SQL DATA READ-ONLY.
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?
Please choose the correct answer. Direct access to Table Pools/Cluster Missing ORDER BY or SORT after SELECT Use of Native SQL and DB Hints Existence check for Secondary Indexes.
The source code editor in ADT provides many helpful features. What are these helpful features?
There are 2 correct answers to this question. Creating Method Implementations from the Method Definition Creating Method Definitions from Implementation Parts Creating interface from Method Calls Creating Parts for Interface Methods.
What are the uses of SQL Trace (ST05)?
There are 3 correct answers to this question. Locate database performance issues Applying Code inspector Detect redundant or identical select statements Display record of all database access Locate work base issues.
ABAP 7.4 provides support for optimizing ABAP applications running on SAP HANA. What are these Transparent Optimizations?
There are 3 correct answers to this question. Performance analysis tools have been improved The consumption of SAP HANA artifacts was simplified Do all the data processing in Application server Re-use components have been extended or optimized for SAP HANA The ABAP language and the OpenSQL language have been extended.
What are the types of schemas in HANA?
There are 3 correct answers to this question. SLT Derived Schema User Defined Schema Dynamic Schema System Defined Schema.
Which components can be a part of a calculation view?
There are 3 correct answers to this question. BAPIs Tables Attribute View Analytic View.
Which system schema contains the information about Time data and Schema Mapping?
Please choose the correct answer. _SYS_BI _SYS_BIC _SYS_XS _SYS_REPO.
What all are the advantages provides by ABAP Development Tools?
There are 3 correct answers to this question. A set of Eclipse data pool and Client- Open platform A set of open, language- and platform-independent APIs A brand new ABAP development experience on top of the Eclipse platform An open platform for developing new ABAP-related tools An open platform for developing powerful database view.
What should you do to follow the code-to-data approach to programming?
There are 3 correct answers to this question. Transfer all data from the database to the ABAP layer, and then aggregate the results. Aggregate data on the database, and transfer the results to the ABAP layer. Perform expensive calculations on the database. Use native SQL to access SAP HANA built-in functions. Perform expensive calculations on the ABAP application server.
You made changes to an object (X) 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 to this question. X is an SAP HANA view X is an AMDP method X is an ABAP Dictionary table X is a stored procedure.
You are using ABAP Development Tools, and you have placed your cursor on a method name in a class. What key do you use to navigate between a method definition and its implementation?
Please choose the correct answer. F2 F3 F1 F4.
Name the views that are available to administer and monitor one or several SAP HANA systems?
There are 2 correct answers to this question. The System Monitor view The Administration view The Security view The Landscape view.
What are the basic principles of ALV SAP HANA?
There are 2 correct answers to this question. The ALV Optimization for SAP HANA to display data on the screen To ensure that the user chooses the data on the selection screen is displayed Only retrieve the database data which is to be displayed on screen Data described declaratively instead of passing big internal tables.
You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory?
There are 3 correct answers to this question. CASE order type WHEN 'A' THEN 1 ELSE 0 END AS order_type crtdby AS created_by SUM(revenue) AS total_revenue ASSOCIATION TO sflight AS _flights CAST('USO' AS abap.cuky) AS currency_key.
What are the conditions for using UNION in CDS Views?
There are 3 correct answers to this question. Be of compatible types Be in the same order Same client Handling Equal No. of columns.
What is Core Data Services (CDS)?
Please choose the correct answer. A collection of domain-specific languages and services for definition and consumption of semantically rich data models A collection of core features and services that provide data from the ABAP application server layer to the user interface A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system A collection of services that provide information about the data volumes of the SAP HANA core tables.
The SAP HANA state-of-the-art search experience includes full-text search with advanced features like...
There are 3 correct answers to this question. Fuzzy search linguistic search freestyle search ACID search Isolation search.
Which system schema contains the list of Activated and inactive Objects?
There are 2 correct answers to this question. Maintain, Monitor and test secondary database connection Maintain only HANA specific objects Use Schema for the Connections Used to access local or remote database system.
Which features does the source code editor provide in ABAP Development Tools (ADT)?
There are 2 correct answers to this question. Screen Painter Quick Fix Content Assist Form-based Class Builder.
What are the two main methods to add a system to the SAP HANA Studio?
There are 2 correct answers to this question. Automatically Manually By Importing a Landscape By Resource console.
Why is a security concept in SAP HANA required?
There are 2 correct answers to this question. Editing of SAP HANA data models should only be possible for “Users.” of the model Need to have selected users in SAP HANA for Information Management Access to ERP tables must be restricted Database administration should be restricted to skilled.
What is the purpose of an ABAP project in ABAP Development tools for eclipse?
There are 2 correct answers to this question. It represents the connection to the SAP HANA server It represents the connection to an ABAP system It is used to transport ABAP repository objects. It provides access to all ABAP repository objects in an ABAP system.
Which of the following features are NOT supported by ALV with IDA?
Please choose the correct answer. Double-click Excel export Personalization Editing values.
You want to implement business logic on the database layer. Which approach do you follow when implementing an ABAP Managed Database Procedure?
Please choose the correct answer. The Left-Right approach The Near-Far approach The Inside-Out approach The Top-Down approach.
Where can you evaluate an exposed association?
There are 3 correct answers to this question. In the Data Preview of ADT In another CDS view In the Data Browser (transaction SE16) In an Open SQL SELECT statement.
What are the Possible Approaches with AS ABAP < 7.4 SP02?
There are 2 correct answers to this question. Interaction with Database Stored Procedures Consume using native SQL SQL units.
In order to get language-specific data, which join is used in SAP HANA?
Please choose the correct answer. Referential Join Text Join It is not possible to fetch language-specific data in HANA Language join.
Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA?
There are 2 correct answers to this question. Use array variants of INSERT UPDATE MODIFY and DELETE Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement Perform all calculations and aggregations in the ABAP layer Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES.
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. Full-text index Core Data service (CDS) view Database procedure proxy ABAP program containing new Open SQL External view.
What is a powerful tool for capturing the SQL profile of a system or transaction?
Please choose the correct answer. Code Inspector SQL Monitor ABAP Test Cockpit SQL Database.
|
