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.
List down the four main concepts of the SAP HANA database?
There are 3 correct answers to this question Compression Tools combinations Partitioning Object store Column Store.
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.
What are the elements of ABAP Database Integration?
There are 3 correct answers to this question.
DB For ABAP Other DB Client database handling DB client-server Application server.
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.
What allows you to resolve errors quickly or warnings reported about the code?
Please choose the correct answer.
ABAP debugger Code execution Debug perspective Quick Fix.
Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”?
Choose the correct answer
Runtime monitor data Critical data table Performance data table Selection data table.
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.
Explain the Enterprise Information System of - SAP HANA Implementation Scenarios?
There are 3 correct answers to this question
All SAP applications on one SAP HANA platform HANA Accelerators Business Suite on HANA / BW on SAP HANA HANA Modeling All HANA Combinations on one platform.
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.
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 Point base ranking Weights for ranking Fuzzy search.
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 join conditions of the CDS view The extent to which records of the CDS view should be buffered on the application server.
What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA?
There are 3 correct answers to this question.
Detect Scaling Optimize Tuning Innovate.
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-write Read-update Read only.
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.
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 SQL units Interaction with Database.
What are the two different kinds of Identifiers used to represent names used in SQL statement?
There are 2 correct answers to this question
Delimited identifiers Undelimited Identifiers Numeric identifiers Limited identifiers.
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.
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.
freestyle search linguistic search Isolation search Fuzzy search ACID search.
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.
Which is the new concept that is introduced and improved by using SAP HANA Specific Features?
Please choose the correct answer.
ABAP-Managed Database Procedures Table buffering Programming model New advanced SQL syntax Procedures.
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.
How SAP HANA supports SQL?
There are 3 correct answers to this question.
Read As a means to define Manipulate data As a Data Calculator Transferring data.
Why is a security concept in SAP HANA required?
There are 2 correct answers to this question
Access to ERP tables must be restricted Editing of SAP HANA data models should only be possible for “Users.” of the model Need to have selected users in SAP HANA for Information Management Database administration should be restricted to skilled.
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.
List down the elements involved in User Management and Security in SAP HANA?
There are 3 correct answers to this question
Assign job security Work management Assign security Manage users Create users.
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.
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.
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 Database oriented programming model SAP HANA specific features New SQL parser used in model.
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.
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.
What are the different views provided by the ABAP Profiling?
There are 2 correct answers to this question
Metadata accesses A Hitlist of the most time-consuming programs or methods Database accesses Performance Check methods.
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 the benefits associated with The SAP HANA real-time Operational analytics?
There are 2 correct answers to this question
Fast insights into business activity High modeling flexibility Simplification of massive data Query Speed support.
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
Services-Name and index server on all nodes Active clusters for all servers Shared file systems for only one server High availability configuration.
When to use Enhanced Open SQL?
There are 2 correct answers to this question.
To view scalar components To access system fields Need the query in one piece of code only At the time of Dictionary Views.
What are the features associated with ABAP CDS?
There are 3 correct answers to this question.
Read Export Update Create Distribution.
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.
Hybrid data and management system High Performance and Scalability Support for system tables Analytical DBMS features.
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 } group by net_amount 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 } select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id.
Open SQL largely standardized, three sub-languages. What are these sub-languages?
There are 3 correct answers to this question
The Data Control Language (DCL) Data Evaluation Language(DEL) Data Transferring Language(DTL) The Data Definition Language (DDL) Data Manipulation Language (DML).
What are the benefits includes with SAP HANA Full Text Search?
There are 2 correct answers to this question
Exploit structured contents in SQL Large number of toolkits are available Fewer data duplication and movement Easy to use modeling tool.
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.
What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling?
There are 2 correct answers to this question
Product-based Profitability Costing-based Profitability Service-based profitability Account-based Profitability.
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 The same value as on a traditional, row-store only based database The same value as on a traditional, row-store only based database A lower value than on a traditional, row-store only based database.
How will you select a preference for Validation rules?
Choose the correct answer
Windows- SAP HANA-Preferences-Modeler-Validation Rules Windows- Preferences-SAP HANA-Modeler-Validation Rules Windows- SAP HANA-Modeler-Preferences-Validation Rules Windows- Modeler – Preferences-SAP HANA-Validation Rules.
What all are the factors involved in Working with ADT
There are 3 correct answers to this question.
ABAP Class ABAP interface Module interface Workbench programs ABAP programs.
What are the benefits of using the SQL Monitor (transaction SQLM)?
There are 2 correct answers to this question.
It schedules ABAP programs to monitor and log all database accesses. It displays the database execution plan for all SQL statements. It collects monitoring data asynchronously without additional database interaction. It can be active in a production system with minimal performance overhead.
What is an attribute view and what are its practices?
There are 3 correct answers to this question.
May contain filters Used in diagrammatic Projections Used to join tables May use in calculation views May contains flow charts.
What are the Functions of Transaction DBACOCKPIT
There are 2 correct answers to this question.
Maintain only HANA specific objects Used to access local or remote database system Maintain, Monitor and test secondary database connection Use Schema for the Connections.
What are the basic principles of ALV SAP HANA?
There are 2 correct answers to this question.
Data described declaratively instead of passing big internal tables Only retrieve the database data which is to be displayed on screen To ensure that the user chooses the data on the selection screen is displayed The ALV Optimization for SAP HANA to display data on the screen.
The source code editor in ADT provides many helpful features. What are these helpful features?
There are 2 correct answers to this question.
Creating interface from Method Calls Creating Method Definitions from Implementation Parts Creating Parts for Interface Methods Creating Method Implementations from the Method Definition.
What are the two types of editors available in ADT?
There are 2 correct answers to this question.
SAP (GUI) Client (native) ABAP (native) Eclipse (native).
What is the main function of Static Code Analysis?
Please choose the correct answer.
Integrated into ABAP Development Tools and ABAP Workbench Integrates with SAP Solution Manager To detect code that would lead to functional or performance issues When migrating to SAP HANA ABAP source code with performance optimization potential.
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.
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.
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.
What are the two main factors of SAP HANA Innovations and Challenges?
There are 2 correct answers to this question.
SAP BW innovations HW technology and innovations SAP SW technology and innovations DBMS technology and innovations.
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 views will be most efficient for General Modeling Principles?
There are 2 correct answers to this question
Schema view Analytical view Attribute view Column view.
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 Buffer system Optimization HANA Specific features Database Optimization.
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.
How to call the stored procedures in ABAP code?
Please choose the correct answer. Native SQL Only SQL Open SQL CDS view.
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 Monitor Administer Organizing Configure.
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 text that you want to search. 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.
What are the components of The Enterprise Procurement Model Demo Scenario?
There are 3 correct answers to this question. Stock Sales Services Procurement Product.
What all are the Types of Applications based on SAP HANA?
There are 2 correct answers to this question. Server based on SAP HANA Data Mart based on SAP HANA New or Native SAP HANA Innovation based on SAP HANA.
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 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 ABAP can run on SAP HANA Optimized ABAP on SAP HANA ABAP applications on SAP HANA.
What are the Guidelines for optimizing ABAP code running on HANA?
There are 3 correct answers to this question. Column store DB specific properties High-speed data analysis Technical settings Open SQL settings.
What all are the advantages provides by ABAP Development Tools?
There are 3 correct answers to this question. A brand new ABAP development experience on top of the Eclipse platform A set of open, language- and platform-independent APIs An open platform for developing powerful database view An open platform for developing new ABAP-related tools A set of Eclipse data pool and Client- Open platform.
What is the central goal of using SAP HANA?
Please choose the correct answer. To set Priorities for system Monitor database for record keeping Accelerate Performance Positive Impact on Business.
When are referential joins executed in analytical views?
Choose the correct answer When fields are selected When fields are optimized When fields from both the tables are requested When all the tables are optimized.
Discuss the basic approach of classical ABAP programming?
There are 2 correct answers to this question. Get all the data you need on the application server and do your processing in ABAP Creating and consuming all the contents from network Keep load from the database Collect all the data and perform Parallel processing in ABAP.
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.
What are the two layers of ABAP system interacts with its database?
There are 2 correct answers to this question. The Data Storage interface The Database specific library The Client database interface The Database independent interface.
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 Built-in support for planning Text indexing capabilities.
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. Development Store Column store Re-use component store Technology store Raw store.
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?
There are 2 correct answers to this question. Quickfix Content assistance Form-based class builder Screen editing.
Discuss the conditions required to ensure the Referential Integrity?
There are 2 correct answers to this question 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 There are two joins in the able.
Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP?
Choose the correct answer Swap axes Insert filter components Create Presentations Create data by members and tables.
ANSI SQL owns features and adds languages these languages divided into three parts. What are they?
There are 3 correct answers to this question. Data Manipulation Language The Data Control Language Data Transferred Language The Database Language The Data Definition Language.
Discuss the main capabilities of SAP BusinessObjects Analysis for Office?
There are 2 correct answers to this question Analyze data with the design panel Sort data by characteristics Convert crosstab cells to formula Suggests style sets for crosstabs.
Which is not a Golden Rule for Open SQL?
Please choose the correct answer. Reduce the Database Load Keep the result set large Minimize the Amount of Data Transferred Minimize the Number of Database Accesses.
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 are the features of New Open SQL?
There are 2 correct answers to this question. Supports conditional expressions Supports arithmetic and string expressions Supports specific units of database Supports Code adjustment model.
What are the uses of SQL Trace (ST05)?
There are 3 correct answers to this question. Display record of all database access Applying Code inspector Locate work base issues Locate database performance issues Detect redundant or identical select statements.
Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources?
Choose the correct answer Administration folder Content folder Security folder Provisioning folder.
|
