ABAP HANA 10

What are the two layers of ABAP system interacts with its database? 2 respuestas. The Data Storage interface. The Database independent interface. The Client database interface. The Database specific library.

What are the supported joins in CDS view? 1 respuesta. Upper join. Injection. Left outer join. Operators join.

What are the basic principles of ALV SAP HANA? 2 respuestas. Only retrieve the database data which is to be displayed on screen. 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. Data described declaratively instead of passing big internal tables.

Which repository objects can you edit only in the ABAP development tools in eclipse and not in theclassical abap workbench? Core data services view 3 respuestas. Core data services view. External view. ABAP program containing new open sql. Database procedure proxy. Full text index.

When are referential joins executed in analytical views? 1 respuesta. When fields are optimized. When fields are selected. When fields from both the tables are requested. When all the tables are optimized.

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 forthe percentage of fields that are effectively used? The. The same value as on a traditional, row-store only based database. A higher value than on a traditional, row-store only based database. A lower value than on a traditional, row-store only based database. A value that you calculate based on the number of tables.

What are the steps that supported several tools, which in total result in a Guided PerformanceOptimization? 2 resppuestas. A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and. A new tool called SQL Monitor to determine the priority if different programs access the database. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime. Tools analyzing performance at run-time, to determine if critical constructs.

What all are the factors involved in Working with ADT? 3 respuestas. ABAP interface. ABAP programs. Module interface. ABAP Class. Workbench programs.

What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)? 3 respuestas. Define all method parameters to be passed by value. Use scalar types for all AMDP method parameters. Mark the AMDP method as a READ-ONLY database procedure. Specify the database system and the language. List all ABAP Dictionary tables used in the procedure body in the USING clause.

Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? 1 respuesta. Create a graph comparing the runtimes of ABAP code before and after optimization. Combine information from static ABAP code scans with runtime data from the SQL Monitor. Estimate the new total runtime of optimized code. Combine information from static ABAP code scans with runtime data from the SQL Trace tool.

What are the two types of editors available in ADT? 2 respuestas. Eclipse (native). ABAP (native). SAP (GUI). Client (native).

You changed an SAP HANA object that you transported using an SAP HANA Transport container. You wantto release the transport request with your changes. In which sequence do you perform activities in theABAP development system immediately before the release? 1 respuesta. Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activatethe SAP HANA transport container. Open the ABAP transport request Select take snapshot and Save Activate the SAP HANA transport container. Open the SAP HANA transport containerSelect take snapshot and Save Activate the SAP HANA Transport Container. Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANAtransport container.

You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains asingle SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. Which prerequisites aremandatory for an implicit deployment of the SAP HANA view onto the database? 2 respuestas. PACKAGE ZHA400J30 HAS deployment Mode A. SYSTEM P81 has SAP HANA has primary database. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK. View CA_CUSTOMER has deployment mode A.

Which features does the source code editor provide in ABAP Development Tools (ADT)? 1 respuesta. Form-based Class Builder. Content Assist. Screen Painter. Quick Fix.

What must you take into consideration when you use the new open SQL syntax (available as of SAP Netweaver 7.4 SP05). 2 respuestas. All fields in the GROUP BY clause must be separated by commas. All Keywords are case sensitive. All ABAP variables must be escaped with a proceeding @ sign. All arithmetic expressions can be used for all type of variables.

Which of the following option provides access to the views and database procedures that you can consumein the ABAP environment 1 respuesta. Catalogue outlook. Modeler Perspective. System Perspective. Open Content outlook.

What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA 3 respuestas. Scaling. Optimize. Detect. Innovate. Tuning.

An Analytic Privilege consists of several restrictions. What are they? 3 respuestas. Cube restrictions. Activity restrictions. Analytic restrictions. View restrictions. Validity restrictions.

Which of the following are view annotations for a CDS view? 3 respuestas. Buffering type. Environment. Client handling. Access control. Semantics.

You developed an ABAP program using ABAP Development Tools for SAP NetWeaver. How can you executeit? 2 respuestas. Use the Open Development Object dialog (CTRL+SHIFT+A) and enter /Execute in. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut. In the Project Explorer view, right-click the program and choose Run As - ABAP Application from.

Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support inopen SQL? 1 respuesta. SAP HANA specific features. Database for sophisticated analysis. New SQL parser used in model. Database oriented programming model /Execute in.

What is the main benefit of the SQL Performance Tuning Worklist? 1 repuesta. It establishes a governance process for performance optimizations. It allows you to simulate the impact of performance optimization patterns. It allows you to correlate the results of an ABAP source code analysis with SQL runtime data. It automatically translates ABAP coding to SQLScript.

AM DP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? 3 respuestas. UNION specific syntax errors. HANA specific syntax errors. SQLScript errors. Database independent syntax errors. Database platform syntax errors.

