Which is not a key factor of ALV for HANA? The data display is restricted to a maximum of 2 billion cells To supply suitable values for any input parameters Derived Column headings from the data element To Activate and execute the program in the application.
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. Left outer joins in open SQL statements Code that relies on implicit database sorting ORDER BY Clauses in Open SQL statements Native SQL statements Direct access to a cluster on the database.
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 data footprint To allow creation of a full-text index To limit the need of indexes.
What information can you specify using annotations (marked with the @ sign) when you define a Core Data Services (CDS) view in an ABAP system? The client dependency 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 ser The logic for aggregations, grouping records, and filtering groups of the CDS view The join conditions of the CDS view.
What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? Service-based profitability Product-based Profitability Costing-based Profitability Account-based Profitability.
What are the supported joins in CDS view? Left outer join Inner join Upper join Operators joint.
List down the elements involved in User Management and Security in SAP HANA? Create users Assign security Manage users Work management Assign job security.
What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment? Monitor Administer Organizing Configure Selecting.
What are the Possible Approaches with AS ABAP < 7.4 SP02? Stored Procedures Consume using native SQL SQL units Interaction with Database.
What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? All ABAP variables must be escaped with a proceeding @ sign. All Keywords are case sensitive All arithmetic expressions can be used for all type of variables All fields in the GROUP BY clause must be separated by commas.
You created and activated database procedure. How can you call this procedure? By a script-based calculation view By another database procedure By a core data services view By using Sap Analysis for Microsoft office.
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? COLUMN ROW LOCAL TEMPORARY GLOBAL TEMPORARY.
Which of the following are characteristics of an external view? It allows access to an SAP HANA information view with Open SQL. It can be used in Open SQL statements for database updates. It is an ABAP Dictionary object type. It defines the underlying SAP HANA information view. It can be used as a data type in ABAP programs.
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? Map the ADDRESS field to a constant value Create a restricted column for the ADDRESS field Exclude the ADDRESS field from the union Create an input parameter for the ADDRESS field.
Which of the following are view annotations for a CDS view? Buffering type Semantics Environment Access control Client handling.
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 Database Optimization Transparent Optimizations Buffer system Optimization.
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 } 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 } group by so_id.
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? X is an ABAP Dictionary table X is an SAP HANA view X is a stored procedure X is an AMDP method.
What are the Perspectives and Views of SAP HANA Studio? Administration console Open system properties System and Properties Development properties.
What is the purpose of an ABAP project in ABAP Development tools for eclipse? 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 an ABAP system It represents the connection to the SAP HANA server.
Explain how and when to create calculated columns - Using Graphical Modeling Tools? 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. The calculation will be opened in a read-only mode Time characteristics based calculation columns.
Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? ABAP managed database procedures Stored procedure Calculation views Core data services views.
User STUDENT_A create and activates a design-time object. In which schema is the run object generated? STUDENT_A _SYS_BI SYSTEM _SYS_BIC.
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 lower value than on a traditional, row-store only based database 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.
Discuss different types of engines associated with The SAP HANA architecture? OPAX engine Analytic engine Join engine OLAP engine.
Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench? External view ABAP program containing new Open SQL Full-text index Core Data service (CDS) view Database procedure proxy.
Which features does the source code editor provide in ABAP Development Tools (ADT)? Content Assist Screen Painter Quick Fix Form-based Class Builder.
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver? Screen editing Content assistance Quickfix Form-based class builder.
When are referential joins executed in analytical views? When all the tables are optimized When fields from both the tables are requested When fields are optimized When fields are selected.
What are the steps that supported several tools, which in total result in a Guided Performance Optimization? The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption 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 A new tool called SQL Monitor to determine the priority if different programs access the database intensively.
Which code-to-data capability supports- Extended view definitions and Better SQL- 92 standard support in open SQL? Database oriented programming model Database for sophisticated analysis New SQL parser used in model SAP HANA specific features.
You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? Use a Comma-separated column list Use the tilde symbol (~) to separate qualifier from column name Explicitly handle the client field Specify the database schema if it is not the user's default schema Use the UP TO n ROWS addition.
Which of the following tool is introduced as a holistic quality assurance tool? DBA Cockpit BW system DBMS Cockpit ABAP Test Cockpit (ATC).
If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. The following parameters are available? Index search Point base ranking Fuzzy search Freestyle search Weights for ranking.
What allows you to resolve errors quickly or warnings reported about the code? ABAP debugger Quick Fix Debug perspective Code execution.
Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources? Security folder Administration folder Content folder Provisioning folder.
When using 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 tabular result of the native SQL call? NEXT_PACKAGE GET_METADATA SET_PARAM SET_PARAM_TABLE.
Explain the Enterprise Information System of - SAP HANA Implementation Scenarios? All SAP applications on one SAP HANA platform HANA Accelerators All HANA Combinations on one platform Business Suite on HANA / BW on SAP HANA HANA Modeling.
What are the steps involved in supporting a database oriented programming model? A new and advanced Open SQL Buffer system services Core Data services Advanced and specific models.
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? Database user – also different from your ABAP user By using Open Catalog look By using SQL application Password for the database user.
What all are the advantages provides by ABAP Development 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 new ABAP-related tools A set of Eclipse data pool and Client- Open platform An open platform for developing powerful database view.
What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? Active clusters for all servers Shared file systems for only one server High availability configuration Services-Name and index server on all nodes.
In which of the following situations could a row store table be more suitable than a column store table? 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 data provisioning methods can you use when you need real time replications? SAP Replication server SAP Data services SAP Landscape transformation Replication server (SAP SLT) SAP HANA Direct extractor connection (SAP DXC).
What are the benefits of using the SQL Monitor (transaction SQLM)? It displays the database execution plan for all SQL statements. It can be active in a production system with minimal performance overhead. It schedules ABAP programs to monitor and log all database accesses. It collects monitoring data asynchronously without additional database interaction.
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? Include the client field in the join condition. Include the client field in the WHERE condition. Include the client field in the field list. Use the CLIENT SPECIFIED addition.
You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? CE function used in the procedure body ABAP Dictionary views used in the procedure body AMDP used in the procedure body SAP HANA views used in the procedure body ABAP Dictionary table used in the procedure body.
To upload data from flat files, SAP HANA offers several features. What are these important features? 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 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.
What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? Innovate Optimize Tuning Scaling Detect.
Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? SQL Trace (transaction ST05) ABAP test cockpit (transaction ATC) SQL monitor (transaction SQLM) Code inspector (transaction SCI) Data base performance monitor (transaction DB50).
Why is a security concept in SAP HANA required? 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 do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA database? Client handling needs to be done explicitely in the the Native SQL statement. The database independency of your report can be lost. Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword. The ABAP system checks the syntax of the Native SQL statements.
What is an attribute view and what are its practices? Used in diagrammatic Projections May use in calculation views May contain filters Used to join tables May contains flow charts.
Which of the following tools and programming techniques use the SQL data definition language? Core data service (CDS) access control Core data services (CDS) data definition ABAP Dictionary Open SQL.
What are the two main factors of SAP HANA Innovations and Challenges? DBMS technology and innovations SAP BW innovations SAP SW technology and innovations HW technology and innovations.
Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? Configuration of check variants Flexible schedule of check runs Enhanced distribution of results Documented checks.
Which steps do you have to perform when defining a view using core data services (CDS)? 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 Define the type mapping between ABAP and SAP HANA Specify the name of the SQL view in ABAP Dictionary.
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 Create a debug configuration for the ABAP application and run the program Choose the Run --> Debug options in the menu Choose the debug as option in the context menu of the ABAP program.
Which of the following are performance recommendations when using SAP HANA? Filter data in lower layers. Avoid transferring large result sets between database and client applications. Move data-intensive calculations from the database to an application server. Define indexes on the columns that are used in calculations.
What are the benefits includes with SAP HANA Full Text Search? Easy to use modeling tool Fewer data duplication and movement Large number of toolkits are available Exploit structured contents in SQL.
An Analytic Privilege consists of several restrictions. What are they? Cube restrictions Analytic restrictions Activity restrictions View restrictions Validity restrictions.
What are the Functions of Transaction DBACOCKPIT Maintain, Monitor and test secondary database connection Use Schema for the Connections Used to access local or remote database system Maintain only HANA specific objects.
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? Editor shortcut key options Code formatting options Code completion options Statement template options.
What is the Limitations of ALV for SAP HANA? Without currency /unit consideration No unit/ currency split if aggregating amounts/ currency values Restricted to 10,000 records All unit/ currency restricted to 10,00,00 records Restricted to 5000 records / unit.
Which is not a Golden Rule for Open SQL? Minimize the Amount of Data Transferred Minimize the Number of Database Accesses Reduce the Database Load Keep the result set large.
What is the main function of Static Code Analysis? ABAP source code with performance optimization potential Integrates with SAP Solution Manager To detect code that would lead to functional or performance issues When migrating to SAP HANA Integrated into ABAP Development Tools and ABAP Workbench.
What is the central goal of using SAP HANA? Accelerate Performance To set Priorities for system Positive Impact on Business Monitor database for record keeping.
What are best practices when programming in ABAP for SAP HANA? Calculate aggregations using ABAP code on the application server to limit database load 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 Eliminate nested SELECT statements to reduce the overall number of database accesses.
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 less than the gross run time The net run time is equal to Zero The gross and net run times are identical The net run time is greater than the gross run time.
List down the four main concepts of the SAP HANA database? Object store Tools combinations Partitioning Column Store Compression.
Which of the following is not an element of Analytical view? Join fact tables Currency conversion is not applicable Read Data from the joined database tables Used to Joined table.
Which data sources can you use for SAP list viewer with integrated data access? Database Procedure External view Internal table CDS View Database Table.
What are the features associated with ABAP CDS? Read Create Distribution Update Export.
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 SET_PARAM_TABLE EXECUTE_QUERY NEXT_PACKAGE.
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.
How to create a core data services view? Use SQL capabilities for Netweaver Use DDL statement DEFINE VIEW and SQL-like syntax to define the view Use additional annotations – marked with the @ sign Use data services tools for updates Use the ABAP Development Tools for SAP NetWeaver.
Explain The Authorization Concept and the types of privileges associated with it? Delta privileges Application privileges Analytic privileges System privileges Object privileges.
Which tasks does the ABAP managed database (AMDP) framework perform? 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 Delete the obsolete versions of the database procedure asynchronously Delete the obsolete versions of the database procedure synchronously.
What are the Parameters for Analytical and Calculation view? To store data for critical analysis Specifying unit of measurement Passing other values to be used in calculations Setting a filter for columns Create a copy of a report.
Discuss the main capabilities of SAP BusinessObjects Analysis for Office? Analyze data with the design panel Suggests style sets for crosstabs Convert crosstab cells to formula Sort data by characteristics.
Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)? Changing Returning Importing Exporting Receiving.
What are the uses of SQL Trace (ST05)? Display record of all database access Locate database performance issues Detect redundant or identical select statements Locate work base issues Applying Code inspector.
What are the principles of Using HANA Transport Containers properly? Takes a ‘snapshot’ of all SAP HANA objects of delivery unit Release of Transport request To create Transport container of delivery unit Import of Transport Request Automatic update for all export methods.
Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? Definition of an enhancement category De-pooling and de-clustering Storage type for tables Definition of full-text indexes Changes of data class.
What are the two different kinds of Identifiers used to represent names used in SQL statement? Undelimited Identifiers Limited identifiers Delimited identifiers Numeric identifiers.
What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)? List all ABAP Dictionary tables used in the procedure body in the USING clause. Define all method parameters to be passed by value. Mark the AMDP method as a READ-ONLY database procedure. Specify the database system and the language. Use scalar types for all AMDP method parameters.
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? A BADI fallback implementation A database procedure A BADI definition A BADI simple implementation AN enhancement spot.
In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? 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 do you understand by The SAP HANA Software Optimization? 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.
Open SQL largely standardized, three sub-languages. What are these sub-languages? Data Evaluation Language(DEL) The Data Control Language (DCL) The Data Definition Language (DDL) Data Transferring Language(DTL) Data Manipulation Language (DML).
The source code editor in ADT provides many helpful features. What are these helpful features? Creating Method Definitions from Implementation Parts Creating Parts for Interface Methods Creating interface from Method Calls Creating Method Implementations from the Method Definition.
What are the Guidelines for optimizing ABAP code running on HANA? Technical settings High-speed data analysis Column store DB specific properties Open SQL settings.
Which of the following tasks can you perform with SQL monitor (transaction SQLM)? Capture the SQL profile of an application Search for problematic SELECT* statements Display the execution plan of an SQL statement Combine static and dynamic performance analysis results.
What are the basic principles of ALV SAP HANA? The ALV Optimization for SAP HANA to display data on the screen Only retrieve the database data which is to be displayed on screen To ensure that the user chooses the data on the selection screen is displayed Data described declaratively instead of passing big internal tables.
What views will be most efficient for General Modeling Principles? Analytical view Attribute view Column view Schema view.
What are the different views provided by the ABAP Profiling? Metadata accesses Database accesses Performance Check methods A Hitlist of the most time-consuming programs or methods.
What are the elements of ABAP Database Integration? Other DB DB For ABAP Application server Client database handling DB client-server.
What are the features of New Open SQL? Supports specific units of database Supports conditional expressions Supports Code adjustment model Supports arithmetic and string expressions.
What all are the Types of Applications based on SAP HANA? Innovation based on SAP HANA Data Mart based on SAP HANA New or Native SAP HANA Server based on SAP HANA.
Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Create data by members and tables Create Presentations Insert filter components Swap axes.
What are the benefits associated with The SAP HANA real-time Operational analytics? Simplification of massive data Fast insights into business activity Query Speed support High modeling flexibility.
AMDP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? SQLScript errors Database platform syntax errors UNION specific syntax errors Database independent syntax errors HANA specific syntax errors.
The SAP HANA state-of-the-art search experience includes full-text search with advanced features like... ACID search Fuzzy search freestyle search linguistic search Isolation search.
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 packages Update resources Update packages Release resources.
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 100,000 records 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.
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? 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 functions of the ABAP Managed Database Procedure (AMDP) framework? It deletes obsolete versions of the database procedure asynchronously It deletes obsolete versions of the database procedure synchronously It creates the database procedure when the AMDP is first activated. It creates the database procedure when the AMDP is first called.
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.
How to call the stored procedures in ABAP code? Open SQL Only SQL Native SQL CDS view.
What are the components of The Enterprise Procurement Model Demo Scenario? Product Stock Services Procurement Sales.
How SAP HANA supports SQL? Read As a Data Calculator Manipulate data Transferring data As a means to define.
Explain Transitioning ABAP Code to SAP HANA – Performance Considerations? Some codes impacted positively and should be priorities Some shifts in priorities, examples, nested selects(higher) indices(lower) Some codes transferred to other systems Some codes immediately run faster Classical performances recommendations for open SQL remain valid.
What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? Edit cells Display diagrams Search in content Double-click on rows Group rows.
When to use Enhanced Open SQL? Need the query in one piece of code only To access system fields To view scalar components At the time of Dictionary Views.
What are the steps involved in SAP HANA Evolution? ABAP as accelerator on SAP HANA ABAP can run on SAP HANA ABAP applications on SAP HANA ABAP can access SAP HANA Optimized ABAP 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 column By setting the hidden property flag of the attribute provider 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.
Which is the new concept that is introduced and improved by using SAP HANA Specific Features? ABAP-Managed Database Procedures Programming model Table buffering New advanced SQL syntax Procedures.
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? 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 a static source code analysis. Combine the results of the SQL Monitor with the results of an ABAP runtime analysis.
Discuss the basic approach of classical ABAP programming? Creating and consuming all the contents from network Collect all the data and perform Parallel processing in ABAP Keep load from the database Get all the data you need on the application server and do your processing in ABAP.
Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”? Runtime monitor data Performance data table Selection data table Critical data table.
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 rules does SAP recommended to improve the performance of ABAP report on SAP HANA? 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 Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement.
Discuss the conditions required to ensure the Referential Integrity? Referential integrity holds true in both the directions There are three joins in the table There are two joins in the able There is at least one join in the other table.
Name the views that are available to administer and monitor one or several SAP HANA systems? The Landscape view The Administration view The System Monitor view The Security view.
ABAP 7.4 provides support for optimizing ABAP applications running on SAP HANA. What are these Transparent Optimizations? Re- use components have been extended or optimized for SAP HANA The consumption of SAP HANA artifacts was simplified The ABAP language and the OpenSQL language have been extended Do all the data processing in Application server Performance analysis tools have been improved.
Which of the following is a limitation when you create an external view? You must use the ABAP Development tools (ADT) TO CREATE the external 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 You must know the underlying tables and join conditions of the SAP HANA view.
ANSI SQL owns features and adds languages these languages divided into three parts. What are they? The Data Control Language Data Transferred Language The Database Language Data Manipulation Language The Data Definition Language.
What output does The SAP HANA provide as a unique combination of hardware and software innovations? Huge potential to optimize business applications that are running on SAP HANA Huge potential to optimize AMDP application DATA Tables The ability to create new complex processes with ABAP application cloud Huge potential to maximize the number of disk blocks in the application.
Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? Database table compression Parallel processing Columnar data storage Partitioning.
You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? CASE expression Nested CASE expression Currency Conversion Unit conversion CASTE Expression.
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Estimate the new total runtime of optimized code. 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. Combine information from static ABAP code scans with runtime data from the SQL Monitor.
The SAP HANA database is a hybrid in-memory database that combines Few technologies within. What are these technologies? Value-based database technology Time-based database technology Row-based database technology Column-based database technology Object-based database technology.
What are the two types of editors available in ADT? Client (native) ABAP (native) Eclipse (native) SAP (GUI).
What made SAP HANA possible? Improved hardware technology Technology and innovations CPU with single core network RAM limitation.
What all are the factors involved in Working with ADT Workbench programs Module interface ABAP Class ABAP programs ABAP interface.
What are the ABAP development guidelines? Extensions to ABAP Language Improved tools for performance analysis Improved hybrid components for SAP HANA Consuming Only ABAP contents for SAP HANA.
Name some perspectives that are available in the SAP HANA Studio? The SAP HANA Modeler perspective The Administration Console perspective The technology & innovation perspective The Information perspective The Resources perspective.
Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment? Open Content outlook Modeler Perspective System Perspective Catalogue outlook.
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? The same number of columns All key fields Columns of compatible types Columns of identical types.
Which form of services is responsible for defining and consuming semantically rich data models? ITe services Conditional services Modell-II services Core Data Services.
What are the Performance Rules and Guidelines for ABAP on SAP HANA? It is beneficial for maximizing your search into database It is beneficial to move data-intensive calculations into the database To Keep all the loads away from the DB To reduce main memory consumption and to improve insert performance.
The new bottlenecks avoided by addressing two challenges, what are they? Avoid CPU cache misses Avoid optimizing data Avoid single network Avoid idling CPU cores.
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? Write only Read-write Read only Read-update.
What are the two layers of ABAP system interacts with its database? The Client database interface The Database specific library The Database independent interface The Data Storage interface.
What all are the steps to perform -To enable type-ahead for an input field on a screen? Switch on proposal search for input fields Process on all the input fields Check Pre-Requisites Identify Elementary Search Help Automatic updates of all the input fields.
What is the main purpose of SAML for SAP HANA Studio? 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 HANA Studio The assertion is issued by a user after the client was successfully authenticated The SAP HANA database supports login of Owners only.
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 SAP HANA transport container
Select 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 HANA transport container Open the ABAP transport request
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.
What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? You need to refresh the content of the container manually Take snapshot manually before releasing of the container Automatic release of units Changes to Delta Container.
Hybrid Data Management System – Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system? Traditional disk-based tables Text indexing capabilities Linguistic search capabilities Text analysis and search Built-in support for planning.
You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? Set the visibility of the corresponding class method in the declaration section to PUBLIC. Implement the interface IF_AMDP_MARKER_HDB. Implement the ABAP AMDP_HDB Event Handler. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANA has to meet. What are these goals? Support for system tables High Performance and Scalability Hybrid data and management system Analytical DBMS features.
What should you do to follow the code-to-data approach to programming? Perform expensive calculations on the ABAP application server. Perform expensive calculations on the database. 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. Aggregate data on the database, and transfer the results to the ABAP layer.
What are the two main methods to add a system to the SAP HANA Studio? Manually By Importing a Landscape Automatically By Resource console.
DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? Column store Re-use component store ROW store Technology store Development Store.
|
