E-HANAAW-16

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. Database Optimization. Buffer system Optimization. HANA Specific features. Transparent Optimizations.

How SAP HANA supports SQL? There are 3 correct answers to this question. As a means to define. Transferring data. Read. Manipulate Data. As a Data Calculator.

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. High availability configuration. Active clusters for all servers. Services-Name and index server on all nodes. Shared file systems for only one server.

Which form of services is responsible for defining and consuming semantically rich data models? Please choose the correct answer. ITe services. Core Data Services. Conditional services. Modell-II services.

Which of the following feature 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 an enhancement category. Definition of full-text indexes. Changes of data class. Storage type for tables.

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 development system. Combine the results of the SQL Monitor with the results of an ABAP runtime analysis. 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.

To upload data from flat files, SAP HANA offers several features. What are these important features? There are 2 correct answers to this question. The new table always has a 2:2 mapping between the file and table columns. The supported file types for upload are: .cssv, .xlls, and .xlsxxx. When loading new data in the table, it gets appended to the existing data. The application suggests the column name and data type for the new tables, and it is possible to edit them.

What are the steps involved in SAP HANA Evolution? There are 3 correct answers to this question. ABAP can run on SAP HANA. ABAP can access SAP HANA. Optimized ABAP on SAP HANA. ABAP as accelerator on SAP HANA. ABAP applications on SAP HANA.

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. CE functions used in the procedure body. ABAP Dictionary tables used in the procedure body. SAP HANA views used in the procedure body. AMDPs used in the procedure body. ABAP Dictionary views used in the procedure body.

Name some perspectives that are available in the SAP HANA Studio? There are 3 correct answers to this question. The Administration Console perspective. The Resources perspective. The Information perspective. The SAP HANA Modeler perspective. The technology & innovation perspective.

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

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 automatically add changed objects to the transport request. Because you can manually re-deploy objects after a failed import. Because you use the technique that is recommended by SAP. Because you always transport entire SAP HANA content packages.

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 locking and commit handling. It has syntax check at compile time. It supports where-usedlist. It supports exception handing.

What made SAP HANA possible? There are 2 correct answers to this question. CPU with single core network. RAM limitation. Technology and innovations. Improved hardware technology.

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 database load. Use a column list in the SELECT clause to ensure that you only read a column if it is really required. Eliminate nested SELECT statements to reduce the overall number of database accesses. Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required.

You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer. 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. Set a breakpoint in the ABAP program and execute the program.

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. Update resources. Release resources. Release packages.

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 HAS deployment Mode A. 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.

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 client dependency of the CDS view. The name of the representation of the CDS view in the ABAP dictionary. The extent to which records of the CDS view should be buffered on the application server.

How to call the stored procedures in ABAP code? Please choose the correct answer. Only SQL. Open SQL. Native SQL. CDS View.

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

What is the purpose of an ABAP project in ABAP Development tools for eclipse? There are 2 correct answers to this question. It is used to transport ABAP repository objects. It provides access to all ABAP repository objects in an ABAP system. It represents the connection to the SAP HANA server. It represents the connection to an ABAP system.

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 Data services. SAP Replication server. SAP HANA Direct extractor connection (SAP DXC).

You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node (IMG1): What does the result of the aggregation look like? (IMG 2) Please choose the correct answer. Option C. Option D. Option A. Option B.

Which is not a key factor of ALV for HANA? Please choose the correct answer. Derived Column headings from the data element. The data display is restricted to a maximum of 2 billion cells. To Activate and execute the program in the application. To supply suitable values for any input parameters.

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.

Which of the following tasks can you perform with SQL monitor (transaction SQLM)?. Capture the SQL profile of an application. Search for problematic SELECT* statements. Combine static and dynamic performance analysis results. Display the execution plan of an SQL statement.

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. Weights for ranking. Freestyle search. Point base ranking. Fuzzy search. Index search.

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. SET_PARAM. NEXT_PACKAGE. GET_METADATA.

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

What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question. Used to access local or remote database system. Maintain, Monitor and test secondary database connection. Use Schema for the Connections. Maintain only HANA specific objects.

You made changes to an object (X) used by an ABAP managed database procedure (AMDP). You did NOT changes the AMDP itself. Now you execute a program that calls this AMDP. In which cases does the call trigger the creation of the database procedure in SAP HANA? There are 2 correct answers to this question. X is an SAP HANA view. X is a stored procedure. X is an ABAP Dictionary table. X is an AMDP method.

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. Statement template options. Code formatting options. Editor shortcut key options. Code completion options.

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 indexing capabilities. Built-in support for planning. Text analysis and search.

