E_HANAAW_14 SAP Online Free Test

Posted by: Pdfprep Category: SAP Online Questions Tags: E_HANAAW_14 Online Questions Post Date: January 4, 2021

Pdfprep2021-01-04T22:55:39+00:00

We provide all of related E_HANAAW_14 exam questions. We provide you with the E_HANAAW_14 prep questions and answers to reflect the E_HANAAW_14 actual test. We can guarantee the wide range of SAP E_HANAAW_14 questions and the high-quality of E_HANAAW_14 exam. So if you decide to join us, you just need to spend one or two days to prepare the E_HANAAW_14 exam skillfully and remember the key knowledge of our E_HANAAW_14 prep questions, and the test will be easy for you.

Page 1 of 7

1. 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.

Analytical DBMS features

Support for system tables

High Performance and Scalability

Hybrid data and management system

2. What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct

answers to this question.

It collects monitoring data asynchronously without additional database interaction.

It schedules ABAP programs to monitor and log all database accesses.

It displays the database execution plan for all SQL statements.

It can be active in a production system with minimal performance overhead.

3. What is the main function of Static Code Analysis? Please choose the correct answer.

Integrates with SAP Solution Manager

To detect code that would lead to functional or performance issues When migrating to SAP HANA

Integrated into ABAP Development Tools and ABAP Workbench

ABAP source code with performance optimization potential

4. An Analytic Privilege consists of several restrictions.

What are they? There 3 correct answers to this question

View restrictions

Analytic restrictions

Validity restrictions

Activity restrictions

Cube restrictions

5. 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.

SELECT * statements where fewer than a specified percentage of all fields are effectively used

SELECT * statements on tables with more than a specified number of fields

SELECT * statements on tables with more than 100,000 records

SELECT * statements on tables with the Column Store storage type

6. Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question

OLAP engine

Analytic engine

OPAX engine

Join engine

7. Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment?

Please choose the correct answer.

Catalogue outlook

Modeler Perspective

System Perspective

Open Content outlook

8. What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

Use native SQL to access SAP HANA built-in functions.

Perform expensive calculations on the database.

Aggregate data on the database, and transfer the results to the ABAP layer.

Perform expensive calculations on the ABAP application server.

Transfer all data from the database to the ABAP layer, and then aggregate the results.

9. 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 UP TO n ROWS addition

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

10. What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer

The SAP HANA database supports login of Owners only

To support scenarios where clients are not directly connected to the SAP HANA Database

The assertion is issued by a user after the client was successfully authenticated

SAML may be selected as an Owner's authentication method when creating users in the SAP HANA Studio

Page 2 of 7

11. 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

Active clusters for all servers

Shared file systems for only one server

Services-Name and index server on all nodes

High availability configuration

12. Which of the following tasks can you perform with SQL monitor (transaction SQLM)? There are 1 correct answer to this question.

Display the execution plan of an SQL statement

Capture the SQL profile of an application

Combine static and dynamic performance analysis results

Search for problematic SELECT* statements

13. 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.

Data base performance monitor (transaction DB50)

Code inspector (transaction SCI)

SQL Trace (transaction ST05)

SQL monitor (transaction SQLM)

ABAP test cockpit (transaction ATC)

14. In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer

Code completion option

Statement Template options

Editor shortcut options

Code formatting option

15. What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.

Open system properties

Administration console

Development properties

System Properties

16. What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.

A new and advanced Open SQL

Core Data services

Buffer system services

Advanced and specific models

17. 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 defines the underlying SAP HANA information view.

It can be used in Open SQL statements for database updates.

It is an ABAP Dictionary object type.

It allows access to an SAP HANA information view with Open SQ

18. What are the benefits associated with The SAP HANA real-time Operational analytics? There are 2 correct answers to this question

Simplification of massive data

Fast insights into business activity

Query Speed support

High modeling flexibility

19. Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question.

Use the DDL statement DEFINE VIEW and SQL like Syntax