You create a new table definition using the ABAP Dictionary and maintain the database specific technicalsettings table. Why do you create a row store instead of a column store? 1 respuesta. To allow creation of a full-text index. To limit the need of indexes. To limit the unpacking and reconstruction of rows. To limit the data footprint.

Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functionalregressions? 1 respuesta. SELECT statements that bypass the table buffer. Use of the ADBC interface. Search for DB operations across modularization units. Standard Web Dynpro checks.

According to the performance analysis recommendations; which steps are recommended after doing adatabase migration to SAP HANA? 1 respuesta. Perform regular performance scans on your ABAP custom coding as part of the development. Switch the storage type of you custom database tables to column store and use the database. Activate your ABAP custom coding, which was deactivated before the database migration, using U. Perform regular performance scans on the ABAP coding delivered by SAP as part of your2.

Discuss the conditions required to ensure the Referential Integrity? 2 respuestas. Referential integrity holds true in both the directions. There are three joins in the table. There are two joins in the table. There is at least one join in the other table.

Explain how and when to create calculated column - Using graphical Modeling Tools? 3 respuestas. The calculation could be an arithmetic of character manipulation. It is possible to nest so that one calculated column, in turn, is based on other calculated columns. Time calculation will be opened in a read-only mode ] Time characteristics based calculation. Calculated column also support non-measure attributes as a part of the calculation.

Which of the following information is mandatory in the definition of an association in a Core Data Services(CDS) view? 1 respuesta. The alias for the association. The cardinality of the association. The target entity of the association. The filter condition for the association.

Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? 3 respuestas. HANAAccelerators. Business Suite on HANA/ BW on SAP HANA. HANA Modeling. All SAP applications on one SAP HANA platform. All HANA Combinations on one platform.

Why is a security concept in SAP HANA required? 2 respuestas. Database administration should be restricted to skilled. Editing of SAP HANA data models should only be possible for "Users" of the model. Access to ERP tables must be restricted. Need to have selected users in SAP HANA for Information Management.

For which purpose can you use literal values in an Open SQL statement? 1 respuestas. To comment your development directly in the coding. To alias the result of an arithmetic expression. To provide a default value for a database table column. To perform a generic existence check.

You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon WebService (AWS) trial system. Which plug-ins do you need to add to the existing Eclipse installation? 1 respuesta. All plug-ins provided by SAP Development Tools for Eclipse. None; everything is preconfigured. SAP HANA Tools. ABAP Development Tools for SAP NetWeaver.

How can you check if Core Data Services (CDS) views with scalar input parameters can be used in OpenSQL queries in your system? 1 respuesta. Use the static method use_features of class cl_abap_dbfeatures. Check the value of the ABAP system field sy-cdsfeatures. Perform a static code check. using the FUNCTIONAL_DB variant. Check the Open SQL statement in the Explain SQL Statement transaction (SDBE).

Which is the new concept that is introduced and improved by using SAP HANA Specific Features? 1 respuesta. Programming model. Table buffering. New advanced SQL syntax Procedures. ABAP-Managed Database Procedures.

What is the Limitations of ALV for SAP HANA? 3 respuestas. All unit/ currency restricted to 10,000,00 records. Restricted to 5000 records / unit. Without currency/unit consideration. No unit/ currency split if aggregating amounts/ currency values. Restricted to 10,000 records.

How can you consume a Core Data Services (CDS) view? 2 respuestas. Use the Data Preview in ABAP Development Tools for SAP NetWeaver. Use the ABAP language statement WRITE and the CDS view name as the argument. Use it as a data source in the FROM clause of an Open SQL query. Use the CDS maintenance transaction (SCDSV).

What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view? 1 respuesta. The entire CDS view. The CDS views used in the FROM clause. The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyFie. The elements in the projection list of the CDS view.

How can you enhance an existing ABAP Search Help with a type-ahead function? 1 respuesta. Enhance the lookup table with an additional ACCURACY field and insert an accuracy value. Modify the search help with the Native SQL command ALTER SEARCH HELP. Use the fuzzy-search exit in transaction SE11. Use the enhanced options in transaction SE11.

Where can you consume associations in a Core Data Services (CDS) view? 3 respuestas. In the FROM clause. In the WHERE and HAVING clauses. In the input parameter list. In the name list. In the projection list.

How can you exchange SQL Monitor data between two systems? 1 respuesta. Configure a secondary database connection to the target system and query the data in the SQL. Create a snapshot of the SQL Monitor data, export it to the file system, and then import it to the. Create and release a transport request containing the SQL Monitor log files. Deactivate the SQL Monitor in the source system and activate the SQL Monitor in the target.

Which feature can you use to improve the performance of data transformation in the Extract, Transformand Load (ETL) process?. ABAP Messaging Channels (AMC). ABAP Managed Database Procedures (AMDP). Service Adaptation Description Language (SADL). Process Agent Framework (PAF).

How to call the stored procedures in ABAP code? 1 Respuesta. Open SQL. CDS view. Native SOL. Only SQL.

Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? 2 respuestas. Database table compression. Partitioning. Column data storage. Parallel processing.

