Real SAP E_HANAAW_17 Exam Questions and Answers For 100% Success

test2022-05-10T05:55:00+00:00

The most updated SAP E_HANAAW_17 questions and answers have been released with 174 exam questions, which have been confirmed as valid E_HANAAW_17 preparation materials. Also all the answers of the updated E_HANAAW_17 practice questions have been verified as correct ones to ensure that you can pass SAP Certified Development Specialist – ABAP for SAP HANA 2.0 Exam in the first attempt. You actually can rely on the E_HANAAW_17 practice questions for preparation and get success in actual exam.

You may now access your knowledge by taking this free E_HANAAW_17 practice test.

Page 1 of 5

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

2. Which system schema contains the list of Activated and inactive Objects?

_SYS_BIC

_SYS_REPO

_SYS_XS

_SYS_BI

3. Which SAP HANA engine executes Calculation view? (2 answers)

OLAP Engine

Calculation Engine

SQL Engine

JOIN Engine

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

5. ANSI SQL owns features and adds languages. These languages divided into three parts.

What are they? There are 3 correct answers to this question.

Data Manipulation Language

The Data Control Language

The Database Language

The Data Definition Language

Data Transferred Language

6. You analyse 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?

Note: There are 3 correct answers to this question.

SQL Monitor was activated for a specific application server

SQL monitor was activated with a filter that excludes database table Y

The data has NOT yet been transferred to the SQL monitor database tables

Program X was executed in the background.

Database table Y is a buffered table.

7. You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes.

In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer.

Open the SAP HANA transport containerSelect take snapshot and Save Activate the SAP HANA Transport Container

Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container

Open the ABAP transport request Select take snapshot and Save Activate the SAP HANA transport container

Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container

8. Discuss the basic approach of classical ABAP programming. Two answers

Collect all the data and perform parallel processing in ABAP

Creating and consuming all the contents from network

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

Keep load from the database

9. How can you exchange SQL Monitor data between two systems?

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

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.

10. You define a core data services (CDS) View.

For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question.

CASTE Expression

CASE expression

Currency Conversion

Nested CASE expression

Unit conversion

Page 2 of 5

11. You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call?

Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.

SET_PARAM_TABLE

SET_PARAM

EXECUTE_QUERY

NEXT_PACKAGE

12. Which of the below statements are true for SAP HANA Studio? (3 right answers)

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

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 a client tool, which can be used to access local or remote HANA system.

SAP HANA Studio is integrated in SAP GUI > 7.40

13. What do you understand by the SAP HANA Software Optimization? Please choose the correct answer.

Speed up the processing within the database

Bring logic to where the data is calculated first then only move to results

Provide combinations of objects and partitioning

Huge potential for hybrid database

14. What language one should know to work in SAP HAN A?

Java

ABAP

SQL

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

16. You implement an ABAP-managed database procedure (AMDP). You want to query data from Calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb.

How can you address the calculation view? Note; There are 2 correct answers to this questions.

"ha400.primdb/CA_BOOKINGS_COUNT"

_SYS_BI

"ha400.primdb::CA_BOOKINGS_COUNT"

_SYS_BI

"ha400.primdb/CA_BOOKINGS_COUNT"

17. Which conditional expressions can be used in Core Data Services (CDS) views? 2 ans

CASE statements in the projection list

IF statements in the projection list

WHILE statements in the WHERE clause

COALESCE functions in the projection list

CASE statements in the HAVING clause

18. What is Core Data Services (CDS)?

A collection of services that provide information about the data volumes of the SAP HANA core tables

A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system

A collection of core features and services that provide data from the ABAP application server layer to the user interface

A collection of domain-specific languages and services for definition and consumption of semantically rich data models

19. Where can you consume associations in a Core Data Services (CDS) view? 3 ans

In the projection list

In the name list

In the input parameter list

In the FROM clause

In the WHERE and HAVING clauses

20. You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00.

Which prereqisities are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.

