[E_HANAAW_17] SAP Certification Dump

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

DUMP

Q1) Which data sources can you use for SAP list viewer with integrated data access?

There are 3 correct answers to this question.

1 point

Database Procedure

Database Table

Internal table

CDS View

External view

Required

Q2) Which task does the ABAP Managed Database Procedure (AMDP) framework perform? *

1 point

Deploy the database procedure whenever the AMDP is called.

Deploy the database procedure whenever the AMDP is activated.

Deploy the database procedure when the AMDP is first activated.

Deploy a new version of the database procedure when the AMDP is first called

Q3) Which of the following are characteristics of an external view?

There are 3 correct answers to this question. *

1 point

It is an ABAP Dictionary object type.

It can be used as a data type in ABAP programs.

It can be used in Open SQL statements for database updates.

It defines the underlying SAP HANA information view.

It allows access to an SAP HANA information view with Open SQL.

Required

Q4) Which is the new concept that is introduced and improved by using SAP HANA Specific Features? *

1 point

New advanced SQL syntax Procedures

Table buffering

Programming model

ABAP-Managed Database Procedures

Q5) What are the components of The Enterprise Procurement Model Demo Scenario?

There are 3 correct answers to this question. *

1 point

Services

Sales

Stock

Product

Procurement

Required

Q6) How SAP HANA supports SQL?

There are 3 correct answers to this question. *

1 point

Manipulate data

Read

As a Data Calculator

As a means to define

transferring data

Required

Q7) You have created a CDS view as follows

Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT? *

1 point

_flights.carrid and _flights.planetype

carrid and _flights.planetype

carrid and planetype

_flights.carrid and planetype

Q8) You developed an ABAP managed database procedure (AMDP).
You want to allow the enhancement of this AMDP using business add-in (BADI).

Which of the following objects must you create?

There are 3 correct answers to this question. *

1 point

AN enhancement spot

A BADI fallback implementation

A BADI simple implementation

A database procedure

A BADI definition

Required

Q9) You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks the validity of its importing parameters and calls method Y.
What pattern of gross and net run time would you expect to see the in the ABAP trace results for method X? *

1 point

The net run time is greater than the gross run time

The gross and net run times are identical

The net run time is equal to Zero

The net run time is less than the gross run time

Q10) Your customer wants to migrate to SAP HANA and you want to identify which business processes should be optimized.

Which of the following steps must you perform to get this information?

There are 2 correct answers to this question. *

1 point

Combine the results of the SQL Monitor with the results of an ABAP runtime analysis.

Combine the results of the SQL Monitor with the results of a static source code analysis.

Activate the new SQL Monitor in a development system.

Activate the new SQL Monitor in a productive system.

Required

Q11) You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data?

There are 3 correct answers to this question. *

1 point

Use the UP TO n ROWS addition

Specify the database schema if it is not the user's default schema

Use a Comma-separated column list

Explicitly handle the client field

Use the tilde symbol (~) to separate qualifier from column name

Required

Q12) Name some perspectives that are available in the SAP HANA Studio?

There are 3 correct answers to this question. *

1 point

The Information perspective

The technology & innovation perspective

The Administration Console perspective

The Resources perspective

The SAP HANA Modeler perspective

Required

Q13) Discuss the main capabilities of SAP BusinessObjects Analysis for Office?

There are 2 correct answers to this question. *

1 point

Suggests style sets for crosstabs

convert crosstab cells to formula

Sort data by characteristics

Analyze data with the design panel

Required

Q14) Which system schema contains the list of Activated and inactive Objects? *

1 point

_SYS_BI

_SYS_BIC

_SYS_XS

_SYS_REPO

Q15) Which is not a key factor of ALV for HANA? *

1 point

Derived Column headings from the data element

The data display is restricted to a maximum of 2 billion cells

To supply suitable values for any input parameters

To Activate and execute the program in the application

Q16) Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment? *

1 point

Open Content outlook

Modeler Perspective

Catalogue outlook

System Perspective

Q17) What are the benefits associated with The SAP HANA real-time Operational analytics?

There are 2 correct answers to this question. *

1 point

High modeling flexibility

Fast insights into business activity

Query Speed support

Simplification of massive data

Required

Q18) You have created a CDS view and used aias names for some of its elements.
In which of the following cases is the alias name mandatory?

There are 3 correct answers to this question. *

1 point

CASE order type WHEN 'A' THEN 1 ELSE 0 END AS order_type

ASSOCIATION TO sflight AS _flights

SUM(revenue) AS total_revenue

crtdby AS created_by

CAST('USO' AS abap.cuky) AS currency_key

Required

Q19) Which of the following is not an element of Analytical view? *

1 point

Join fact tables

Read Data from the joined database tables

Used to Joined table

Currency conversion is not applicable

Q20) What information can you specify using annotations (marked with the @ sign) when you define a Core Data Services (CDS) view in an ABAP system?

There are 3 correct answers to this question *

1 point

The extent to which records of the CDS view should be buffered on the application server

The logic for aggregations, grouping records, and filtering groups of the CDS view

The name of the SQL View created in the database

The join conditions of the CDS view

The link between an amount field and the relevant currency code

Required

Q21) Which task can you perform with the SQL Monitor (transaction SQLM)? *

1 point

Capture the SQL profile of an application.

Search for problematic SELECT statements.

Display the execution plan of an SQL statement.

Combine static and dynamic performance analysis results.

Q22) Explain the Enterprise Information System of - SAP HANA Implementation Scenarios?

There are 3 correct answers to this question. *

1 point

All SAP applications on one SAP HANA platform

HANA Accelerators

Business Suite on HANA / BW on SAP HANA

HANA Modeling

All HANA Combinations on one platform

Required

Q23) What are best practices when programming in ABAP for SAP HANA?

There are 2 correct answers to this question. *

1 point

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

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 repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required

Required

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

1 point

Database procedure proxy

Full-text index

ABAP program containing new Open SQL

Core Data service (CDS) view

External view

Required

Q25) What are the uses of SQL Trace (ST05)?

