• Author / Uploaded
• majin Bala

Citation preview

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 for the percentage of fields that are effectively used? Please choose the correct answer. A higher value than on a traditional, row-store only based database The same value as 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

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 interface from Method Calls Creating Parts for Interface Methods Creating Method Definitions from Implementation Parts

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 Form-based Class Builder Content Assist

Name some perspectives that are available in the SAP HANA Studio? There are 3 correct answers to this question The SAP HANA Modeler perspective The Information perspective

The Administration Console perspective The technology & innovation perspective The Resources perspective

What all are the factors involved in Working with ADT There are 3 correct answers to this question. Module interface ABAP programs ABAP Class Workbench programs ABAP interface

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

Why is a security concept in SAP HANA required? There are 2 correct answers to this question Need to have selected users in SAP HANA for Information Management Access to ERP tables must be restricted Editing of SAP HANA data models should only be possible for “Users.” of the model Database administration should be restricted to skilled

What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question.

Takes a ‘snapshot’ of all SAP HANA objects of delivery unit Import of Transport Request Automatic update for all export methods To create Transport container of delivery unit Release of Transport request

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. freestyle search Fuzzy search ACID search linguistic search Isolation search

How many result sets are returned when an SAP HANA database procedure is called using the CALL. WITH OVERVIEW statement? Please choose the correct answer. As many result sets as there are table output parameters in the procedure Two result sets One result set As many result sets as there are input parameters in the procedure

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

You made changes to an object (X) used by an ABAP managed database procedure (AMDP). You did NOT change 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 AMDP method X is a stored procedure. X is an ABAP Dictionary table X is an SAP HANA view

Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer. Estimate the new total runtime of optimized code. Combine information from static ABAP code scans with runtime data from the SQL Monitor. 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 Trace tool.

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

Which data provisioning methods can you use when you need real time replications? There are 2 correct answers to this question. SAP Landscape transformation Replication server (SAP SLT) SAP Replication server

SAP Data services SAP HANA Direct extractor connection (SAP DXC)

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

What are the Possible Approaches with AS ABAP < 7.4 SP02? There are 2 correct answers to this question. SQL units Interaction with Database Stored Procedures Consume using native SQL

You use ABAP database connectivity (ADBC) to issue native SQL calls to the database. Which of the following methods of class CL_SQL_RESULT_SET retrieves the result set of the native SQL call? Please choose the correct answer. SET_PARAM NEXT_PACKAGE EXECUTE_QUERY SET_PARAM_TABLE

What are the benefits associated with The SAP HANA real-time Operational analytics? There are 2 correct answers to this question Simplification of massive data Query Speed support Fast insights into business activity

High modeling flexibility

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

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

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

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

Windows- SAP HANA-Preferences-Modeler-Validation Rules Windows- Modeler – Preferences-SAP HANA-Validation Rules

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

You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer. Read only Read-update Read-write Write only

What all are the advantages provided by ABAP Development Tools? There are 3 correct answers to this question. A set of Eclipse data pool and Client- Open platform 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 A set of open, language- and platform-independent APIs

What are the two main factors of SAP HANA Innovations and Challenges?

There are 2 correct answers to this question. SAP BW innovations HW technology and innovations DBMS technology and innovations SAP SW technology and innovations

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES Use array variants of INSERT UPDATE MODIFY and DELETE Perform all calculations and aggregations in the ABAP layer Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

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

Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment? Please choose the correct answer. Catalogue outlook Modeler Perspective Open Content outlook System Perspective

Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question. Define the type mapping between ABAP and SAP HANA Specify the name of the SQL view in ABAP Dictionary Use the DDL statement DEFINE VIEW and SQL like Syntax Create a proxy object for the defined view. Create a data definition in your ABAP package

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

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. Data base performance monitor (transaction DB50) SQL Trace (transaction ST05) SQL monitor (transaction SQLM) Code inspector (transaction SCI) ABAP test cockpit (transaction ATC)

What do you understand by The SAP HANA Software Optimization? Choose the correct answer Huge potential for hybrid database Provide combinations of Objects and Partitioning Bring logic to where the data is calculated first, then only move to results

Speed up the processing within the database

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

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

You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes. In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer. Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container

Open the SAP HANA transport container Select take snapshot and Save Activate the SAP HANA Transport Container

Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container

Open the ABAP transport request Select take snapshot and Save Activate the SAP HANA transport container

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

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. The ABAP language and the OpenSQL language have been extended Performance analysis tools have been improved Do all the data processing in Application server Re- use components have been extended or optimized for SAP HANA The consumption of SAP HANA artifacts was simplified

What information can you specify using annotations (marked with the @ sign) when you define a Core Data Services (CDS) view in an ABAP system?

There are 3 correct answers to this question. 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 The name of the representation of the CDS view in the ABAP dictionary The logic for aggregations, grouping records, and filtering groups of the CDS view

Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? There are 2 correct answers to this question. Database table compression Parallel processing Columnar data storage Partitioning

When to use Enhanced Open SQL? There are 2 correct answers to this question. To view scalar components Need the query in one piece of code only To access system fields At the time of Dictionary Views

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

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

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. 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. The table contains text that you want to search.

Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question. Core data services (CDS) data definition ABAP Dictionary Core data service (CDS) access control Open SQL

What is the main function of Static Code Analysis? Please choose the correct answer. ABAP source code with performance optimization potential To detect code that would lead to functional or performance issues When migrating to SAP HANA Integrated into ABAP Development Tools and ABAP Workbench

Integrates with SAP Solution Manager

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