View CA_CUSTOMER has deployment mode

Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK

SYSTEM P81 has SAP HANA has primary database

PACKAGE ZHA400J30 HAS deployment Mode A

Page 3 of 5

21. Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Choose the correct answer

Create data by members and tables

Insert filter components

Swap axes

Create Presentations

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

23. What should you do to follow the code-to-data approach to programming? 2 ans

Perform expensive calculations on the database

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

Perform expensive calculations on the ABAP application server.

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

24. 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?

In the Problems view

In the Project Explorer view

In the Performance Analysis view

In the Outline view of the ABAP Performance perspective

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

26. Which of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 ans

CL_SQL_EXECUTE_QUERY

CL_SQL_RESULT_SET

CL_SQL_STATEMENT

CL_EXEC_SQL

CL_ADBC_SQL_STATEMENT

27. How will you hide the attributes that are not required for client consumption? Choose the correct answer

By setting the hidden property flag of the attribute in the View

By setting the hidden property flag of the attribute provider

By setting the hidden property flag of the attribute column

By setting the hidden property flag of the attribute in the Semantics screen

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

29. Which system schema/user is the owner of all the activated objects?

_SYS_XS

_SYS_BI

_SYS_REP0

_SYS_BIC

30. What you must do when you define and implement an ABAP Managed Database Procedure AMDP? (3 ans) There are 3 correct answers to this question.

Define all the method parameters to pass by value

List all the ABAP dictionary tables used in the procedure body in the USING clause

Use Scalar types for all the AMDP method parameters

Specify the database system and language

Mark the AMDP method as read-only

Page 4 of 5

31. You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD).

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 sojd

select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd

select from snwd_so {sojd, sum(net_amount) as sum_amount}

select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount

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

33. What are functions of the ABAP Managed Database Procedure (AMDP) framework? (2 right answers)

It deletes obsolete versions of the database procedure synchronously

It deletes obsolete versions of the database procedure asynchronously

It creates the database procedure when the AMDP is first called.

It creates the database procedure when the AMDP is first activated.

34. Which of the following is true?

ABAP

OSQL

Oc#

Java

35. HANA modeling views can be created under

Catalog

Schema

File System

Content

36. According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?

Perform regular performance scans on your ABAP custom coding as part of the development process.

Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process.

Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5.

Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion.

37. What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question.

Read

Create

Delete/Edit Table

Update

38. You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node.

This is the data that goes into the aggregation node:

AT Vienna 11 AT Vienna 15 DE Berlin 13 DE Berlin 13

AT Vienna 11 AT Vienna 15 DE Berlin 13

AT Vienna 26 DE Berlin 26

AT Vienna 11 DE Berlin 13

39. Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question

HANA Accelerators

All HANA Combinations on one platform

HANA Modeling

All SAP applications on one SAP HANA platform

Business Suite on HANA/ BW on SAP HANA

40. What is the central goal of using SAP HANA? Please choose the correct answer

Positive Impact on Business

Accelerate Performance

To set Priorities for system

Monitor database for record keeping

Page 5 of 5

41. User STUDENT_A creates and activates a design-time Object. In which schema is the runtime object generated?

SYS_BI

SYSTEM

_SYS_BIC

STUDENT_A

42. You want to execute a native SQL statement in your program.

Why should you use ABAP Database Connectivity (ADBC)? (Choose Two)

It has syntax check as compile time.

It supports exception handling

It supports locking and commit handling

It supports where-used list.

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

44. How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?

Use the static method use_features of class cl_abap_dbfeatures.

Perform a static code check using the FUNCTIONAL_DB variant.

Check the Open SQL statement in the Explain SQL Statement transaction (SDBE).

Check the value of the ABAP system field sy-cdsfeatures.

Real SAP E_HANAAW_17 Exam Questions and Answers For 100% Success

Real SAP E_HANAAW_17 Exam Questions and Answers For 100% Success

Share this post

Author

Leave a Reply Cancel reply

Related Posts