Current E_HANAAW_17 Exam Dumps [2023] Complete SAP Exam Smoothly [Q91-Q110] : Best Free Exam Guide : http://free.exams4sures.com

NO.91 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

NO.92 What output does the SAP HANA provide as a unique combination of hardware and software innovations? Please choose the correct answer.

Huge potential to optimize business applications that are running on SAP HANA

The ability to create new complex processes with ABAP application cloud

Huge potential to optimize AMDP application DATA Tables

Huge potential to maximize the number of disk blocks in the application

NO.93 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

NO.94 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.

NO.95 What are the elements of ABAP Database Integration? There are 3 correct answers to this question.

Client database handling

Application server

DB client-server

Other DB

DB For ABAP

NO.96 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

NO.97 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

NO.98 You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench?

Code completion options

Code formatting options

Statement template options

Editor shortcut key options

NO.99 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)

NO.100 Which is better from performance point of view?

SQLScript Procedure

Modeling Views

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

Create

Export

Update

Read

Distribution

NO.102 Which of the following is a limitation when you create an external view? Please choose the correct answer.

You must include the name of the SAP HANA view in the name of the external view.

You can only use native SQL to consume the external view

You must know the underlying tables and join conditions of the SAP HANA view.

You must use the ABAP Development tools (ADT) TO CREATE the external view

NO.103 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

NO.104 Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? There are 3 correct answers to this question.

De-pooling and de-clustering

Changes of data class

Definition of full-text indexes

Definition of an enhancement category

Storage type for tables

NO.105 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

NO.106 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

NO.107 What is Core Data Services (CDS)?

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

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 services that provide information about the data volumes of the SAP HANA core tables

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

NO.108 How can you consume a Core Data Services (CDS) view? 2 ans

Use the Data Preview in ABAP Development Tools for SAP NetWeaver.

Use it as a data source in the FROM clause of an Open SQL query.

Use the ABAP language statement WRITE and the CDS view name as the argument.

Use the CDS maintenance transaction (SCDSV).

NO.109 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)

NO.110 You apply static code checks on your ABAP coding to find performance optimization potential and receive a message about a “Problematic SELECT * statement” issue. How can you improve the performance of your ABAP code?

Use Native SQL to perform the SELECT * statement.

Use the ABAP pragma ##OPTIMIZE_QUERY.

Use the Open SQL SELECT RELEVANT statement.

Use a field list containing only the relevant fields.