Independence Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

E_HANAAW_17 Questions and Answers

Question # 6

What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

A.

Use Schema for the Connections

B.

Maintain, Monitor and test secondary database connection

C.

Maintain only HANA specific objects

D.

Used to access local or remote database system

Full Access
Question # 7

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

A.

Code execution

B.

Quick Fix

C.

Debug perspective

D.

ABAP debugger

Full Access
Question # 8

You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP

HANA is used as the db

In the check parameters, which value would you use for the percentage of fields that are effectively used?

Please choose the correct answer.

A.

A value that you calculate based on the number of tables

B.

A higher value than on a traditional, row-store only based database

C.

A lower value than on a traditional, row-store only based database

D.

The same value as on a traditional, row-store only based database

Full Access
Question # 9

What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.

A.

Server based on SAP HANA

B.

Innovation based on SAP HANA

C.

New or Native SAP HANA

D.

Data Mart based on SAP HANA

Full Access
Question # 10

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.

A.

Database Optimization

B.

Transparent Optimizations

C.

HANA Specific features

D.

Buffer system Optimization

Full Access
Question # 11

You want to implement business logic on the database layer.

Which approach do you follow when implementing an ABAP Managed Database Procedure?

A.

The Left-Right approach

B.

The Near-Far approach

C.

The Top-Down approach

D.

The Inside-Out approach

Full Access
Question # 12

Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.

A.

CDS View

B.

Database procedure

C.

External view

D.

Database Table

E.

Internal table

Full Access
Question # 13

Which form of services is responsible for defining and consuming semantically rich data models. Please choose the correct answer.

A.

Core Data Services

B.

ITe services

C.

Conditional services

D.

Modell-ll services

Full Access
Question # 14

When are referential joins executed in analytical views? Choose the correct answer

A.

When all the tables are optimized

B.

When fields are selected

C.

When fields are optimized

D.

When fields from both the tables are requested

Full Access
Question # 15

You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statement check. What does this check report? Please choose the correct answer.

A.

SELECT * statements where fewer than a specified percentage of all fields are effectively used

B.

SELECT * statements on tables with more than a specified number of fields

C.

SELECT * statements on tables with more than 100,000 records

D.

SELECT * statements on tables with the Column Store storage type

Full Access
Question # 16

In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? Please choose the correct answer.

A.

Include all fields used in the ON condition in projection list

B.

Specify an alias for the target entity

C.

Define the cardinality for the target entity

D.

Specify the other views in which the association can be used

Full Access
Question # 17

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

A.

Create data by members and tables

B.

Insert filter components

C.

Swap axes

D.

Create Presentations

Full Access
Question # 18

What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.

A.

Open system properties

B.

Administration console

C.

Development properties

D.

System Properties

Full Access
Question # 19

Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL

SELECT statement. Which of the following changes to the SELECT statement can you use to retrieve the same data as

before?

There are 2 correct answers to this question

A.

Include the client field in the field list.

B.

Include the client field in the WHERE condition.

C.

Include the client field in the join condition.

D.

Use the CLIENT SPECIFIED addition.

Full Access
Question # 20

What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question

A.

Fewer data duplication and movement

B.

Exploit structured contents in SQL

C.

Easy to use modeling tool

D.

Large number of toolkits are available

Full Access
Question # 21

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 22

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?

A.

PERFORMANCE_OPT

B.

CHECK_PERFORMANCE

C.

FUNCTIONAL_DB

D.

PERFORMANCE_DB

Full Access
Question # 23

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

A.

Positive Impact on Business

B.

Accelerate Performance

C.

To set Priorities for system

D.

Monitor database for record keeping

Full Access
Question # 24

What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question.

A.

Calculate aggregations using ABAP code on the application server to limit database load

B.

Eliminate nested SELECT statements to reduce the overall number of database accesses

C.

Use a column list in the SELECT clause to ensure that you only read a column if it is really required

D.

Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required

Full Access
Question # 25

What is the operating system supported by HANA? (2 correct answers)

A.

Only Windows 8

B.

Red Hat Enterprise Linux (RHEL)

C.

SUSE Linux Enterprise Server

D.

Both Linux and Window 8

Full Access
Question # 26

Which of the following can be part of an analytic view? (3 answers)

A.

Query transformation

B.

Logical joins

C.

Attributes

D.

Data foundation

E.

Unions

Full Access