E_HANAAW_12

INFO
STADISTICS
RECORDS
Title of test:
E_HANAAW_12

Description:
ABAP for SAP HANA

Author:
ABAP_HANA
(Other tests from this author)

Creation Date:
05/04/2018

Category:
Others
Click 'LIKE' to follow the bests test of daypo at facebook
Last comments
No comments about this test.
Content:
Name the views that are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question The Landscape view The Administration view The System Monitor view The Security view.
Your customer wants to migrate to SAP HANA and you want to identify which business processes should be optimized. Which of the following steps must you perform to get this information? There are 2 correct answers to this question 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 Activate the new SQL Monitor in a development system.
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. Implement the ABAP AMDP_HDB Event Handler. Implement the interface IF_AMDP_MARKER_HDB. Set the visibility of the corresponding class method in the declaration section to PUBLIC. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
Name some perspectives that are available in the SAP HANA Studio? There are 3 correct answers to this question The Information perspective The SAP HANA Modeler perspective The Resources perspective The technology & innovation perspective The Administration Console perspective.
What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA database? There are 2 correct answers to this question. Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword. Client handling needs to be done explicitely in the the Native SQL statement. The ABAP system checks the syntax of the Native SQL statements. The database independency of your report can be lost.
Explain how and when to create calculated columns - Using Graphical Modeling Tools? There are 3 correct answers to this question Time characteristics based calculation columns The calculation will be opened in a read-only mode The calculation could be an arithmetic or character manipulation. It is possible to nest so that one calculated column, in turn, is based on other calculated columns Calculated columns also support non-measure attributes as part of the calculation.
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? Please choose the correct answer. Update resources Update packages Release packages Release resources.
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 Row-based database technology Time-based database technology Column-based database technology Object-based database technology.
What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question Core Data services A new and advanced Open SQL Advanced and specific models Buffer system services.
What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question Manually Automatically By Importing a Landscape By Resource console.
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. Performance analysis tools have been improved The ABAP language and the OpenSQL language have been extended Do all the data processing in Application server The consumption of SAP HANA artifacts was simplified Re- use components have been extended or optimized for SAP HANA.
What is the Limitations of ALV for SAP HANA? There are 3 correct answers to this question Restricted to 5000 records / unit No unit/ currency split if aggregating amounts/ currency values Without currency /unit consideration Restricted to 10,000 records All unit/ currency restricted to 10,00,00 records.
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 name of the representation of the CDS view in the ABAP dictionary The client dependency of the CDS view The logic for aggregations, grouping records, and filtering groups of the CDS view The extent to which records of the CDS view should be buffered on the application server The join conditions of the CDS view.
Explain The Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question Object privileges Analytic privileges System privileges Delta privileges Application privileges.
To upload data from flat files, SAP HANA offers several features. What are these important features? There are 2 correct answers to this question The new table always has a 2:2 mapping between the file and table columns The supported file types for upload are: .cssv, .xlls, and .xlsxxx 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 steps that supported several tools, which in total result in a Guided Performance Optimization? There are 2 correct answers to this question. 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 A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.
What are the ABAP development guidelines? There are 2 correct answers to this question. Consuming Only ABAP contents for SAP HANA Extensions to ABAP Language Improved tools for performance analysis Improved hybrid components for SAP HANA.
Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question Analytic engine Join engine OLAP engine OPAX engine.
What are the supported joins in CDS view? There are 2 correct answers to this question. Left outer join Upper join Operators joint Inner join.
What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question. Release of Transport request Import of Transport Request Takes a ‘snapshot’ of all SAP HANA objects of delivery unit Automatic update for all export methods To create Transport container of delivery unit.
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. Use the CLIENT SPECIFIED addition. Include the client field in the WHERE condition. Include the client field in the field list. Include the client field in the join condition.
What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to this question. It is beneficial for maximizing your search into database To reduce main memory consumption and to improve insert performance To Keep all the loads away from the DB It is beneficial to move data-intensive calculations into the database.
An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question Cube restrictions Validity restrictions Analytic restrictions View restrictions Activity restrictions.
What are the Parameters for Analytical and Calculation view? There are 3 correct answers to this question. Specifying unit of measurement Create a copy of a report To store data for critical analysis Passing other values to be used in calculations Setting a filter for columns.
Which is not a key factor of ALV for HANA? Please choose the correct answer. To supply suitable values for any input parameters To Activate and execute the program in the application The data display is restricted to a maximum of 2 billion cells Derived Column headings from the data element.
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 defines the underlying SAP HANA information view It can be used in Open SQL statements for database updates It allows access to an SAP HANA information view with Open SQL It is an ABAP Dictionary object type.
Which of the following tool is introduced as a holistic quality assurance tool? Choose the correct answer DBMS Cockpit DBA Cockpit ABAP Test Cockpit (ATC) BW system.
What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question. Open system properties Development properties Administration console System and Properties.
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. Automatic release of units You need to refresh the content of the container manually Take snapshot manually before releasing of the container Changes to Delta Container.
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 deletes obsolete versions of the database procedure synchronously. It creates the database procedure when the AMDP is first called It creates the database procedure when the AMDP is first activated.
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 SET_PARAM NEXT_PACKAGE.
How to create a core data services view? There are 3 correct answers to this question. Use additional annotations – marked with the @ sign Use SQL capabilities for Netweaver Use the ABAP Development Tools for SAP NetWeaver Use data services tools for updates Use DDL statement DEFINE VIEW and SQL-like syntax to define the 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 value that you calculate based on the number of tables A value that you calculate based on the number of tables A higher value than on a traditional, row-store only based database A lower value than on a traditional, row-store only based database.
What do you understand by The SAP HANA Software Optimization? Choose the correct answer Huge potential for hybrid database Bring logic to where the data is calculated first, then only move to results Provide combinations of Objects and Partitioning Speed up the processing within the database.
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 Trace tool. Estimate the new total runtime of optimized code. Combine information from static ABAP code scans with runtime data from the SQL Monitor.
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. SQLScript errors Database platform syntax errors HANA specific syntax errors UNION specific syntax errors Database independent syntax errors.
Explain Transitioning ABAP Code to SAP HANA – Performance Considerations? There are 3 correct answers to this question Some codes transferred to other systems Classical performances recommendations for open SQL remain valid Some codes impacted positively and should be priorities Some shifts in priorities, examples, nested selects(higher) indices(lower) Some codes immediately run faster.
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.
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 Used to Joined table Currency conversion is not applicable.
Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question. Avoid transferring large result sets between database and client applications. Filter data in lower layers. Move data-intensive calculations from the database to an application server. Define indexes on the columns that are used in calculations.
What output does The SAP HANA provide as a unique combination of hardware and software innovations? Choose the correct answer Huge potential to optimize business applications that are running on SAP HANA The ability to create new complex processes with ABAP application cloud Huge potential to maximize the number of disk blocks in the application Huge potential to optimize AMDP application DATA Tables.
You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statements check. What does this check report? Please choose the correct answer. SELECT * statements on tables with the Column Store storage type SELECT * statements on tables with more than a specified number of fields SELECT * statements on tables with more than 100,000 records SELECT * statements where fewer than a specified percentage of all fields are effectively used.
What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer 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 To support scenarios where clients are not directly connected to the SAP HANA Database The assertion is issued by a user after the client was successfully authenticated.
Which form of services is responsible for defining and consuming semantically rich data models? Please choose the correct answer. Core Data Services ITe services Modell-II services Conditional services.
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 Open Content outlook System Perspective Modeler Perspective Catalogue outlook.
What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question. Automatic updates of all the input fields Process on all the input fields Switch on proposal search for input fields Check Pre-Requisites Identify Elementary Search Help.
What made SAP HANA possible? There are 2 correct answers to this question Improved hardware technology RAM limitation CPU with single core network Technology and innovations.
Report abuse Terms of use
We use cookies to personalize your experience. If you continue browsing you will be accepting its use. More information.