TEST BORRADO, QUIZÁS LE INTERESE:
ABAP HANNA 40 - Second
COMENTARIOS |
ESTADÍSTICAS |
RÉCORDS
|
|---|
REALIZAR TEST
|
Título del Test:
ABAP HANNA 40 - Second Descripción: SAP ABAP HANNA Autor:
Fecha de Creación: 08/07/2021 Categoría: Otros Número Preguntas: 40 |
COMPARTE EL TEST
COMENTAR
No hay ningún comentario sobre este test.
Temario:
|
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 crtdby AS created_by SUM(revenue) AS total_revenue ASSOCIATION TO sflight AS _flights CAST('USO' AS abap.cuky) AS currency_key. 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 where-usedlist. It has syntax check at compile time. It supports locking and commit handling. Which of the following tasks can you perform with SQL monitor (transaction SQLM)? Capture the SQL profile of an application Display the execution plan of an SQL statement Combine static and dynamic performance analysis results Search for problematic SELECT* statements. 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 } order by so_id select from snwd_so { so_id, sum(net_amount) as sum_amount } group by net_amount select from snwd_so { so_id, sum(net_amount) as sum_amount } select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id. 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. Changes to Delta Container You need to refresh the content of the container manually Take snapshot manually before releasing of the container Automatic release of units. 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 ORDER BY Clauses in Open SQL statements Direct access to a cluster on the database Code that relies on implicit database sorting Native SQL statements Left outer joins in open SQL statements. What are the benefits associated with The SAP HANA real-time Operational analytics? There are 2 correct answers to this question High modeling flexibility Fast insights into business activity Query Speed support Simplification of massive data. When to use Enhanced Open SQL? There are 2 correct answers to this question. To view scalar components Need the query in one piece of code only To access system fields At the time of Dictionary Views. What is the Limitations of ALV for SAP HANA? There are 3 correct answers to this question. Restricted to 5000 records / unit Without currency /unit consideration No unit/ currency split if aggregating amounts/ currency values Restricted to 10,000 records All unit/ currency restricted to 10,00,00 records. When using an SAP HANA full text search, what do you have to keep in mind? Please choose the correct answer. The full-text index is always updated asynchronously. SAP HANA has to be the primary database to create a full text search. The SCORE( ) function is required to ensure the best hits of your search appear on top. The LIKE operator is required in your SELECT statement to implement fuzzy logic. Which task can you perform with the SQL Monitor (transaction SQLM)? Please choose the correct answer. Display the execution plan of an SQL statement. Combine stat c and dynamic performance analysis results. Search for problematic SELECT • statements. Capture the SQL profile of an application. 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 schema explicity in your statement. All tables and fields you are using must exist in the ABAP Dictionary of the Secondary DB. You have to use native SQL when reading data from the secondary DB. You have to specify the DB connection explicitly in your statement. What all are the factors involved in Working with ADT There are 3 correct answers to this question. Module interface Workbench programs ABAP interface ABAP programs ABAP Class. 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 supported file types for upload are: .cssv, .xlls, and .xlsxxx The new table always has a 2:2 mapping between the file and table columns 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 Possible Approaches with AS ABAP < 7.4 SP02? There are 2 correct answers to this question. Interaction with Database Stored Procedures Consume using native SQL SQL units. What are the two main factors of SAP HANA Innovations and Challenges? There are 2 correct answers to this question. HW technology and innovations SAP SW technology and innovations SAP BW innovations DBMS technology and innovations. Which form of services is responsible for defining and consuming semantically rich data models? Please choose the correct answer. Conditional services Modell-II services Core Data Services ITe services. What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question. Sales Stock Procurement Product Services. 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. 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. SQL Monitor was activated with a fitter that excludes database table Y. Program X was executed in the background. 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. Re- use components have been extended or optimized for SAP HANA Do all the data processing in Application server Performance analysis tools have been improved The ABAP language and the OpenSQL language have been extended The consumption of SAP HANA artifacts was simplified. 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 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. Activate the new SQL Monitor in a development system. What are the basic principles of ALV SAP HANA? There are 2 correct answers to this question. The ALV Optimization for SAP HANA to display data on the screen 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 Data described declaratively instead of passing big internal tables. What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question Schema view Attribute view Analytical view Column view. What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to this question. To reduce main memory consumption and to improve insert performance It is beneficial to move data-intensive calculations into the database To Keep all the loads away from the DB It is beneficial for maximizing your search into database. To connect with the SAP HANA system and see the corresponding catalog content etc., use the Systems view. How will you add a system to this view? There are 2 correct answers to this question. Database user – also different from your ABAP user Password for the database user By using SQL application By using Open Catalog look. 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 Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question. Administration console System and Properties Open system properties Development properties. How to call the stored procedures in ABAP code? Please choose the correct answer. Open SQL Native SQL Only SQL CDS view. What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers to this question. It can be active in a production system with minimal performance overhead. It displays the database execution plan for all SQL statements. It schedules ABAP programs to monitor and log all database accesses. It collects monitoring data asynchronously without additional database interaction. Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question SQL monitor (transaction SQLM) Data base performance monitor (transaction DB50) Code inspector (transaction SCI) ABAP test cockpit (transaction ATC) SQL Trace (transaction ST05). 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 Fuzzy search Index search Point base ranking Weights for ranking Freestyle search. 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 High Performance and Scalability Support for system tables Hybrid data and management system Analytical DBMS features. Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer. Programming model New advanced SQL syntax Procedures ABAP-Managed Database Procedures Table buffering. 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-update Read-write. What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question Automatically Manually By Importing a Landscape By Resource console. 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 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. How to create a core data services view? There are 3 correct answers to this question. Use data services tools for updates Use the ABAP Development Tools for SAP NetWeaver. Use DDL statement DEFINE VIEW and SQL-like syntax to define the view Use additional annotations – marked with the @ sign Use SQL capabilities for Netweaver. 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 Enhanced distribution of results Documented checks Configuration of check variants Flexible schedule of check runs. 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 completion options Code formatting options Editor shortcut key options. What are the supported joins in CDS view? There are 2 correct answers to this question. Operators joint Upper join Inner join Left outer join. |
Denunciar Test