option
Cuestiones
ayuda
daypo
buscar.php
TEST BORRADO, QUIZÁS LE INTERESE: ABAP HANNA 40 - First
COMENTARIOS ESTADÍSTICAS RÉCORDS
REALIZAR TEST
Título del Test:
ABAP HANNA 40 - First

Descripción:
SAP ABAP HANNA

Autor:
AVATAR
ABAP HANNA
OTROS TESTS DEL AUTOR

Fecha de Creación:
26/06/2021

Categoría: Otros

Número Preguntas: 40
COMPARTE EL TEST
COMENTARNuevo Comentario
No hay ningún comentario sobre este test.
Temario:
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. ABAP program containing new Open SQL Database procedure proxy Full-text index External view Core Data service (CDS) view.
Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question. Delete the obsolete versions of the database procedure synchronously Delete the obsolete versions of the database procedure asynchronously Create a new version of the database when the AMDP is first activated Create a new version of the database when the AMDP is first called.
You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the database. In the check parameters, which value would you use for the percentage of fields that are effectively used? Please choose the correct answer. A value that you calculate based on the number of tables A lower value than on a traditional, row-store only based database A higher value than on a traditional, row-store only based database The same value as on a traditional, row-store only based database.
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)? Please choose the correct answer. Missing ORDER BY or SORT after SELECT Use of Native SQL and DB Hints Direct access to Table Pools/Cluster Existence check for Secondary Indexes.
How will you select a preference for Validation rules? Choose the correct answer Windows- Preferences-SAP HANA-Modeler-Validation Rules Windows- SAP HANA-Modeler-Preferences-Validation Rules Windows- Modeler – Preferences-SAP HANA-Validation Rules Windows- SAP HANA-Preferences-Modeler-Validation Rules.
What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question Services-Name and index server on all nodes Shared file systems for only one server Active clusters for all servers High availability configuration.
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. Set the visibility of the corresponding class method in the declaration section to PUBLIC. Implement the ABAP AMDP_HDB Event Handler. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB. Implement the interface IF_AMDP_MARKER_HDB.
What are the two types of editors available in ADT? There are 2 correct answers to this question. ABAP (native) Client (native) Eclipse (native) SAP (GUI).
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 AMDPs used in the procedure body ABAP Dictionary views used in the procedure body ABAP Dictionary tables used in the procedure body SAP HANA views used in the procedure body.
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 COLUMN GLOBAL TEMPORARY ROW.
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. Release packages Release resources Update resources Update packages.
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 only a small number of records. The table contains text that you want to search. The table contains mainly distinct values per column across rows. The table contains data that you want to aggregate.
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 always transport entire SAP HANA content packages. Because you use the technique that is recommended by SAP.
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 NEXT_PACKAGE SET_PARAM GET_METADATA.
Which of the following is not an element of Analytical view? Please choose the correct answer. Currency conversion is not applicable Join fact tables Read Data from the joined database tables Used to Joined table.
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 Core data services (CDS) data definition ABAP Dictionary Open SQL.
What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question. Automatic update for all export methods Release of Transport request Import of Transport Request Takes a ‘snapshot’ of all SAP HANA objects of delivery unit To create Transport container of delivery unit.
User STUDENT_A creates and activates a design-time object. In which schema is the runtime object generated? SYSTEM STUDENT_A _SYS_ BI _SYS_ BIC.
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 As many result sets as there are table output parameters in the procedure One result set Two result sets.
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 ACID search Fuzzy search linguistic search Isolation search.
Which of the following are characteristics of an external view? There are 3 correct answers to this question. It can be used as a data type in ABAP programs. It is an ABAP Dictionary object type. 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.
You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL. Which of the following are necessary adjustments? There are 3 correct answers to this question. Replace ORDER BY additions. Add explicit client handling. Specify the schema for every table. Replace CORRESPOND ING FIELDS additions. Replace UP TO n ROWS additions.
What are the ABAP development guidelines? There are 2 correct answers to this question. Improved hybrid components for SAP HANA Consuming Only ABAP contents for SAP HANA Improved tools for performance analysis Extensions to ABAP Language.
What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question. Innovation based on SAP HANA Server based on SAP HANA Data Mart based on SAP HANA New or Native SAP HANA.
What is the purpose of an ABAP project in ABAP Development tools for eclipse? There are 2 correct answers to this question. It represents the connection to the SAP HANA server It represents the connection to an ABAP system It is used to transport ABAP repository objects. It provides access to all ABAP repository objects in an ABAP system.
You are debugging in ABAP Development Tools in Eclipse. What features are available? There are 2 correct answers to this question. Watch points Debugger scripting Memory usage analysis Conditional breakpoints.
Which code-to-data capability supports- Extended view definitions and Better SQL- 92 standard support in open SQL? Please choose the 1 correct answer. Database for sophisticated analysis Database oriented programming model SAP HANA specific features New SQL parser used in model.
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.
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 A new and advanced Open SQL Core Data services.
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 an AMDP method X is an ABAP Dictionary table X is a stored procedure.
What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question Fewer data duplication and movement Easy to use modeling tool Exploit structured contents in SQL Large number of toolkits are available.
Which features does the source code editor provide in ABAP Development Tools (ADT)? There are 2 correct answers to this question. Screen Painter Quick Fix Content Assist Form-based Class Builder.
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. Transfer all data from the database to the ABAP layer, and then aggregate the results. Aggregate data on the database, and transfer the results to the ABAP layer. Perform expensive calculations on the ABAP application server. Use native SQL to access SAP HANA built-in functions.
What are the Guidelines for optimizing ABAP code running on HANA? There are 3 correct answers to this question. Open SQL settings Technical settings DB specific properties Column store High-speed data analysis.
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 Reduced memory consumption Increased parallel processing.
You developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of this AMDP using business add-in (BADI). Which of the following objects must you create? There are 3 correct answers to this question. A BADI definition AN enhancement spot A database procedure A BADI simple implementation A BADI fallback implementation.
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 View CA_CUSTOMER has deployment mode A. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK SYSTEM P81 has SAP HANA as primary database PACKAGE ZHA400_00 HAS deployment Mode A.
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 System Monitor view The Administration view The Security view The Landscape view.
In an ABAP Core Data Services (CDS) view, what must you do to expose an association for use in another CDS view? Please choose the correct answer. Specify the other views in which the association can be used. Include all fields used in the ON condition in the project on list. Specify an alias for the target entity. Define the cardinality for the target entity.
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer. Create a graph comparing the runtimes of ABAP code before and after optimization. Combine information from static ABAP code scans with runtime data from the SQL Monitor. Combine information from static ABAP code scans with runtime data from the SQL Trace tool. Estimate the new total runtime of optimized code.
Denunciar Test