There are 3 correct answers to this question. *

1 point

Display record of all database access

Locate work base issues

Applying Code inspector

Detect redundant or identical select statements

Locate database performance issues

Required

Q26) 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. *

1 point

Definition of an enhancement category

Definition of full-text indexes

Storage type for tables

Changes of data class

De-pooling and de-clustering

Required

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

1 point

Service Adaptation Description Language (SADL)

ABAP Managed Database Procedures (AMDP)

ABAP Messaging Channels (AMC)

Process Agent Framework (PAF)

Q28) Explain how and when to create calculated columns - Using Graphical Modeling Tools?

There are 3 correct answers to this question. *

1 point

Calculated columns also support non-measure attributes as part of the calculation.

Time characteristics based calculation columns.

The calculation could be an arithmetic or character manipulation.

The calculation will be opened in a read-only mode.

It is possible to nest so that one calculated column, in turn, is based on other calculated columns

Required

Q29) What made SAP HANA possible?

There are 2 correct answers to this question. *

1 point

Technology and innovations

RAM limitation

Improved hardware technology

CPU with single core network

Required

Q30) 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? *

1 point

Release resources

Release packages

Update packages

Update resources

Q31) What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling?

There are 2 correct answers to this question. *

1 point

Product-based Profitability

Service-based profitability

Costing-based Profitability

Account-based Profitability

Required

Q32) You are debugging in ABAP Development Tools in Eclipse. What features are available?

There are 2 correct answers to this question. *

1 point

Debugger scripting

Memory usage analysis

Watch points

Conditional breakpoints

Required

Q33) When to use Enhanced Open SQL?

There are 2 correct answers to this question *

1 point

Need the query in one piece of code only

To view scalar components

To access system fields

At the time of Dictionary Views

Required

Q34) Which is not a Golden Rule for Open SQL? *

1 point

Minimize the Amount of Data Transferred

Reduce the Database Load

Keep the result set large

Minimize the Number of Database Accesses

Q35) Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA?

There are 2 correct answers to this question *

1 point

Perform all calculations and aggregations in the ABAP layer

Use array variants of INSERT UPDATE MODIFY and DELETE

Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES

Required

Q36) Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? *

1 point

Create data by members and tables

Create Presentations

Insert filter components

Swap axes

Q37) 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. *

1 point

Process on all the input fields

Check Pre-Requisites

Automatic updates of all the input fields

Switch on proposal search for input fields

Identify Elementary Search Help

Required

Q38) List down the elements involved in User Management and Security in SAP HANA?

There are 3 correct answers to this question. *

1 point

Create users

Assign job security

Manage users

Assign security

Work management

Required

Q39) The SAP HANA state-of-the-art search experience includes full-text search with advanced features like...

There are 3 correct answers to this question. *

1 point

Fuzzy search

freestyle search

ACID search

Isolation search

linguistic search

Required

Q40) What are the different types of Variables in HANA?

There are 3 correct answers to this question *

1 point

Single Value

Ranges

Double

Interval

Required

Q41) What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster?

There are 2 correct answers to this question. *

1 point

Services-Name and index server on all nodes

Active clusters for all servers

High availability configuration

Shared file systems for only one server

Required

Q42) 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. *

1 point

ROW store

Technology store

Column store

Development Store

Re-use component store

Required

Q43) 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?
There are 2 correct answers to this question. *

1 point

Because you always transport entire SAP HANA content packages.

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

Because you use the technique that is recommended by SAP.

Because you automatically add changed objects to the transport request.

Required

Q44) Discuss the basic approach of classical ABAP programming?

There are 2 correct answers to this question. *

1 point

Keep load from the database

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

Required

Q45) Which system schema contains the column views of activated objects? *

1 point

_SYS_XS

_SYS_BI

_SYS_REPO

_SYS_BIC

Q46) What are the steps that supported several tools, which in total result in a Guided Performance Optimization?

There are 2 correct answers to this question. *

1 point

A new tool called SQL Monitor to determine the priority if different programs access the database intensively

A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.

Tools analyzing performance at run-time, to determine if critical constructs

The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption

Required

Q47) What all are the factors involved in Working with ADT

There are 3 correct answers to this question. *

1 point

ABAP interface

ABAP programs

ABAP Class

Workbench programs

Module interface

Required

Q48) What all are the Types of Applications based on SAP HANA?

There are 2 correct answers to this question. *

1 point

Server based on SAP HANA

New or Native SAP HANA

Data Mart based on SAP HANA

Innovation based on SAP HANA

Required

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

1 point

"Consume CDS view"

"Read from DDL source"

"Map to Data source"

"Relate to Business Entity"

Q50) Explain Transitioning ABAP Code to SAP HANA – Performance Considerations?

There are 3 correct answers to this question. *

1 point

Some codes immediately run faster

Some codes transferred to other systems

Some codes impacted positively and should be priorities

Classical performances recommendations for open SQL remain valid

Some shifts in priorities, examples, nested selects(higher) indices(lower)

Required

Q51) Which of the following features were added to the ABAP dictionary to support the SAP HANA database?

There are 3 correct answers to this question.

1 point

Definition of enhancement category

De-pooling and de-clustering

Storage type for tables

Definition of full-text indexes

Change of data class

Required

Q52) What are the benefits includes with SAP HANA Full Text Search?

There are 2 correct answers to this question. *

1 point

Large number of toolkits are available

Easy to use modeling tool

Exploit structured contents in SQL

Fewer data duplication and movement

Required

Q53) You plan a database migration to SAP HANA and want to check your ABAP coding for potential functional regressions.

Which Code Inspector check variant can you use? *

1 point

PREV_FUNC_REG

FUNCTIONAL_DB

FUNCTIONAL_CHECK

PERFORMANCE_DB

Q54) Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”? *

1 point

Critical data table

Performance data table

Runtime monitor data

Selection data table

Q55) What are the two main methods to add a system to the SAP HANA Studio?

There are 2 correct answers to this question. *

1 point

Manually

By Importing a Landscape

Automatically

By Resource console