How will you select a preference for Validation rules? 1 Respuesta. Windows- Modeler- Preferences-SAP HANA-Validation Rules. Windows- SAP HANA-Modeler-Preferences-Validation Rules. Windows- Preferences-SAP HANA-Modeler-Validation Rules. Windows- SAP HANA-Preferences-Modeler-Validation Rules.

What all are the steps to perform -To enable type-ahead for an input field on a screen? 3 Respuesta. Process on all the input fields. Switch on proposal search for input fields. Identify Elementary Search Help. Automatic updates of all the input fields. Check Pre-Requisites.

Which recent software innovations are applied in SAP HANA? 3 Respuestas. Improved data compression algorithms. Columnar data storage. Automated de-installation at system shutdown. Insert Only approach. Random Undefined Multi-Memory Swapping (RUMMS).

In a Graphical calculation view you want to implement a union between two result sets that differ only inthe fact that one of the two has one additional field named ADDRESS. How can you achieve this in a unionnode? 2 Respuestas. Create an input parameter for the ADDRESS field. Exclude the ADDRESS field from the union. Create a restricted column for the ADDRESS field. Map the ADDRESS field to a constant value.

You created and activated database procedure. How can you call this procedure? 2 Respuestas. By a core data services view. By another database procedure. By a script-based calculation view. By using Sap Analysis for Microsoft office.

In an Open SQL query, you select the sum of sales order gross amounts and a CASE statement to flag saorder gross amounts below a certain value. What information has to be provided in the GROUP BY list? 1 Respuesta. The alias of the CASE construct used in the SELECT list. None; the GROUP BY list is added automatically. The CASE statement as provided in the SELECT list without its alias. The name of the gross amount column that is used in the CASE statement.

You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Searchproblematic SELECT * statement check. What does this check report? 1 Respuesta. SELECT * statements where fewer than a specified percentage of all fields are effectively used. SELECT * statements on tables with the Column Store storage type. SELECT * statements on tables with more than a specified number of fields. SELECT * statements on tables with more than 100,000 records.

In which of the following situations could a row store table be more suitable than a column store table? 2 Respestas. The table contains text that you want to search. The table contains data that you want to aggregate. The table contains only a small number of records. The table contains mainly distinct values per column across rows.

Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace thiswith a native SQL SELECT statement. Which of the following changes to the SELECT statement can you useto retrieve the same data as before? 2 Respuestas. Use the CLIENT SPECIFIED addition. Include the client field in the join condition. Include the client field in the field list. Include the client field in the WHERE condition.

List down the elements involved in User Management and Security in SAP Hana? 3 Respuestas Correctas. Create users. Assign security. Manage users. Work Management. Assign Job security.

Name some perspectives that are available in the SAP HANA Studio? 3 Respuestas. The Administration Console perspective. The information perspective. The technology & innovation perspective. The Resources perspective. The SAP HANA Modeler Perspective.

One of your SAP systems needs to be migrated from its current database to an SAP HANA database. Youwant to avoid any functional issues after the migration. What should you search for and if necessaryreplace in the existing custom ABAP code? 3 Respuestas. Code that relies on implicit database sorting. Direct access to a cluster on the database. ORDER BY Clauses in Open SQL statements. Native SQL statements. Left outer joins in open SQL statements.

How to create a core data services view? 3 respuestas. Use additional annotations - marked with the @sign. Use SQL capabilities for Netweaver. Use DDL statement DEFINE VIEW and SQL like syntax to define the view. Use the ABAP Development Tools for SAP Netweaver. Use data services tools for updates.

What is the main purpose of SAML for SAP HANA Studio? 1 Respuesta. The assertion is issued by a user after the client was successfully authenticated. To support scenarios where clients are not directly connected to the SAP HANA Database. SAML may be selected as an Owner's authentication method when creating users in the SAP. The SAP HANA database supports login of Owners only.

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

What is Core Data Services (CDS)? 1 Respuesta. A collection of core features and services that provide data from the ABAP application server layer. A collection of services for ABAP application programming that provide access to the core features. A collection of services that provide information about the data volumes of the SAP HANA core. A collection of domain-specific languages and services for definition and consumption of.

SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANA has to meet.What are these goals? 2 Respuestas. Analytical DBMS features. Hybrid data and management system. High Performance and Scalability. Support for system tables.

The SAP HANA database is a hybrid in-memory database that combines Few technologies within. What arethese technologies? 3 Respuestas. Row-based database technology. Column-based database technology. Value-based database technology. Time-based database technology. Object-based database technology.

What you must do when you define and implement an ABAP Managed Database Procedure AMDP? 3 Respuestas. Specify the database system and language. Define all the method parameters to pass by value. List all the ABAP dictionary tables used in the procedure body in the USING clause. Use Scalar types for all the AMDP method parameters. Mark the AMDP method as read-only.

