Questions
ayuda
option
My Daypo

ERASED TEST, YOU MAY BE INTERESTED ONABAP for SAP HANA 2.0

COMMENTS STATISTICS RECORDS
TAKE THE TEST
Title of test:
ABAP for SAP HANA 2.0

Description:
E_HANAAW_17

Author:
Mii
(Other tests from this author)

Creation Date:
26/03/2024

Category:
Science

Number of questions: 178
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question. Database Table External view Internal table CDS View Database Procedure.
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 represents the connection to an ABAP system It represents the connection to the SAP HANA server It provides access to all ABAP repository objects in an ABAP system.
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 Create a debug configuration for the ABAP application and run the program Choose the Run --> Debug options in the menu Choose the debug as option in the context menu of the ABAP program.
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. Unit conversion Currency Conversion Nested CASE expression CASE expression CASTE Expression.
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 extent to which records of the CDS view should be buffered on the application server 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.
What are functions of the ABAP Managed Database Procedure (AMDP) framework? There are 2 correct answers to this question. It creates the database procedure when the AMDP is first activated. It deletes obsolete versions of the database procedure synchronously. It creates the database procedure when the AMDP is first called. It deletes obsolete versions of the database procedure asynchronously.
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. GLOBAL TEMPORARY COLUMN ROW LOCAL TEMPORARY.
Which of the following objects can you use in the ABAP layer when using the top-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.
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. Flexible schedule of check runs Configuration of check variants Documented checks Enhanced distribution of results.
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. SYSTEM P81 has SAP HANA as primary database PACKAGE ZHA400_00 HAS deployment Mode A Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK View CA_CUSTOMER has deployment mode A.
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 text that you want to search. The table contains only a small number of records. The table contains data that you want to aggregate.
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver? There are 2 correct answers to this question. Content assistance Form-based class builder Quickfix Screen editing.
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.
Which of the following are view annotations for a CDS view? There are 3 correct answers to this question. Access control Client handling Buffering type Environment Semantics.
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}.
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. SET_PARAM SET_PARAM_TABLE NEXT_PACKAGE EXECUTE_QUERY.
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. F3 F1 F4 F2.
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 Conditional breakpoints Debugger scripting.
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. As many result sets as there are input parameters in the procedure One result set Two result sets As many result sets as there are table output parameters in the procedure.
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. Native SQL statements Left outer joins in open SQL statements Code that relies on implicit database sorting Direct access to a cluster on the database ORDER BY Clauses in Open SQL statements.
You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer. Create a debug configuration for the ABAP application and run the program Set a breakpoint in the ABAP program and execute the program Choose the Run --> Debug options in the menu Choose the debug as option in the context menu of the ABAP program.
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.
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).
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 Columns of identical types All key fields The same number of columns.
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 synchronously Create a new version of the database when the AMDP is first called Delete the obsolete versions of the database procedure asynchronously.
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 SAP HANA views used in the procedure body ABAP Dictionary tables used in the procedure body ABAP Dictionary views used in the procedure body AMDPs used in the procedure body.
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. Exporting Receiving Changing Importing Returning.
What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)? There are 3 correct answers to this question. Use scalar types for all AMDP method parameters. Define all method parameters to be passed by value. Specify the database system and the language. Mark the AMDP method as a READ-ONLY database procedure. List all ABAP Dictionary tables used in the procedure body in the USING clause.
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. Database table compression Partitioning Parallel processing Columnar data storage.
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. Include the client field in the join condition. Include the client field in the WHERE condition. Use the CLIENT SPECIFIED addition.
You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question. By using Sap Analysis for Microsoft office By a script-based calculation view By a core data services view By another database procedure.
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 more than a specified number of fields SELECT * statements where fewer than a specified percentage of all fields are effectively used SELECT * statements on tables with more than 100,000 records SELECT * statements on tables with the Column Store storage type.
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 an alias for the target entity. 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.
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. Estimate the new total runtime of optimized code. Combine information from static ABAP code scans with runtime data from the SQL Monitor. Combine information from static ABAP code scans with runtime data from the SQL Trace tool.
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. Specify the schema for every table. Replace UP TO n ROWS additions. Add explicit client handling. Replace ORDER BY additions.
Explain The Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question. Object privileges Delta privileges Analytic privileges System privileges Application privileges.
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 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 schema explicity in your statement.
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 carrid and planetype _flights.carrid and _flight.s .planetype _flights.carrid and planetype.
Which of the following are characteristics of an external view? There are 3 correct answers to this question. 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. It can be used as a data type in ABAP programs.
What benefits does SAP HANA Data Compression provide? There are 2 correct answers to this question. Optimized data partitioning Optimized access to column store tables Increased parallel processing Reduced memory consumption.
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 Editor shortcut key options Code completion options Code formatting options.
Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement Perform all calculations and aggregations in the ABAP layer Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES Use array variants of INSERT UPDATE MODIFY and DELETE.
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.
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 using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node: What does the result of the aggregation look like? Please choose the correct answer. Option C Option B Option A Option D.
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. CASE order type WHEN 'A' THEN 1 ELSE 0 END AS order_type SUM(revenue) AS total_revenue crtdby AS created_by CAST('USO' AS abap.cuky) AS currency_key ASSOCIATION TO sflight AS _flights.
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. SQL Monitor was activated for a specific application server. Program X was executed in the background. 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. Database table Y is a buffered table.
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. Use the tilde symbol (~) to separate qualifier from column name Use the UP TO n ROWS addition Explicitly handle the client field Specify the database schema if it is not the user's default schema Use a Comma-separated column list.
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 locking and commit handling. It has syntax check at compile time. It supports where-usedlist.
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. External view ABAP program containing new Open SQL Full-text index Core Data service (CDS) view Database procedure proxy.
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. "ha400.pr mdb/CA_BOOKINGS_COUNT" _SYS_ BIC."ha400.prirndb/CA_BOOKINGS_COUNT" "ha400.primdb::CA_BOOKINGS_COUNT" _SYS_ BIC."ha400.primdb::CA_BOOKINGS_COUNT".
Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question. Define indexes on the columns that are used in calculations. Filter data in lower layers. Avoid transferring large result sets between database and client applications. Move data-intensive calculations from the database to an application server.
User STUDENT_A create and activates a design-time object. In which schema is the run object generated? Please choose the correct answer. _SYS_BI STUDENT_A _SYS_BIC SYSTEM.
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 The consumption of SAP HANA artifacts was simplified Do all the data processing in Application server Re-use components have been extended or optimized for SAP HANA.
Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA? Please choose the correct answer. Dictionary encoding Columnar data storage Parallel processing Database table compression.
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 need of indexes To limit the data footprint To allow creation of a full-text index To limit the unpacking and reconstruction of rows.
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 Core data services (CDS) data definition ABAP Dictionary.
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. AMDPs used in the procedure body SAP HANA views used in the procedure body ABAP Dictionary views used in the procedure body ABAP Dictionary tables used in the procedure body CE functions used in the procedure body.
What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question. A. Perform expensive calculations on the database B. Perform expensive calculations on the ABAP application server C. Aggregate data on the database, and transfer the results to the ABAP layer D. Use native SQL to access SAP HANA built-in functions E. Transfer all data from the database to the ABAP layer, and then aggregate the results.
How SAP HANA supports SQL? There are 3 correct answers to this question. A. As a means to define B. Transferring data C. Read D. Manipulate Data E. As a Data Calculator.
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. A. Combine the results of the SQL Monitor with the results of a static source code analysis B. Combine the results of the SQL Monitor with the results of an ABAP runtime analysis C. Activate the new SQL Monitor in a development system D. Activate the new SQL Monitor in a productive system.
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. A. Column-based database technology B. Value-based database technology C. Row-based database technology D. Object-based database technology E. Time-based database technology.
What is the main function of Static Code Analysis? A. To detect code that would lead to functional or performance issues when migrating to SAP HANA B. Integrated into ABAP Development Tools and ABAP Workbench C. Integrates with SAP Solution Manager D. ABAP source code with performance optimization potential.
What allows you to resolve errors quickly or warnings reported about the code? A. Code execution B. Quick Fix C. ABAP debugger D. Debug perspective.
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. A. It supports locking and commit handling B. It has syntax check at compile time C. It supports where-usedlist D. It supports exception handing.
What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question. A. Applying Code inspector B. Display record of all database access C. Detect redundant or identical select statements D. Locate database performance issues E. Locate work base issues.
What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question. A. Sales B. Stock C. Procurement D. Services E. Product.
What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question. A. By Importing a Landscape B. Automatically C. By Resource console D. Manually.
When would you use a column store table instead of a row store table? There are 2 correct answers to this question. A. When you require aggregation and analysis of values B. When there are mainly distinct values in the table C. When you want to enable a full-text search of the table D. When the table has a small number of records.
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? A. Statement template options B. Code formatting options C. Editor shortcut key options D. Code completion options.
What made SAP HANA possible? There are 2 correct answers to this question. A. CPU with single core network B. RAM limitation C. Technology and innovations D. Improved hardware technology.
What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question. A. Attribute view B. Analytical view C. Schema view D. Column view.
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. A. CASE expression B. CASTE Expression C. Unit conversion D. Nested CASE expression E. Currency Conversion.
What is the Limitations of ALV for SAP HANA? There are 3 correct answers to this question A. Restricted to 5000 records / unit B. Restricted to 10,000 records C. No unit/ currency split if aggregating amounts/ currency values D. Without currency /unit consideration E. All unit/ currency restricted to 10,00,00 records.
What all are the factors involved in Working with ADT? There are 3 correct answers to this question. A. ABAP interface B. ABAP programs C. Workbench programs D. ABAP Class E. Module interface.
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. A. You have to specify the DB connection explicitly in your statement B. You have to specify the DB schema explicity in your statement C. You have to use native SQL when reading data from the secondary DB D. All tables and fields you are using must exist in the ABAP Dictionary of the Secondary DB.
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. A. Identify Elementary Search Help B. Check Pre-Requisites C. Automatic updates of all the input fields D. Switch on proposal search for input fields E. Process on all the input fields.
The source code editor in ADT provides many helpful features. What are these helpful features? There are 2 correct answers to this question. A. Creating Method Definitions from Implementation Parts B. Creating Method Implementations from the Method Definition C. Creating Parts for Interface Methods D. Creating interface from Method Calls.
Name some perspectives that are available in the SAP HANA Studio? There are 3 correct answers to this question. A. The Information perspective B. The technology & innovation perspective C. The Administration Console perspective D. The Resources perspective E. The SAP HANA Modeler perspective.
What are the Guidelines for optimizing ABAP code running on HANA? There are 3 correct answers to this question. A. Column store B. High-speed data analysis C. Technical settings D. Open SQL settings E. DB specific properties.
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? A. Write Only B. Read Only C. Read-Write D. Read-update.
Which task does the ABAP Managed Database Procedure (AMDP) framework perform? A. Deploy a new version of the database procedure when the AMDP is first called B. Deploy the database procedure whenever the AMDP is activated C. Deploy the database procedure when the AMDP is first activated D. Deploy the database procedure whenever the AMDP is called.
Which step of the Guided Performance Analysis should you perform in the product on system? A. Collecting data with SQL Monitor (SQLM) B. Performing an inspection with Code Inspector (SCI) C. Building a work list with SQL Performance Tuning Work list (SWLT) D. Executing a check run with ABAP Test Cockpit (ATC).
The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question. A. Avoid idling CPU cores B. Avoid optimizing data C. Avoid single network D. Avoid CPU cache misses.
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. A. ABAP Dictionary views used in the procedure body B. ABAP Dictionary table used in the procedure body C. AMDP used in the procedure body D. CE function used in the procedure body E. SAP HANA views used in the procedure body.
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. A. Re-use component store B. Development Store C. ROW store D. Column store.
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? A. select from snwd_so { so_id, sum(net_amount) as sum_amount } B. select from snwd_so { so_id, sum(net_amount) as sum_amount } order by so_id C. select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id D. select from snwd_so { so_id, sum(net_amount) as sum_amount } group by net_amount.
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. A. ASSOCIATION TO sflight AS _flights B. CASE order type WHEN 'A' THEN 1 ELSE 0 END AS order_type C. CAST('USO' AS abap.cuky) AS currency_key D. SUM(revenue) AS total_revenue E. crtdby AS created_by.
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? A. SET_PARAM_TABLE B. SET_PARAM C. NEXT_PACKAGE D. GET_METADATA.
What advanced search experience does SAP HANA's state-of-the-art search experience include full-text search? There are 3 correct answers to this question. A. freestyle search B. Isolation search C. linguistic search D. ACID search E. Fuzzy search.
What benefits does SAP HANA Data Compression provide? There are 2 correct answers to this question. A. Increased parallel processing B. Reduced memory consumption C. Optimized access to column store tables D. Optimized data partitioning.
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? A. Open the SAP HANA delivery unit Select take snapshot and save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container B. Open the SAP HANA transport container Select take snapshot and save Activate the SAP HANA transport container C. Open the package Select take snapshot and save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container C. Open the package Select take snapshot and save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container.
An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question. A. View restrictions B. Validity restrictions C. Cube restrictions D. Analytic restrictions E. Activity restrictions.
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. A. Core Data service (CDS) view B. External view C. Database procedure proxy D. Full-text index E. ABAP program containing new Open SQL.
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? A. SELECT * statements where fewer than a specified percentage of all fields are effectively used B. SELECT * statements on tables with more than a specified number of fields C. SELECT * statements on tables with the Column Store storage type D. SELECT * statements on tables with more than 100,000 records.
How to call the stored procedures in ABAP code? A. Only SQL B. Open SQL C. Native SQL D. CDS View.
Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question. A. External view B. Database Table C. Database Procedure D. CDS View E. Internal table.
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? A. To limit the need of indexes B. To limit the unpacking and reconstruction of rows C. To allow creation of a full-text index D. To limit the data footprint.
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. A. You need to refresh the content of the container manually B. Changes to Delta Container C. Take snapshot manually before releasing of the container D. Automatic release of units.
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. A. Importing B. Returning C. Exporting D. Receiving E. Changing.
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. A. De-pooling and de-clustering B. Definition of an enhancement category C. Definition of full-text indexes D. Changes of data class E. Storage type for tables.
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. A. Because you automatically add changed objects to the transport request B. Because you can manually re-deploy objects after a failed import C. Because you use the technique that is recommended by SAP D. Because you always transport entire SAP HANA content packages.
Which code-to-data capability supports- Extended view definitions and Better SQL92 standard support in open SQL? A. Database for sophisticated analysis B. New SQL parser used in model C. SAP HANA specific features D. Database oriented programming model.
What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question. A. Product-based Profitability B. Costing-based Profitability C. Account-based Profitability D. Service-based profitability.
What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to this question. A. To keep all the loads away from the DB B. It is beneficial for maximizing your search into database C. It is beneficial to move data-intensive calculations into the database D. To reduce main memory consumption and to improve insert performance.
Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”? A. Performance data table B. Runtime monitor data C. Critical data table D. Selection data table.
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. A. Package ZHA400_00 has deployment mode A B. View CA_CUSTOMER has deployment mode A C. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK D. System P81 has SAP HANA as primary database.
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. A. Code that relies on implicit database sorting B. Direct access to a cluster on the database C. Left outer joins in open SQL statements D. Native SQL statements E. ORDER BY Clauses in Open SQL statements.
What are the Functions of Transaction DBACOCKPIT? There are 2 correct answers to this question. A. Used to access local or remote database system B. Maintain, Monitor and test secondary database connection C. Use Schema for the Connections D. Maintain only HANA specific objects.
What output does The SAP HANA provide as a unique combination of hardware and software innovations? A. Huge potential to maximize the number of disk blocks in the application B. The ability to create new complex processes with ABAP application cloud C. Huge potential to optimize AMDP application DATA Tables D. Huge potential to optimize business applications that are running on SAP HANA.
Name the views that are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question. A. The Security view B. The Administration view C. The Landscape view D. The System Monitor view.
How to create a core data services view? There are 3 correct answers to this question. A. Use the ABAP Development Tools for SAP NetWeaver B. Use DDL statement DEFINE VIEW and SQL-like syntax to define the view C. Use SQL capabilities for Netweaver D. Use additional annotations – marked with the @ sign E. Use data services tools for updates.
You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? A. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB B. Implement the interface IF_AMDP_MARKER_HDB C. Set the visibility of the corresponding class method in the declaration section to PUBLIC D. Implement the ABAP AMDP_HDB Event Handler.
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. A. Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword B. The ABAP system checks the syntax of the Native SQL statements C. Client handling needs to be done explicitely in the the Native SQL statement D. The database independency of your report can be lost.
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. A. SYS BIC."ha400.primdb::CA_BOOKINGS_COUNT" B. SYS BIC."ha400.prirndb/CA_BOOKINGS_COUNT" C. "ha400.pr mdb/CA_BOOKINGS_COUNT" D. "ha400.primdb::CA_BOOKINGS_COUNT".
When are referential joins executed in analytical views? A. When fields are selected B. When all the tables are optimized C. When fields from both the tables are requested D. When fields are optimized.
Which data provisioning methods can you use when you need real time replications? There are 2 correct answers to this question. A. SAP Landscape transformation Replication server (SAP SLT) B. SAP Data services C. SAP Replication server D. SAP HANA Direct extractor connection (SAP DXC).
Which of the following are characteristics of an external view? There are 3 correct answers to this question. A. It allows access to an SAP HANA information view with Open SQL B. It defines the underlying SAP HANA information view C. It can be used in Open SQL statements for database updates D. It is an ABAP Dictionary object type E. It can be used as a data type in ABAP programs.
Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA? A. Dictionary encoding B. Parallel processing C. Database table compression D. Columnar data storage.
When to use Enhanced Open SQL? There are 2 correct answers to this question. A. Need the query in one piece of code only B. To view scalar components C. To access system fields D. At the time of Dictionary Views.
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. A. High availability configuration B. Active clusters for all servers C. Services-Name and index server on all nodes D. Shared file systems for only one server.
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? A. Update packages B. Update resources C. Release resources D. Release packages.
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. A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues B. A new tool called SQL Monitor to determine the priority if different programs access the database intensively C. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption D. Tools analyzing performance at run-time, to determine if critical constructs.
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. A. Program X was executed in the background B. SQL Monitor was activated with a fitter that excludes database table Y C. The data has not yet been transferred to the SQL Monitor database tables D. Database table Y is a buffered table E. SQL Monitor was activated for a specific application server.
Which code-to-data capability is responsible for the Optimizations & Translation of “Open SQL SELECT FOR ALL ENTRIES “clauses into native SQL? A. Database Optimization B. Buffer system Optimization C. HANA Specific features D. Transparent Optimizations.
What is an attribute view and what are its practices? There are 3 correct answers to this question. A. Used in diagrammatic Projections B. May use in calculation views C. May contains flow charts D. May contain filters E. Used to join 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. A. Data Transferred Language B. The Database Language C. The Data Definition Language D. Data Manipulation Language E. The Data Control Language.
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. A. Replace CORRESPOND ING FIELDS additions B. Replace ORDER BY additions C. Add explicit client handling D. Replace UP TO n ROWS additions E. Specify the schema for every table.
Which of the following are view annotations for a CDS view? There are 3 correct answers to this question. A. Buffering type B. Client handling C. Semantics D. Environment E. Access control.
Which is not a Golden Rule for Open SQL? A. Minimize the Amount of Data Transferred B. Keep the result set large C. Reduce the Database Load D. Minimize the Number of Database Accesses.
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. A. By using SQL application B. Database user – also different from your ABAP user C. Password for the database user D. By using Open Catalog look.
You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question. A. By a core data services view B. By a script-based calculation view C. By using Sap Analysis for Microsoft office D. By another database procedure.
User STUDENT_A create and activates a design-time object. In which schema is the run object generated? A. _SYS_BIC B. _SYS_BI C. SYSTEM D. STUDENT_A.
What are the two layers of ABAP system interacts with its database? There are 2 correct answers to this question. A. The Client database interface B. The Database specific library C. The Data Storage interface D. The Database independent interface.
What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question. A. Innovation based on SAP HANA B. New or Native SAP HANA C. Data Mart based on SAP HANA D. Server based on SAP HANA.
Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question. A. Use the DDL statement DEFINE VIEW and SQL like Syntax B. Define the type mapping between ABAP and SAP HANA C. Specify the name of the SQL view in ABAP Dictionary D. Create a data definition in your ABAP package E. Create a proxy object for the defined view.
In an ABAP Core Data Services (CDS) view, what must you do to expose an association for use in another CDS view? A. Include all fields used in the on condition in the project on list B. Specify the other views in which the association can be used C. Define the cardinality for the target entity D. Specify an alias for the target entity.
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. A. Exclude the ADDRESS field from the union B. Create a restricted column for the ADDRESS field C. Map the ADDRESS field to a constant value D. Create an input parameter for the ADDRESS field.
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. A. Analytical DBMS features B. High Performance and Scalability C. Hybrid data and management system D. Support for system tables.
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)? A. Existence check for Secondary Indexes B. Use of Native SQL and DB Hints C. Missing ORDER BY or SORT after SELECT D. Direct access to Table Pools/Cluster.
What are the elements of ABAP Database Integration? There are 3 correct answers to this question. A. DB client-server B. Application server C. Other DB D. Client database handling E. DB For ABAP.
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. A. Configure B. Organizing C. Administer D. Monitor E. Selecting.
What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question. A. Buffer system services B. Advanced and specific models C. Core Data services D. A new and advanced Open SQL.
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. A. Weights for ranking B. Freestyle search C. Point base ranking D. Fuzzy search E. Index search.
Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question. A. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES B. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement C. Perform all calculations and aggregations in the ABAP layer D. Use array variants of INSERT UPDATE MODIFY and DELETE.
You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? A. Choose the Run --> Debug options in the menu B. Create a debug configuration for the ABAP application and run the program C. Choose the debug as option in the context menu of the ABAP program D. Set a breakpoint in the ABAP program and execute the program.
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. A. X is an SAP HANA view B. X is a stored procedure C. X is an ABAP Dictionary table D. X is an AMDP method.
What are the two types of editors available in ADT? There are 2 correct answers to this question. A. SAP (GUI) B. Client (native) C. ABAP (native) D. Eclipse (native).
What are the steps involved in SAP HANA Evolution? There are 3 correct answers to this question. A. ABAP can run on SAP HANA B. ABAP can access SAP HANA C. Optimized ABAP on SAP HANA D. ABAP as accelerator on SAP HANA E. ABAP applications on SAP HANA.
When using a SAP HANA full text search, what do you have to keep in mind? A. The SCORE( ) function is required to ensure the best hits of your search appear on top B. SAP HANA has to be the primary database to create a full text search C. The full-text index is always updated asynchronously D. The LIKE operator is required in your SELECT statement to implement fuzzy logic.
Which of the following tasks can you perform with SQL monitor (transaction SQLM)? A. Capture the SQL profile of an application B. Search for problematic SELECT* statements C. Combine static and dynamic performance analysis results D. Display the execution plan of an SQL statement.
Which of the Golden Rules for Open SQL Performance have become more important with SAP HANA? There are 2 correct answers to this question. A. Minimize the number of database accesses B. Minimize the amount of transferred data C. Minimize the search overhead D. Keep unnecessary load away from the database.
What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question. A. Calculate aggregations using ABAP code on the application server to limit database load B. Use a column list in the SELECT clause to ensure that you only read a column if it is really required C. Eliminate nested SELECT statements to reduce the overall number of database accesses D. Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required.
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. A. Configuration of check variants B. Enhanced distribution of results C. Flexible schedule of check runs D. Documented checks.
What are the features of New Open SQL? There are 2 correct answers to this question. A. Supports arithmetic and string expressions B. Supports conditional expressions C. Supports specific units of database D. Supports Code adjustment model.
What are functions of the ABAP Managed Database Procedure (AMDP) framework? There are 2 correct answers to this question. A. It deletes obsolete versions of the database procedure synchronously B. It deletes obsolete versions of the database procedure asynchronously C. It creates the database procedure when the AMDP is first called D. It creates the database procedure when the AMDP is first activated.
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. A. The consumption of SAP HANA artifacts was simplified B. Performance analysis tools have been improved C. The ABAP language and the OpenSQL language have been extended D. Re- use components have been extended or optimized for SAP HANA E. Do all the data processing in Application server.
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? A. Row B. Column C. Local Temporary D. Global Temporary.
Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment? A. System Perspective B. Catalogue outlook C. Open Content outlook D. Modeler Perspective.
To upload data from flat files, SAP HANA offers several features. What are these important features? There are 2 correct answers to this question. A. The new table always has a 2:2 mapping between the file and table columns B. The supported file types for upload are: .cssv, .xlls, and .xlsxxx C. When loading new data in the table, it gets appended to the existing data D. The application suggests the column name and data type for the new tables, and it is possible to edit them.
Which form of services is responsible for defining and consuming semantically rich data models? A. ITe services B. Core Data Services C. Conditional services D. Modell-II services.
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. A. The join conditions of the CDS view B. The client dependency of the CDS view C. The name of the representation of the CDS view in the ABAP dictionary D. The extent to which records of the CDS view should be buffered on the application server E. The logic for aggregations, grouping records, and filtering groups of the CDS view.
What are the two main factors of SAP HANA Innovations and Challenges? There are 2 correct answers to this question. A. HW technology and innovations B. SAP SW technology and innovations C. SAP BW innovations D. DBMS technology and innovations.
Explain the Enterprise Information System of - SAP HANA Implementation Scenarios? There are 3 correct answers to this question. A. HANA Modeling B. All HANA Combinations on one platform C. HANA Accelerators D. Business Suite on HANA / BW on SAP HANA E. All SAP applications on one SAP HANA platform.
Explain Transitioning ABAP Code to SAP HANA – Performance Considerations? There are 3 correct answers to this question. A. Some codes transferred to other systems B. Classical performances recommendations for open SQL remain valid C. Some codes impacted positively and should be priorities D. Some shifts in priorities, examples, nested selects(higher) indices(lower) E. Some codes immediately run faster.
Why is a security concept in SAP HANA required? There are 2 correct answers to this question. A. Database administration should be restricted to skilled B. Need to have selected users in SAP HANA for Information management C. Editing of SAP HANA data models should only be possible for “Users.” of the model D. Access to ERP tables must be restricted.
What is the central goal of using SAP HANA? A. Accelerate Performance B. Positive Impact on Business C. Monitor database for record keeping D. To set Priorities for system.
Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question. A. Analytic engine B. OPAX engine C. Join engine D. OLAP engine.
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. A. ABAP managed database procedures B. Calculation views C. Stored procedures D. Core data services views.
What is the main purpose of SAML for SAP HANA Studio? A. SAML may be selected as an Owner’s authentication method when creating users in the SAP HANA Studio B. To support scenarios where clients are not directly connected to the SAP HANA Database C. The assertion is issued by a user after the client was successfully authenticate D. The SAP HANA database supports login of Owners only.
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. A. The same number of columns B. All key fields C. Columns of compatible types D. Columns of identical types.
What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers to this question. A. Tuning B. Detect C. Innovate D. Scaling E. Optimize.
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. A. All ABAP variables must be escaped with a proceding @ sign B. All Keywords are case sensitive C. All fields in the GROUP BY clause must be separated by commas D. All arithmetic expressions can be used for all type of variables.
What is the purpose of an ABAP project in ABAP Development tools for eclipse? There are 2 correct answers to this question. A. It is used to transport ABAP repository objects B. It provides access to all ABAP repository objects in an ABAP system C. It represents the connection to the SAP HANA server D. It represents the connection to an ABAP system.
What are the basic principles of ALV SAP HANA? There are 2 correct answers to this question. A. Only retrieve the database data which is to be displayed on screen B. To ensure that the user chooses the data on the selection screen is displayed C. The ALV Optimization for SAP HANA to display data on the screen D. Data described declaratively instead of passing big internal tables.
What are the Parameters for Analytical and Calculation view? There are 3 correct answers to this question. A. To store data for critical analysis B. Passing other values to be used in calculations C. Setting a filter for columns D. Create a copy of a report E. Specifying unit of measurement.
What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question. A. A set of open, language- and platform-independent APIs B. A brand new ABAP development experience on top of the Eclipse platform C. A set of Eclipse data pool and Client- Open platform D. An open platform for developing powerful database view E. An open platform for developing new ABAP-related tools.
Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question. A. Core data service (CDS) access control B. Open SQL C. ABAP Dictionary D. Core data services (CDS) data definition.
Report abuse Consent Terms of use