Required

Q56) You want to access SAP HANA view CA BOOKINGCOUNT in package ha400.primdb via a native SQL query. Which of the following are correct ways of specifying package path and object name in the FROM clause

There are 2 correct answers to this question. *

1 point

FROM SYS BIC."ha400.primdb/CA BOOKINGS COUNT"

FROM "ha400.primdb/CA BOOKINGS COUNT"

FROM SYS BIC."ha400.primdb::CA BOOKINGS COUNT"

FROM "ha400.primdb::CA BOOKINGS COUNT"

Required

Q57) Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources? *

1 point

Content folder

Security folder

Provisioning folder

Administration folder

Q58) 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? *

1 point

it_books

:it_books

{it_books}

@it_books

Q59) Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA?

There are 2 correct answers to this question. *

1 point

Partitioning

Database table compression

Columnar data storage

Parallel processing

Required

Q60) What are the Parameters for Analytical and Calculation view?

There are 3 correct answers to this question. *

1 point

Passing other values to be used in calculations

Setting a filter for columns

Create a copy of a report

Specifying unit of measurement

To store data for critical analysis

Required

Q61) Which SAP HANA engine executes Calculation view by default? *

1 point

SQL Engine

OLAP Engine

Calc Engine

Join Engine

Q62) ANSI SQL owns features and adds languages these languages divided into three parts.
What are they?

There are 3 correct answers to this question. *

1 point

The Database Language

The Data Transferred Language

The Data Definition Language

The Data Manipulation Language

The Data Control Language

Required

Q63) You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL.

Which of the following are necessary adjustments?
There are 3 correct answers to this question. *

1 point

Replace ORDER BY additions.

Add explicit client handling.

Replace CORRESPOND ING FIELDS additions.

Replace UP TO n ROWS additions.

Specify the schema for every table.

Required

Q64) You create a check variant in the Code Inspector
which includes the check 'Search problematic Select * statements'.
SAP HANA is used as the database. In the check parameters,

which value would you use for the percentage of fields that are effectively used *

1 point

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

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

A value that you calculate based on the number of tables

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

Q65) What are the Possible Approaches with AS ABAP < 7.4 SP02?

There are 2 correct answers to this question. *

1 point

Consume using native SQL

Interaction with Database

Stored Procedures

SQL units

Required

Q66) You created and activated database procedure.
How can you call this procedure?

There are 2 correct answers to this question. *

1 point

By a script-based calculation view

By another database procedure

By using Sap Analysis for Microsoft office

By a core data services view

Required

Q67) What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA?

There are 3 correct answers to this question. *

1 point

Innovate

Detect

Scaling

Tuning

Optimize

Required

Q68) The SAP HANA database is a hybrid in-memory database that combines Few technologies within. What are these technologies?

There are 3 correct answers to this question. *

1 point

Time-based database technology

Column-based database technology

Object-based database technology

Row-based database technology

Value-based database technology

Required

Q69) You import an ABAP workbench request into an SAP SYSTEM P81.
The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package ZHA400_00.

WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database?

There are 2 correct answers to this question. *

1 point

Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK

PACKAGE ZHA400_00 HAS deployment Mode A

View CA_CUSTOMER has deployment mode A.

SYSTEM P81 has SAP HANA as primary database

Required

Q70) What are the different types of Calculation View?

There are 2 correct answers to this question. *

1 point

Scripted Calculation View

Graphical Calculation View

Text-Based Calculation

OLAP Calculation View

Required

Q71) 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. *

1 point

Exporting

Returning

Changing

Receiving

Importing

Required

Q72) Which steps do you have to perform when defining a view using core data services (CDS)?

There are 3 correct answers to this question. *

1 point

Use the DDL statement DEFINE VIEW and SQL like Syntax

Create a data definition in your ABAP package

Specify the name of the SQL view in ABAP Dictionary

Define the type mapping between ABAP and SAP HANA

Create a proxy object for the defined view.

Required

Q73) Which form of services is responsible for defining and consuming semantically rich data models? *

1 point

Conditional services

ITe services

Core Data Services

Modell-II services

Q74) What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container?

There are 2 correct answers to this question. *

1 point

Take snapshot manually before releasing of the container

You need to refresh the content of the container manually

Changes to Delta Container

Automatic release of units

Required

Q75) 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. *

1 point

ABAP test cockpit (transaction ATC)

Code inspector (transaction SCI)

Data base performance monitor (transaction DB50)

SQL Trace (transaction ST05)

SQL monitor (transaction SQLM)

Required

Q76) What are the two layers of ABAP system interacts with its database?

There are 2 correct answers to this question. *

1 point

The Database specific library

The Database independent interface

The Data Storage interface

The Client database interface

Required

Q77) What views will be most efficient for General Modeling Principles?

There are 2 correct answers to this question *

1 point

Schema view

Analytical view

Column view

Attribute view

Required

Q78) Which of the Golden Rules for Open SQL Performance have become more important with SAP HANA?

There are 2 correct answers to this question. *

1 point

Minimize the number of database accesses.

Minimize the search overhead.

Keep unnecessary load away from the database.

Minimize the amount of transferred data.

Required

Q79) What is the main function of Static Code Analysis? *

1 point

ABAP source code with performance optimization potential

To detect code that would lead to functional or performance issues When migrating to SAP HANA

Integrated into ABAP Development Tools and ABAP Workbench

Integrates with SAP Solution Manager

Q80) Which of the following are view annotations for a CDS view?

There are 3 correct answers to this question. *

1 point

Buffering type

Semantics

Client handling

Access control

Environment

Required

Q81) What are the Functions of Transaction DBACOCKPIT?

There are 2 correct answers to this question. *

1 point

Use Schema for the Connections

Used to access local or remote database system

Maintain, Monitor and test secondary database connection

Maintain only HANA specific objects

Required

Q82) In a Graphical calculation view you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS.

How can you achieve this in a union node?

There are 2 correct answers to this question. *

1 point

Create a restricted column for the ADDRESS field

Exclude the ADDRESS field from the union

