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.
Seleccione una: A. Release packages B. Release resources C. Update resources D. Update packages.
What do you understand by The SAP HANA Software Optimization?
Choose the correct answer.
Seleccione una: A. Provide combinations of Objects and Partitioning B. Bring logic to where the data is calculated first, then only move to results C. Speed up the processing within the database D. Huge potential for hybrid database.
Which of the following option provides access to the views and database procedures that you canconsume in the ABAP environment?
Please choose the correct answer.
Seleccione una: A. Open Content outlook B. Modeler Perspective C. System Perspective D. Catalogue outlook.
What all are the advantages provides by ABAP Development Tools?
There are 3 correct answers to this question.
Seleccione una o más de una:
A. A set of open, language- and platform-independent APIs B. An open platform for developing new ABAP-related tools C. A brand new ABAP development experience on top of the Eclipse platform D. An open platform for developing powerful database view E. A set of Eclipse data pool and Client- Open platform.
What are the features of New Open SQL?
There are 2 correct answers to this question. A. Supports specific units of database B. Supports arithmetic and string expressions C. Supports Code adjustment model D. Supports conditional expressions.
How to create a core data services view?
There are 3 correct answers to this question. A. Use data services tools for updates B. Use DDL statement DEFINE VIEW and SQL-like syntax to define the view C. Use the ABAP Development Tools for SAP NetWeaver D. Use additional annotations – marked with the @ sign E. Use SQL capabilities for Netweaver.
What are the Functions of Transaction DBACOCKPIT?
There are 2 correct answers to this question. A. Maintain only HANA specific objects B. Maintain, Monitor and test secondary database connection C. Use Schema for the Connections D. Used to access local or remote database system.
What are the steps that supported several tools, which in total result in a Guided Performance Optimization?
There are 2 correct answers to this question.
Seleccione una o más de una: A. A new tool called SQL Monitor to determine the priority if different programs access the databaseintensively B. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption C. A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional andperformance issues. D. Tools analyzing performance at run-time, to determine if critical constructs.
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.
What are the uses of SQL Trace (ST05)?
There are 3 correct answers to this question. A. Locate database performance issues B. Applying Code inspector C. Display record of all database access D. Detect redundant or identical select statements E. Locate work base issues.
Discuss the conditions required to ensure the Referential Integrity?
There are 2 correct answers to this question. A. Referential integrity holds true in both the directions B. There is at least one join in the other table C. There are three joins in the table D. There are two joins in the able.
The SAP HANA database is a hybrid in-memory database that combines Few technologies within. Whatare these technologies?
There are 3 correct answers to this question. A. Column-based database technology B. Row-based database technology C. Time-based database technology D. Value-based database technology E. Object-based database technology.
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for eachsales order (column SO_ID). Which SELECT statement would you use in the definition?
Choose the correct answer.
Seleccione una: A. select from snwd_so { so_id, sum(net_amount) as sum_amount } order by so_id B. select from snwd_so { so_id, sum(net_amount) as sum_amount } C. select from snwd_so { so_id, sum(net_amount) as sum_amount } group by net_amount D. select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id.
How SAP HANA supports SQL?
There are 3 correct answers to this question. A. Read B. As a means to define C. As a Data Calculator D. Manipulate data E. Transferring data.
Which of the following are performance recommendations when using SAP HANA?
There are 2 correct answers to this question. A. Filter data in lower layers. B. Define indexes on the columns that are used in calculations. C. Avoid transferring large result sets between database and client applications. D. Move data-intensive calculations from the database to an application server.
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.
A. The consumption of SAP HANA artifacts was simplified B. Performance analysis tools have been improved C. Do all the data processing in Application server D. Re- use components have been extended or optimized for SAP HANA E. The ABAP language and the OpenSQL language have been extended.
What are the two types of editors available in ADT?
There are 2 correct answers to this question.
Seleccione una o más de una: A. Eclipse (native) B. Client (native) C. ABAP (native) D. SAP (GUI).
Explain Transitioning ABAP Code to SAP HANA – Performance Considerations?
There are 3 correct answers to this question. A. Some codes transferred to other systems B. Some shifts in priorities, examples, nested selects(higher) indices(lower) C. Some codes immediately run faster D. Classical performances recommendations for open SQL remain valid E. Some codes impacted positively and should be priorities.
An Analytic Privilege consists of several restrictions. What are they?
There 3 correct answers to this question. A. Activity restrictions B. Validity restrictions C. Cube restrictions D. Analytic restrictions E. View restrictions.
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 indexing capabilities C. Text analysis and search D. Traditional disk-based tables E. Linguistic search capabilities.
What are the Perspectives and Views of SAP HANA Studio?
There are 2 correct answers to this question.
Seleccione una o más de una: A. System and Properties B. Development properties C. Administration console D. Open system properties.
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. Identify Elementary Search Help C. Automatic updates of all the input fields D. Check Pre-Requisites E. Switch on proposal search for input fields.
In SAP HANA studio, in which of the following can you create users?
There are 2 correct answers to this question. A. The Content node B. The Roles node C. The Administration console D. The SQL editor.
What are the two main methods to add a system to the SAP HANA Studio?
There are 2 correct answers to this question. A. Automatically B. By Resource console C. By Importing a Landscape D. Manually.
What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling?
There are 2 correct answers to this question. A. Product-based Profitability B. Account-based Profitability C. Service-based profitability D. Costing-based Profitability.
Which is not a Golden Rule for Open SQL?
Please choose the correct answer.
Seleccione una: A. Reduce the Database Load B. Minimize the Number of Database Accesses C. Keep the result set large D. Minimize the Amount of Data Transferred.
What are the components of The Enterprise Procurement Model Demo Scenario?
There are 3 correct answers to this question. A. Procurement B. Services C. Sales D. Product E. Stock.
You have an SQLScript procedure with a table input parameter it_books. You want to use the
parameteron the right-hand side of an assignment operator within the procedure.
Please choose the correct answer.
Seleccione una: A. :it_books B. @it_books C. {it_books} D. it_books.
What are the Performance Rules and Guidelines for ABAP on SAP HANA?
There are 2 correct answers to this question. A. It is beneficial to move data-intensive calculations into the database B. To reduce main memory consumption and to improve insert performance C. It is beneficial for maximizing your search into database D. To Keep all the loads away from the DB.
What information can you specify using annotations (marked with the @ sign) when you define a CoreData Services (CDS) view in an ABAP system?
There are 3 correct answers to this question. A. The name of the representation of the CDS view in the ABAP dictionary. B. The extent to which records of the CDS view should be buffered on the application server. C. The join conditions of the CDS view. D. The logic for aggregations, grouping records, and filtering groups of the CDS view. E. The client dependency of the CDS view.
When are referential joins executed in analytical views?
Choose the correct answer. A. When fields from both the tables are requested B. When all the tables are optimized C. When fields are optimized D. When fields are selected.
When would you use a column store table instead of a row store table?
There are 2 correct answers to this question. A. When you require aggregation and analysis of values B. When there are mainly distinct values in the table C. When you want to enable a full-text search of the table D. When the table has a small number of records.
What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA?
There are 3 correct answers to this question. A. Optimize B. Tuning C. Detect D. Scaling E. Innovate.
You have created a graphical calculation view with a large number of columns. Which of the following doyou use to ensure that only required columns are shown when querying the created view?
There are 2 correct answers to this question. A. The Type selection in the semantics area B. The Hidden checkbox in the semantics area C. Projection nodes D. Function CE_PROJECTION.
What are the key points that should be kept in mind while performing the Nonautomatic update in SAPHANA Transport Container?
There are 2 correct answers to this question. A. You need to refresh the content of the container manually B. Take snapshot manually before releasing of the container C. Automatic release of units D. Changes to Delta Container.
What all are the factors involved in Working with ADT?
There are 3 correct answers to this question. A. ABAP Class B. ABAP interface C. Workbench programs D. ABAP programs E. Module interface.
What are the steps involved in SAP HANA Evolution?
There are 3 correct answers to this question. A. ABAP applications on SAP HANA B. Optimized ABAP on SAP HANA C. ABAP can run on SAP HANA D. ABAP can access SAP HANA E. ABAP as accelerator on SAP HANA.
AMDP 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. Database platform syntax errors B. Database independent syntax errors C. UNION specific syntax errors D. HANA specific syntax errors E. SQLScript errors.
Discuss the main capabilities of SAP Business Objects Analysis for Office?
There are 2 correct answers to this question. A. Sort data by characteristics B. Analyze data with the design panel C. Convert crosstab cells to formula D. Suggests style sets for crosstabs.
What should you do to follow the code-to-data approach to programming?
There are 2 correct answers to this question. A. Perform expensive calculations on the ABAP application server. B. Perform expensive calculations on the database. C. Aggregate data on the database, and transfer the results to the ABAP layer. D. Transfer all data from the database to the ABAP layer, and then aggregate the results.
What are the benefits of using the SQL Monitor (transaction SQLM)?
There are 2 correct answers to this question.
Seleccione una o más de una: A. It collects monitoring data asynchronously without additional database interaction. B. It displays the database execution plan for all SQL statements. C. It schedules ABAP programs to monitor and log all database accesses. D. It can be active in a production system with minimal performance overhead.
What is the main purpose of SAML for SAP HANA Studio?
Choose the correct answer A. The assertion is issued by a user after the client was successfully authenticated B. The SAP HANA database supports login of Owners only C. SAML may be selected as an Owner’s authentication method when creating users in the SAP HANAStudio D. To support scenarios where clients are not directly connected to the SAP HANA Database.
Which is the new concept that is introduced and improved by using SAP HANA Specific Features?
Please choose the correct answer. A. New advanced SQL syntax Procedures B. ABAP-Managed Database Procedures C. Programming model D. Table buffering.
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)?
Please choose the correct answer.
Seleccione una: A. Combine information from static ABAP code scans with runtime data from the SQL Monitor. B. Combine information from static ABAP code scans with runtime data from the SQL Trace tool. C. Estimate the new total runtime of optimized code. D. Create a graph comparing the runtimes of ABAP code before and after optimization.
Explain the Enterprise Information System of - SAP HANA Implementation Scenarios?
There are 3 correct answers to this question. A. Business Suite on HANA / BW on SAP HANA B. All SAP applications on one SAP HANA platform C. HANA Accelerators D. HANA Modeling E. All HANA Combinations on one platform.
For what purpose do you use SQL Script in SAP HANA?
There are 2 correct answers to this question. A. To combine two analytic views B. To achieve very high performance on SELECT statements C. To transfer a large amount of data between engines D. To create database procedures.
Which of the following are characteristics of a referential join?
There are 2 correct answers to this question.
Seleccione una o más de una: A. It requires referential integrity between right and left tables B. If a field is selected from the right table, it acts similar to an inner join C. It assumes referential integrity between right and left tables D. If a field is selected from the right table, it acts similar to a left outer join.
Which tasks does the ABAP Managed Database Procedure (AMDP) framework perform?
There are 2 correct answers to this question. A. Creating a new version of the database procedure when the AMDP is first called. B. Deleting the obsolete versions of the database procedure synchronously. C. Creating a new version of the database procedure when the AMDP is first activated. D. Deleting the obsolete versions of the database procedure asynchronously.
When to use Enhanced Open SQL?
There are 2 correct answers to this question.
Seleccione una o más de una: A. At the time of Dictionary Views B. To access system fields C. Need the query in one piece of code only D. To view scalar components.
The new bottlenecks avoided by addressing two challenges, what are they?
There are 2 correct answers to this question. A. Avoid CPU cache misses B. Avoid single network C. Avoid optimizing data D. Avoid idling CPU cores.
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 only a small number of records. C. The table contains text that you want to search. D. The table contains mainly distinct values per column across rows.
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 interface from Method Calls B. Creating Method Definitions from Implementation Parts C. Creating Method Implementations from the Method Definition D. Creating Parts for Interface Methods.
Which of the following folder is essential to relate to Smart Data Access and also combines data fromremote sources?
Choose the correct answer.
Seleccione una: A. Administration folder B. Provisioning folder C. Security folder D. Content folder.
|