The source code editor in ADT provides many helpful features. What are these helpful features? 2 Respuestas. Creating interface from Method Calls. Creating Parts for Interface Methods. Creating Method Implementations from the Method Definition. Creating Method Definitions from Implementation Parts.

Which character is used to escape host variables in the new Open SQL syntax? 1 respuesta. ~ (tilde). * (asterisk). : (colon). @ (at).

User STUDENT_A create and activates a design-time object. In which schema is the run object generated? 1 Respuesta. _SYS_BI. _SYS_BIC. STUDENT_A. SYSTEM.

Which conditional expressions can be used in Core Data Services (CDS) views? 2 Respuestas. CASE statements in the projection list. IF statements in the projection list. COALESCE functions in the projection list. WHILE statements in the WHERE clause.

What do you understand by the SAP HANA Software Optimization? 1 Respuesta. Provide combinations of objects and partitioning. Speed up the processing within the database. Huge potential for hybrid database. Bring logic to where the data is calculated first then only move to results.

What allows you to resolve errors quickly or warnings reported about the code? 1 Respuesta. Debug perspective. Quick Fix. Code execution. ABAP debugger.

Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? 3 Respuestas. Storage type for tables. Definition of full-text indexes. De-pooling and de-clustering. Changes of data class. D. Definition of an enhancement category.

What are best practices when programming in ABAP for SAP HANA? 2 Respuestas. Eliminate nested SELECT statements to reduce the overall number of database accesses. Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required. Calculate aggregations using ABAP code on the application server to limit database load. Use a column list in the SELECT clause to ensure that you only read a column if it is really required.

Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not inthe Classical ABAP workbench? 3 Respuestas. Core Data service (CDS) view. External view. Database procedure proxy. ABAP program containing new Open SQL. Full-text index.

What are the benefits associated with The SAP HANA real-time Operational analytics? 2 Respuestas. Query Speed support. Fast insights into business activity. High modeling flexibility. Simplification of massive data.

Which of the following tools and programming techniques use the SQL data definition language? 2 Respuestas. Core data service (CDS) access control. Open SQL. Core data services (CDS) data definition. ABAP Dictionary.

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

Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view? 1 Respuesta. "Read from DDL source". "Map to Data source". "Relate to Business Entity". "Consume CDS view".

What are the benefits of using the SQL Monitor (transaction SQLM)? 2 respuestas. It displays the database execution plan for all SQL statements. It collects monitoring data asynchronously without additional database interaction. It can be active in a production system with minimal performance overhead. It schedules ABAP programs to monitor and log all database accesses.

Which TADIR object type is used for the definition of a Core Data Services (CDS) view? 1 Respuesta. R3TR DDLS. R3TR VIEW. R3TR TABL. R3TR DDIC.

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

What are the different views provided by the ABAP Profiling? 2 Respuestas. Performance Check methods. Metadata accesses. A Hitlist of the most time-consuming programs or methods. Database accesses.

Why is not a key factor of ALV for HAN A? 1 Respuesta. To activate and execute the program in the application. Derived column headings from the data element. To supply suitable values for any input parameters. The data display is restricted to a maximum of 2 billion cell.

What are the Functions of Transaction DBACOCKPIT? 1 Respuesta. Use Schema for the Connections. Maintain, Monitor and test secondary database connection. Maintain only HANA specific objects. Used to access local or remote database system.

You define and implement an AM DP. What do you have to list after the USING clause? 3 respuestas. SAP HANA views used in procedure body. ABAP dictionary views used in procedure body. AMDP Used in Procedure Body. ABAP dictionary tables used in procedure body. CE function used in procedure Body.

What are the Guidelines for optimizing ABAP code running on HANA? 3 Respuestas. High-speed data analysis. DB specific properties. Column store. Technical settings. Open SQL settings.

You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAPDatabase Connectivity (ADBC) API method. Which additional steps are necessary to retrieve the result setinto an internal table? 2 Respuestas. Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance. Close the CL_SQL_STATEMENT object to release the resources. Use an Open SQL query that uses the JOIN between the result set and the internal table as a data. Fetch the result using the next_package method of class CL_SQL_RESULT_SET.

What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? 2 respuestas. Shared file systems for only one server. Active clusters for all servers. Services-Name and index server on all nodes. High availability configuration.

You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call?Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQLcall? 1 respuesta. SET_PARAM. EXECUTE_QUERY. NEXT_PACKAGE. SET_PARAM_TABLE.

What are the Parameters for Analytical and Calculation view? 3 Respuestas. Specifying unit of measurement. Create a copy of a report. Passing other values to be used in calculations. Setting a filter for columns. To store data for critical analysis.

You want to implement business logic on the database layer. 1 Respuesta. The Left-Right approach. The Near-Far approach. The Inside-Out approach. The Top-Down approach.

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? 1 Respuesta. Update packages. Release resources. Update resources. Update resources.

What are the two different kinds of Identifiers used to represent names used in SQL statement? 2 Respuestas. Limited identifiers. Undelimited Identifiers. Delimited identifiers. Numeric identifiers.

