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 Method Definitions from Implementation Parts Creating Parts for Interface Methods Creating interface from Method Calls. What are the ABAP development guidelines?
There are 2 correct answers to this question. Improved hybrid components for SAP HANA Consuming Only ABAP contents for SAP HANA Improved tools for performance analysis Extensions to ABAP Language. 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. 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 Transferring Language(DTL) Data Manipulation Language (DML) The Data Definition Language (DDL) The Data Control Language (DCL). 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. What made SAP HANA possible?
There are 2 correct answers to this question. CPU with single core network Improved hardware technology Technology and innovations RAM limitation. 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. Write only Read only Read-update Read-write. Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources?
Choose the correct answer Content folder Security folder Provisioning folder Administration folder. 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. 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. 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. What are the Guidelines for optimizing ABAP code running on HANA?
There are 3 correct answers to this question. Open SQL settings Technical settings DB specific properties Column store High-speed data analysis. Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)?
Please choose the correct answer. Create a graph comparing the runtimes of ABAP code before and after optimization. Combine information from static ABAP code scans with runtime data from the SQL Monitor. Combine information from static ABAP code scans with runtime data from the SQL Trace tool. Estimate the new total runtime of optimized code. How will you select a preference for Validation rules?
Choose the correct answer Windows- SAP HANA-Preferences-Modeler-Validation Rules Windows- Modeler – Preferences-SAP HANA-Validation Rules Windows- Preferences-SAP HANA-Modeler-Validation Rules Windows- SAP HANA-Modeler-Preferences-Validation Rules. 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. When are referential joins executed in analytical views?
Choose the correct answer When fields are selected When fields from both the tables are requested When fields are optimized When all the tables are optimized. What are the two main factors of SAP HANA Innovations and Challenges?
There are 2 correct answers to this question. HW technology and innovations SAP SW technology and innovations SAP BW innovations DBMS technology and innovations. 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 join conditions of the CDS view The name of the representation of the CDS view in the ABAP dictionary The client dependency of the CDS view The extent to which records of the CDS view should be buffered on the application server. List down the elements involved in User Management and Security in SAP HANA?
There are 3 correct answers to this question Create users Assign security Manage users Assign job security Work management. AMDP can detect 3 types of syntax errors in active or inactive source code. What are these errors?
There are 3 correct answers to this question. UNION specific syntax errors Database platform syntax errors Database independent syntax errors HANA specific syntax errors SQLScript errors. What are the steps involved in SAP HANA Evolution?
There are 3 correct answers to this question. ABAP can access SAP HANA ABAP can run on SAP HANA Optimized ABAP on SAP HANA ABAP applications on SAP HANA ABAP as accelerator on SAP HANA. Which of the following is not an element of Analytical view?
Please choose the correct answer. Join fact tables Read Data from the joined database tables Currency conversion is not applicable Used to Joined table. What are the Functions of Transaction DBACOCKPIT
There are 2 correct answers to this question. 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. How to create a core data services view?
There are 3 correct answers to this question. Use data services tools for updates Use the ABAP Development Tools for SAP NetWeaver Use DDL statement DEFINE VIEW and SQL-like syntax to define the view Use additional annotations – marked with the @ sign Use SQL capabilities for Netweaver. 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 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 features does the source code editor provide in ABAP Development Tools (ADT)?
There are 2 correct answers to this question. Screen Painter Quick Fix Content Assist Form-based Class Builder. 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?
There are 2 correct answers to this question. Database user – also different from your ABAP user Password for the database user By using SQL application By using Open Catalog look. 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. 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. Fuzzy search linguistic search freestyle search ACID search Isolation search. 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. What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment?
There are 3 correct answers to this question. Organizing Selecting Administer Monitor Configure. What are the Possible Approaches with AS ABAP < 7.4 SP02?
There are 2 correct answers to this question. Interaction with Database Stored Procedures Consume using native SQL SQL units. How to call the stored procedures in ABAP code?
Please choose the correct answer. Open SQL Native SQL Only SQL CDS view. 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. The new bottlenecks avoided by addressing two challenges, what are they?
There are 2 correct answers to this question. Avoid single network Avoid optimizing data Avoid CPU cache misses Avoid idling CPU cores. 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. 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. High Performance and Scalability Hybrid data and management system Support for system tables Analytical DBMS features. Which of the following tool is introduced as a holistic quality assurance tool?
Choose the correct answer DBMS Cockpit BW system ABAP Test Cockpit (ATC) DBA Cockpit. Discuss the main capabilities of SAP BusinessObjects Analysis for Office?
There are 2 correct answers to this question Suggests style sets for crosstabs Sort data by characteristics Analyze data with the design panel Convert crosstab cells to formula. Hybrid Data Management System – Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system?
There are 3 correct answers to this question. Traditional disk-based tables Text analysis and search Built-in support for planning Text indexing capabilities Linguistic search capabilities. Discuss different types of engines associated with The SAP HANA architecture?
There are 2 correct answers to this question Join engine OLAP engine Analytic engine OPAX engine. 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 do you understand by The SAP HANA Software Optimization?
Choose the correct answer Speed up the processing within the database Provide combinations of Objects and Partitioning Bring logic to where the data is calculated first, then only move to results Huge potential for hybrid database. What is the central goal of using SAP HANA?
Please choose the correct answer. Accelerate Performance To set Priorities for system Positive Impact on Business Monitor database for record keeping. What is an attribute view and what are its practices?
There are 3 correct answers to this question. Used in diagrammatic Projections Used to join tables May contain filters May use in calculation views May contains flow charts. What are the main points of SAP HANA High Availability PerDatacenter that are available even in the event of a disaster?
There are 2 correct answers to this question High availability configuration Services-Name and index server on all nodes Shared file systems for only one server Active clusters for all servers. When would you use a column store table instead of a row store table?
There are 2 correct answers to this question. When you require aggregation and analysis of values When there are mainly distinct values in the table When you want to enable a full-text search of the table When the table has a small number of records. If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. The following parameters are available?
There are 3 correct answers to this question Index search Freestyle search Fuzzy search Weights for ranking Point base ranking. 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. Discuss the conditions required to ensure the Referential Integrity?
There are 2 correct answers to this question There are two joins in the table There are three joins in the table There is at least one join in the other table Referential integrity holds true in both the directions. List down the four main concepts of the SAP HANA database?
There are 4 correct answers to this question Column Store Compression Partitioning Object store Tools combinations. 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. Which of the following are characteristics of an external view?
There are 3 correct answers to this question. It can be used as a data type in ABAP programs. It is an ABAP Dictionary object type. It allows access to an SAP HANA information view with Open SQL. It defines the underlying SAP HANA information view. It can be used in Open SQL statements for database updates. 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 benefits includes with SAP HANA Full Text Search?
There are 2 correct answers to this question Fewer data duplication and movement Easy to use modeling tool Exploit structured contents in SQL Large number of toolkits are available. 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?
Please choose the correct answer. 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 net_amount 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 benefits of using the SQL Monitor (transaction SQLM)?
There are 2 correct answers to this question. It collects monitoring data asynchronously without additional database interaction. 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. You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class?
Please choose the correct answer. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB. Implement the interface IF_AMDP_MARKER_HDB. Implement the ABAP AMDP_HDB Event Handler. Set the visibility of the corresponding class method in the declaration section to PUBLIC. 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. What are the benefits associated with The SAP HANA real-time Operational analytics?
There are 2 correct answers to this question High modeling flexibility Fast insights into business activity Query Speed support Simplification of massive data. What are the two main methods to add a system to the SAP HANA Studio?
There are 2 correct answers to this question Automatically Manually By Importing a Landscape By Resource console. How SAP HANA supports SQL?
There are 3 correct answers to this question As a Data Calculator As a means to define Read Manipulate data Transferring data. 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. System Perspective Modeler Perspective Open Content outlook Catalogue outlook. 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. 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 lower value than on a traditional, row-store only based database The same value as 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. What all are the Types of Applications based on SAP HANA?
There are 2 correct answers to this question. Innovation based on SAP HANA Server based on SAP HANA Data Mart based on SAP HANA New or Native SAP HANA. What is the main purpose of SAML for SAP HANA Studio?
Choose the correct answer 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 assertion is issued by a user after the client was successfully authenticated. Which of the following are performance recommendations when using SAP HANA?
There are 2 correct answers to this question. Define indexes on the columns that are used in calculations. 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. Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP?
Choose the correct answer Swap axes Create Presentations Insert filter components Create data by members and tables. What are the uses of SQL Trace (ST05)?
There are 3 correct answers to this question. Applying Code inspector Display record of all database access Detect redundant or identical select statements Locate database performance issues Locate work base issues. What are the features associated with ABAP CDS?
There are 3 correct answers to this question. Distribution Export Read Update Create. What is the Limitations of ALV for SAP HANA?
There are 3 correct answers to this question. Restricted to 5000 records / unit 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. What are the different views provided by the ABAP Profiling?
There are 2 correct answers to this question. A Hitlist of the most time-consuming programs or methods Database accesses Metadata accesses Performance Check methods. What are the two types of editors available in ADT?
There are 2 correct answers to this question. ABAP (native) Eclipse (native) SAP (GUI) Client (native). 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 When loading new data in the table, it gets appended to the existing data The application suggests the column name and data type for the new tables, and it is possible to edit them The supported file types for upload are: .cssv, .xlls, and .xlsxxx. What are the components of The Enterprise Procurement Model Demo Scenario?
There are 3 correct answers to this question. Sales Stock Procurement Product Services. Explain how and when to create calculated columns - Using Graphical Modeling Tools?
There are 3 correct answers to this question The calculation could be an arithmetic or character manipulation. Calculated columns also support non-measure attributes as part of the calculation. It is possible to nest so that one calculated column, in turn, is based on other calculated columns The calculation will be opened in a read-only mode Time characteristics based calculation columns. 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 are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container?
There are 2 correct answers to this question. Changes to Delta Container You need to refresh the content of the container manually Take snapshot manually before releasing of the container Automatic release of units. What are the features of New Open SQL?
There are 2 correct answers to this question. Supports arithmetic and string expressions Supports conditional expressions Supports Code adjustment model Supports specific units of database. 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?
Please choose the correct answer. SET_PARAM_TABLE GET_METADATA NEXT_PACKAGE SET_PARAM. 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.
|