INETUM_1

An ABAP developer notices that a particular transaction is taking longer than expected. They decide to use the Guided Performance Analysis tool. What outcomes can they expect? 3 Answers. Identification of performance bottlenecks in the code. Recommendations for code pushdown opportunities. Suggestions for database index optimizations. Insights into user behavior and transaction frequency. Detailed trace of SQL statements and their execution times.

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. UNION specific syntax errors. Database platform syntax errors. Database independent syntax errors. HANA specific syntax errors. SQLScript errors.

Analytic Privilege can be applied to __________. There are 3 correct answers to this question. Table. Analytic views. SQL View. Attribute views. Calculation views.

What can you include in the projection list of a Core Data Services (CDS) view? There are 3 correct answers to this question. A field from the projection list of another CDS view used in the FROM clause. A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause. Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause. ABAP system fields such as sy-langu or sy-mandt / CI String constants and literal values.

Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? There are 3 correct answers to this question. LANGUAGE dbjang (dbjang = SQLSCRIP ..). FOR db (db = HD ..). AUTHORIZATION db auth (db_auth = SYSTE ..). BY DATABASE PROCEDURE. CLIENT SPECIFIED.

Which of the following entities can be found in the object list of the ABAP Workbench or the Project Explorer of ADT? There are 2 correct answers to this question. Data definition (also known as DDL source). CDS view. SQL view.

The SAP HANA database is a hybrid in-memory database that combines Few technologies within. What are these technologies? There are 3 correct answers to this question. Value-based database technology. Time-based database technology. Row-based database technology. Column-based database technology. Object-based database technology.

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 Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to this question. To reduce main memory consumption and to improve insert performance. It is beneficial to move data-intensive calculations into the database. To Keep all the loads away from the DB. It is beneficial for maximizing your search into database.

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. Include the client field in the WHERE condition. Use the CLIENT SPECIFIED addition. Include the client field in the join condition. Include the client field in the field list.

What language one should know to work in SAP HANA? Please choose the correct answer. C#. Java. ABAP. SQL.

Which code-to-data capability supports- Extended view definitions and Better SQL- 92 standard support in open SQL? Please choose the correct answer. Database for sophisticated analysis. Database oriented programming model. SAP HANA specific features. New SQL parser used in model.

What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question. Fewer data duplication and movement. Easy to use modeling tool. Exploit structured contents in SQL. Large number of toolkits are available.

An import parameter that is annotated with @Environment.systemField: becomes optional in the following places: Please choose the correct answer. In Data Preview in ADT. In ABAP Open SQL. In the definition of another CDS view. In the Data Browser (SE16).

Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources? Please choose the correct answer. Content folder. Security folder. Provisioning folder. Administration folder.

What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question. Sales. Stock. Procurement. Product. Services.

What are the features of New Open SQL? There are 2 correct answers to this question. Supports arithmetic and string expressions. Supports conditional expressions. Supports Code adjustment model. Supports specific units of database.

Which of the following SAP HANA-based scenarios involve ABAP applications? There are 2 correct answers to this question. Native SAP HANA applications. Data marts based on SAP HANA. SAP HANA as Business Accelerator. AS ABAP with SAP HANA as primary database.

What output does The SAP HANA provide as a unique combination of hardware and software innovations? Please choose the correct answer. Huge potential to optimize AMDP application DATA Tables. Huge potential to optimize business applications that are running on SAP HANA. The ability to create new complex processes with ABAP application cloud. Huge potential to maximize the number of disk blocks in the application.

Which of the following capabilities does the New ABAP SQL provide for integrating HANA coding into ABAP? There are 2 correct answers to this question. Fuzzy search. Hierarchical retrieval. Dynamic tokenization. Parallel processing.

Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question. Internal table. Database Procedure. Database Table. External view. CDS View.

An organization notices that certain SQL queries are taking longer than expected in their SAP HANA system. They want to identify bottlenecks and optimize the queries. Which of the following steps should they consider? Please select all the correct answers that apply (3 Answers). Use PlanViz to analyze and visualize the query execution plan. Increase the memory allocation for the HANA system. Check for expensive statements using SQL Trace. Migrate data to a non-columnar table. Optimize joins and filters in the query.

In ADT which setting below to a specific project rather than the entire workbench? Please choose the correct answer. Statement Template options. Code formatting option. Code completion option. Editor shortcut options.

Which tool in SAP HANA provides guided performance analysis? Please choose the correct answer. SAP HANA Studio. SAP HANA Cockpit. ABAP Test Cockpit. Performance Trace Tool.

What is the primary purpose of the PlanViz tool in SAP HANA? Please choose the correct answer. To visualize SQL query execution plans. To create ABAP programs. To manage HANA security roles. To transport changes between systems.

In the context of SAP HANA and ABAP integration, which of the following are benefits of code pushdown? Please select all the correct answers that apply. 3 Correct Answers. Improved performance. Reduction in data footprint. Utilization of HANA's in-memory capabilities. Elimination of ABAP layer. Simplified code structure.

Which of the following tools can be used for performance analysis in SAP HANA? There are 2 correct answers to this question. SQL Trace. ABAP Test Cockpit. PlanViz. SE93 Transaction Codes.

Which of the following statements are true about “Content”? Please choose the correct answer. It contains the designs-time artifacts. It represents SAP HANA’s data dictionary. All the physical tables and views can be found under the Catalog node.

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.

Max number of tables that can now be joined in new SQL? Max number of sub-queries? Please choose the correct answer. 25. 35. 10. 50.

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.

You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench? Please choose the correct answer. Statement template options. Code completion options. Code formatting options. Editor shortcut key options.

What are the ABAP development guidelines? There are 2 correct answers to this question. Improved hybrid components for SAP HANA. Consuming Only ABAP contents for SAP HANA. Improved tools for performance analysis. Extensions to ABAP Language.

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. De-pooling and de-clustering. Changes of data class. Definition of an enhancement category. Definition of full-text indexes. Storage type for tables.

What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are 3 correct answers to this question. Display diagrams. Edit cells. Double-click on rows. Group rows. Search in content.

You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement? There are 2 correct answers to this question. You have to specify the DB schema explicity in your statement. All tables and fields you are using must exist in the ABAP Dictionary of the Secondary DB. You have to use native SQL when reading data from the secondary DB. You have to specify the DB connection explicitly in your statement.

Which of the following tools is primarily used for ABAP development in the context of SAP HANA? Please choose the correct answer. SAP HANA Studio. Eclipse with ABAP Development Tools (ADT). SAP GUI. SAP Web IDE.

What is the language SAP HANA is developed in? Please choose the correct answer. C++. Assembly. O. Java.

Which engine is used to execute Analytic View? Please choose the correct answer. Calc Engine. Join Engine. SQL Engine. OLAP Engine.

Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question. Filter data in lower layers. Move data-intensive calculations from the database to an application server. Avoid transferring large result sets between database and client applications. Define indexes on the columns that are used in calculations.