What output does The SAP HANA provide as a unique combination of hardware and software innovations?
1 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 AMDP application DATA Tables Huge potential to optimize business applications that are running on SAP HANA.
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 Services-Name and index server on all nodes Shared file systems for only one server High availability configuration.
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)?
1 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.
AMDP can detect 3 types of syntax errors in active or inactive source code. What are these errors ?
3 HANA specific syntax errors Database independent syntax errors UNION specific syntax errors SQLScript errors
Database platform syntax errors.
Explain Transitioning ABAP Code to SAP HANA – Performance Considerations?
2 Some codes transferred to other systems Classical performances recommendations for open SQL remain valid Some codes immediately run faster Some codes impacted positively and should be priorities Some shifts in priorities, examples, nested selects(higher) indices(lower).
SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANA has to meet. What are these goals?
2 High Performance and Scalability Analytical DBMS features Support for system tables Hybrid data and management system.
What are the steps involved in supporting a database oriented programming model?
2 Advanced and specific models Core Data services A new and advanced Open SQL Buffer system services.
What views will be most efficient for General Modeling Principles?
2 Schema view Analytical view Attribute view Column view.
What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container?
Take snapshot manually before releasing of the container Automatic release of units Changes to Delta Container You need to refresh the content of the container manually.
What are the benefits includes with SAP HANA Full Text Search?
Fewer data duplication and movement Easy to use modeling tool Exploit structured contents in SQL Large number of toolkits are available.
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?
1 :it_books it_books {it_books} @it_books.
What are the Functions of Transaction DBACOCKPIT
Used to access local or remote database system Use Schema for the Connections
Maintain, Monitor and test secondary database connection
Maintain only HANA specific objects.
What is the main function of Static Code Analysis?
To detect code that would lead to functional or performance issues When migrating to SAP HANA Integrated into ABAP Development Tools and ABAP Workbench ABAP source code with performance optimization potential Integrates with SAP Solution Manager.
What all are the factors involved in Working with ADT
3 ABAP interface ABAP Class Workbench programs Module interface ABAP programs.
Discuss different types of engines associated with The SAP HANA architecture?
2 Analytic engine OPAX engine OLAP engine Join engine.
What are the purposes of tools in SAP HANA system that is an Eclipsebased integrated development environment?
Organizing
Selecting
Administer Monitor Configure.
What are the two different kinds of Identifiers used to represent names used in SQL statement?
2 Undelimited Identifiers Delimited identifiers Numeric identifiers Limited identifiers.
What are the elements of ABAP Database Integration?
3 DB client-server Client database handling Application server DB For ABAP Other DB.
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.
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 WHERE condition. Use the CLIENT SPECIFIED addition. Include the client field in the join condition. Include the client field in the field list.
Which of the following tool is introduced as a holistic quality assurance tool?
ABAP Test Cockpit (ATC) DBMS Cockpit BW system DBA Cockpit.
What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment?
3 Selecting Administer Monitor Configure Organizing.
What should you do to follow the code-to-data approach to programming?
2 Transfer all data from the database to the ABAP layer, and then aggregate the results. Perform expensive calculations on the ABAP application server. Perform expensive calculations on the database. Aggregate data on the database, and transfer the results to the ABAP layer.
Which is the new concept that is introduced and improved by using SAP HANA Specific Features?
1 ABAP-Managed Database Procedures New advanced SQL syntax Procedures Programming model Table buffering.
Name some perspectives that are available in the SAP HANA Studio?
3 The Administration Console perspective The technology & innovation perspective The Information perspective The Resources perspective
The SAP HANA Modeler perspective.
What are the two main factors of SAP HANA Innovations and Challenges?
2 SAP BW innovations
SAP SW technology and innovations HW technology and innovations DBMS technology and innovations.
Discuss the main capabilities of SAP BusinessObjects Analysis for Office?
2 Suggests style sets for crosstabs Convert crosstab cells to formula Sort data by characteristics Analyze data with the design panel.
Hybrid Data Management System – Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system?
3 Built-in support for planning Traditional disk-based tables Linguistic search capabilities Text analysis and search Text indexing capabilities.
What are the ABAP development guidelines?
2 Improved tools for performance analysis Improved hybrid components for SAP HANA Consuming Only ABAP contents for SAP HANA Extensions to ABAP Language.
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?
1 Release resources Release packages Update packages Update resources.
What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA database?
.2 Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword The ABAP system checks the syntax of the Native SQL statements. The database independency of your report can be lost. Client handling needs to be done explicitely in the the Native SQL statement.
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 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. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB. Set the visibility of the corresponding class method in the declaration section to PUBLIC. Implement the ABAP AMDP_HDB Event Handler.
Explain how and when to create calculated columns - Using Graphical Modeling Tools?
3 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.
List down the four main concepts of the SAP HANA database?
3 Column Store Compression Partitioning Object store Tools combinations.
List down the elements involved in User Management and Security in SAP HANA?
3 Create users Assign security Manage users Assign job security Work management.
What are the Parameters for Analytical and Calculation view?
3 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 uses of SQL Trace (ST05)?
Locate work base issues Locate database performance issues Detect redundant or identical select statements Display record of all database access Applying Code inspector.
|