Your customer wants to migrate to SAP HANA and you want to identify which business processes shouldbe optimized. Which of the following steps must you perform to get this information? 2 Respuestas. Combine the results of the SQL Monitor with the results of a static source code analysis. Combine the results of the SQL Monitor with the results of an ABAP runtime analysis. Activate the new SQL Monitor in a productive system. Activate the new SQL Monitor in a development system.

You want to debug an ABAP program using ABAP development tools (ADT). How do you launch thedebugger? 1 Respuesta. Choose the Run --> Debug options in the menu. Set a breakpoint in the ABAP program and execute the program. Choose the debug as option in the context menu of the ABAP program. Create a debug configuration for the ABAP application and run the program.

What are the Possible Approaches with AS ABAP < 7.4 SP02 2 Respuestas. Consume using native SQL. Stored Procedures. SQL units. Interaction with Database.

In ABAP Development Tools for SAP NetWeaver, you execute the ABAP Test Cockpit on an ABAP program tofind performance optimization potential. Where can you find the result of the static code checks? 1 Respuesta. In the Project Explorer view. In the Problems view. In the Outline view of the ABAP Performance perspective. In the Outline view of the ABAP Performance perspective.

What is the scope of the AbapCatalog. Buffering annotation in a Core Data Services (CDS) view? 1 Respuesta. The CDS views used in the FROM clause. The elements in the projection list of the CDS view. The entire CDS view. The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyFie.

How many result sets are returned when an SAP HANA database procedure is called using the CALL WITHOVERVIEW statement? 1 Respuesta. As many result sets as there are input parameters in the procedure. One result sets. As many result sets as there are table output parameters in procedure. Two result sets.

In the source code editor you can navigate quickly from the definition of a method to its impelmentation.To do so, you select the method name and press wich key(S)? 1 Respuesta. ctrl + f2. f6. ctrl + shift +f5. f3.

List down the three main concepts of the SAP HANA database 3 respuestas correctas. Object store. Column Store. Partitioning. Tools combinations. Compression.

ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? 3 Respuestas. Data Definition Language. Data Control Language. Data Transferred Language. Data Manipulation Language. Database Language.

What are the elements of ABAP Database Integration? 3 Respuestas. DB For ABAP. Application server. Client database handling. Other DB.

Explain the Authorization Concept and the types of privileges associated with it? 3 respuestas. System privileges. Application privileges. Analytic privileges. Object privileges. Package privileges.

What are the steps involved in SAP HANA Evolution? 3 Respuestas. Optimized ABAP on SAP HANA. ABAP applications on SAP HANA. ABAP as accelerator on SAP HANA. ABAP can run on SAP HANA. ABAP can access SAP HANA.

What information can you specify using annotations (marked with the @ sign) when you define a CDS viewin an ABAP system? 3 respuestas. The logic for aggregations, grouping records, and filtering groups of the CDS view. The name of the representation of the CDS view in the ABAP dictionary. The extent to which records of the CDS view should be buffered on the application server. The join conditions of the CDS view. The client dependency of the CDS view.

What are the components of The Enterprise Procurement Model Demo Scenario? 3 Respuestas. Stock. Product. Procurement. Sales. Services.

Which of the following folder is essential to relate to Smart Data Access and also combines data fromremote sources? 1 Respuesta. Security folder. Content folder. Administration folder. Provisioning folder.

Discuss the main capabilities of SAP Business Objects Analysis for Office? 2 Respuestas. Sort data by characteristics. Convert crosstab cells to formula. Analyze data with the design pane. Suggests style sets for crosstabs.

In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDSview? 3 respuestas. Include all fields used in the ON condition in projection list. Define the cardinality for the target entity. Specify an alias for the target entity. Specify the other views in which the association can be used.

What are the key points that should be kept in mind while performing the Non-automatic update in SAPHANATr.Cont.? 2 Respuestas. Take snapshot manually before releasing of the container. You need to refresh the content of the container manually. Automatic release of units. Changes to Delta Container.

What is the purpose of an ABAP project in ABAP Development Tool for eclipse? 2 Respuestas. It represents the connection to an ABAP System. It provides access to all ABAP repository objects in an ABAP system. It is used to transport the ABAP repository Objects. It represents the connection to the SAP HANA Layer.

Discuss the basic approach of classical ABAP programming? 2 respuestas. Creating and consuming all the contents from network. Keep load from the database. Get all the data you need on the application server and do your processing in ABAP. Collect all the data and perform Parallel processing in ABAP.

Open SQL largely standardized, three sub-languages. What are these sub-languages? 3 respuestas. Data Transferring Language(DTL). The Data Definition Language (DDL). The Data Control Language (DCL). Data Manipulation Language (DML). Data Evaluation Language(DEL).

Name the views that are available to administer and monitor one or several SAP HANA systems? 2 respuestas. The Administration view. The Security view. The Landscape view. The System Monitor view.

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. In which cases does the call triggerthe creation of the database procedure in SAP HANA? 2 respuestas. X is an ABAP Dictionary table. X is a stored procedure. X is an AMDP method. X is an SAP HANA view.

