Punto de cruz 1

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

How can you exchange SQL Monitor data between two systems? Please choose the correct answer. Deactivate the SQL Monitor in the source system and activate the SQL Monitor in the target system. Configure a secondary database connection to the target system and query the data in the SQL Monitor. Create and release a transport request containing the SQL Monitor log files. Create a snapshot of the SQL Monitor data, export it to the file system, and then import it to the target system.

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

An organization notices that certain SQL queries are taking longer than expected in their SAP HANA system. They want to identify bottlenecks and optimize the queries. Which of the following steps should they consider? Please select all the correct answers that apply. Migrate data to a non-columnar table. Optimize joins and filters in the query. Check for expensive statements using SQL Trace. Increase the memory allocation for the HANA system. Use PlanViz to analyze and visualize the query execution plan.

Which features does the source code editor provide in ABAP Development Tools (ADT)? There are 2 correct answers to this question. Form-based Class Builder. Content Assist. Screen Painter. Quick Fix.

Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question. Filter data in lower layers. Define indexes on the columns that are used in calculations. Move data-intensive calculations from the database to an application server. Avoid transferring large result sets between database and client applications.

How can you consume a Core Data Services (CDS) view? There are 2 correct answers for this question. Use it as a data source in the FROM clause of an Open SQL query. Use the Data Preview in ABAP Development Tools for SAP NetWeaver. Use the CDS maintenance transaction (SCDSV). Use the ABAP language statement WRITE and the CDS view name as the argument.

You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon Web Service (AWS) trial system. Which plug-ins do you need to add to the existing Eclipse installation? Please choose the correct answer. SAP HANA Tools. None; everything is preconfigured. ABAP Development Tools for SAP NetWeaver. All plug-ins provided by SAP Development Tools for Eclipse.

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.

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

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

According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA? Please choose the correct answer. Perform regular performance scans on your ABAP custom coding as part of the development process. Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5. Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process. Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion.

Which of the following can be part of an analytic view? There are 3 correct answers to this question. Data foundation. Logical joins. Unions. Attributes. Query transformation.

What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view? Please choose the correct answer. The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyField. The entire CDS view. The elements in the projection list of the CDS view. The CDS views used in the FROM clause.

Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer. Table buffering. Programming model. New advanced SQL syntax Procedures. ABAP-Managed Database Procedures.

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. 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. SAP HANA has to be the primary database to create a full text search.

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 a Comma-separated column list. Specify the database schema if it is not the user's default schema. Explicitly handle the client field. Use the UP TO n ROWS addition.

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

A company is migrating its traditional SAP system to SAP HANA. The ABAP developer needs to optimize the existing ABAP code to leverage SAP HANA's capabilities. Which of the following steps should the developer consider? Please select all the correct answers that apply. Convert all transparent tables to columnar storage. Replace all SQL statements with HANA CDS views. Utilize the power of code pushdown to move data-intensive calculations to the HANA database. Implement ALV with IDA to leverage HANA's processing capabilities. Avoid using native SQL to maintain database independence.

Which of the below statements are true for SAP HANA Studio? There are 3 correct answers to this question. SAP HANA Studio is a client tool, which can be used to access local or remote HANA. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data et. SAP HANA Studio is integrated in SAP GUI > 7.40. SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.