What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question. Sales. Stock. Procurement. Services. Product.

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.

Which of the following are view annotations for a CDS view? There are 3 correct answers to this question. Buffering type. Client handling. Semantics. Environment. Access control.

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. Configure. Organizing. Administer. Monitor. Selecting.

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement. Perform all calculations and aggregations in the ABAP layer. Use array variants of INSERT UPDATE MODIFY and DELETE.

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. Include all fields used in the ON condition in the project on list. Specify the other views in which the association can be used. Define the cardinality for the target entity. Specify an alias for the target entity.

Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? There are 2 correct answers to this question. Configuration of check variants. Enhanced distribution of results. Flexible schedule of check runs. Documented checks.

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 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 Keywords are case sensitive. All ABAP variables must be escaped with a proceding @ sign. All fields in the GROUP BY clause must be separated by commas. All arithmetic expressions can be used for all type of variables.

What are the features of New Open SQL? There are 2 correct answers to this question. Supports arithmetic and string expressions. Supports conditional expressions. Supports specific units of database. Supports Code adjustment model.

What is the Limitations of ALV for SAP HANA? There are 3 correct answers to this question. Restricted to 5000 records / unit. Restricted to 10,000 records. No unit/ currency split if aggregating amounts/ currency values. without currency /unit consideration. All unit/ currency restricted to 10,00,00 records.

What are the basic principles of ALV SAP HANA? There are 2 correct answers to this question. To ensure that the user chooses the data on the selection screen is displayed. Only retrieve the database data which is to be displayed on screen. The ALV Optimization for SAP HANA to display data on the screen. Data described declaratively instead of passing big internal tables.

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.primdb::CA_BOOKINGS_COUNT". _SYS_ BIC."ha400.prirndb/CA_BOOKINGS_COUNT". "ha400.pr mdb/CA_BOOKINGS_COUNT". "ha400.primdb::CA_BOOKINGS_COUNT".

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. Huge potential for hybrid database. Speed up the processing within the database.

What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer. 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 authenticate. The SAP HANA database supports login of Owners only.

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. Code that relies on implicit database sorting. Direct access to a cluster on the database. Left outer joins in open SQL statements. Native SQL statements. ORDER BY Clauses in Open SQL statements.

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 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.

Name some perspectives that are available in the SAP HANA Studio? There are 3 correct answers to this question. The Information perspective. The technology & innovation perspective. The Administration Console perspective. The Resources perspective. The SAP HANA Modeler perspective.

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). Performing an inspection with Code Inspector (SCI). Building a work list with SQL Performance Tuning Work list (SWLT). Executing a check run with ABAP Test Cockpit (ATC).

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 three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers to this question. Tuning. Detect. Innovate. Scaling. Optimize.

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. Analytical DBMS features. High Performance and Scalability. Support for system tables. Hybrid data and management system.

What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer. Code execution. Quick Fix. ABAP debugger. Debug perspective.

What benefits does SAP HANA Data Compression provide? There are 2 correct answers to this question. Reduced memory consumption. Increased parallel processing. Optimized access to column store tables. Optimized data partitioning.

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.

What are the two main factors of SAP HANA Innovations and Challenges?. HW technology and innovations. SAP SW technology and innovations. SAP BW innovations. DBMS technology and innovations.

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

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. Define the cardinality for the target entity. Specify the other views in which the association can be used. Specify an alias for the target entity. Include all fields used in the ON condition in the project on list.

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. Automatically. By Resource console. Manually.

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

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 Security view. The Administration view. The Landscape view. The System Monitor view.

What made SAP HANA possible? There are 2 correct answers to this question. RAM limitation. Technology and innovations. Improved hardware technology. CPU with single core network.

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 synchronously. It deletes obsolete versions of the database procedure asynchronously. It creates the database procedure when the AMDP is first called. It creates the database procedure when the AMDP is first activated.

Explain the Enterprise Information System of - SAP HANA Implementation Scenarios? There are 3 correct answers to this question. HANA Modeling. All HANA Combinations on one platform. Business Suite on HANA / BW on SAP HANA. All SAP applications on one SAP HANA platform. HANA Accelerators.

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. ABAP Dictionary views used in the procedure body. ABAP Dictionary table used in the procedure body. AMDP used in the procedure body. CE function used in the procedure body. SAP HANA views used in the procedure body.

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 specify the DB connection explicitly in your statement. You have to specify the DB schema explicity in your statement. 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.

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. The consumption of SAP HANA artifacts was simplified. Performance analysis tools have been improved. The ABAP language and the OpenSQL language have been extended. Re- use components have been extended or optimized for SAP HANA. Do all the data processing in Application server.

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

