My Daypo

ABAP for SAP HANA 2.0 09/21

Title of test:
ABAP for SAP HANA 2.0 09/21

ABAP for SAP HANA 2.0 09/21

(Other tests from this author)

Creation Date:


Number of questions: 197
Share the Test:
Share the Test:
Last comments
No comments about this test.
What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? (2 right answers) Account-based Profitability Product-based Profitability Costing-based Profitability Service-based profitability.
In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? specify the other views in which the association can be used specify an alias for the target entity define the cardinality for the target entity include all fields used in the ON condition in projection list.
What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers) 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 ABAP repository objects It represents the connection to the SAP HANA server.
Which of the following are characteristics of an external view? (3 right answers) It can be used in Open SQL statements for database updates. It is an ABAP Dictionary object type. It can be used as a data type in ABAP programs. It allows access to an SAP HANA information view with Open SQL. It defines the underlying SAP HANA information view.
What are the benefits associated with The SAP HANA real-time Operational analytics? (2 right answers) Query Speed support Simplification of massive data High modeling flexibility Fast insights into business activity.
The SAP HANA state-of-the-art search experience includes full-text search with advanced features like... (3 right answers) Isolation search Fuzzy search freestyle search ACID search linguistic search.
To connect with the SAP HANA system and see the corresponding catalog content etc., use the Systems view. How will you add a system to this view? (2 right answers) By using SQL application Database user � also different from your ABAP user Password for the database user By using Open Catalog look.
What are the steps involved in supporting a database oriented programming model (2 right answers) Advanced and specific models A new and advanced Open SQL Core Data services Buffer system services.
Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? (2 right answers) Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES Perform all calculations and aggregations in the ABAP layer Use array variants of INSERT UPDATE MODIFY and DELETE.
Which is not a Golden Rule for Open SQL? Minimize the Number of Database Accesses Keep the result set large Minimize the Amount of Data Transferred Reduce the Database Load.
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? 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.
You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? (3 right answers) SAP HANA views used in the procedure body AMDP used in the procedure body CE function used in the procedure body ABAP Dictionary table used in the procedure body ABAP Dictionary views used in the procedure body.
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? SET_PARAM_TABLE EXECUTE_QUERY SET_PARAM NEXT_PACKAGE.
Explain the Enterprise Information System of - SAP HANA Implementation Scenarios? (3 right answers) HANA Modeling All SAP applications on one SAP HANA platform HANA Accelerators Business Suite on HANA / BW on SAP HANA All HANA Combinations on one platform.
What are the features associated with ABAP CDS (3 right answers) Distribution Export Read Create Update.
In which of the following situations could a row store table be more suitable than a column store table? (2 right answers) 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. The table contains data that you want to aggregate.
Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Create data by members and tables Create Presentations Swap axes Insert filter components.
Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? (3 right answers) De-pooling and de-clustering Definition of an enhancement category Definition of full-text indexes Changes of data class Storage type for tables.
If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. The following parameters are available? (3 right answers) Fuzzy search Index search Point base ranking Freestyle search Weights for ranking.
Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? (2 right answers) Configuration of check variants Enhanced distribution of results Flexible schedule of check runs Documented checks.
What information can you specify using annotations (marked with the @ sign) when you define a Core Data Services (CDS) view in an ABAP system? (3 right answers) The client dependency of the CDS view The extent to which records of the CDS view should be buffered on the application server 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 join conditions of the CDS view.
ABAP 7.4 provides support for optimizing ABAP applications running on SAP HANA. What are these Transparent Optimizations? (3 right answers) The consumption of SAP HANA artifacts was simplified Do all the data processing in Application server Performance analysis tools have been improved Re- use components have been extended or optimized for SAP HANA The ABAP language and the OpenSQL language have been extended.
Name the views that are available to administer and monitor one or several SAP HANA systems (2 right answers) The Security view The Administration view The Landscape view The System Monitor view.
Explain The Authorization Concept and the types of privileges associated with it? (3 right answers) Application privileges Analytic privileges Object privileges System privileges Delta privileges.
The new bottlenecks avoided by addressing two challenges, what are they? (2 right answers) Avoid optimizing data Avoid CPU cache misses Avoid idling CPU cores Avoid single network.
What allows you to resolve errors quickly or warnings reported about the code? Quick Fix ABAP debugger Debug perspective Code execution.
Which data provisioning methods can you use when you need real time replications? (2 right answers) SAP Replication server SAP Landscape transformation Replication server (SAP SLT) SAP Data services SAP HANA Direct extractor connection (SAP DXC).
Which of the following tools and programming techniques use the SQL data definition language? (2 right answers) Core data services (CDS) data definition ABAP Dictionary Open SQL Core data service (CDS) access control.
Discuss the basic approach of classical ABAP programming? (2 right answers) Keep load from the database Collect all the data and perform Parallel processing in ABAP Get all the data you need on the application server and do your processing in ABAP Creating and consuming all the contents from network.
Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)? (3 right answers) Receiving Changing Importing Exporting Returning.
Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? (2 right answers) Partitioning Database table compression Columnar data storage Parallel processing.
You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? (3 right answers) Nested CASE expression CASE expression Unit conversion Currency Conversion CAST Expression.
List down the four main concepts of the SAP HANA database? (3 right answers) Partitioning Column Store Compression Object store Tools combinations.
Which of the following are view annotations for a CDS view? (3 right answers) Semantics Access control Environment Buffering type Client handling.
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SO_ID). Which SELECT statement would you use in the definition? 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 so_id select from snwd_so { so_id, sum(net_amount) as sum_amount } select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id.
What are the different views provided by the ABAP Profiling? (2 right answers) Database accesses Metadata accesses A Hitlist of the most time-consuming programs or methods Performance Check methods.
What are the steps that supported several tools, which in total result in a Guided Performance Optimization? (2 right answers) A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues. Tools analyzing performance at run-time, to determine if critical constructs The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption A new tool called SQL Monitor to determine the priority if different programs access the database intensively.
Which code-to-data capability is responsible for the Optimizations & Translation of �Open SQL SELECT FOR ALL ENTRIES �clauses into native SQL? HANA Specific features Buffer system Optimization Database Optimization Transparent Optimizations.
What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? (2 right answers) Active clusters for all servers High availability configuration Services-Name and index server on all nodes Shared file systems for only one server.
What is the central goal of using SAP HANA? Positive Impact on Business To set Priorities for system Accelerate Performance Monitor database for record keeping.
What is an attribute view and what are its practices? (3 right answers) May contain filters Used in diagrammatic Projections Used to join tables May use in calculation views May contains flow charts.
When are referential joins executed in analytical views? When all the tables are optimized When fields are optimized When fields from both the tables are requested When fields are selected.
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? To limit the unpacking and reconstruction of rows To limit the need of indexes To allow creation of a full-text index To limit the data footprint.
What all are the Types of Applications based on SAP HANA? (2 right answers) Server based on SAP HANA New or Native SAP HANA Innovation based on SAP HANA Data Mart based on SAP HANA.
How will you hide the attributes that are not required for client consumption? By setting the hidden property flag of the attribute provider By setting the hidden property flag of the attribute column By setting the hidden property flag of the attribute in the Semantics screen By setting the hidden property flag of the attribute in the View.
The source code editor in ADT provides many helpful features. What are these helpful features? (2 right answers) Creating Method Definitions from Implementation Parts Creating interface from Method Calls Creating Parts for Interface Methods Creating Method Implementations from the Method Definition.
What are the features of New Open SQL? (2 right answers) Supports specific units of database Supports conditional expressions Supports Code adjustment model Supports arithmetic and string expressions.
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver? (2 right answers) Form-based class builder Quickfix Screen editing Content assistance.
How SAP HANA supports SQL? (3 right answers) Manipulate data As a Data Calculator Read As a means to define Transferring data.
Which steps do you have to perform when defining a view using core data services (CDS)? (3 right answers) Define the type mapping between ABAP and SAP HANA Create a proxy object for the defined view. Specify the name of the SQL view in ABAP Dictionary Create a data definition in your ABAP package Use the DDL statement DEFINE VIEW and SQL like Syntax.
What are best practices when programming in ABAP for SAP HANA? (2 right answers) Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required Use a column list in the SELECT clause to ensure that you only read a column if it is really required Calculate aggregations using ABAP code on the application server to limit database load Eliminate nested SELECT statements to reduce the overall number of database accesses.
Which data sources can you use for SAP list viewer with integrated data access? (3 right answers) Database Procedure CDS View External view Internal table Database Table.
What views will be most efficient for General Modeling Principles? (2 right answers) Column view Schema view Attribute view Analytical view.
Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources? Security folder Content folder Provisioning folder Administration folder.
Which form of services is responsible for defining and consuming semantically rich data models? ITe services Conditional services Core Data Services Modell-II services.
What are the Perspectives and Views of SAP HANA Studio? (2 right answers) System and Properties Administration console Development properties Open system properties.
What do you understand by The SAP HANA Software Optimization? Provide combinations of Objects and Partitioning Huge potential for hybrid database Bring logic to where the data is calculated first, then only move to results Speed up the processing within the database.
You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? Implement the interface IF_AMDP_MARKER_HDB. Set the visibility of the corresponding class method in the declaration section to PUBLIC. Implement the ABAP AMDP_HDB Event Handler. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
What is the main purpose of SAML for SAP HANA Studio? 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 The SAP HANA database supports login of Owners only SAML may be selected as an Owner�s authentication method when creating users in the SAP HANA Studio.
The SAP HANA database is a hybrid in-memory database that combines Few technologies within. What are these technologies? (3 right answers) Column-based database technology Time-based database technology Row-based database technology Object-based database technology Value-based database technology.
How to call the stored procedures in ABAP code? Only SQL Open SQL CDS view Native SQL.
Discuss different types of engines associated with The SAP HANA architecture? (2 right answers) OLAP engine OPAX engine Analytic engine Join engine.
You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Set a breakpoint in the ABAP program and execute the program Choose the Run --> Debug options in the menu 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 two main factors of SAP HANA Innovations and Challenges? (2 right answers) SAP SW technology and innovations DBMS technology and innovations HW technology and innovations SAP BW innovations.
List down the elements involved in User Management and Security in SAP HANA? (3 right answers) Work management Assign job security Assign security Manage users Create users.
What are the Guidelines for optimizing ABAP code running on HANA? (3 right answers) Technical settings Column store High-speed data analysis Open SQL settings DB specific properties.
What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment? (3 right answers) Monitor Administer Configure Organizing Selecting.
What are the ABAP development guidelines? (2 right answers) Improved hybrid components for SAP HANA Extensions to ABAP Language Consuming Only ABAP contents for SAP HANA Improved tools for performance analysis.
To upload data from flat files, SAP HANA offers several features. What are these important features? (2 right answers) When loading new data in the table, it gets appended to the existing data 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 The new table always has a 2:2 mapping between the file and table columns.
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? @it_books {it_books} it_books :it_books.
Which code-to-data capability supports- Extended view definitions and Better SQL- 92 standard support in open SQL? SAP HANA specific features Database oriented programming model New SQL parser used in model Database for sophisticated analysis.
What are functions of the ABAP Managed Database Procedure (AMDP) framework? (2 right answers) It deletes obsolete versions of the database procedure asynchronously It creates the database procedure when the AMDP is first called. It deletes obsolete versions of the database procedure synchronously It creates the database procedure when the AMDP is first activated.
Which is the new concept that is introduced and improved by using SAP HANA Specific Features? New advanced SQL syntax Procedures Table buffering ABAP-Managed Database Procedures Programming model.
What are the uses of SQL Trace (ST05)? (3 right answers) Display record of all database access Detect redundant or identical select statements Locate work base issues Locate database performance issues Applying Code inspector.
User STUDENT_A create and activates a design-time object. In which schema is the run object generated? SYSTEM STUDENT_A _SYS_BIC _SYS_BI.
Why is a security concept in SAP HANA required? (2 right answers) 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 Database administration should be restricted to skilled Access to ERP tables must be restricted.
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? 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.
What are the Parameters for Analytical and Calculation view? (3 right answers) Passing other values to be used in calculations Specifying unit of measurement To store data for critical analysis Setting a filter for columns Create a copy of a report.
What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 right answers) Take snapshot manually before releasing of the container You need to refresh the content of the container manually Changes to Delta Container Automatic release of units.
AMDP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? (3 right answers) SQLScript errors Database independent syntax errors HANA specific syntax errors Database platform syntax errors UNION specific syntax errors.
You developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of this AMDP using business add-in (BADI). Which of the following objects must you create? (3 right answers) A BADI fallback implementation A BADI definition A BADI simple implementation AN enhancement spot A database procedure.
What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)? (3 right answers) Define all method parameters to be passed by value. Use scalar types for all AMDP method parameters. Specify the database system and the language. List all ABAP Dictionary tables used in the procedure body in the USING clause. Mark the AMDP method as a READ-ONLY database procedure.
Discuss the conditions required to ensure the Referential Integrity? (2 right answers) There are two joins in the able Referential integrity holds true in both the directions There is at least one join in the other table There are three joins in the table.
Open SQL largely standardized, three sub-languages. What are these sub-languages? (3 right answers) Data Manipulation Language (DML) The Data Definition Language (DDL) The Data Control Language (DCL) Data Transferring Language(DTL) Data Evaluation Language(DEL).
You made changes to an object (X) used by an ABAP managed database procedure (AMDP). You did NOT changes the AMDP itself. Now you execute a program that calls this AMDP. In which cases does the call trigger the creation of the database procedure in SAP HANA? (2 right answers) X is an AMDP method X is a stored procedure X is an ABAP Dictionary table X is an SAP HANA view.
What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? (2 right answers) All ABAP variables must be escaped with a proceeding @ sign. All fields in the GROUP BY clause must be separated by commas All Keywords are case sensitive All arithmetic expressions can be used for all type of variables.
What are the steps involved in SAP HANA Evolution? (3 right answers) Optimized ABAP on SAP HANA ABAP can run on SAP HANA ABAP applications on SAP HANA ABAP as accelerator on SAP HANA ABAP can access SAP HANA.
What should you do to follow the code-to-data approach to programming? (3 right answers) Aggregate data on the database, and transfer the results to the ABAP layer. Use native SQL to access SAP HANA built-in functions Transfer all data from the database to the ABAP layer, and then aggregate the results. Perform expensive calculations on the database. Perform expensive calculations on the ABAP application server.
Which of the following is not involved in database table of �The New ABAP SQL Monitor � Architecture�? Performance data table Runtime monitor data Selection data table Critical data table.
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? (2 right answers) Create a restricted column for the ADDRESS field Create an input parameter for the ADDRESS field Exclude the ADDRESS field from the union Map the ADDRESS field to a constant value.
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? (2 right answers) Use the CLIENT SPECIFIED addition. Include the client field in the WHERE condition. Include the client field in the join condition. Include the client field in the field list.
Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? (2 right answers) Stored procedure Calculation views ABAP managed database procedures Core data services views.
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? SELECT * statements on tables with more than a specified number of fields SELECT * statements on tables with more than 100,000 records SELECT * statements on tables with the Column Store storage type SELECT * statements where fewer than a specified percentage of all fields are effectively used.
Which of the following is not an element of Analytical view? Join fact tables Read Data from the joined database tables Used to Joined table Currency conversion is not applicable.
What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? (3 right answers) Tuning Innovate Detect Optimize Scaling.
What are the two layers of ABAP system interacts with its database? (2 right answers) The Data Storage interface The Client database interface The Database specific library The Database independent interface.
Which of the following is a limitation when you create an external view? You can only use native SQL to consume the external view 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.
What all are the factors involved in Working with ADT (3 right answers) Workbench programs ABAP Class ABAP programs Module interface ABAP interface.
What made SAP HANA possible? (2 right answers) CPU with single core network RAM limitation Technology and innovations Improved hardware technology.
What all are the steps to perform -To enable type-ahead for an input field on a screen? (3 right answers) Identify Elementary Search Help Automatic updates of all the input fields Check Pre-Requisites Switch on proposal search for input fields Process on all the input fields.
Which is not a key factor of ALV for HANA? To supply suitable values for any input parameters The data display is restricted to a maximum of 2 billion cells Derived Column headings from the data element To Activate and execute the program in the application.
How to create a core data services view? (3 right answers) Use data services tools for updates Use DDL statement DEFINE VIEW and SQL-like syntax to define the view Use SQL capabilities for Netweaver Use the ABAP Development Tools for SAP NetWeaver. Use additional annotations � marked with the @ sign.
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? Release resources Update packages Update resources Release packages.
Explain Transitioning ABAP Code to SAP HANA � Performance Considerations? (3 right answers) Some shifts in priorities, examples, nested selects(higher) indices(lower) Some codes immediately run faster Some codes transferred to other systems Classical performances recommendations for open SQL remain valid Some codes impacted positively and should be priorities.
What are the benefits of using the SQL Monitor (transaction SQLM)? (2 right answers) It can be active in a production system with minimal performance overhead. It displays the database execution plan for all SQL statements. It schedules ABAP programs to monitor and log all database accesses. It collects monitoring data asynchronously without additional database interaction.
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? (2 right answers) View CA_CUSTOMER has deployment mode A. SYSTEM P81 has SAP HANA has primary database Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK PACKAGE ZHA400_00 HAS deployment Mode A.
What are the basic principles of ALV SAP HANA? (2 right answers) To ensure that the user chooses the data on the selection screen is displayed The ALV Optimization for SAP HANA to display data on the screen Only retrieve the database data which is to be displayed on screen Data described declaratively instead of passing big internal tables.
What are the principles of Using HANA Transport Containers properly? (3 right answers) Release of Transport request 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.
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? A value that you calculate based on the number of tables 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.
Name some perspectives that are available in the SAP HANA Studio? (3 right answers) The technology & innovation perspective The SAP HANA Modeler perspective The Administration Console perspective The Information perspective The Resources perspective.
SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANA has to meet. What are these goals? (2 right answers) Analytical DBMS features Hybrid data and management system Support for system tables High Performance and Scalability.
DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? (2 right answers) Column store Development Store Re-use component store ROW store Technology store.
Which features does the source code editor provide in ABAP Development Tools (ADT)? (2 right answers) Form-based Class Builder Content Assist Quick Fix Screen Painter.
What are the components of The Enterprise Procurement Model Demo Scenario? (3 right answers) Sales Procurement Stock Services Product.
What output does The SAP HANA provide as a unique combination of hardware and software innovations? Huge potential to optimize AMDP application DATA Tables Huge potential to maximize the number of disk blocks in the application The ability to create new complex processes with ABAP application cloud Huge potential to optimize business applications that are running on SAP HANA .
How many result sets are returned when an SAP HANA database procedure is called using the CALL. WITH OVERVIEW statement? Two result sets As many result sets as there are table output parameters in the procedure One result set As many result sets as there are input parameters in the procedure.
What are the Possible Approaches with AS ABAP < 7.4 SP02? (2 right answers) Consume using native SQL Stored Procedures SQL units Interaction with Database.
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? (2 right answers) 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. Activate the new SQL Monitor in a productive system. Combine the results of the SQL Monitor with the results of an ABAP runtime analysis.
What is the Limitations of ALV for SAP HANA? (3 right answers) No unit/ currency split if aggregating amounts/ currency values Restricted to 5000 records / unit Restricted to 10,000 records All unit/ currency restricted to 10,00,00 records Without currency /unit consideration.
You define a core data services (CDS) view to merge the results of queries using the UNION keyword. What must the column list of this queries contain? (2 right answers) All key fields Columns of identical types The same number of columns Columns of compatible types.
How will you select a preference for Validation rules? Windows- Preferences-SAP HANA-Modeler-Validation Rules Windows- SAP HANA-Preferences-Modeler-Validation Rules Windows- Modeler � Preferences-SAP HANA-Validation Rules Windows- SAP HANA-Modeler-Preferences-Validation Rules.
Discuss the main capabilities of SAP BusinessObjects Analysis for Office? (2 right answers) Suggests style sets for crosstabs Convert crosstab cells to formula Sort data by characteristics Analyze data with the design panel.
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Combine information from static ABAP code scans with runtime data from the SQL Trace tool. 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 Estimate the new total runtime of optimized code.
What are the elements of ABAP Database Integration? (3 right answers) Other DB DB For ABAP Client database handling DB client-server Application server.
What all are the advantages provides by ABAP Development Tools? (3 right answers) An open platform for developing powerful database view An open platform for developing new ABAP-related tools A set of Eclipse data pool and Client- Open platform A set of open, language- and platform-independent APIs A brand new ABAP development experience on top of the Eclipse platform.
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? Code formatting options Editor shortcut key options Code completion options Statement template options.
What are the Performance Rules and Guidelines for ABAP on SAP HANA? (2 right answers) It is beneficial for maximizing your search into database 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.
Which of the following tasks can you perform with SQL monitor (transaction SQLM)? Capture the SQL profile of an application Display the execution plan of an SQL statement Combine static and dynamic performance analysis results Search for problematic SELECT* statements.
What are the supported joins in CDS view? (2 right answers) Operators joint Upper join Inner join Left outer join.
Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment? Catalogue outlook System Perspective Modeler Perspective Open Content outlook.
Which of the following tool is introduced as a holistic quality assurance tool? BW system ABAP Test Cockpit (ATC) DBMS Cockpit DBA Cockpit.
Hybrid Data Management System � Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system? (3 right answers) Text indexing capabilities Text analysis and search Traditional disk-based tables Linguistic search capabilities Built-in support for planning.
What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? (3 right answers) Group rows Display diagrams Search in Content Double-click on rows Edit cells.
Which of the following are performance recommendations when using SAP HANA? (2 right answers) Avoid transferring large result sets between database and client applications. Move data-intensive calculations from the database to an application server. Filter data in lower layers. Define indexes on the columns that are used in calculations.
An Analytic Privilege consists of several restrictions. What are they? (3 right answers) Cube restrictions View restrictions Analytic restrictions Validity restrictions Activity restrictions.
You created and activated database procedure. How can you call this procedure? (2 right answers) By using Sap Analysis for Microsoft office By a core data services view By another database procedure By a script-based calculation view.
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. (3 right answers) Code that relies on implicit database sorting Direct access to a cluster on the database Left outer joins in open SQL statements Native SQL statements ORDER BY Clauses in Open SQL statements.
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? LOCAL TEMPORARY GLOBAL TEMPORARY COLUMN ROW.
What are the benefits includes with SAP HANA Full Text Search? (2 right answers) Large number of toolkits are available Exploit structured contents in SQL Easy to use modeling tool Fewer data duplication and movement.
What are the two different kinds of Identifiers used to represent names used in SQL statement? (2 right answers) Undelimited Identifiers Delimited identifiers Numeric identifiers Limited identifiers.
Explain how and when to create calculated columns - Using Graphical Modeling Tools? (3 right answers) The calculation will be opened in a read-only mode It is possible to nest so that one calculated column, in turn, is based on other calculated columns The calculation could be an arithmetic or character manipulation. Calculated columns also support non-measure attributes as part of the calculation. Time characteristics based calculation columns.
What are the two main methods to add a system to the SAP HANA Studio? (2 right answers) Manually By Resource console By Importing a Landscape Automatically.
Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench? (3 right answers) External view Core Data service (CDS) view ABAP program containing new Open SQL Full-text index Database procedure proxy.
Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? (3 right answers) Code inspector (transaction SCI) SQL Trace (transaction ST05) SQL monitor (transaction SQLM) ABAP test cockpit (transaction ATC) Data base performance monitor (transaction DB50).
You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? (3 right answers) Specify the database schema if it is not the user's default schema Explicitly handle the client field Use the UP TO n ROWS addition Use a Comma-separated column list Use the tilde symbol (~) to separate qualifier from column name.
When to use Enhanced Open SQL? (2 right answers) At the time of Dictionary Views To view scalar components To access system fields Need the query in one piece of code only.
What is the main function of Static Code Analysis? 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.
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? Read-write Read only Read-update Write only.
What are the two types of editors available in ADT? (2 right answers) ABAP (native) SAP (GUI) Eclipse (native) Client (native).
What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA database? (2 right answers) The ABAP system checks the syntax of the Native SQL statements. Client handling needs to be done explicitely in the the Native SQL statement. Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword. The database independency of your report can be lost.
What are the Functions of Transaction DBACOCKPIT (2 right answers) Maintain only HANA specific objects Use Schema for the Connections Maintain, Monitor and test secondary database connection Used to access local or remote database system.
Which system schema contains the list of Activated and inactive Objects? _SYS_XS _SYS_BI _SYS_BIC _SYS_REPO.
What is the main purpose of Analytic Privilege? Restrict users to access database tables Restrict user to access modeling view Restrict row level access so that user will be able to see only certain portion of the data.
Graphical calculation views can later be converted to Scripted calculation view if required. yes no.
Which statement is true for SAP HANA? SAP provides both hardware and software for SAP HANA. SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners.
Which of the statement is true for SAP HANA? SAP HANA also uses disc memory to keep backup. In case of power failure the database can be re-stored to the last consistent state. In SAP HANA all the data resides in RAM. Hence in case of power failure all the data will be lost.
HANA modeling views can be created under File System Schema Catalog Content.
Which of the following statements are true about �Content�? All the physical tables and views can be found under the Catalog node. It contains the design-time artifacts. It represents SAP HANA�s data dictionary.
Which system schema contains the information about Time data and Schema Mapping? _SYS_BIC _SYS_BI _SYS_XS _SYS_REPO.
What are the different types of Calculation View? (2 answers) Text-Based Calculation Scripted Calculation View OLAP Calculation View Graphical Calculation View.
Which of the following is latest release of SAP HANA? SAP HANA 1.0 SAP HANA 1.6 SP03 SAP HANA 2.0 SPS 05 SAP HANA 1.0 SP06.
While creating a Graphical Calculation view, what are the options available in Tools palette? (4 right answers) Join Projection Union Aggregation Cast Distinct.
Which of the following statements are true about �Catalog�? All the physical tables and views can be found under the Catalog node. It contains the design-time artifacts. It represents SAP HANA�s data dictionary.
Which of the below statements are true for SAP HANA Studio? (3 right answers) SAP HANA Studio is a client tool, which can be used to access local or remote HANA system. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server. SAP HANA Studio is integrated in SAP GUI > 7.40.
What are the different types of Variables in HANA? (3 right answers) Single Value Interval Range Double.
What language one should know to work in SAP HANA? ABAP C# Java SQL.
Which components can be a part of a calculation view? (3 answers) Tables BAPIs Attribute View Analytic View.
What are the advantages of column based tables? (3 correct answers) Better parallel Processing Better Compression Faster Data Access Bigger Data Set.
Which of the following is true? (2 correct answers) A Read-write procedure cannot call another read-write procedure. A read only procedure cannot call read-write procedure. A read-write procedure can call both read-write and read only procedures.
Which is better from performance point of view? SQLScript Procedure Modeling Views.
Which of the below has huge negative impact on performance? (2 answers) Inner Join Mixing up SQL statement and CE functions Join on calculated column.
Which SQL syntax is used to create a read only procedure? READS PROCEDURE READ-ONLY NO-SIDE-EFFECT READS SQL DATA.
What is the language SAP HANA is developed in? Java Assembly C C++.
SQLScript supports control logic like if/else, while traditional SQL does not support that. True False.
Which system schema contains the column views of activated objects? _SYS_XS _SYS_BI _SYS_BIC _SYS_REPO.
Which SAP HANA engine executes Calculation view by default? Join Engine Calc Engine SQL Engine OLAP Engine.
Analytic Privilege can be applied to (3 Answers) Table Attribute views SQL View Calculation views Analytic views.
What is the operating system supported by HANA? (2 correct answers) SUSE Linux Enterprise Server Both Linux and Window 8 Only Windows 8 Red Hat Enterprise Linux (RHEL).
What are the types of schemas in HANA? (3 correct) System Defined Schema Dynamic Schema User Defined Schema SLT Derived Schema.
What is the full form of HANA? High-Performance Analytic Appliance High-Performance Analytic Accelerator High-Performance Analytic Application High Accelerator Numeric Analytics.
Which of the following can be part of an analytic view? (3 answers) Attributes Query transformation Data foundation Logical joins Unions.
In order to get language-specific data, which join is used in SAP HANA? Text Join Referential Join It is not possible to fetch language-specific data in HANA Language join.
Which system schema/user is the owner of all the activated objects? _SYS_XS _SYS_BI _SYS_BIC _SYS_REPO.
Which engine is used to execute Analytic View? Join Engine Calc Engine SQL Engine OLAP Engine.
Which SAP HANA engine executes Calculation view? (2 answers) SQL Engine OLAP Engine Calculation Engine JOIN Engine.
What is the main advantage of SQLScript? (2 answers) SQLScript is faster than traditional SQL SQLScript code can easily be translated into modeling view SQLScript can be better modularized than traditional SQL.
Which of the statements are true for SQLScript? (2 answers) SQLScript is used to push down data intensive logic into the database. SQLScript is a collection of extensions to SQL. SQLScript is an open standard.
Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA) and NOT the SAP HANA Transport Container (HTC). Why would you choose HTA? Note: There are 2 correct answers to this question. Because you can manually re-deploy objects after a failed import Because you use the technique that is recommended by SAP Because you automatically add changed objects to the transport request. Because you always transport entire SAP HANA content packages.
ou want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL Which of the following are necessary adjustments? There are 3 correct answers to this question. Specify the schema for every table Replace ORDER BY additions Replace UP TO n ROWS additions Replace CORRESPONDING FIELDS additions Add explicit client handling.
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM) Specify the schema for every table Replace ORDER BY additions Replace UP TO n ROWS additions Replace CORRESPONDING FIELDS additions Add explicit client handling.
You implement an ABAP-managed database procedure (AMDP). You want to query data from Calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb. How can you address the calculation view? There are 2 correct answers to this questions. "ha400.primdb/CA_BOOKINGS_COUNT" _SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT" "ha400.primdb::CA_BOOKINGS_COUNT" _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT".
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)? Existence check for secondary indexes Use of Native SQL and DB Hints Missing ORDER BY or SORT after SELECT Direct access to table pools/cluster.
You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node: AT Vienna 11 AT Vienna 15 DE Berlin 13 DE Berlin 13 AT Vienna 11 AT Vienna 15 DE Berlin 13 AT Vienna 26 DE Berlin 26 AT Vienna 11 DE Berlin 13.
Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA? There are 2 correct answers to this question. Keep unnecessary load away from the database. Minimize the number of database accesses Minimize the amount of transferred data Minimize the search overhead.
You analyse SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its data. But the relevant database access is NOT listed in SQLMD. What could be the reason? There are 3 correct answers to this question. SQL Monitor was activated for a specific application server SQL monitor was activated with a filter that excludes database table Y The data has NOT yet been transferred to the SQL monitor database tables Program X was executed in the background Database table Y is a buffered table.
Report abuse Terms of use
Author's Tests