What is an attribute view and what are its practices? 3 respuestas. May contain filters. May contains flow charts. Used to join tables. Used in diagrammatic Projections. May use in calculation views.

What all are the advantages provides by ABAP Development Tools? 3 respuestas. An open platform for developing new ABAP-related tools. 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 powerful database view. A set of Eclipse data pool and Client- Open platform.

What are the two main factors of SAP HANA Innovations and Challenges? 2 Respustas. HW technology and innovations. SAP BW innovations. DBMS technology and innovations. SAP SW technology and innovations.

You follow the Code-to-Data paradigm in your ABAP coding. Which of the following scenarios conflicts withthe SQL performance guideline "Keep unnecesary load away from the database"? 1 Respuesta. The data-intensive calculations can be performed on SAP Netweaver Application Server ABAP when code-to-datamode is switched on. The transfer of coding to the database reduces the memory consumption of associated ABAP Dictionary tables inthe application layer. Then in-memory architecture of SAP HANA prevents the transfer of large datasets between the database layerand the application layer. The in-memory capabilities of SAP HANA allow calculations to be performed on the database layer, which helps toavoid unnecesary movement of data.

To connect with the SAP HANA system and seethe corresponding catalog content etc., use the Systemsview. How will you add a system to this view? 2 Respuestas. Database user- also different from your ABAP user. By using SQL application. By using Open Catalog look. Password for the database user.

Which of the following is a limitation when you create an external view? 1 Respuesta. You must know the underlying tables and join conditions of the SAP HANA view. You must use the ABAP Development tools (ADT) TO CREATE the external view. You can only use native SQL to consume the external view. You must include the name of the SAP HANA view in the name of the external view.

The SAP HANA state-of-the-art search experience includes full-text search with advanced features like... 3 Respuestas. Fuzzy search. ACID search. Linguistic search. Freestyle search. Isolation search.

Which data provisioning methods can you use when you need real time replications? 2 Respuestas. SAP Landscape transformation Replication server (SAP SLT). SAP Replication server. SAP HANA Direct extractor connection (SAP DXC). SAP Data services.

Which form of services is responsible for defining and consuming semantically rich data models? 1 Respuesta. Conditional services. Model-ll services. Core Data Services (CDS). It services.

In ADT which setting below to a specific project rather than the entire workbench. 1 Respuesta. Code formatting option. Statement Template options. Code completion option. Editor shortcut options.

In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Whichof the following table types fulfill this requirement? 1 Respuesta. GLOBAL TEMPORARY. LOCAL TEMPORARY. COLUMN. ROW.

You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks thevalidity of its importing parameters and calls method Y. What pattern of gross and net run time would youexpect to see the in the ABAP trace results for method X? 1 Respuesta. The net run time is less than the gross run time. The net run time is greater than the gross run time. The net run time is equal to Zero. The gross and net run times are identical.

You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? 3 Respuesta. Explicitly handle the client field. Specify the database schema if it is not the user's default schema. Use a Comma-separated column list. Use the UP TO n ROWS addition. Use the tilde symbol (-) to separate qualifier from column name.

What all are the Types of Applications based on SAP HANA? 2 Respuestas. Server based on SAP HANA. Data Mart based on SAP HANA. Innovation based on SAP HANA. New or Native SAP HANA.

Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? 1 Respuesta. Swap axes. Insert filter components. Create Presentations. Create data by members and tables.

What are the two main methods to add a system to the SAP HANA Studio? 2 Respuestas. By Resource console. Automatically. By Importing a Landscape. Manually.

What views will be most efficient for General Modeling Principles? 2 Respuestas. Attribute view. Schema view. Column view. Analytical view.

You want to debug an ABAP program using ABAP development tools (ADT). How do you launch thedebugger? 1 Respuesta. Choose the debug as option in the context menu of the ABAP program. Set a breakpoint in the ABAP program and execute the program. Choose the Run --> Debug options in the menu. Create a debug configuration for the ABAP application and run the program.

Which of the following tasks can you perform with SQL monitor (transaction SQLM)? 1 Respuesta. Search for problematic SELECT* statements. Display the execution plan of an SQL statement. Capture the SQL profile of an application. Combine static and dynamic performance analysis results.

Which data sources can you use for SAP list viewer with integrated data access? 3 Respuestas. Internal table. CDS View. Database Table. Database procedure. External view.

When would you use a column store table instead of a row store table? 2 Respuestas. When there are mainly distinct values in the table. When the table has a small number of records. When you require aggregation and analysis of values. When you want to enable a full-text-search of the table.

If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. Thefollowing parameters are available? 3 Respuestas. Fuzzy search. Freestyle search. Point base ranking. Weights for ranking. Index search.

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

