hana Full V1

What are the key points that should be kept in mind while performing theNonautomatic update in SAP HANA Transport Container? There are 2 correct answers to this question. Take snapshot manually before releasing of the container. You need to refresh the content of the container manually. Changes to Delta Container. Automatic release of units.

You define and implement an ABAP Managed database procedure (AMDP). Whatdo you have to list after the USING clause? There are 3 correct answers to this question. ABAP Dictionary views used in the procedure body. SAP HANA views used in the procedure body. CE function used in the procedure body. AMDP used in the procedure body. ABAP Dictionary table used in the procedure body.

What are the two main methods to add a system to the SAP HANAStudio? There are 2 correct answers to this question. Automatically. Manually. By Importing a Landscape. By Resource console.

How will you select a preference for Validation rules? Choose the correct answer. Windows- Modeler – Preferences-SAP HANA-Validation Rules. Windows- Preferences-SAP HANA-Modeler-Validation Rules. Windows- SAP HANA-Preferences-Modeler-Validation Rules. Windows- SAP HANA-Modeler-Preferences-Validation Rules.

In which of the following situations could a row store table be more suitablethan a column store table? There are 2 correct answers to this question. The table contains only a small number of records. The table contains mainly distinct values per column across rows. The table contains text that you want to search. The table contains data that you want to aggregate.

Your development team needs to include SAP HANA objects into an ABAPworkbench request. You want to use SAP HANA Transport for ABAP (HTA), andNOT the SAP HANA Transport Container (HTC). Why would you choose HTA? There are 2 correct answers to this question. Because you can manually re-deploy objects after a failed import. Because you use the technique that is recommended by SAP. Because you automatically add changed objects to the transport request. Because you always transport entire SAP HANA content packages.

You use native SQL to access the SAP HANA database. What should you do toretrieve the correct data? There are 3 correct answers to this question. Explicitly handle the client field. Specify the database schema if it is not the user's default schema. Use a Comma-separated column list. Use the UP TO n ROWS addition. Use the tilde symbol (~) to separate qualifier from column name.

Which of the following objects can you use in the ABAP layer when using thetop-down approach to bring code to data? There are 2 correct answers to this question. Stored procedures. Core data services views. ABAP managed database procedures. Calculation views.

When using an SAP HANA full text search, what do you have to keep in mind? Please choose the correct answer. 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. The SCORE( ) function is required to ensure the best hits of your search appear ontop.

What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question. Calculate aggregations using ABAP code on the application server to limit databaseload. Use a column list in the SELECT clause to ensure that you only read a column if it isreally required. Use repeated SELECT SINGLE statements to ensure that you only read arrow if it isreally required. Eliminate nested SELECT statements to reduce the overall number of databaseaccesses.

You implement an ABAP-managed database procedure (AMDP). Within thisAMDP, you want to query data from calculation view CA_BOOKINGS_COUNT inSAP HANA content package ha400.primdb. How can you address the calculation view? There are 2 correct answers to this question. "ha400.pr mdb/CA_BOOKINGS_COUNT". "ha400.primdb::CA_BOOKINGS_COUNT". _SYS_ BIC."ha400.prirndb/CA_BOOKINGS_COUNT". _SYS_ BIC."ha400.primdb::CA_BOOKINGS_COUNT".

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. Need to have selected users in SAP HANA for Information Management. Access to ERP tables must be restricted. Database administration should be restricted to skilled.

When to use Enhanced Open SQL? There are 2 correct answers to this question. To view scalar components. Need the query in one piece of code only. To access system fields. At the time of Dictionary Views.

What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question. Schema view. Attribute view. Analytical view. Column view.

To connect with the SAP HANA system and see the correspondingcatalog content etc., use the Systems view. How will you add a system to thisview? 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.

One of your SAP systems needs to be migrated from its current database to anSAP 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 ABAPcode? There are 3 correct answers to this question. ORDER BY Clauses in Open SQL statements. 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.

When using ABAP Database Connectivity (ADBC) to issue native SQL calls to thedatabase, which of the following methods of class CL_SQL_RESULT_SETretrieves the tabular result of the native SQL call? Please choose the correct answer. NEXT_PACKAGE. SET_PARAM_TABLE. GET_METADATA. SET_PARAM.

