SAP Certification E_HANAAW_17 Training Material

dumps2022-02-25T02:33:44+08:00

SAP Certified Development Specialist E_HANAAW_17 exam training material is available, which is helpful for you to pass the test. In real SAP certification E_HANAAW_17 exam, there are 40 questions, and you have 90 minutes to write the test. The required passing score of SAP E_HANAAW_17 exam is 56%. The available language is English. Free SAP certification E_HANAAW_17 exam training material is below.

Page 1 of 6

1. What can you include in the projection list of a Core Data Services (CDS) view? 3 ans

ABAP system fields such as sy-langu or sy-mandt / CI String constants and literal values

Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause

A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause

A field from the projection list of another CDS view used in the FROM clause

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

3. Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question

Convert crosstab cells to formula

Analyze data with the design pane

Suggests style sets for crosstabs

Sort data by characteristics

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

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

6. Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA? Note: There are 2 correct answers to this question.

Keep unnecessary load away from the database.

Minimize the number of database accesses

Minimize the amount of transferred data

Minimize the search overhead.

7. DB-Specific Properties that allows switching between storage types when running on an SAP HANA database.

What are these storage types? There are 2 correct answers to this question.

Column store

Development Store

Row store

Technology store

Re-use component store

8. You define and implement an ABAP Managed database procedure (AMDP).

What do you have to list after the USING clause? (3 right answers)

ABAP Dictionary views used in the procedure body

ABAP Dictionary table used in the procedure body

AMDP used in the procedure body

function used in the procedure body

SAP HANA views used in the procedure body

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

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

Page 2 of 6

11. Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?

Existence check for secondary indexes

Use of Native SQL and DB Hints

Missing ORDER BY or SORT after SELECT

Direct access to table pools/cluster

12. Analytic Privilege can be applied to (3 Answers)

Calculation views

Attribute views

Analytic views

Table

SQL View

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

14. Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 ans

FOR db (db = HD

..)

LANGUAGE dbjang (dbjang = SQLSCRIP

..)

BY DATABASE PROCEDURE

CLIENT SPECIFIED

AUTHORIZATION db_auth (db_auth = SYSTE

..)

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

Double-click on rows

Search in content

Edit cells

Group rows

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

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

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

Used to access local or remote database system

Maintain, Monitor and test secondary database connection

Use Schema for the Connections

Maintain only HANA specific objects

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

20. Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question

Calculation views

ABAP managed database procedures

Stored procedure

Core data services views

Page 3 of 6

21. Which is better from performance point of view?

SQLScript Procedure

Modeling Views

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

23. You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method.

Which additional steps are necessary to retrieve the result set into an internal table? 2 ans

Close the CL_SQL_STATEMENT object to release the resources.

Use an Open SQL query that uses the JOIN between the result set and the internal table as a data source.

Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance.

Fetch the result using the next_package method of class CL_SQL_RESULT_SE

Fetch the result using the fetch method of class CL_SQL_EXECUT

24. Which of the statements are true for SQLScript? (2 answers)

SQLScript is an open standard.

SQLScript is used to push down data intensive logic into the database.

SQLScript is a collection of extensions to SQ

25. In addition to closing the result set. what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer.

Release resources

Update resources

Update packages

26. You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA.

Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer.

Read-write

Read only

Write only

Read-update

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

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

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

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

Because you always transport entire SAP HANA content packages

Because you use the technique that is recommended by SAP

Because you automatically add changed objects to the transport request

30. Why is a security concept in SAP HANA required? There are 2 correct answers to this question

Need to have selected users in SAP HANA for Information Management

Access to ERP tables must be restricted

Editing of SAP HANA data models should only be possible for "Users" of the model

Database administration should be restricted to skilled

Page 4 of 6

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

32. Which statement is true for SAP HANA?

SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners

SAP provides both hardware and software for SAP HAN

33. Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.

ABAP Dictionary

Open SQL

Core data services (CDS) data definition

Core data services (CDS) access control

34. Which system schema contains the column views of activated objects?

_SYS_BI

_SYS_REPO

_SYS_XS

_SYS_BIC

35. You developed an ABAP program using ABAP Development Tools for SAP NetWeaver.

How can you execute it? 2 ans

In the Project Explorer view, right-click the program and choose Run As ― ABAP Application from the context menu.

Use the Open Development Object dialog (CTRL+SHIFT+A) and enter <Program_Name>/Execute in the search field.

Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8.

Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl.

Call transaction SRUN_ADT and enter the name of the ABAP program.

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

37. Which components can be a part of a calculation view? (2 answers)

BAPIs

Analytic View

Tables

Attribute View

38. What is the main advantage of SQLScript? (2 answers)

SQLScript can be better modularized than traditional SQL

SQLScript code can easily be translated into modeling view

SQLScript is faster than traditional SQL

39. How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement? Please choose the correct answer.

As many result sets as there are input parameters in the procedure

Two result sets

One result set

As many result sets as there are table output parameters in the procedure

40. What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?

The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyFie

The CDS views used in the FROM clause

The entire CDS view

The elements in the projection list of the CDS view

Page 5 of 6

41. 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)

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

43. What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question

Account-based Profitability

Costing-based Profitability

Product-based Profitability

Service-based profitability

44. Which of the following is not an element of Analytical view? Please choose the correct answer.

Currency conversion is not applicable

Join fact tables

Read Data from the joined database tables

Used to Joined table

45. What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers)

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

It represents the connection to an ABAP system

It represents the connection to the SAP HANA server

It is used to transport ABAP repository objects

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

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

48. Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?

Service Adaptation Description Language (SADL)

Process Agent Framework (PAF)

ABAP Messaging Channels (AMC)

ABAP Managed Database Procedures (AMDP)

49. Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?

Standard Web Dynpro checks

Search for DB operations across modularization units

SELECT statements that bypass the table buffer

Use of the ADBC interface

50. 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)

Page 6 of 6

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

52. 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"

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

SAP Certification E_HANAAW_17 Training Material

SAP Certification E_HANAAW_17 Training Material

Share this post

Leave a Reply Cancel reply

Related Posts