What are the steps involved in SAP HANA Evolution?
There are 3 correct answers to this question. ABAP as accelerator on SAP HANA ABAP can access SAP HANA Optimized ABAP on SAP HANA ABAP applications on SAP HANA ABAP can run on SAP HANA.
What all are the factors involved in Working with ADT
There are 3 correct answers to this question.
ABAP Class Module interface ABAP interface ABAP programs Workbench programs.
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.
By using SQL application Password for the database user Database user – also different from your ABAP user By using Open Catalog look.
What are the features associated with ABAP CDS?
There are 3 correct answers to this question.
export create update read distribution.
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?
There are 2 correct answers to this question.
Exclude the ADDRESS field from the union Create an input parameter for the ADDRESS field Map the ADDRESS field to a constant value Create a restricted column for the ADDRESS field.
What are the steps involved in supporting a database oriented programming model?
There are 2 correct answers to this question.
A new and advanced Open SQL Advanced and specific models Buffer system services Core Data services.
You are debugging in ABAP Development Tools in Eclipse. What features are available?
There are 2 correct answers to this question.
Conditional breakpoints Watch points Memory usage analysis Debugger scripting.
What are the Parameters for Analytical and Calculation view?
There are 3 correct answers to this question.
To store data for critical analysis Specifying unit of measurement Create a copy of a report Setting a filter for columns Passing other values to be used in calculations.
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.
Discuss the main capabilities of SAP BusinessObjects Analysis for Office?
There are 2 correct answers to this question
Analyze data with the design panel Convert crosstab cells to formula Suggests style sets for crosstabs Sort data by characteristics.
You have created a CDS view and used aias names for some of its elements. In which of the following cases is the alias name mandatory?
There are 3 correct answers to this question.
ASSOCIATION TO sflight AS _flights CAST('USO' AS abap.cuky) AS currency_key crtdby AS created_by SUM(revenue) AS total_revenue CASE order type WHEN 'A' THEN 1 ELSE 0 END AS order_type.
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.
What should you search for and if necessary replace in the existing custom ABAP code?
There are 3 correct answers to this question.
Left outer joins in open SQL statements Code that relies on implicit database sorting Direct access to a cluster on the database Native SQL statements ORDER BY Clauses in Open SQL statements.
User STUDENT_A creates and activates a design-time object. In which schema is the runtime object generated? _SYS_ BI _SYS_ BIC STUDENT_A SYSTEM.
How SAP HANA supports SQL? As a means to define Manipulate data read As a Data Calculator Transferring data.
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 application suggests the column name and data type for the new tables, and it is possible to edit them When loading new data in the table, it gets appended to the existing data The supported file types for upload are: .cssv, .xlls, and .xlsxxx.
What should you do to follow the code-to-data approach to programming?
There are 3 correct answers to this question.
Perform expensive calculations on the ABAP application server. Transfer all data from the database to the ABAP layer, and then aggregate the results. Perform expensive calculations on the database. Use native SQL to access SAP HANA built-in functions. Aggregate data on the database, and transfer the results to the ABAP layer.
What are the ABAP development guidelines?
There are 2 correct answers to this question.
Consuming Only ABAP contents for SAP HANA Improved hybrid components for SAP HANA Improved tools for performance analysis Extensions to ABAP Language.
Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA?
Please choose the correct answer.
Parallel processing Columnar data storage Dictionary encoding Database table compression.
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 Modeler Perspective Catalogue outlook System Perspective.
What benefits does SAP HANA Data Compression provide?
There are 2 correct answers to this question.
Increased parallel processing Reduced memory consumption Optimized data partitioning Optimized access to column store tables.
You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement?
There are 2 correct answers to this question.
You have to use native SQL when reading data from the secondary DB. All tables and fields you are using must exist in the ABAP Dictionary of the Secondary DB. You have to specify the DB connection explicitly in your statement. You have to specify the DB schema explicity in your statement.
What are the components of The Enterprise Procurement Model Demo Scenario?
There are 3 correct answers to this question.
Service Product Procurement sales Stock.
You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data?
There are 3 correct answers to this question.
Specify the database schema if it is not the user's default schema Use the tilde symbol (~) to separate qualifier from column name Explicitly handle the client field Use the UP TO n ROWS addition Use a Comma-separated column list.
Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA), and NOT the SAP HANA Transport Container (HTC).
Why would you choose HTA?
There are 2 correct answers to this question.
Because you always transport entire SAP HANA content packages. Because you use the technique that is recommended by SAP. Because you can manually re-deploy objects after a failed import. Because you automatically add changed objects to the transport request.
What are the benefits associated with The SAP HANA real-time Operational analytics?
There are 2 correct answers to this question
Query Speed support High modeling flexibility Simplification of massive data Fast insights into business activity.
You analyze SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its data. But the relevant database access is NOT listed in SQLMD.
What could be the reason?
There are 3 correct answers to this question.
Database table Y is a buffered table. The data has NOT yet been transferred to the SQL Monitor database tables. SQL Monitor was activated with a fitter that excludes database table Y. SQL Monitor was activated for a specific application server. Program X was executed in the background.
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.
Isolation search Fuzzy search linguistic search ACID search freestyle search.
How to call the stored procedures in ABAP code?
Please choose the correct answer.
Native SQL Open SQL CDS view Only SQL.
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 field list. Use the CLIENT SPECIFIED addition Include the client field in the WHERE condition. Include the client field in the join condition.
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.
Selecting Organizing Administer Monitor Configure.
Which code-to-data capability supports- Extended view definitions and Better SQL- 92 standard support in open SQL?
Please choose the correct answer.
SAP HANA specific features Database oriented programming model New SQL parser used in model Database for sophisticated análisis.
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 Identify Elementary Search Help Check Pre-Requisites.
What is the purpose of an ABAP project in ABAP Development tools for eclipse?
There are 2 correct answers to this question.
It represents the connection to the SAP HANA server It represents the connection to an ABAP system It is used to transport ABAP repository objects. It provides access to all ABAP repository objects in an ABAP system.
Which is not a Golden Rule for Open SQL?
Please choose the correct answer.
Minimize the Number of Database Accesses Keep the result set large Minimize the Amount of Data Transferred Reduce the Database Load.
Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA?
There are 2 correct answers to this question.
Perform all calculations and aggregations in the ABAP layer Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES Use array variants of INSERT UPDATE MODIFY and DELETE.
When are referential joins executed in analytical views?
Choose the correct answer
When all the tables are optimized When fields are Selected When fields from both the tables are requested When fields are optimized.
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. Linguistic search capabilities Traditional disk-based tables Text analysis and search Text indexing capabilities Built-in support for planning.
What are some of the features available SAP List Viewer with integrated data access (SALV IDA)?
There are 3 correct answers to this question.
Display diagrams Edit cells Group rows Double-click on rows Search in content.
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.
Database independent syntax errors HANA specific syntax errors SQLScript errors UNION specific syntax errors Database platform syntax errors.
Explain the Enterprise Information System of - SAP HANA Implementation Scenarios?
There are 3 correct answers to this question
HANA Modeling HANA Accelerators All HANA Combinations on one platform All SAP applications on one SAP HANA platform Business Suite on HANA / BW on SAP HANA.
In an ABAP Core Data Services (CDS) view, what must you do to expose an association for use in another CDS view?
Please choose the correct answer.
Specify the other views in which the association can be used. Define the cardinality for the target entity. Include all fields used in the ON condition in the project on list. Specify an alias for the target entity.
What are the two types of editors available in ADT?
There are 2 correct answers to this question.
Client (native) ABAP (native) SAP (GUI) Eclipse (native).
List down the elements involved in User Management and Security in SAP HANA?
There are 3 correct answers to this question
Manage users Assign security Work management Create users Assign job security.
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?
Please choose the correct answer.
Code formatting options Statement template options Code completion options Editor shortcut key options.
What all are the advantages provides by ABAP Development Tools?
There are 3 correct answers to this question. An open platform for developing new ABAP-related tools A set of Eclipse data pool and Client- Open platform 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 powerful database view.
When would you use a column store table instead of a row store table?
There are 2 correct answers to this question.
When the table has a small number of records When there are mainly distinct values in the table When you require aggregation and analysis of values When you want to enable a full-text search of the table.
An Analytic Privilege consists of several restrictions. What are they?
There 3 correct answers to this question
Validity restrictions View restrictions Analytic restrictions Cube restrictions Activity restrictions.
Which of the following is a limitation when you create an external view?
Please choose the correct answer.
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. You must use the ABAP Development tools (ADT) TO CREATE the external view.
What are the supported joins in CDS view?
There are 2 correct answers to this question. Operators joint Inner join Left outer join Upper join.
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 Performance Check methods Metadata accesses.
Explain how and when to create calculated columns - Using Graphical Modeling Tools?
There are 3 correct answers to this question
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 Time characteristics based calculation columns The calculation could be an arithmetic or character manipulation. The calculation will be opened in a read-only mode
.
Which code-to-data capability supports- Extended view definitions and Better SQL- 92 standard support in open SQL?
Please choose the correct answer.
Database for sophisticated analysis SAP HANA specific features New SQL parser used in model Database oriented programming model.
Why is a security concept in SAP HANA required?
There are 2 correct answers to this question.
Editing of SAP HANA data models should only be possible for “Users.” of the model
Database administration should be restricted to skilled Need to have selected users in SAP HANA for Information Management Access to ERP tables must be restricted.
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.
By using Open Catalog look By using SQL application Database user – also different from your ABAP user Password for the database user.
What are the benefits associated with The SAP HANA real-time Operational analytics?
There are 2 correct answers to this question
Query Speed support Simplification of massive data High modeling flexibility Fast insights into business activity.
Which tasks does the ABAP managed database (AMDP) framework perform?
There are 2 correct answers to this question.
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 Create a new version of the database when the AMDP is first called.
What benefits does SAP HANA Data Compression provide?
There are 2 correct answers to this question.
Optimized data partitioning Increased parallel processing Reduced memory consumption Optimized access to column store tables.
Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)?
There are 3 correct answers to this question.
Returning Changing Receiving Exporting Importing.
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 packages Release resources Release packages Update resources
.
Which is the new concept that is introduced and improved by using SAP HANA Specific Features?
Please choose the corre ct answer.
ABAP-Managed Database Procedures Table buffering Programming model New advanced SQL syntax Procedures.
What is the central goal of using SAP HANA?
Please choose the correct answer. To set Priorities for system Accelerate Performance Positive Impact on Business Monitor database for record keeping.
You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger?
Please choose the correct answer.
Set a breakpoint in the ABAP program and execute the program Choose the Run --> Debug options in the menu Create a debug configuration for the ABAP application and run the program Choose the debug as option in the context menu of the ABAP program.
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?
Please choose the correct answer.
Missing ORDER BY or SORT after SELECT Use of Native SQL and DB Hints Direct access to Table Pools/Cluster Existence check for Secondary Indexes.
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?
Please choose the correct answer.
The net run time is less than the gross run time The gross and net run times are identical The net run time is greater than the gross run time The net run time is equal to Zero.
Discuss different types of engines associated with The SAP HANA architecture?
There are 2 correct answers to this question OLAP engine Join engine Analytic engine OPAX engine.
Which code-to-data capability is responsible for the Optimizations & Translation of “Open SQL SELECT FOR ALL ENTRIES “clauses into native SQL?
Please choose the correct answer.
Transparent Optimizations Database Optimization Buffer system Optimization HANA Specific features.
What allows you to resolve errors quickly or warnings reported about the code?
Please choose the correct answer.
Quick Fix Code execution ABAP debugger Debug perspective.
Which of the following tasks can you perform with SQL monitor (transaction SQLM)?
Response: Capture the SQL profile of an application Display the execution plan of an SQL statement Combine static and dynamic performance analysis results Search for problematic SELECT* statements.
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
Object-based database technology Column-based database technology Row-based database technology Value-based database technology Time-based database technology.
What are the principles of Using HANA Transport Containers properly?
There are 3 correct answers to this question. Takes a ‘snapshot’ of all SAP HANA objects of delivery unit Import of Transport Request Release of Transport request To create Transport container of delivery unit Automatic update for all export methods.
How to create a core data services view?
There are 3 correct answers to this question. Use data services tools for updates Use SQL capabilities for Netweaver Use additional annotations – marked with the @ sign Use the ABAP Development Tools for SAP NetWeaver. Use DDL statement DEFINE VIEW and SQL-like syntax to define the view.
You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause?
There are 3 correct answers to this question. SAP HANA views used in the procedure body CE function used in the procedure body ABAP Dictionary table used in the procedure body ABAP Dictionary views used in the procedure body AMDP used in the procedure body.
What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster?
There are 2 correct answers to this question Active clusters for all servers High availability configuration Services-Name and index server on all nodes Shared file systems for only one server.
What are the Possible Approaches with AS ABAP < 7.4 SP02?
There are 2 correct answers to this question. Stored Procedures Consume using native SQL Interaction with Database SQL units.
Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)?
There are 3 correct answers to this question. SQL monitor (transaction SQLM) Code inspector (transaction SCI) ABAP test cockpit (transaction ATC) SQL Trace (transaction ST05) Data base performance monitor (transaction DB50).
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 Security view The System Monitor view.
Which of the following features were added to the ABAP dictionary to support the SAP HANA database?
There are 3 correct answers to this question.
De-pooling and de-clustering Definition of full-text indexes Storage type for tables Definition of enhancement category Change of data class.
Which features does the source code editor provide in ABAP Development Tools (ADT)?
There are 2 correct answers to this question.
Form-based Class Builder Screen Painter Content Assist Quick Fix.
List down the four main concepts of the SAP HANA database?
There are 3 correct answers to this question Compression Partitioning Column Store Object store Tools combinations.
uestion:
What views will be most efficient for General Modeling Principles?
There are 2 correct answers to this question Attribute view Analytical view Column view Schema view.
What are the basic principles of ALV SAP HANA?
There are 2 correct answers to this question. Only retrieve the database data which is to be displayed on screen Data described declaratively instead of passing big internal tables 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.
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 extent to which records of the CDS view should be buffered on the application server The name of the representation of the CDS view in the ABAP dictionary The join conditions of the CDS view The logic for aggregations, grouping records, and filtering groups of the CDS view The client dependency of the CDS view
.
What output does The SAP HANA provide as a unique combination of hardware and software innovations?
Choose the correct answer 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 Huge potential to optimize business applications that are running on SAP HANA.
What are the two main factors of SAP HANA Innovations and Challenges?
There are 2 correct answers to this question.
Response:
HW technology and innovations SAP SW technology and innovations SAP BW innovations DBMS technology and innovations.
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)?
Please choose the correct answer. Combine information from static ABAP code scans with runtime data from the SQL Monitor. Create a graph comparing the runtimes of ABAP code before and after optimization. Estimate the new total runtime of optimized code. Combine information from static ABAP code scans with runtime data from the SQL Trace tool.
What are the two different kinds of Identifiers used to represent names used in SQL statement?
There are 2 correct answers to this question Undelimited Identifiers Delimited identifiers Numeric identifiers Limited identifiers.
What are the benefits includes with SAP HANA Full Text Search?
There are 2 correct answers to this question Easy to use modeling tool Fewer data duplication and movement Large number of toolkits are available Exploit structured contents in SQL.
What all are the Types of Applications based on SAP HANA?
There are 2 correct answers to this question. New or Native SAP HANA Data Mart based on SAP HANA Server based on SAP HANA Innovation based on SAP HANA.
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?
Please choose the correct answer. NEXT_PACKAGE EXECUTE_QUERY SET_PARAM_TABLE SET_PARAM.
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 A higher 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.
Explain The Authorization Concept and the types of privileges associated with it?
There are 3 correct answers to this question. Analytic privileges System privileges Object privileges Application privileges Delta privileges.
What benefits does SAP HANA Data Compression provide?
There are 2 correct answers to this question. Increased parallel processing Optimized data partitioning Optimized access to column store tables Reduced memory consumption.
Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA?
There are 2 correct answers to this question.
Partitioning Parallel processing Database table compression Columnar data storage.
You have created a CDS view as follows:
define view zha400 as select from spfli
association[*] to sflight as _flights
on spfli.carrid =_flights.carrid
and spfli.connid =_flights.connid
{…}
Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?
Please choose the correct answer.
carr id and _flights.planetype _flights.carrid and _flight.s .planetype _flights.carrid and planetype carrid and planetype.
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?
Please choose the correct answer.
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.
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?
Please choose the correct answer. Open the SAP HANA transport container
Select take snapshot and Save
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 Open the package
Select take snapshot and Save
Activate the SAP HANA Delivery unit
Activate the SAP HANA transport container.
You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL.
Which of the following are necessary adjustments?
There are 3 correct answers to this question. Replace ORDER BY additions. Specify the schema for every table. Replace UP TO n ROWS additions. Add explicit client handling. Replace CORRESPOND ING FIELDS additions.
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. The database independency of your report can be lost. Client handling needs to be done explicitely in the the Native SQL statement. 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 are the Functions of Transaction DBACOCKPIT
There are 2 correct answers to this question. Maintain, Monitor and test secondary database connection Use Schema for the Connections Maintain only HANA specific objects Used to access local or remote database system.
Which of the following are characteristics of an external view?
There are 3 correct answers to this question. It is an ABAP Dictionary object type. It allows access to an SAP HANA information view with Open SQL. It can be used as a data type in ABAP programs. It can be used in Open SQL statements for database updates. It defines the underlying SAP HANA information view.
What are the features of New Open SQL?
There are 2 correct answers to this question.
Supports Code adjustment model Supports specific units of database Supports arithmetic and string expressions Supports conditional expressions.
ANSI SQL owns features and adds languages these languages divided into three parts. What are they?
There are 3 correct answers to this question. The Data Control Language The Data Definition Language Data Manipulation Language Data Transferred Language The Database Language.
Which step of the Guided Performance Analysis should you perform in the product on system?
Please choose the correct answer
Collecting data with SQL Monitor (SQLM) Executing a check run with ABAP Test Cockpit (ATC) Building a work list with SQL Performance Tuning Work list (SWLT) Performing an inspection with Code Inspector (SCI)
.
What do you understand by The SAP HANA Software Optimization?
Choose the correct answer
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 Huge potential for hybrid database.
Which of the following tools and programming techniques use the SQL data definition language?
There are 2 correct answers to this question. Open SQL Core data services (CDS) data definition ABAP Dictionary Core data service (CDS) access control.
When to use Enhanced Open SQL?
There are 2 correct answers to this question. At the time of Dictionary Views To view scalar components To access system fields Need the query in one piece of code only
.
What are the Guidelines for optimizing ABAP code running on HANA?
There are 3 correct answers to this question. Open SQL settings High-speed data analysis Technical settings Column store DB specific properties.
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 .
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.
Which of the following tool is introduced as a holistic quality assurance tool?
Choose the correct answer
ABAP Test Cockpit (ATC) DBA Cockpit BW system DBMS Cockpit.
What are the elements of ABAP Database Integration?
There are 3 correct answers to this question. Application server DB For ABAP Other DB DB client-server Client database handling.
What are best practices when programming in ABAP for SAP HANA?
There are 2 correct answers to this question. Eliminate nested SELECT statements to reduce the overall number of database accesses Use a column list in the SELECT clause to ensure that you only read a column if it is really required Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required Calculate aggregations using ABAP code on the application server to limit database load.
How many result sets are returned when an SAP HANA database procedure is called using the CALL. WITH OVERVIEW statement?
Please choose the correct answer. One result set Two result sets
As many result sets as there are table output parameters in the procedure As many result sets as there are input parameters in the procedure.
What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)?
There are 2 correct answers to this question. All fields in the GROUP BY clause must be separated by commas. All ABAP variables must be escaped with a proceding @ sign. All arithmetic expressions can be used for all type of variables. All Keywords are case sensitive.
When using an SAP HANA full text search, what do you have to keep in mind?
Please choose the correct answer. The SCORE( ) function is required to ensure the best hits of your search appear on top. The LIKE operator is required in your SELECT statement to implement fuzzy logic. SAP HANA has to be the primary database to create a full text search. The full-text index is always updated asynchronously.
Which of the following is not an element of Analytical view?
Please choose the correct answer. Currency conversion is not applicable Join fact tables Read Data from the joined database tables Used to Joined table.
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.
Discuss the conditions required to ensure the Referential Integrity?
There are 2 correct answers to this question Referential integrity holds true in both the directions There is at least one join in the other table There are two joins in the able There are three joins in the table.
You are using ABAP Development Tools, and you have placed your cursor on a method name in a class. What key do you use to navigate between a method definition and its implementation?
Please choose the correct answer. F1 F2 F3 F4.
Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”?
Choose the correct answer Critical data table Runtime monitor data Performance data table Selection data table.
What are the two layers of ABAP system interacts with its database?
There are 2 correct answers to this question. The Database specific library The Database independent interface The Data Storage interface The Client database interface.
Which is not a key factor of ALV for HANA?
Please choose the correct answer. 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 To supply suitable values for any input parameters.
How will you select a preference for Validation rules?
Choose the correct answer Windows- Preferences-SAP HANA-Modeler-Validation Rules Windows- SAP HANA-Modeler-Preferences-Validation Rules Windows- Modeler – Preferences-SAP HANA-Validation Rules Windows- SAP HANA-Preferences-Modeler-Validation Rules.
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. A new tool called SQL Monitor to determine the priority if different programs access the database intensively Tools analyzing performance at run-time, to determine if critical constructs 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.
Discuss the basic approach of classical ABAP programming?
There are 2 correct answers to this question. 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 Creating and consuming all the contents from network.
In an ABAP Core Data Services (CDS) view, what must you do to expose an association for use in another CDS view?
Please choose the correct answer.
Response:
Include all fields used in the ON condition in the project on 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.
.
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 Development Store Technology store Re-use component store.
What is the Limitations of ALV for SAP HANA?
There are 3 correct answers to this question. Without currency /unit consideration Restricted to 10,000 records No unit/ currency split if aggregating amounts/ currency values Restricted to 5000 records / unit All unit/ currency restricted to 10,00,00 records.
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 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 100,000 records SELECT * statements on tables with more than a specified number of fields.
You implement an ABAP-managed database procedure (AMDP). Within this AMDP, you want to query data from calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb.
How can you address the calculation view?
There are 2 correct answers to this question. _SYS_ BIC."ha400.prirndb/CA_BOOKINGS_COUNT" "ha400.primdb::CA_BOOKINGS_COUNT" "ha400.pr mdb/CA_BOOKINGS_COUNT" _SYS_ BIC."ha400.primdb::CA_BOOKINGS_COUNT"
.
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?
There are 2 correct answers to this question.
Columns of compatible types The same number of columns All key fields Columns of identical types
.
Which data sources can you use for SAP list viewer with integrated data access?
There are 3 correct answers to this question. Database Table CDS View External view Database Procedure Internal table.
What are the Performance Rules and Guidelines for ABAP on SAP HANA?
There are 2 correct answers to this question. It is beneficial to move data-intensive calculations into the database To reduce main memory consumption and to improve insert performance It is beneficial for maximizing your search into database To Keep all the loads away from the DB.
Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP?
Choose the correct answer
Create data by members and tables Swap axes Create Presentations Insert filter components.
You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)?
There are 2 correct answers to this question. It supports exception handing. It supports where-usedlist. It supports locking and commit handling. It has syntax check at compile time.
What is an attribute view and what are its practices?
There are 3 correct answers to this question.
May contain filters May use in calculation views Used to join tables May contains flow charts Used in diagrammatic Projections.
What is the main function of Static Code Analysis?
Please choose the correct answer. To detect code that would lead to functional or performance issues When migrating to SAP HANA ABAP source code with performance optimization potential Integrated into ABAP Development Tools and ABAP Workbench Integrates with SAP Solution Manager.
Which of the following are view annotations for a CDS view?
There are 3 correct answers to this question.
Access control Buffering type Client handling Semantics Environment.
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 interface from Method Calls Creating Parts for Interface Methods.
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?
There are 3 correct answers to this question. A BADI definition A BADI fallback implementation AN enhancement spot A database procedure A BADI simple implementation.
You created and activated database procedure. How can you call this procedure?
There are 2 correct answers to this question. By a script-based calculation view By another database procedure By using Sap Analysis for Microsoft office By a core data services view.
Which data provisioning methods can you use when you need real time replications?
There are 2 correct answers to this question. SAP Landscape transformation Replication server (SAP SLT) SAP Replication server SAP HANA Direct extractor connection (SAP DXC) SAP Data services.
You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias?
There are 3 correct answers to this question.
Currency Conversion Unit conversion CASE expression CASTE Expression Nested CASE expression.
You import an ABAP workbench request into an 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?
There are 2 correct answers to this question. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK SYSTEM P81 has SAP HANA as primary database View CA_CUSTOMER has deployment mode A. PACKAGE ZHA400_00 HAS deployment Mode A.
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. Combine the results of the SQL Monitor with the results of a static source code analysis. Activate the new SQL Monitor in a productive system. 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 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.
What are the uses of SQL Trace (ST05)?
There are 3 correct answers to this question.
Locate database performance issues Detect redundant or identical select statements Display record of all database access Locate work base issues Applying Code inspector.
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. Define indexes on the columns that are used in calculations. Move data-intensive calculations from the database to an application server.
Which task does the ABAP Managed Database Procedure (AMDP) framework perform?
Please choose the correct answer.
Response:
Deploy a new version of the database procedure when the AMDP is first called. Deploy the database procedure whenever the AMDP is activated. Deploy the database procedure when the AMDP is first activated. Deploy the database procedure whenever the AMDP is called.
Which of the following is not an element of Analytical view?
Please choose the correct answer.
Currency conversion is not applicable Read Data from the joined database tables Join fact tables Used to Joined table
.
Which of the Golden Rules for Open SQL Performance have become more important with SAP HANA?
There are 2 correct answers to this question.
Minimize the number of database accesses. Minimize the amount of transferred data. Minimize the search overhead. Keep unnecessary load away from the database.
Open SQL largely standardized, three sub-languages. What are these sub-languages?
There are 3 correct answers to this question Data Transferring Language(DTL) The Data Control Language (DCL) Data Evaluation Language(DEL) Data Manipulation Language (DML) The Data Definition Language (DDL)
.
Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources?
Choose the correct answer
Provisioning folder Content folder Administration folder Security folder.
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 assertion is issued by a user after the client was successfully authenticated 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.
What are the two main methods to add a system to the SAP HANA Studio?
There are 2 correct answers to this question By Importing a Landscape Manually By Resource console Automatically.
In which of the following situations could a row store table be more suitable than a column store table?
There are 2 correct answers to this question.
The table contains mainly distinct values per column across rows. The table contains only a small number of records. The table contains data that you want to aggregate. The table contains text that you want to search.
|