Map the ADDRESS field to a constant value

Create an input parameter for the ADDRESS field

Required

Q83) An Analytic Privilege consists of several restrictions. What are they?

There are 3 correct answers to this question. *

1 point

View restrictions

Analytic restrictions

Validity restrictions

Activity restrictions

Cube restrictions

Required

Q84) Where can you consume associations in a Core Data Services (CDS) view?

There are 3 correct answers to this question. *

1 point

In the WHERE and HAVING clauses

In the projection list

In the input parameter list

In the name list

In the FROM clause

Required

Q85) You perform a static code check using the Code Inspector (SCI).
In your SCI variant, you select the Search problematic SELECT * statements check.

What does this check report?

1 point

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

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

SELECT * statements on tables with the Column Store storage type

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

Q86) To upload data from flat files, SAP HANA offers several features.
What are these important features?

There are 2 correct answers to this question. *

1 point

The new table always has a 2:2 mapping between the file and table columns

The supported file types for upload are: .csv, .xls, and .xlsx

When loading new data in the table, it gets appended to the existing data

The application suggests the column name and data type for the new tables, and it is possible to edit them

Required

Q87) What all are the advantages provides by ABAP Development Tools?

There are 3 correct answers to this question. *

1 point

An open platform for developing new ABAP-related tools

A set of Eclipse data pool and Client- Open platform

An open platform for developing powerful database view

A brand new ABAP development experience on top of the Eclipse platform

A set of open, language- and platform-independent APIs

Required

Q88) What are the supported joins in CDS view?

There are 2 correct answers to this question. *

1 point

Operators joint

Left outer join

Inner join

Upper join

Required

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

1 point

Direct access to Table Pools/Cluster

Existence check for Secondary Indexes

Missing ORDER BY or SORT after SELECT

Use of Native SQL and DB Hints

Q90) What is the main purpose of SAML for SAP HANA Studio? *

1 point

To support scenarios where clients are not directly connected to the SAP HANA Database

SAML may be selected as an Owner’s authentication method when creating users in the SAP HANA Studio

The SAP HANA database supports login of Owners only

The assertion is issued by a user after the client was successfully authenticated

Q91) The source code editor in ADT provides many helpful features. What are these helpful features?

There are 2 correct answers to this question. *

1 point

Creating interface from Method Calls

Creating Method Implementations from the Method Definition

Creating Method Definitions from Implementation Parts

Creating Parts for Interface Methods

Required

Q92) Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? *

1 point

Combine information from static ABAP code scans with runtime data from the SQL Trace tool.

Estimate the new total runtime of optimized code.

Combine information from static ABAP code scans with runtime data from the SQL Monitor.

Create a graph comparing the runtimes of ABAP code before and after optimization.

Q93) You are using ABAP Development Tools, and you have placed your cursor on a method name in a class.

What key do you use to navigate between a method definition and its implementation?

1 point

Q94) How to create a core data services view?

There are 3 correct answers to this question. *

1 point

Use the ABAP Development Tools for SAP NetWeaver.

Use DDL statement DEFINE VIEW and SQL-like syntax to define the view

Use additional annotations – marked with the @ sign

Use data services tools for updates

Use SQL capabilities for Netweaver

Required

Q95) Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA? *

1 point

Columnar data storage

Parallel processing

Database table compression

Dictionary encoding

Q96) Discuss the conditions required to ensure the Referential Integrity?

There are 2 correct answers to this question. *

1 point

There are three joins in the table

Referential integrity holds true in both the directions

There is at least one join in the other table

There are two joins in the able

Required

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

1 point

Core data services views

Stored procedures

Calculation views

ABAP managed database procedures

Required

Q98) Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer?

There are 2 correct answers to this question. *

1 point

Documented checks

Flexible schedule of check runs

Configuration of check variants

Enhanced distribution of results

Required

Q99) What are the elements of ABAP Database Integration?

There are 3 correct answers to this question. *

1 point

DB For ABAP

Other DB

Client database handling

DB client-server

Application server

Required

Q100) Which code-to-data capability is responsible for the Optimizations & Translation of

“Open SQL SELECT FOR ALL ENTRIES “clauses into native SQL?

1 point

Transparent Optimizations

Buffer system Optimization

Database Optimization

HANA Specific features

Q101) What are the two main factors of SAP HANA Innovations and Challenges?

There are 2 correct answers to this question. *

1 point

HW technology and innovations

SAP SW technology and innovations

SAP BW innovations

DBMS technology and innovations

Required

Q102) In which of the following situations could a row store table be more suitable than a column store table?

There are 2 correct answers to this question. *

1 point

The table contains text that you want to search.

The table contains mainly distinct values per column across rows.

The table contains only a small number of records.

The table contains data that you want to aggregate.

Required

Q103) What are the principles of Using HANA Transport Containers properly?

There are 3 correct answers to this question. *

1 point

To create Transport container of delivery unit

Release of Transport request

Import of Transport Request

Automatic update for all export methods

Takes a ‘snapshot’ of all SAP HANA objects of delivery unit

Required

Q104) Which SAP HANA engine executes Calculation view?

There are 2 correct answers to this question. *

1 point

Calculation Engine

OLAP Engine

JOIN Engine

SQL Engine

Required

Q105) When using ABAP Database Connectivity (ADBC) to issue native SQL calls to the database, which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? *

1 point

SET_PARAM

SET_PARAM_TABLE

GET_METADATA

NEXT_PACKAGE

Q106) You want to execute a native SQL statement in your program.

Why should you use ABAP Database Connectivity (ADBC)?

There are 2 correct answers to this question.

1 point

It supports locking and commit handling.

It supports exception handing.

It has syntax check at compile time.

It supports where-used list.

Required

Q107) What are some of the features available SAP List Viewer with integrated data access (SALV IDA)?

There are 3 correct answers to this question. *

1 point

Double-click on rows

Search in content

Edit cells

Group rows

Display diagrams

Required

Q108) In order to get language-specific data, which join is used in SAP HANA? *

1 point

Referential Join

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

Text Join

Language join

