INETUM_2

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 a snapshot of the SQL Monitor data, export it to the file system, and then import it to the target system. Create and release a transport request containing the SQL Monitor log files.

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

Which of the following tools can be used for performance analysis in SAP HANA? There are 2 correct answers to this question. SQL Trace. ABAP Test Cockpit. PlanViz. SE93 Transaction Codes.

What is the primary purpose of the PlanViz tool in SAP HANA? Please choose the correct answer. To visualize SQL query execution plans. To create ABAP programs. To manage HANA security roles. To transport changes between systems.

In ABAP Development Tools for SAP NetWeaver, you execute the ABAP Test Cockpit on an ABAP program to find performance optimization potential. Where can you find the result of the static code checks? Please choose the correct answer. In the Outline view of the ABAP Performance perspective. In the Problems view. In the Project Explorer view. In the Performance Analysis view.

Which of the following object types in ABAP repository are proxy objects for SAP HANA artefacts? There are 2 correct answers to this question. SQL View. Database View. Procedure Proxy. External View.

What is the operating system supported by HANA? There are 2 correct answers to this question. Both Linux and Window 8. Red Hat Enterprise Linux (RHEL). SUSE Linux Enterprise Server. Only Windows 8.

What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question. Undelimited Identifiers. Delimited identifiers. Numeric identifiers. Limited identifiers.

While creating a Graphical Calculation view, what are the options available in Tools palette? There 4 correct answers to this question. Cast. Distinct. Projection. Join. Union. Aggregation.

Which of the statements are true for SQLScript? There are 2 correct answers to this question. SQLScript is an open standard. SQLScript is used to push down data intensive logic into the database. SQLScript is a collection of extensions to SQL.

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. EXECUTE_QUERY. SET_PARAM_TABLE. NEXT_PACKAGE.

What are the different types of Variables in HANA? There are 3 correct answers to this question. Interval. Range. Single Value. Double.

What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are 3 correct answers to this question. Display diagrams. Edit cells. Double-click on rows. Group rows. Search in content.

Which of the below statements are true for SAP HANA Studio? There are 3 correct answers to this question. SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server. SAP HANA Studio is integrated in SAP GUI > 7.40. SAP HANA Studio is a client tool, which can be used to access local or remote HANA system. 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 etc.

A retail company is using SAP HANA to analyze sales data. They want to create a model that combines data from the Products, Sales, and Customers tables and also allows for complex calculations. Which type of information view should they use? 3 Correct Answers.. Attribute View. Analytic View. Calculation View with SQL. Calculation View with Script. Column View.

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.

What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question. Automatic update for all export methods. Takes a ‘snapshot’ of all SAP HANA objects of delivery unit. Release of Transport request. Import of Transport Request. To create Transport container of delivery unit.

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 3 correct answers that apply. Replace all SQL statements with HANA CDS views. Utilize the power of code pushdown to move data-intensive calculations to the HANA database. Convert all transparent tables to columnar storage. Avoid using native SQL to maintain database independence. Implement ALV with IDA to leverage HANA's processing capabilities.

Which system schema contains the information about Time data and Schema Mapping? Please choose the correct answer. _SYS_BI. _SYS_BIC. _SYS_REPO. _SYS_XS.

Which of the following ABAP repository objects can be the data source for ALV with IDA? Please select all the 2 correct answers that apply. Transparent table. External view. Database view. CDS view.

Which data provisioning methods can you use when you need real time replications? There are 2 correct answers to this question. SAP HANA Direct extractor connection (SAP DXC). SAP Replication server. SAP Data services. SAP Landscape transformation Replication server (SAP SLT).

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

Which of the following are benefits of using Core Data Services (CDS) views in ABAP for SAP HANA? Please select all the 3 correct answers that apply. Code pushdown for better performance. Reusability of views across applications. Automatic generation of OData services. Direct integration with SAP Fiori apps.

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.

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

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

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

Max number of tables that can now be joined in new SQL? Max number of sub-queries? Please choose the correct answer. 25. 35. 10. 50.

What are the advantages of column based tables? There are 3 correct answers to this question. Better Compression. Bigger Data Set. Faster Data Access. Better parallel Processing.

For which purpose can you use literal values in an Open SQL statement? Please choose the correct answer. To comment your development directly in the coding. To perform a generic existence check. To provide a default value for a database table column. To alias the result of an arithmetic expression.

An organization is developing a complex report in their SAP S/4HANA system. The report requires multiple calculations, aggregations, and joins. They want to ensure optimal performance and leverage the capabilities of HANA. Which of the following approaches should they consider? Please select all the 3 correct answers that apply. Use traditional ABAP SELECT statements for data retrieval. Implement AMDP procedures for complex calculations. Use Core Data Services (CDS) views for data modeling. Store all data in row-based tables for faster access. Leverage the power of SQLScript for data processing in HANA.

Which SAP HANA engine executes Calculation view by default? Please choose the correct answer. OLAP Engine. Calc Engine. Join Engine. SQL Engine.

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.

Which of the following are potential functional issues when migrating ABAP code to SAP HANA? There are 2 correct answers to this question. The existence of customer-specific cluster tables. Use of secondary database connections. Use of native SQL or DB Hints. Coding that assumes that a SELECT result is always sorted. The existence of table appends.

Which recent software innovations are applied in SAP HANA? There are 3 correct answers for this question. Random Undefined Multi-Memory Swapping (RUMMS). Improved data compression algorithms. Insert Only approach. Automated de-installation at system shutdown. Columnar data storage.

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. Full-text index. Core Data service (CDS) view. Database procedure proxy. ABAP program containing new Open SQL. External view.

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.

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

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