What are the uses of SQL Trace (ST05)? 3 Respuestas. Applying Code inspector. Detect redundant or identical select statements. Locate database performance issues. Display record of all database access. Locate work base issues.

ABAP 7.4 provide support for optimizing ABAP applications running on SAP HANA. What are thesetransparent optimizations? 3 Repsuestas. Do all the data processing in Application server. Performance analysis tools have been improved. The ABAP language and the Open SQL language have been extended. Re-use components have been extended or optimized for SAP HANA. The consumption of SAP HANA artifacts was simplified.

DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? 2 Respuestas. Column store. Re-use component store. Row store. Technology store.

What are the steps involved in SAP HANA Evolution? 3 Respuestas. ABAP can run on SAP HANA. ABAP can access SAP HANA. Optimized ABAP on SAP HANA. ABAP as accelerator on SAP HANA. ABAP applications on SAP HANA.

You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have todo in the corresponding ABAP class? 1 Respuesta. Implement the ABAP AMDPJHDB Event Handler. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB. Set the visibility of the corresponding class method in the declaration section to PUBLIC. Implement the interface IF_AMDP_MARKER_HDB.

What are the Perspectives and Views of SAP HANA Studio. 2 Respuestas. System Properties. Administration console. Open system properties. Development properties.

Explain Transitioning ABAP Code to SAP HANA - Performance Considerations? 3 Respuestas. Some codes transferred to other systems. Classical performances recommendations for open SQL remain valid. Some shifts in priorities, examples, nested selects(higher) indices(lower). Some codes immediately run faster. Some codes impacted positively and should be priorities.

Which is not a Golden Rule for Open SQL? 1 Respuesta. Minimize the Amount of Data Transferred. Keep the result set large. Minimize the Number of Database Accesses. Reduce the Database Load.

What are the principles of Using HANA Transport Containers properly? 3 Respuestas. Release of Transport request. Automatic update for all export methods. Import of Transport Request. To create Transport container of delivery unit. Takes a 'snapshot' of all SAP HANA objects of delivery unit.

What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated developmentenvironment? 3 Respuestas. Organizing. Configure. Administer. Selecting. Monitor.

Which of the following tool is introduced as a holistic quality assurance tool? 1 Respuesta. ABAP Test Cockpit (ATC). DBA Cockpit. DBMS Cockpit. BW system.

How many result sets are returned when an SAP HANA database procedure is called using the CALL WITHOVERVIEW statement? 1 Respuesta. Two result sets. As many result sets as there are input parameters in the procedure. One result set. As many result sets as there are table output parameters in the procedure.

You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQLSECURITY DEFINER READS SQL DATA. Which type of database procedures can be called in this SQLScriptprocedure? 1 Respuesta. Read-update. Write only. Read-write. Read only.

How will you hide the attributes that are not required for client consumption? 1 Respuesta. 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 View. By setting the hidden property flag of the attribute in the Semantics screen.

Which of the following is not involved in database table of The New ABAP SQL Monitor-Architecture? 1 Respuesta. Runtime monitor data. Selection data table. Critical data table. Performance data table.

Which of the following categories of parameters can you use in the definition of an ABAP manage databaseprocedure (AMDP)? 3 Respuestas. Returning. Importing. Changing. Receiving. Exporting.

You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter onthe right-hand side of an assignment operator within the procedure. How do you refer to the parameter? 1 Respuesta. it_books. :it_books. {it.books}. @it_books.

Which tasks does the ABAP managed database (AMDP) framework perform? 2 Respuestas. Delete the obsolete versions of the database procedure synchronously. Delete the obsolete versions of the database procedure asynchronously. Create a new version of the database when the AMDP is first called. Create a new version of the database when the AMDP is first activated.

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

What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? 2 Respuestas. Account-based Profitability. Service-based profitability. Costing-based Profitability. Product-based Profitability.

Discuss different types of engines associated with The SAP HANA architecture 2 Respuestas. Join engine. OPAX engine. OLAP engine. Analytic engine.

Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOTOffer? 2 Respuestas. Flexible schedule of check runs. Enhanced distribution of results. Documented checks. Configuration of check variants.

What are the Possible Approaches with AS ABAP < 7.4 SP02? 2 Respuestas. SQL units. Stored Procedures. Interaction with Database. Consume using native SQL.

Which code-to-data capability is responsible for the Optimizations & Translation of Open SQL SELECT FORALL ENTRIES clauses into native SQL? 1 Respuesta. Transparent Optimizations. HANA Specific features. Buffer system Optimization. Database Optimization.

What are the features associated with ABAP CDS? 3 Respuestas. Update. Create. Read. Export. Distribution.

To upload data from flat files, SAP HANA offers several features. What are these important features? 2 Respuestas. When loading new data in the table, it gets appended to the existing data. The application suggests the column name and data type for the new tables, and it is possible to edit them. The supported file types for upload are: .cssv, .xlls, and .xlsxxx. The new table always has a 2:2 mapping between the file and table columns.