Q109) Which of the following tasks can you perform with SQL monitor (transaction SQLM)? *

1 point

Search for problematic SELECT* statements

Combine static and dynamic performance analysis results

Capture the SQL profile of an application

Display the execution plan of an SQL statement

Q110) Which of the following tools and programming techniques use the SQL data definition language?

There are 2 correct answers to this question. *

1 point

ABAP Dictionary

Open SQL

Core data service (CDS) access control

Core data services (CDS) data definition

Required

Q111) Which of the following is latest release of SAP HANA? *

1 point

SAP HANA 1.0 SP06

SAP HANA 1.0

SAP HANA 2.0 SPS 06

SAP HANA 1.6 SP03

Q112) List down the four main concepts of the SAP HANA database?

There are 3 correct answers to this question. *

1 point

Column Store

Tools combinations

Object store

Partitioning

Compression

Required

Q113) What is the full form of HANA? *

1 point

High-Performance Analytic Accelerator

High-Performance Analytic Application

High-Performance Analytic Appliance

High Accelerator Numeric Analytics

Q114) You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SO_ID).

Which SELECT statement would you use in the definition?

1 point

select from snwd_so { so_id, sum(net_amount) as sum_amount } order by so_id

select from snwd_so { so_id, sum(net_amount) as sum_amount } group by net_amount

select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id

select from snwd_so { so_id, sum(net_amount) as sum_amount }

Q115) What are the steps involved in SAP HANA Evolution?

There are 3 correct answers to this question. *

1 point

ABAP can access SAP HANA

ABAP can run on SAP HANA

ABAP as accelerator on SAP HANA

Optimized ABAP on SAP HANA

ABAP applications on SAP HANA

Required

Q116) You use ABAP database connectivity (ADBC) to issue native SQL calls to the database.

Which of the following methods of class CL_SQL_RESULT_SET retrieves the result set of the native SQL call?

1 point

NEXT_PACKAGE

SET_PARAM

EXECUTE_QUERY

SET_PARAM_TABLE

Q117) You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA.

What do you have to do in the corresponding ABAP class?

1 point

Implement the ABAP AMDP_HDB Event Handler.

Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.

Implement the interface IF_AMDP_MARKER_HDB.

Set the visibility of the corresponding class method in the declaration section to PUBLIC.

Q118) What are the steps involved in supporting a database oriented programming model?

There are 2 correct answers to this question. *

1 point

Core Data services

A new and advanced Open SQL

Advanced and specific models

Buffer system services

Required

Q119) What are the Perspectives and Views of SAP HANA Studio?

There are 2 correct answers to this question. *

1 point

Open system properties

Administration console

System and Properties

Development properties

Required

Q120) What do you understand by The SAP HANA Software Optimization? *

1 point

Huge potential for hybrid database

Provide combinations of Objects and Partitioning

Speed up the processing within the database

Bring logic to where the data is calculated first, then only move to results

Q121) What allows you to resolve errors quickly or warnings reported about the code? *

1 point

Code execution

Debug perspective

ABAP debugger

Quick Fix

Q122) What are the benefits of using the SQL Monitor (transaction SQLM)?

There are 2 correct answers to this question. *

1 point

It can be active in a production system with minimal performance overhead.

It collects monitoring data asynchronously without additional database interaction.

It displays the database execution plan for all SQL statements.

It schedules ABAP programs to monitor and log all database accesses.

Required

Q123) What is the system privilege required to create analytic privilege? *

1 point

CREATE PRIVILEGE

PRIVILEGE ADMIN

STRUCTUREDPRIVILEGE ADMIN

CREATE STRUCTURED PRIVILEGE

Q124) You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause?

There are 3 correct answers to this question. *

1 point

CE function used in the procedure body

AMDP used in the procedure body

SAP HANA views used in the procedure body

ABAP Dictionary views used in the procedure body

ABAP Dictionary table used in the procedure body

Required

Q125) Hybrid Data Management System – Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system?

There are 3 correct answers to this question. *

1 point

Traditional disk-based tables

Text indexing capabilities

Text analysis and search

Built-in support for planning

Linguistic search capabilities

Required

Q126) Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?

There are 2 correct answers to this question *

1 point

Screen editing

Form-based class builder

Content assistance

Quickfix

Required

Q127) 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? *

1 point

Open the ABAP transport request Select take snapshot and Save Activate the SAP HANA transport container

Open the SAP HANA transport container 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

Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container

Q128) What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)?

There are 3 correct answers to this question. *

1 point

Specify the database system and the language.

List all ABAP Dictionary tables used in the procedure body in the USING clause.

Mark the AMDP method as a READ-ONLY database procedure.

Define all method parameters to be passed by value.

Use scalar types for all AMDP method parameters.

Required

Q129) What are the basic principles of ALV SAP HANA?

There are 2 correct answers to this question. *

1 point

Data described declaratively instead of passing big internal tables

To ensure that the user chooses the data on the selection screen is displayed

Only retrieve the database data which is to be displayed on screen

The ALV Optimization for SAP HANA to display data on the screen

Required

Q130) Discuss different types of engines associated with The SAP HANA architecture? (What are different types of engines associated with The SAP HANA architecture?)

There are 2 correct answers to this question. *

1 point

Join engine

OLAP engine

OPAX engine

Analytic engine

Required

Q131) Why is a security concept in SAP HANA required?

There are 2 correct answers to this question. *

1 point

Access to ERP tables must be restricted

Database administration should be restricted to skilled

Editing of SAP HANA data models should only be possible for “Users.” of the model

Need to have selected users in SAP HANA for Information Management

Required

Q132) Open SQL largely standardized, three sub-languages. What are these sub-languages?

There are 3 correct answers to this question. *

1 point

Data Manipulation Language (DML)

The Data Definition Language (DDL)

The Data Control Language (DCL)

Data Evaluation Language (DEL)

Data Transferring Language (DTL)

Required

Q133) What are the Guidelines for optimizing ABAP code running on HANA?

There are 3 correct answers to this question. *

1 point

Open SQL settings

Column store