What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question. Buffer system services. Advanced and specific models. Core Data services. A new and advanced Open SQL.

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

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. The same number of columns. All key fields. Columns of compatible types. Columns of identical types.

Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench? There are 3 correct answers to this question. Core Data service (CDS) view. External view. Database procedure proxy. Full-text index. ABAP program containing new Open SQL.

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)? Please choose the correct answer. Existence check for Secondary Indexes. Use of Native SQL and DB Hints. Missing ORDER BY or SORT after SELECT. Direct access to Table Pools/Cluster.

You are debugging in ABAP Development Tools in Eclipse. What features are available? There are 2 correct answers to this question. Memory usage analysis. Watch points. Debugger scripting. Conditional breakpoints.

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. Integrated into ABAP Development Tools and ABAP Workbench. Integrates with SAP Solution Manager. ABAP source code with performance optimization potential.

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. Technology store. Re-use component store. Development Store. ROW store. Column store.

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. Importing. Returning. Exporting. Receiving. Changing.

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 selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues. A new tool called SQL Monitor to determine the priority if different programs access the database intensively. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption. Tools analyzing performance at run-time, to determine if critical constructs.

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 Only. Read-Write. Read-update.

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

Explain the Enterprise Information System of - SAP HANA Implementation Scenarios? There are 3 correct answers to this question. HANA Modeling. All HANA Combinations on one platform. HANA Accelerators. Business Suite on HANA / BW on SAP HANA. All SAP applications on one SAP HANA platform.

What output does The SAP HANA provide as a unique combination of hardware and software innovations? Choose the correct answer. 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.

Which of the following are characteristics of an external view? There are 3 correct answers to this question. It allows access to an SAP HANA information view with Open SQL. It defines the underlying SAP HANA information view. It can be used in Open SQL statements for database updates. It is an ABAP Dictionary object type. It can be used as a data type in ABAP programs.

Which is not a Golden Rule for Open SQL? Please choose the correct answer. Minimize the Amount of Data Transferred. Keep the result set large. Reduce the Database Load. Minimize the Number of Database Accesses.

Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”? Choose the correct answer. Performance data table. Runtime monitor data. Critical data table. Selection data table.

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

Why is a security concept in SAP HANA required? There are 2 correct answers to this question. Database administration should be restricted to skilled. Need to have selected users in SAP HANA for Information Management. Editing of SAP HANA data models should only be possible for “Users.” of the model. Access to ERP tables must be restricted.

How to create a core data services view? There are 3 correct answers to this question. Use the ABAP Development Tools for SAP NetWeaver. Use DDL statement DEFINE VIEW and SQL-like syntax to define the view. Use SQL capabilities for Netweaver. Use additional annotations – marked with the @ sign. Use data services tools for updates.

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

Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question. Keep load from the database. Collect all the data and perform Parallel processing in ABAP. Creating and consuming all the contents from network. Get all the data you need on the application server and do your processing in ABAP.

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. Data Mart based on SAP HANA. Server based on SAP HANA.

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. You need to refresh the content of the container manually. Changes to Delta Container. Take snapshot manually before releasing of the container. Automatic release of units.

What are the Guidelines for optimizing ABAP code running on HANA? There are 3 correct answers to this question. Column store. High-speed data analysis. Technical settings. Open SQL settings. DB specific properties.

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 delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container. Open the SAP HANA transport container Select take snapshot and Save 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. Open the ABAP transport request Select take snapshot and Save Activate the SAP HANA transport container.

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 Transferred Language. The Database Language. The Data Definition Language. Data Manipulation Language. The Data Control Language.

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. Identify Elementary Search Help. Check Pre-Requisites. Automatic updates of all the input fields. Switch on proposal search for input fields. Process on all the input fields.

In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog. Which of the following table types fulfill this requirement? Please choose the correct answer. LOCAL TEMPORARY. ROW. COLUMN. GLOBAL TEMPORARY.

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. Column-based database technology. Value-based database technology. Row-based database technology. Object-based database technology. Time-based database technology.

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 CORRESPOND ING FIELDS additions. Replace ORDER BY additions. Add explicit client handling. Replace UP TO n ROWS additions. Specify the schema for every table.