Create a data definition in your ABAP package

Create a proxy object for the defined view.

Specify the name of the SQL view in ABAP Dictionary

Define the type mapping between ABAP and SAP HANA

20. What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question.

Calculate aggregations using ABAP code on the application server to limit database load

Eliminate nested SELECT statements to reduce the overall number of database accesses

Use a column list in the SELECT clause to ensure that you only read a column if it is really required

Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required

Page 3 of 7

21. Open SQL largely standardized, three sub-languages.

What are these sub-languages? There are 3 correct answers to this question

Data Evaluation Language (DEL)

The Data Definition Language (DDL)

Data Transferring Language (DTL)

The Data Control Language (DCL)

Data Manipulation Language (DML)

22. What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question

Manually

By Resource console

By Importing a Landscape

Automatically

23. 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.

Documented checks

Enhanced distribution of results

Configuration of check variants

Flexible schedule of check runs

24. What are the ABAP development guidelines? There are 2 correct answers to this question.

Consuming Only ABAP contents for SAP HANA

Improved tools for performance analysis

Improved hybrid components for SAP HANA

Extensions to ABAP Language

25. What information can you specify using annotations (marked with the @ sign) when you define a CDS view in an ABAP system? There are 3 correct answers to this question.

The join conditions of the CDS view

The logic for aggregations, grouping records, and filtering groups of the CDS view

The client dependency of the CDS view

The name of the representation of the CDS view in the ABAP dictionary

The extent to which records of the CDS view should be buffered on the application server

26. 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 a static source code analysis.

Activate the new SQL Monitor in a development system.

Combine the results of the SQL Monitor with the results of an ABAP runtime analysis.

Activate the new SQL Monitor in a productive system.

27. 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

Database procedure proxy

ABAP program containing new Open SQL

Core Data service (CDS) view

External view

28. Which form of services is responsible for defining and consuming semantically rich data models. Please choose the correct answer.

Core Data Services

ITe services

Conditional services

Modell-ll services

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

Sales

Procurement

Stock

Services

Product

30. How to call the stored procedures in ABAP code? Please choose the correct answer.

Open SQL

Only SQL

Native SOL

CDS view

Page 4 of 7

31. Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question

Analytic privileges

Package privileges

Application privileges

Object privileges

System privileges

32. What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question.

Applying Code inspector

Locate database performance issues

Display record of all database access

Detect redundant or identical select statements

Locate work base issues

33. What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

Use Schema for the Connections

Maintain, Monitor and test secondary database connection

Maintain only HANA specific objects

Used to access local or remote database system

34. The source code editor in ADT provides many helpful features.

What are these helpful features? There are 2 correct answers to this question.

Creating Method Implementations from the Method Definition

Creating interface from Method Calls

Creating Method Definitions from Implementation Parts

Creating Parts for Interface Methods

35. What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment? There are 3 correct answers to this question.

Organizing

Administer

Configure

Monitor

Selecting

36. 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.

Direct access to a cluster on the database

Left outer joins in open SQL statements

Native SQL statements

Code that relies on implicit database sorting

ORDER BY Clauses in Open SQL statements

37. 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 debug as option in the context menu of the ABAP program

Create a debug configuration for the ABAP application and run the program

Set a breakpoint in the ABAP program and execute the program

Choose the Run --> Debug options in the menu

38. 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 the table has a small number of records

When there are mainly distinct values in the table

When you want to enable a full-text-search of the table

39. 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 application suggests the column name and data type for the new tables, and it is possible to edit them

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

40. Which features does the source code editor provide in ABAP Development Tools (ADT)? There are 2 correct answers to this question.

Quick Fix

Screen Painter

Content Assist

Form-based Class Builder

Page 5 of 7

41. You created and activated database procedure.

How can you call this procedure? There are 2 correct answers to this question.

By another database procedure

By using Sap Analysis for Microsoft office

By a script-based calculation view