Hybrid Data Management System - Combining different paradigms in one system. Discuss capabilitiesassociated with the Hybrid Data Management system 3 Respuestas. Traditional disk-based tables. Built-in support for planning. Text analysis and search. Text indexing capabilities. Linguistic search capabilities.

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

SAP HANA DB Migration: you want to avoid any functional issues after the migration? 3 respuestas. Order by clause in open SQL statement. Left outer joins in open SQL statements. Code that relies on implicit database sorting. Direct access to a cluster on the database. Native sql statement.

What are the features of New Open SQL? 2 Respuestas. Supports conditional expressions. Supports arithmetic and string expressions. Supports specific units of database. Supports Code adjustment model.

You developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of thisAMDP using business add-in (BADI). Which of the following objects must you create? 3 Respuestas. An enhancement spot. A BADI fallback implementation. A database procedure. A BADI definition. A BADI simple implementation.

When to use Enhanced Open SQL 2 Respuestas. At the time of Dictionary Views. To access system fields. A BADI simple implementation. Need the query in one piece of code only. To view scalar components.

What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANADB? 2 Respuestas. The ABAP system check the syntax of the Native SQL statements. The database independency of your report can be lost. Hashed or sorted tables must be used with the INTO CORRESPONDING FIELDS keyword. Client handling needs to be done explicitely in the Native SQL statement.

Which steps do you have to perform when defining a view using core data services (CDS)? 2 respuestas. Use the DDL statement DEFINE VIEW and SQL like Syntax. Create a proxy object for the defined view. Define the type mapping between ABAP and SAP HANA. Specify the name of the SQL view in ABAP Dictionary.

Which tools can you use to provide input data for the SQL performance tuning work list (TransactionSWLT)? 3 Respuestas. ABAP test cockpit (transaction ATC). SQL monitor (transaction SQLM). Code inspector (transaction SCI). Data base performance monitor (transaction DB50). SQL Trace (transaction ST05).

What are the Performance Rules and Guidelines for ABAP on SAP HANA? 2 Respuestas. To keep all the loads away from the DB. To reduce main memory consumption and to improve insert performance. It is beneficial for maximizing your search into database. It is beneficial to move data-intensive calculations into the database.

What should you do to follow the code-to-data approach to programming? 3 Repsuestas. Use native SQL to access SAP HANA built-in functions. Perform expensive calculations on the database. Transfer all data from the database to the ABAP layer, and then aggregate the results. Perform expensive calculations on the ABAP application server. Aggregate data on the database, and transfer the results to the ABAP layer.

How SAP HANA supports SQL? 3 Respuestas. As a means to define. Transferring data. Read. Manipulate data. As a Data Calculator.

What is the system privilege required to drop analytic privilege? 1 Respuesta. STRUCTURED PRIVILEGE ADMIN. CREATE STRUCTURED PRIVILEGE. PRIVILEGE ADMIN. CREATE PRIVILEGE.

What made SAP HANA possible? 2 Respuesta. Improved hardware technology. Technology and innovations. RAM limitation. CPU with single core network.

Which of the following JOIN types are supported in Open SQL? 3 Respuestas. INNER JOIN. CROSS JOIN. REFERENTIAL JOIN. RIGHT OUTER JOIN. LEFT OUTER JOIN.

What is the full form of HANA? 1 Respuesta. High-Performance Analytic Appliance. High-Performance Analytic Application. High-Performance Analytic Accelerator. High Accelerator Numeric Analytics.

What is the main advantage of SQLScript? 2 Respuestas. SQLScript code can easily be translated into modeling view. SQLScript can be better modularized than traditional SQL. SQLScript is faster than traditional SQL.

Which rules does SAP recommended to improve the performance of ABAP report on SAP? 2 Respuestas. 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 statements are true for SQLScript? 2 Respuestas. SQLScript is used to push down data intensive logic into the database. SQLScript is an open standard. SQLScript is a collection of extensions to SQL.

In ABAP Development Tools for SAP NetWeaver, you execute the ABAP Test Cockpit on an ABAP program tofind performance optimization potential. Where can you find the result of the static code checks? 1 respuesta. In the Project Explorer view. In the Outline view of the ABAP Performance perspective. In the Performance Analysis view. In the Problems view.

You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for eachsales order (column SOJD). Which SELECT statement would you use in the definition? 1 Respuesta. select from snwd_so {sojd, sum(net_amount) as sum_amount}. select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd. select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount. select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd.

What is the central goal of using SAP HANA? 1 Respuesta. Positive Impact on Business. Accelerate Performance. Monitor database for record keeping. To set Priorities for system.

The new bottlenecks avoided by addressing two challenges, what are they? 2 Respuestas. Avoid CPU cache misses. Avoid single network. Avoid optimizing data. Avoid idiling CPU cores.

Which of the following objects can you use in the ABAP layer when using the top-down approach to bringcode to data? 2 Respuestas. ABAP managed database procedures. Core data services views. Calculation views. Stored procedure.