DB specific properties

Technical settings

High-speed data analysis

Required

Q134) What output does The SAP HANA provide as a unique combination of hardware and software innovations? *

1 point

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

Huge potential to optimize AMDP application DATA Tables

The ability to create new complex processes with ABAP application cloud

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

Q135) In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog.

Which of the following table types fulfill this requirement?

1 point

LOCAL TEMPORARY

COLUMN

ROW

GLOBAL TEMPORARY

Q136) SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANA has to meet. What are these goals?

There are 2 correct answers to this question *

1 point

Analytical DBMS features

Support for system tables

High Performance and Scalability

Hybrid data and management system

Required

Q137) Which components can be a part of a calculation view?

There are 3 correct answers to this question. *

1 point

Tables

Attribute View

BAPIs

Analytic View

Required

Q138) When would you use a column store table instead of a row store table?

There are 2 correct answers to this question. *

1 point

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

When you require aggregation and analysis of values

Required

Q139) Explain The Authorization Concept and the types of privileges associated with it?

There are 3 correct answers to this question. *

1 point

Application privileges

Delta privileges

Object privileges

Analytic privileges

System privileges

Required

Q140) Which engine is used to execute Analytic View? *

1 point

OLAP Engine

SQL Engine

Join Engine

Calc Engine

Q141) What is the purpose of an ABAP project in ABAP Development tools for eclipse?

There are 2 correct answers to this question. *

1 point

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

It represents the connection to the SAP HANA server

It represents the connection to an ABAP system

It is used to transport ABAP repository objects.

Required

Q142) What are the ABAP development guidelines?

There are 2 correct answers to this question. *

1 point

Consuming Only ABAP contents for SAP HANA

Improved hybrid components for SAP HANA

Improved tools for performance analysis

Extensions to ABAP Language

Required

Q143) You define a core data services (CDS) view to merge the results of queries using the UNION keyword.
What must the column list of this queries contain?

There are 2 correct answers to this question. *

1 point

All key fields

Columns of compatible types

The same number of columns

Columns of identical types

Required

Q144) What are the features of New Open SQL?

There are 2 correct answers to this question. *

1 point

Supports arithmetic and string expressions

Supports conditional expressions

Supports Code adjustment model

Supports specific units of database

Required

Q145) AMDP 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 *

1 point

UNION specific syntax errors

SQLScript errors

Database platform syntax errors

Database independent syntax errors

HANA specific syntax errors

Required

Q146) The new bottlenecks avoided by addressing two challenges, what are they?

There are 2 correct answers to this question. *

1 point

Avoid idling CPU cores

Avoid CPU cache misses

Avoid single network

Avoid optimizing data

Required

Q147) Which step of the Guided Performance Analysis should you perform in the product on system? *

1 point

Collecting data with SQL Monitor (SQLM)

Executing a check run with ABAP Test Cockpit (ATC)

Building a work list with SQL Performance Tuning Work list (SWLT)

Performing an inspection with Code Inspector (SCI)

Q148) What are the two types of editors available in ADT?

There are 2 correct answers to this question. *

1 point

ABAP (native)

Client (native)

SAP (GUI)

Eclipse (native)

Required

Q149) You are programming a report that reads data from a secondary HANA database (DB).
What do you need to consider in your SQL statement?

There are 2 correct answers to this question.

1 point

You have to use native SQL when reading data from the secondary DB.

All tables and fields you are using must exist in the ABAP Dictionary of the Secondary DB.

You have to specify the DB schema explicit in your statement.

You have to specify the DB connection explicitly in your statement.

Required

Q150) Which of the following functions are available in both the ADT Debug perspective and the SAP GUI Debugger?

There are 2 correct answers to this question. *

1 point

Memory analysis

Source code editing in the debugger

Setting breakpoints dynamically during debugging

Displaying the contents of an internal table

Required

Q151) When are referential joins executed in analysis views? *

1 point

When fields from both tables are requested

When fields are selected

When all the tables are optimized

When fields are optimized

Q152) 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. *

1 point

All arithmetic expression : can be used for all type of variables

ALL Fields in the GROUP BY clause must be separated by commas

ALL ABAP valuables must be-escaped with a proceeding @ sign

All keywords are case sensitive

Required

Q153) What are the supported joins int CDS view?

There are 2 correct answers to this question. *

1 point

Upper Join

Operations join

Inner Join

Left Outer Join

Required

Q154) What are the different views provided by the ABAP profiling?

There are 2 correct answers to this question. *

1 point

Metadata access

Database accesses

Performance Check methods

A Hit-list of the most time-consuming programs of methods

Required

Q155) What is Core Data Services(CDS)? *

1 point

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

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

Q156) What are the different views provided by the ABAP profiling?

There are 2 correct answers to this question. *

1 point

A Hit-list of the most time-consuming programs of methods

Metadata access

Database accesses

Performance Check methods

Required

Q157) What are the performance Rules and Guidelines for ABAP on SAP HANA?

There are 2 correct answers to this question. *

1 point

It is beneficial to move data-intensive calculations into the database

It is beneficial for maximizing your search into database

To keep all the loads away from the DB

To reduce main memory consumption and to improve Insert performance

Required

Q158) What are the types of privileges associated with Authorization Concept?

There are 3 correct answers to this question. *

1 point

System privileges

Analytic privileges

Object privileges

Delta privileges

Application privileges

Required

Q159) What is an attribute view and what are its practices?

There are 3 correct answers to this question. *

1 point

Used to join tables

May use in calculation Views

May contains flow charts

Used in diagrammatic Projections

May Contain filters

Required

Q160) You implement and ABAP-managed database procedure(AMDP).
You want to query data from Calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.prim.
How can you address the calculation view?

There are 2 correct answers to this question. *

1 point

“ha400.primdb/CA_BOOKING_COUNT”

_SYS_BIC. “ha400.primdb::CA_BOOKING_COUNT”

_SYS_BIC. “ha400.primdb/CA_BOOKING_COUNT”

“ha400.primdb::CA_BOOKING_COUNT”

