E_HANAAW_18 Online Practice Questions and Answers

SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANAhas to meet. What are these goals?

There are 2 correct answers to this question.

A. Analytical DBMS features

B. Support for system tables

C. High Performance and Scalability

D. Hybrid data and management system

You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statement check. What does this check report? Please choose the correct answer.

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 more than 100,000 records

D. SELECT * statements on tables with the Column Store storage type

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?

Note: There are 2 correct answers to this question.

A. Because you can manually re-deploy objects after a failed import

B. Because you always transport entire SAP HANA content packages

C. Because you use the technique that is recommended by SAP

D. Because you automatically add changed objects to the transport request

How can you exchange SQL Monitor data between two systems?

A. Create a snapshot of the SQL Monitor data, export it to the file system, and then import it to the target system.

B. Deactivate the SQL Monitor in the source system and activate the SQL Monitor in the target system.

C. Configure a secondary database connection to the target system and query the data in the SQL Monitor.

D. Create and release a transport request containing the SQL Monitor log files.

List down the elements involved in User Management and Security in SAP Hana? There are 3 correct answers to this question

A. Manage users

B. Assign Job security

C. Assign security

D. Work Management

E. Create users

While creating a Graphical Calculation view, what are the options available in Tools palette? (4 answers)

A. Union

B. Cast

C. Aggregation

D. Projection

E. Join

F. Distinct

Which system schema contains the column views of activated objects?

A. _SYS_BI

B. _SYS_REPO

C. _SYS_XS

D. _SYS_BIC

Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 answers

A. SQLM

B. SE09

C. SWLT

D. ST22

E. SE3S

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? Note: There are 3 correct answers to this question.

A. Replace UP TO n ROWS additions

B. Specify the schema for every table

C. Replace ORDER BY additions

D. Replace CORRESPONDING FIELDS additions

E. Add explicit client handling

What are the advantages of column based tables? (3 correct answers)

A. Bigger Data Set

B. Better Compression

C. Better parallel Processing

D. Faster Data Access