You import an ABAP workbench request into an SAP SYSTEM P81.The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMERthat belongs to package ZHA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAPHANA view onto the database? There are 2 correct answers to this question. View CA_CUSTOMER has deployment mode A. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK. SYSTEM P81 has SAP HANA as primary database. PACKAGE ZHA400_00 HAS deployment Mode A.

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 join conditions of the CDS view. The logic for aggregations, grouping records, and filtering groups of the CDS view. The name of the representation of the CDS view in the ABAP dictionary. The client dependency of the CDS view. The extent to which records of the CDS view should be buffered on the applicationserver.

What are the Parameters for Analytical and Calculation view? There are 3 correct answers to this question. Passing other values to be used in calculations. Setting a filter for columns. To store data for critical analysis. Specifying unit of measurement. Create a copy of a report.

What all are the factors involved in Working with ADT There are 3 correct answers to this question. Workbench programs. ABAP Class. ABAP interface. ABAP programs. Module interface.

What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question. Innovation based on SAP HANA. New or Native SAP HANA. Server based on SAP HANA. Data Mart based on SAP HANA.

The SAP HANA database is a hybrid in-memory database that combines Fewtechnologies within. What are these technologies? There are 3 correct answers to this question. Object-based database technology. Value-based database technology. Row-based database technology. Time-based database technology. Column-based database technology.

Which code-to-data capability is responsible for the Optimizations & Translationof “Open SQL SELECT FOR ALL ENTRIES “clauses into native SQL? Please choose the correct answer. HANA Specific features. Buffer system Optimization. Transparent Optimizations. Database Optimization.

Which of the following categories of parameters can you use in the definition ofan ABAP manage database procedure (AMDP)? There are 3 correct answers to this question. Returning. Exporting. Receiving. Importing. Changing.

What are the elements of ABAP Database Integration? There are 3 correct answers to this question. Application server. Other DB. DB client-server. DB For ABAP. Client database handling.

What are the steps that supported several tools, which in total result in a GuidedPerformance Optimization? There are 2 correct answers to this question. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compareruntime consumption. A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potentialfunctional and performance issues. A new tool called SQL Monitor to determine the priority if different programs accessthe database intensively. Tools analyzing performance at run-time, to determine if critical constructs.

You are using ABAP Development Tools, and you have placed your cursor on amethod name in a class. What key do you use to navigate between a methoddefinition and its implementation? Please choose the correct answer. F1. F2. F3. F4.

What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question. An open platform for developing powerful database view. A set of Eclipse data pool and Client- Open platform. A brand new ABAP development experience on top of the Eclipse platform. An open platform for developing new ABAP-related tools. A set of open, language- and platform-independent APIs.

If the Search Options are enabled, you can set the Search Parameters for anattribute of a view. The following parameters are available? There are 3 correct answers to this question. Weights for ranking. Freestyle search. Point base ranking. Index search. Fuzzy search.

What are the three best approach for Transitioning and optimizing ABAPapplications to SAP HANA? There are 3 correct answers to this question. Scaling. Optimize. Tuning. Innovate. Detect.

Which of the following option provides access to the views anddatabase procedures that you can consume in the ABAP environment? Please choose the correct answer. System Perspective. Modeler Perspective. Open Content outlook. Catalogue outlook.

An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question. Cube restrictions. View restrictions. Validity restrictions. Activity restrictions. Analytic restrictions.

List down the four main concepts of the SAP HANA database? There are 3 correct answers to this question. Partitioning. Compression. Tools combinations. Column Store. Object store.

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 SQLMonitor. Combine information from static ABAP code scans with runtime data from the SQLTrace tool. Estimate the new total runtime of optimized code.

The new bottlenecks avoided by addressing two challenges, whatare they? There are 2 correct answers to this question. Avoid single network. Avoid optimizing data. Avoid CPU cache misses. Avoid idling CPU cores.

What are the different views provided by the ABAP Profiling? There are 2 correct answers to this question. Performance Check methods. Metadata accesses. Database accesses. A Hitlist of the most time-consuming programs or methods.

When are referential joins executed in analytical views? Choose the correct answer. When fields are selected. When fields from both the tables are requested. When fields are optimized. When all the tables are optimized.

What is an attribute view and what are its practices? There are 3 correct answers to this question. May contains flow charts. May contain filters. Used to join tables. Used in diagrammatic Projections. May use in calculation views.

ABAP 7.4 provides support for optimizing ABAP applications running on SAPHANA. What are these Transparent Optimizations?. Performance analysis tools have been improved. The consumption of SAP HANA artifacts was simplified. Do all the data processing in Application server. The ABAP language and the OpenSQL language have been extended. Re- use components have been extended or optimized for SAP HANA.