[Apr-2023] Updated and Accurate E_HANAAW_17 Questions & Answers for passing the exam Quickly [Q92-Q108] : Exam for engine : http://blog.test4engine.com

Q92. What is the language SAP HANA is developed in?

Assembly

C++

Java

Q93. AM DP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers to this question.

UNION specific syntax errors

Database platform syntax errors

Database independent syntax errors

HANA specific syntax errors

SQLScript errors

Q94. Which of the following is true?

ABAP

OSQL

Oc#

Java

Q95. You want to implement business logic on the database layer.
Which approach do you follow when implementing an ABAP Managed Database Procedure?

The Left-Right approach

The Near-Far approach

The Top-Down approach

The Inside-Out approach

Q96. What are the features associated with ABAP CDS? There are 3 correct answers to this question.

Create

Export

Update

Read

Distribution

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

Q98. What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

All arithmetic expressions can be used for all type of variables

All ABAP variables must be escaped with a proceeding @ sign.

All Keywords are case sensitive.

All fields in the GROUP BY clause must be separated by commas.

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

Q100. What are the Possible Approaches with AS ABAP < 7.4 SP02? There are 2 correct answers to this question

SQL units

Consume using native SQL

Stored Procedures

Interaction with Database

Q101. 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 dat a. 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.

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

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

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

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

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

SQLM

SE09

SWLT

ST22

SE3S

Q107. You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

:it_books

it_books

{it.books}

@it_books

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

Bigger Data Set

Better Compression

Better parallel Processing

Faster Data Access

[Apr-2023] Updated and Accurate E_HANAAW_17 Questions & Answers for passing the exam Quickly [Q92-Q108]

Exam Preparation of SAP E_HANAAW_17: SAP Certified Development Specialist - ABAP for SAP HANA 2.0