Required

Q161) What are the two different kinds of Identifiers used to represent names used in SQL statement?

There are 2 correct answers to this question. *

1 point

Delimited Identifiers

Numeric identifiers

Limited identifiers

Underlimited Identifiers

Required

Q162) User STUDENT_A create and activates a design-time object.
In which schema is the run object generated? *

1 point

_SYS_BIC

_SYS_BI

STUDENT_A

SYSTEM

Q163) You follow the Code-to-Data paradigm in your ABAP Coding.

Which of the following scenarios conflicts with the SQL performance guideline “Keep unnecessary load away from the database?”

1 point

Perform join operations on database tables, then transfer the results to the application layer

Perform Business logic and aggregation on database table content, then transfer the results to the application layer

Perform calculations on data transferred to the database layer, then transfer the results back to the application layer

Perform text search operations on database table content, then transfer the results to the application layer

Q164) You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings table.

Why do you create a row store instead of a column store?

1 point

To limit the unpacking and reconstruction of row

To allow creation of a full-text index

To limit the need of indexes

To limit the data footprint

Q165) Which code-to-data capability supports-Extended view definitions and Better SQL-92 standard support in open SQL? *

1 point

Database oriented programming model

Database for sophisticate analysis

New SQL PARSER used in model

SAP HANA specific features

Q166) You made changes to an object (X) used by an ABAP managed database procedure (AMDP). You did NOT changes the AMDP itself. Now you execute a program that calls this. In which cases does the call trigger the creation of the database procedure in SAP HANA?

There are 2 correct answers to this question. *

1 point

X is an ABAP Dictionary table

X is a stored procedure.

X is an AMDP method

X is an SAP HANA view

Required

Q167) Which of the following new repository objects belong to code push down approach?

There are 2 correct answers to this question. *

1 point

Database procedure proxy

ABAP managed database procedure

External View

CDS Views

Required

Q168) 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? *

1 point

Editor shortcut key options

Code completion options

Code formatting options

Statement template options

Q169) What is the central goal of using SAP HANA? *

1 point

Positive Impact on Business

To set Priorities for system

Accelerate Performance

Monitor database for record keeping

Q170) You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? *

1 point

Choose the Run --> Debug options in the menu

Create a debug configuration for the ABAP application and run the program

Choose the debug as option in the context menu of the ABAP program

Set a breakpoint in the ABAP program and execute the program

Q171) ABAP 7.4 provides support for optimizing ABAP applications running on SAP NANA. What are these Transparent Optimizations?

There are 3 correct answers to this question. *

1 point

The ABAP language and the openSQL language have been extended

Do all the data processing in Application server

Performance analysis tools have been improved

The consumption of SAP HANA artifacts was simplified

Re-use components have been extended or optimized for SAP HANA

Required

Q172) Which of the following feature is not supported by ALV with IDA? *

1 point

Editing values

Personalization

Excel export

Double click

Q173) Which of the following is a limitation when you create an external view? *

1 point

You must use the AMP Development tools (ADT) to create an 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 include the name of the SAP HANA view in the name of the external view

Q174) What should you do to follow the code-to-data approach to programming?

There are 3 correct answers to this question.

1 point

Perform expensive calculations on the database

Use native SQL to access SAP HANA built-in functions

Aggregate data on the database, and transfer the results to the ABAP layer

Perform expensive calculations on the ABAP application server.

Transfer all data from the database to the ABAP layer, and then aggregate the results.

Required

Q175) How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement? *

1 point

One result set

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

Two result sets

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

Q176) 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?

1 point

Read-Only

Read-Write

Read-update

Write-Only

Q177) Which JOIN types can be used in the definition of a Core Data Services (CDS) view?

There are 2 correct answers to this question. *

1 point

FULL OUTER JOIN

RIGHT OUTER JOIN

REFERENTIAL JOIN

CROSS JOIN

LEFT OUTER JOIN

Required

Q178) What are the basic principles of SAP ALV IDA?

There are 2 correct answers to this question. *

1 point

Data described declaratively instead of passing big internal tables

Only retrieve the database data which is to be displayed on screen

The ALV Optimization for SAP HANA to display data on the screen

To ensure that the user chooses the data on the selection screen is displayed

Required

Q179) When using an SAP HANA full text search, What do you have to keep in mind? *

1 point

The full-text index is always updated asynchronously

The SCORE () function is required to ensure the best hits of your search appear on top

SAP HANA has to be the primary database to create a full text search

The LIKE operator is required in your SELECT statement to implement fuzzy logic

Q180) Which of the following are potential functional issues when migrating ABAP code to SAP HANA?

There are 2 correct answers to this question. *

1 point

existence of customer specific cluster tables

coding that assume that SELECT result is always sorted

use of secondary database connections

existence of table appends

use of native SQL or DB hints

Required

Q181) What are the features associated with ABAP CDS?

There are 3 correct answers to this question. *

1 point

Distribution

Create

Export

Read

Update

Required

Q182) How will you select a preference for Validation rules? *

1 point

Windows- Preferences-SAP HANA-Modeler-Validation Rules

Windows- Modeler - Preferences-SAP HANA-Validation Rules

Windows- SAP HANA-Preferences-Modeler-Validation Rules

Windows- SAP HANA-Modeler-Preferences-Validation Rules

Q183) You define a core data services (CDS) View For which of the following expressions and built in functions must you provide alias?

There are 3 correct answers to this question. *

1 point

Unit conversion

CASE expression

Nested CASE expression

Currency Conversion

Required

Q184) Which of the following tool is introduced as a holistic quality assurance tool? *

1 point

ABAP Test Cockpit (ATC)

DBMS Cockpit

BW system

DBA Cockpit

Q185) How will you hide the attributes that are not required for client consumption? *

1 point

By setting the hidden property flag of the attribute in the View

By setting the hidden property flag of the attribute in the Semantics screen

By setting the hidden property flag of the attribute provider

By setting the hidden property flag of the attribute column

Q186) Which of the following entries can be found under node CATALOG and not under node CONTENT