List down the four main concepts of the SAP HANA database? There are 3 correct answers to this question Column Store Compression Partitioning Object store Tools combinations

Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question. 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

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. SQL Trace (transaction ST05)

ABAP test cockpit (transaction ATC) Code inspector (transaction SCI) Data base performance monitor (transaction DB50) SQL monitor (transaction SQLM)

An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question Analytic restrictions Cube restrictions Activity restrictions Validity restrictions View restrictions

What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question. Administration console System and Properties Open system properties Development properties

What are the supported joins in CDS view? There are 2 correct answers to this question. Operators joint Upper join Inner join Left outer join

How will you hide the attributes that are not required for client consumption?

Choose the correct answer By setting the hidden property flag of the attribute in the View 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 provider

What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question Schema view Attribute view Analytical view Column view

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. Transparent Optimizations Database Optimization HANA Specific features Buffer system Optimization

DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? There are 2 correct answers to this question. Column store ROW store Re-use component store Development Store Technology store

What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question Service-based profitability Costing-based Profitability Account-based Profitability Product-based Profitability

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 the elements of ABAP Database Integration? There are 3 correct answers to this question. DB client-server Client database handling Application server DB For ABAP Other DB

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 of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question. Calculation views Core data services views ABAP managed database procedures Stored procedure

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.

You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package ZHA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question. View CA_CUSTOMER has deployment mode A. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK SYSTEM P81 has SAP HANA has primary database PACKAGE ZHA400_00 HAS deployment Mode A

You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statements check. What does this check report? Please choose the correct answer. SELECT * statements on tables with more than a specified number of fields 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 100,000 records

What all are the advantages provided by ABAP Development Tools? There are 3 correct answers to this question. An open platform for developing powerful database view A set of Eclipse data pool and Client- Open platform A brand-new ABAP development experience on top of the Eclipse platform An open platform for developing new ABAP-related tools A set of open, language- and platform-independent APIs

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. Re- use components have been extended or optimized for SAP HANA Do all the data processing in Application server Performance analysis tools have been improved The ABAP language and the OpenSQL language have been extended The consumption of SAP HANA artifacts was simplified

What are the features associated with ABAP CDS? There are 3 correct answers to this question. Distribution Export

Read Update Create 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 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

Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”? Choose the correct answer Performance data table Selection data table Runtime monitor data Critical data table

Which form of services is responsible for defining and consuming semantically rich data models? Please choose the correct answer.

Conditional services Modell-II services Core Data Services ITe services

Name some perspectives that are available in the SAP HANA Studio? There are 3 correct answers to this question The SAP HANA Modeler perspective The Administration Console perspective The Resources perspective The Information perspective The technology & innovation perspective

What is the main function of Static Code Analysis? Please choose the correct answer. ABAP source code with performance optimization potential To detect code that would lead to functional or performance issues When migrating to SAP HANA Integrated into ABAP Development Tools and ABAP Workbench Integrates with SAP Solution Manager

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

Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer. New advanced SQL syntax Procedures ABAP-Managed Database Procedures

Programming model Table buffering

What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer. ABAP debugger Quick Fix Code execution Debug perspective

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

Your customer wants to migrate to SAP HANA and you want to identify which business processes should be optimized .Which of the following steps must you perform to get this information? There are 2 correct answers to this question. Combine the results of the SQL Monitor with the results of an ABAP runtime analysis. Activate the new SQL Monitor in a productive system.

Combine the results of the SQL Monitor with the results of a static source code analysis. Activate the new SQL Monitor in a development system.

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

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

What are functions of the ABAP Managed Database Procedure (AMDP) framework? There are 2 correct answers to this question. It deletes obsolete versions of the database procedure asynchronously It creates the database procedure when the AMDP is first called. It creates the database procedure when the AMDP is first activated. It deletes obsolete versions of the database procedure synchronously.

Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question System privileges Object privileges

Analytic privileges Delta privileges Application privileges

Which is not a key factor of ALV for HANA? Please choose the correct answer. 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 cells To Activate and execute the program in the application

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

Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question. Create a data definition in your ABAP package Specify the name of the SQL view in ABAP Dictionary Create a proxy object for the defined view. Use the DDL statement DEFINE VIEW and SQL like Syntax Define the type mapping between ABAP and SAP HANA

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

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

Which of the following are view annotations for a CDS view? There are 3 correct answers to this question. Client handling Semantics Access control Environment Buffering type

You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question. By a script-based calculation view By another database procedure

By using Sap Analysis for Microsoft office By a core data services view

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

You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? There are 3 correct answers to this question. CE function used in the procedure body ABAP Dictionary table used in the procedure body AMDP used in the procedure body ABAP Dictionary views used in the procedure body SAP HANA views used in the procedure body

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. Code formatting options Statement template options Editor shortcut key options Code completion options

In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view?

Please choose the correct answer. Include all fields used in the ON condition in projection list SPECIFY THE OTHER VIEWS IN WHICH THE ASSOCIATION CAN BE USED define the cardinality for the target entity specify an alias for the target entity

Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)? There are 3 correct answers to this question. Returning Importing Receiving Changing Exporting

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

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. Flexible schedule of check runs Configuration of check variants Enhanced distribution of results

Documented checks

In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement? Please choose the correct answer. GLOBAL TEMPORARY ROW COLUMN LOCAL TEMPORARY

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

User STUDENT_A create and activates a design-time object. In which schema is the run object generated? Please choose the correct answer. _SYS_BI STUDENT_A SYSTEM _SYS_BIC