What is the central goal of using SAP HANA? Please choose the correct answer. Accelerate Performance. Positive Impact on Business. Monitor database for record keeping. To set Priorities for system.

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 more than a specified number of fields. SELECT * statements on tables with the Column Store storage type. SELECT * statements on tables with more than 100,000 records.

You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question. By a core data services view. By a script-based calculation view. By using Sap Analysis for Microsoft office. By another database procedure.

Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question. Use the DDL statement DEFINE VIEW and SQL like Syntax. Define the type mapping between ABAP and SAP HANA. Specify the name of the SQL view in ABAP Dictionary. Create a data definition in your ABAP package. Create a proxy object for the defined view.

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. System Perspective. Catalogue outlook. Open Content outlook. Modeler Perspective.

Which code-to-data capability supports- Extended view definitions and Better SQL92 standard support in open SQL? Please choose the correct answer. Database for sophisticated analysis. New SQL parser used in model. SAP HANA specific features. Database oriented programming model.

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. SAP HANA has to be the primary database to create a full text search. The full-text index is always updated asynchronously. The LIKE operator is required in your SELECT statement to implement fuzzy logic.

Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question. External view. Database Table. Database Procedure. CDS View. Internal table.

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. CASE expression. Currency Conversion. CASTE Expression. Unit conversion. Nested CASE expression.

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. Program X was executed in the background. SQL Monitor was activated with a fitter that excludes database table Y. The data has NOT yet been transferred to the SQL Monitor database tables. Database table Y is a buffered table. SQL Monitor was activated for a specific application server.

What are the two layers of ABAP system interacts with its database? There are 2 correct answers to this question. The Client database interface. The Database specific library. The Data Storage interface. The Database independent interface.

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 database. Perform expensive calculations on the ABAP application server. Aggregate data on the database, and transfer the results to the ABAP layer. Use native SQL to access SAP HANA built-in functions. Transfer all data from the database to the ABAP layer, and then aggregate the results.

What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to this question. To Keep all the loads away from the DB. It is beneficial for maximizing your search into database. It is beneficial to move data-intensive calculations into the database. To reduce main memory consumption and to improve insert performance.

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 allow creation of a full-text index. To limit the need of indexes. To limit the unpacking and reconstruction of rows. To limit the data footprint.

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. Isolation search. linguistic search. ACID search. Fuzzy search.

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. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB. Implement the interface IF_AMDP_MARKER_HDB. Set the visibility of the corresponding class method in the declaration section to PUBLIC. Implement the ABAP AMDP_HDB Event Handler.

Which task does the ABAP Managed Database Procedure (AMDP) framework perform? Please choose the correct answer. 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.

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. Database user – also different from your ABAP user. Password for the database user. By using Open Catalog look.

Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question. Analytic engine. OPAX engine. Join engine. OLAP engine.

Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question. Core data service (CDS) access control. Open SQL. ABAP Dictionary. Core data services (CDS) data definition.

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 planetype. carrid and planetype. _flights.carrid and _flight.s .planetype.

What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question. Applying Code inspector. Display record of all database access. Detect redundant or identical select statements. Locate database performance issues. Locate work base issues.

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. Account-based Profitability. Service-based profitability.

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

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 fallback implementation. A database procedure. A BADI definition. AN enhancement spot. A BADI simple implementation.

Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA? Please choose the correct answer. Dictionary encoding. Parallel processing. Database table compression. Columnar data storage.

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. CASE order type WHEN 'A' THEN 1 ELSE 0 END AS order_type. CAST('USO' AS abap.cuky) AS currency_key. SUM(revenue) AS total_revenue. crtdby AS created_by.

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

User STUDENT_A create and activates a design-time object. In which schema is the run object generated? Please choose the correct answer. _SYS_BIC. _SYS_BI. SYSTEM. STUDENT_A.

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 a restricted column for the ADDRESS field. Map the ADDRESS field to a constant value. Create an input parameter for the ADDRESS field.

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. The ABAP system checks the syntax of the Native SQL statements. Client handling needs to be done explicitely in the the Native SQL statement. The database independency of your report can be lost.

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 }. 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 } group by so_id. select from snwd_so { so_id, sum(net_amount) as sum_amount } group by net_amount.

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 Method Implementations from the Method Definition. Creating Parts for Interface Methods.

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. Combine the results of the SQL Monitor with the results of an ABAP runtime analysis. Activate the new SQL Monitor in a development system. Activate the new SQL Monitor in a productive system.