2022 Valid E_HANAAW_17 Exam Updates - 2022 Study Guide [Q21-Q39] : Latest Exam Prep : http://certify.vceprep.com

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

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

NO.24 What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer.

Code execution

Quick Fix

Debug perspective

ABAP debugger

NO.25 You plan a database migration to SAP HANA and want to check your ABAP coding for performance optimization potential.
Which Code Inspector check variant can you use?

PERFORMANCE_OPT

CHECK_PERFORMANCE

FUNCTIONAL_DB

PERFORMANCE_DB

NO.26 In order to get language-specific data, which join is used in SAP HANA?

Referential Join

Language join

Text Join

It is not possible to fetch language-specific data in HANA

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

SQLScript Procedure

Modeling Views

NO.28 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.29 You define and implement an AM DP. What do you have to list after the USING clause? There are 3 correct answers to this question.

ABAP dictionary tables used in procedure body

ABAP dictionary views used in procedure body

CE function used in procedure Body

AMDP Used in Procedure Body

SAP HANA views used in procedure body

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

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

NO.32 What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question

Attribute view

Schema view

Column view

Analytical view

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

NO.34 Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?

“Map to Data source”

“Consume CDS view”

“Relate to Business Entity”

“Read from DDL source”

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

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

NO.37 What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question

Delimited identifiers

Limited identifiers

Undelimited Identifiers

Numeric identifiers

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

OLAP Engine

Calculation Engine

SQL Engine

JOIN Engine

NO.39 Which engine is used to execute Analytic View?

SQL Engine

Calc Engine

OLAP Engine

Join Engine