There are 2 correct answers to this question. *

1 point

schema

table

package

calculation view

Required

Q187) What benefits does SAP HANA Data Compression provide?

There are 2 correct answers to this question *

1 point

Reduced memory consumption

Increased parallel processing

Optimized access to column store tables

Optimized data partitioning

Required

Q188) Which of the following are performance recommendations when using SAP HANA?

There are 2 correct answers to this question *

1 point

Define indexes on the columns that are used in calculations

Move data-intensive calculations from the database to an application server.

Filter data in lower layers.

Avoid transferring large result sets between database and client applications

Required

Q189) The below CDS view has two fields MARA and MARC. How to fetch fieldA and FieIdB from Marc into view to complete view.

define view ZMM_I_MAT as select from MARA as m association to MARC as _plant on rn.mara = _plant.mara { matnr,
werks,
…..
…..
} *

1 point

_plant.fieldA, _plant.fieldB

_plant.fieldA.fieldB, _plant.fieldB

Q190) Which tasks does the ABAP managed database (AMDP) framework perform?

There are 2 correct answers to this question.

1 point

Create a new version of the database when the AMDP is first activated

Delete the obsolete versions of the database procedure asynchronously

Delete the obsolete versions of the database procedure synchronously

Create a new version of the database-when the AMDP is first called

Required

Q191) Which views are available to administer and monitor one or several SAP HANA systems?

There are 2 correct answers to this question. *

1 point

The System Monitor view

The Security view

The Landscape view

The Administration view

Required

Q192) In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? *

1 point

specify an alias for the target entity

define the cardinality for the target entity

include all fields used in the ON condition in projection list

specify the other views in which the association can be used

Q193) An access control (DCL source) defines access restrictions for a given CDS view.

These restrictions are implicitly evaluated when the CDS view is accessed in the following places?

There are 2 correct answers to this question.

1 point

In data preview in ADT

In ABAP open SQL

In definition of another CDS view

In data browser (SE16)

Required

Q194) Which data provisioning methods can you use when you need real time replications?

There are 2 correct answers to this question. *

1 point

SAP Data services

SAP HANA Direct extractor connection (SAP DXC)

SAP Replication server

SAP Landscape transformation Replication server (SAP SLT)

Required

Q195) If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. The following parameters are available?

There are 3 correct answers to this question. *

1 point

Point base ranking

Index search

Freestyle search

Fuzzy search

Weights for ranking

Required

Q196) To connect with the SAP HANA system and see the corresponding catalog content etc., use the Systems view.

How will you add a system to this view?

There are 2 correct answers to this question.

1 point

By using Open Catalog look

Password for the database user

Database user — also different from your ABAP user

By using SQL application

Required

Q197) What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment?

There are 3 correct answers to this question. *

1 point

Monitor

Organizing

Selecting

Configure

Administer

Required

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

1 point

Use the CLIENT SPECIFIED addition.

Include the client field in the field list.

Include the client field in the join condition

Include the client field in the WHERE condition.

Required

Q199) In the source code editor you can navigate quickly from the definition of a method to its implementation.

To do so, you select the method name and press which key(s)?

1 point

Ctrl + F2

Ctrl + Shift + F5

Q200) What are the advanced features of SAP HANA full-text search.

There are 3 correct answers to this question. *

1 point

Freestyle search

linguistic search

Fuzzy search

ACID search

Isolation search

Required

Q201) Which of the following SAP HANA based scenarios involve ABAP applications?

There are 2 correct answers to this question. *

1 point

AS ABAP with SAP HANA as primary database

Data mart based on SAP HANA

SAP HANA as business accelerator

Native SAP HANA applications

Required

Q202) In addition to closing the result set, what else CLOSE method of the CL_SQL_RESULT SET class in ABAP Database Connectivity (ADBC) do? *

1 point

Release resources

Update resources

Update packages

Release packages

Q203) You analyze 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?

There are 3 correct answers to this question.

1 point

Program X was executed in the background.

SQL Monitor was activated for a specific application server

SQL monitor was activated with a filter that excludes database table Y

Database table Y is a buffered table

The data has NOT yet been transferred to the SQL monitor database tables

Required

Q204) What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA database?

There are 2 correct answers to this question. *

1 point

The database independency of your report can be lost

Client handling needs to be done explicitly in the Native SQL statement

Hashed or sorted tables must be used with the INTO CORRESPONDING FIELDS keyword

The ABAP system checks the syntax of the Native SQL statements

Required

Q205) How to call the stored procedures in ABAP code? *

1 point

Only SQL

Open SQL

Native SQL

CDS View

Q206) Which of the following are view annotations for a CDS view?

There are 3 correct answers to this question. *

1 point

Environment

Access control

Client handling

Semantics

Buffering type

Required

Q207) One of your SAP systems needs to be migrated from its current database to an SAP HANA database.

You want to avoid any functional issues after the migration.

What should you search for and if necessary replace in the existing custom ABAP code?

There are 3 correct answers to this question.

1 point

Native SQL statements

Code that relies on implicit database sorting

Left outer joins in open SQL statements

Direct access to a cluster on the database

ORDER BY Clauses in Open SQL statements

Required

Q208) You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon Web Service (AWS) trial system.

Which plug-ins do you need to add to the existing Eclipse installation?

1 point

SAP HANA Tools

ABAP Development Tools for SAP NetWeaver

None; everything is preconfigured

All plug-ins provided by SAP Development Tools for Eclipse

Q209) What is the limitations of ALV for SAP HANA?

There are 3 correct answers to this question. *

1 point

Restricted to 10,000 records

No unit/ currency split if aggregating amounts/ currency values

Restricted to 5000 records / unit

Without currency/unit consideration

All unit/ currency restricted to 10,000,000 records

Required

Q210) Which of the SQL performance rules become more important with SAP HANA?

There are 2 correct answers to this question. *

1 point

Keep the result set small

Minimize amount of transferred data

Minimize search overhead

Minimize number of database accesses

Keep unnecessary load away from DB

Required

Submit

Clear form

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms