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 only Read-update Read-write. What all are the Types of Applications based on SAP HANA?
2 Innovation based on SAP HANA Server based on SAP HANA Data Mart based on SAP HANA New or Native SAP HANA. 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 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 Performance Rules and Guidelines for ABAP on SAP HANA?
2 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 It is beneficial for maximizing your search into database. 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 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. What are the different views provided by the ABAP Profiling?
2 A Hitlist of the most time-consuming programs or methods Database accesses Metadata accesses Performance Check methods. What all are the advantages provides by ABAP Development Tools?
3 An open platform for developing powerful database view A set of Eclipse data pool and Client- Open platform A brand new ABAP development experience on top of the Eclipse platform An open platform for developing new ABAP-related tools A set of open, language- and platform-independent APIs. What are the Guidelines for optimizing ABAP code running on HANA?
3 Open SQL settings Technical settings DB specific properties Column store High-speed data analysis. In which of the following situations could a row store table be more suitable than a column store table?
2 The table contains data that you want to aggregate. The table contains only a small number of records. The table contains mainly distinct values per column across rows. The table contains text that you want to search. What made SAP HANA possible?
2 CPU with single core network Improved hardware technology Technology and innovations RAM limitation. What are the Perspectives and Views of SAP HANA Studio?
2 Administration console System and Properties Open system properties Development properties. What are the benefits associated with The SAP HANA real-time Operational analytics?
2 High modeling flexibility Fast insights into business activity Query Speed support Simplification of massive data. What are the steps that supported several tools, which in total result in a Guided Performance Optimization?
2 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 A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption. The source code editor in ADT provides many helpful features. What are these helpful features?
2 Creating Method Implementations from the Method Definition Creating Method Definitions from Implementation Parts Creating Parts for Interface Methods Creating interface from Method Calls. Discuss the basic approach of classical ABAP programming?
2 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. What is the central goal of using SAP HANA?
1 Accelerate Performance To set Priorities for system Positive Impact on Business Monitor database for record keeping. Which code-to-data capability is responsible for the Optimizations & Translation of “Open SQL SELECT FOR ALL ENTRIES “clauses into native SQL?
Transparent Optimizations Database Optimization HANA Specific features Buffer system Optimization. What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling?
2 Costing-based Profitability Account-based Profitability Service-based profitability Product-based Profitability. An Analytic Privilege consists of several restrictions. What are they?
3 Analytic restrictions Cube restrictions Activity restrictions Validity restrictions View restrictions. What are the two main methods to add a system to the SAP HANA Studio?
2 By Resource console Automatically Manually By Importing a Landscape. How to create a core data services view?
3 Use the ABAP Development Tools for SAP NetWeaver. Use additional annotations – marked with the @ sign Use DDL statement DEFINE VIEW and SQL-like syntax to define the view Use data services tools for updates Use SQL capabilities for Netweaver. ABAP 7.4 provides support for optimizing ABAP applications running on SAP HANA. What are these Transparent Optimizations?
3 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 two layers of ABAP system interacts with its database?
2 The Database independent interface The Database specific library The Client database interface The Data Storage interface. What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA?
3 Detect Optimize Innovate Scaling Tuning. What all are the steps to perform -To enable type-ahead for an input field on a screen?
3 Check Pre-Requisites Identify Elementary Search Help Switch on proposal search for input fields Process on all the input fields Automatic updates of all the input fields. What is the main purpose of SAML for SAP HANA Studio?
1 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. Name the views that are available to administer and monitor one or several SAP HANA systems?
2 The Security view The Landscape view The Administration view The System Monitor view. What are the principles of Using HANA Transport Containers properly?
3 Automatic update for all export methods Takes a ‘snapshot’ of all SAP HANA objects of delivery unit Release of Transport request Import of Transport Request To create Transport container of delivery unit. DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types?
2 Column store Raw store Re-use component store Development Store Technology store. How will you hide the attributes that are not required for client consumption? 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.
|