By a core data services view

42. What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question.

A set of open, language- and platform-independent APIs

A brand new ABAP development experience on top of the Eclipse platform

An open platform for developing new ABAP-related tools

An open platform for developing powerful database view

A set of Eclipse data pool and Client- Open platform

43. When are referential joins executed in analytical views? Choose the correct answer

When all the tables are optimized

When fields are selected

When fields are optimized

When fields from both the tables are requested

44. Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? There are 2 correct answers to this question.

Partitioning

Database table compression

Column data storage

Parallel processing

45. Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer.

Programming model

Table buffering

New advanced SQL syntax Procedures

ABAP-Managed Database Procedures

46. What made SAP HANA possible?

There are 2 correct answers to this question.

Improved hardware technology

CPU with single core network

RAM limitation

Technology and innovations

47. When to use Enhanced Open SQL? There are 2 correct answers to this question.

To view scalar components

At the time of Dictionary Views

Need the query in one piece of code only

To access system fields

48. 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 Landscape view

The System Monitor view

The Security view

The Administration view

49. You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks the validity of its importing parameters and calls method Y.

What pattern of gross and net run time would you expect to see the in the ABAP trace results for method X? Please choose the correct answer.

The gross and net run times are identical

The net run time is less than the gross run time

The net run time is equal to Zero

The net run time is greater than the gross run time

50. Which of the following are view annotations for a CDS view? There are 3 correct answers to this question.

Semantics

Client handling

Buffering type

Environment

Access control

Page 6 of 7

51. What are the Parameters for Analytical and Calculation view? There are 3 correct answers to this question.

Specifying unit of measurement

Passing other values to be used in calculations

Create a copy of a report

To store data for critical analysis

Setting a filter for columns

52. What is the purpose of an ABAP project in ABAP Development Tool for eclipse? There are 2 correct answers to this question

It represents the connection to an ABAP System

It provides access to all ABAP repository objects in an ABAP system

It represents the connection to the SAP HANA Layer

It is used to transport the ABAP repository Objects.

53. Which of the following is not involved in database table of "The NewABAP SQL Monitor-Architecture? Choose the correct answer

Selection data table

Performance data table

Critical data table

Runtime monitor data

54. 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.

Returning

Receiving

Exporting

Changing

Importing

55. Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question.

Get all the data you need on the application server and do your processing in ABAP

Creating and consuming all the contents from network

Keep load from the database

Collect all the data and perform Parallel processing in ABAP

56. Which code-to-data capability is responsible for the Optimizations & Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL? Please choose the correct answer.

Database Optimization

Transparent Optimizations

HANA Specific features

Buffer system Optimization

57. What are the two types of editors available in ADT? There are 2 correct answers to this question.

Eclipse (native)

Client (native)

SAP (GUI)

ABAP (native)

58. Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.

Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

Use array variants of INSERT UPDATE MODIFY and DELETE

Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES

Perform all calculations and aggregations in the ABAP layer

59. The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.

Avoid idiling CPU cores

Avoid CPU cache misses

Avoid optimizing data

Avoid single network

60. Discuss the conditions required to ensure the Referential Integrity? There are 2 correct answers to this question

There are three joins in the table

Referential integrity holds true in both the directions

There is at least one join in the other table

There are two joins in the table

Page 7 of 7

61. What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.

Process on all the input fields

Automatic updates of all the input fields

Check Pre-Requisites

Identify Elementary Search Help

Switch on proposal search for input fields

62. Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer.

Combine information from static ABAP code scans with runtime data from the SQL Monitor.

Create a graph comparing the runtimes of ABAP code before and after optimization.

Estimate the new total runtime of optimized code.

Combine information from static ABAP code scans with runtime data from the SQL Trace tool.

63. 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.

ACID search

Freestyle search

Isolation search

Fuzzy search

Linguistic search

64. 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.

ROW

GLOBAL TEMPORARY

COLUMN

LOCAL TEMPORARY