sas

HA100
HA300
Practice Test 1 - Results

 Return to review

Attempt 1
 All questions
Question 1: Correct
In static code check using the Code Inspector (SCI) variant, you select the "search
problematic SELECT * statements check. What does this check report?

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

(Correct)

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

SELECT * statements on tables with the Column Store storage type

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

Explanation
Question 2: Incorrect
What are the benefits associated with The SAP HANA real-time operational analytics?  
There are 2 correct answers.

High modeling flexibility

(Correct)

Simplification of massive data

(Incorrect)


 Fast insights into business activity

(Correct)

Query Speed support

Explanation
Question 3: Correct
In addition to closing the result set, what else CLOSE method of the
CL_SQL_RESULT_SET class in ABAP Database Connectivity (ADBC) do ?

Release resources

(Correct)

Update resources

Update packages

Release packages

Explanation
Question 4: Correct
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?


Read only

(Correct)

Read-write

Read-update

Write only

Explanation
Question 5: Correct
Approach use to follow the code-to-data programming? 
There are 3 correct answers.

Use native SQL to access SAP HANA built-in functions.

(Correct)

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

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

(Correct)


Perform expensive calculations on the database.

(Correct)

Perform expensive calculations on the ABAP application server.

Explanation
Question 6: Incorrect
What all are the advantages provides by ABAP Development Tools (ADT) in eclipse ?
There are 3 correct answers.

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

(Correct)

An open platform for developing new ABAP-related tools

(Correct)

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

(Correct)

An open platform for developing powerful database view

(Incorrect)


 A set of Eclipse data pool and Client- Open platform

(Incorrect)

Explanation
Question 7: Incorrect
What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2
correct answers.

To reduce main memory consumption and to improve insert performance

(Correct)

It is beneficial for maximizing your search into database

(Incorrect)

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

(Correct)

To Keep all the loads away from the DB

Explanation
Question 8: Incorrect
What must you do when you define and implement an ABAP Managed Database
Procedure (AMDP)?
There are 3 correct answers.

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

(Incorrect)


Define all method parameters to be passed by value.

(Correct)

Use scalar types for all AMDP method parameters.

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

(Correct)

Specify the database system and the language.

(Correct)

Explanation
Question 9: Correct
What are the Parameters for Analytical and Calculation view?  There are 3 correct
answers.

Create a copy of a report

Specifying unit of measurement

(Correct)

Setting a filter for columns

 (Correct)

Passing other values to be used in calculations

(Correct)

To store data for critical analysis

Explanation
Question 10: Incorrect
ABAP 7.4 provides support for optimizing ABAP applications running on SAP HANA.
What are these Transparent Optimizations?  There are 3 correct answers.

The ABAP language and the OpenSQL language have been extended

(Correct)

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

(Incorrect)

The consumption of SAP HANA artifacts was simplified

(Correct)

Performance analysis tools have been improved

(Correct)


 Do all the data processing in Application server

(Incorrect)

Explanation
Question 11: Correct
What are the steps involved in supporting a database oriented programming model? 
There are 2 correct answers.

A new and advanced Open SQL

(Correct)

Buffer system services

Advanced and specific models

Core Data services

(Correct)

Explanation
Question 12: Incorrect
In an ABAP Core Data services (CDS) view, what you must do to expose an association
for use in another CDS view?

Specify the other views in which the association can be used

(Incorrect)

Include all fields used in the ON condition in projection list

 (Correct)

define the cardinality for the target entity

specify an alias for the target entity

Explanation
Question 13: Incorrect
Which of the following options in ABAP Development Tools (ADT) in eclipse belongs to
the settings of a specific ABAP project rather than the entire Eclipse workbench?

Code formatting options

(Correct)

Editor shortcut key options

Code completion options

Statement template options

(Incorrect)

Explanation
Question 14: Correct
List down the elements involved in User Management and Security in SAP HANA? 
There are 3 correct answers.


 Assign security

(Correct)

Assign job security

Create users

(Correct)

Manage users

(Correct)

Work management

Explanation
Question 15: Correct
What are the advanced features of  SAP HANA full-text search.
There are 3 correct answers.

freestyle search

(Correct)

ACID search


 Fuzzy search

(Correct)

linguistic search

(Correct)

Isolation search

Explanation
Question 16: Incorrect
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)?

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

(Correct)

Estimate the new total runtime of optimized code.

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

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

(Incorrect)

Explanation
Question 17: Correct
Which are the features added to the ABAP Dictionary to support the SAP HANA
database?
 There are 3 correct answers.

De-pooling and de-clustering

(Correct)

Changes of data class

Storage type for tables

(Correct)

Definition of an enhancement category

Definition of full-text indexes

(Correct)

Explanation
Question 18: Incorrect
What are the two different kinds of Identifiers used to represent names used in SQL
statement? There are 2 correct answers.

Limited identifiers

(Incorrect)

Undelimited Identifiers
 (Correct)

Numeric identifiers

Delimited identifiers

(Correct)

Explanation
Question 19: Incorrect
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.

External view

(Correct)

Database procedure proxy

(Correct)

ABAP program containing new Open SQL

(Incorrect)

Core Data service (CDS) view

(Correct)


Full-text index
Question 20: Correct
Which of the following option is not the main capability of SAP Business Objects
Analysis for OLAP?

Swap axes

Insert filter components

Create data by members and tables

(Correct)

Create Presentations

Explanation
Question 21: Incorrect
Which features does the source code editor provide in ABAP Development Tools for
SAP NetWeaver? There are 2 correct answers.

Screen editing

Quickfix

(Correct)


Content assistance

(Correct)

Form-based class builder

(Incorrect)

Explanation
Question 22: Incorrect
What are different types of engines associated with the SAP HANA architecture?
There are 2 correct answers.

Analytic engine

(Incorrect)

OPAX engine

OLAP engine

(Correct)

Join engine

(Correct)

Explanation
Question 23: Correct
Which of the following new repository objects belongs to code push down approach?
 There are 2 correct answers.

external view

CDS views

(Correct)

ABAP managed database procedure

(Correct)

database procedure proxy

Question 24: Correct
Which is the new concept that is introduced and improved by using SAP HANA specific
features?

ABAP-Managed Database Procedures

(Correct)

Programming model

Table buffering


 New advanced SQL syntax Procedures

Explanation
Question 25: Correct
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?

select from tab_so

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

(Correct)

select from tab_so

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

select from tab_so

{
so_id,
sum(net_amount) as sum_amount
}

select from tab_so

{
so_id,
sum(net_amount) as sum_amount
}
group by net_amount
Explanation
 Question 26: Incorrect
Which of the following tasks can be you perform with SQL monitor (SQLM)?

Combine static and dynamic performance analysis results

Display the execution plan of the SQL statement

Capture the SQL profile of an application

(Correct)

Search the problematic SELECT * statement

(Incorrect)

Question 27: Incorrect
Which of the following are potential functional issues when migrating ABAP code to
SAP HANA ?
There are 2 correct answers.

use of native SQL  or DB hints

(Correct)

existence of customer specific cluster tables

coding that assume that SELECT result is always sorted

(Correct)


existence of table appends

use of secondary database connections

(Incorrect)

Question 28: Correct
You create a new table definition using ABAP dictionary and maintain the database
specific technical setting. Why do you create a row store instead of a column store
table?

To limit data footprint

To limit the need of indexes

To allow creation of full-text index

(Correct)

To limit the unpacking and reconstruction of rows

Question 29: Correct
Which views are available to administer and monitor one or several SAP HANA
systems ?
There are 2 correct answers.

The Landscape view



The Security view

The Administration view

(Correct)

The System Monitor view

(Correct)

Explanation
Question 30: Correct
When are referential joins executed in analytical views?

When fields from both the tables are requested

(Correct)

When fields are optimized

When fields are selected

When all the tables are optimized

Explanation
Question 31: Incorrect
 Which of the following objects must you create if you want to allow the enhancement of
AMDP using business add-in (BADI). 
There are 3 correct answers .

A BADI fallback implementation

(Correct)

A BADI definition

(Correct)

An enhancement spot

(Correct)

A database procedure

(Incorrect)

A BADI simple implementation

(Incorrect)

Explanation
Question 32: Incorrect
When your customer wants to migrate to SAP HANA, Which of the following steps you
must perform to get the information about the business processes that should be
optimized ?
There are 2 correct answers.

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

(Incorrect)

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

(Correct)

Activate the new SQL Monitor in a development system.

(Incorrect)

Activate the new SQL Monitor in a productive system.

(Correct)

Explanation
Question 33: Incorrect
In ABAP Managed database procedure (AMDP), what do you have to list after the
USING clause? There are 3 correct answers

SAP HANA views used in the procedure body

(Incorrect)

AMDP used in the procedure body

(Correct)

ABAP Dictionary table used in the procedure body

 (Correct)

CE function used in the procedure body

ABAP Dictionary views used in the procedure body

(Correct)

Explanation
Question 34: Correct
What are the conditions required to ensure the Referential Integrity?  There are 2
correct answers.

Referential integrity holds true in both the directions

(Correct)

There are two joins in the able

There are three joins in the table

There is at least one join in the other table

(Correct)

Explanation
Question 35: Correct
What are the basic approach of classical ABAP programming?
There are 2 correct answers.


Get all the data you need on the application server and do your processing in ABAP

(Correct)

Collect all the data and perform Parallel processing in ABAP

Creating and consuming all the contents from network

Keep load from the database

(Correct)

Explanation
Question 36: Incorrect
Which of the following folder is essential to relate to Smart Data Access (SDA) and also
combines data from remote sources?

Security folder

Content folder

(Incorrect)

Provisioning folder

(Correct)


Administration folder

Explanation
Question 37: Incorrect
What are the basic principles of SAP ALV IDA ?
There are 2 correct answers.

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

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

(Incorrect)

Data described declaratively instead of passing big internal tables

(Correct)

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

(Correct)

Explanation
Question 38: Incorrect
What is the Limitations of ALV for SAP HANA?  There are 3 correct answers.

Restricted to 10,000 records

(Correct)


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

(Incorrect)

Without currency /unit consideration

(Correct)

Restricted to 5000 records / unit

No unit/ currency split if aggregating amounts/ currency values

(Correct)

Explanation
Question 39: Incorrect
What are the benefits includes with SAP HANA Full Text Search? There are 2 correct
answers.

Easy to use modeling tool

(Correct)

Exploit structured contents in SQL

(Incorrect)


 Large number of toolkits are available

Fewer data duplication and movement

(Correct)

Explanation
Question 40: Correct
Which of the following feature were added to ABAP dictionary to support the SAP
HANA database? There are 3 correct answers.

storage types of tables

(Correct)

Definition of an enhancement category

changes of data class

definition of full text indexes

(Correct)

De-pooling and de-clustering

(Correct)

Question 41: Incorrect
Which data provisioning methods can you use when you need real time replications? 
There are 3 correct answers.


SAP Replication server

(Correct)

SAP HANA Direct extractor connection (SAP DXC)

SAP Data services

SAP Landscape transformation Replication server (SAP SLT)

(Correct)

Explanation
Question 42: Incorrect
Which of the following entries can be found under node CATALOG and not under
node CONTENT ?
There are 2 correct answers.

calculation view

(Incorrect)

schema

(Correct)

package


table

(Correct)

Question 43: Incorrect
Which are the best practices when programming in ABAP for SAP HANA?
There are 2 correct answers.

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

(Correct)

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

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

(Incorrect)

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

(Correct)

Question 44: Incorrect
What are the principles of using HANA Transport Containers (HTC) properly?
There are 3 correct answers.

Import of Transport Request

 (Correct)

Release of Transport request

(Correct)

Takes a snapshot of all SAP HANA objects of delivery unit

(Correct)

Automatic update for all export methods

(Incorrect)

To create Transport container of delivery unit

(Incorrect)

Explanation
Question 45: Incorrect
Which of the following SAP HANA based scenarios involve ABAP applications?
There are 2 correct answers.

SAP HANA as business accelerator

(Correct)

AS ABAP with SAP HANA as primary database

(Correct)


Native SAP HANA applications

(Incorrect)

Data mart based on SAP HANA

Continue
Retake test

Attempt 1
All questions
Question 1: Incorrect
Which of the following are characteristics of an external view? There are 3 correct
answers .

It is an ABAP Dictionary object type.

(Correct)

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

(Incorrect)

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

(Correct)

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

 (Correct)

It defines the underlying SAP HANA information view.

(Incorrect)

Explanation
Question 2: Incorrect
what are the types of privileges associated with the authorization concept ? There
are 3 correct answers

Analytic privileges

(Correct)

Application privileges

(Incorrect)

Delta privileges

System privileges

(Correct)

Object privileges

(Correct)

Explanation
Question 3: Incorrect
 What are the three best approach for Transitioning and optimizing ABAP
applications to SAP HANA? There are 3 correct answers.

Tuning

Innovate

(Correct)

Optimize

(Correct)

Scaling

(Incorrect)

Detect

(Correct)

Explanation
Question 4: Incorrect
What is the central goal of using SAP HANA?

To set Priorities for system

Positive Impact on Business

 (Incorrect)

Accelerate Performance

(Correct)

Monitor database for record keeping

Explanation
Question 5: Incorrect
Which is not a key factor of ALV for HANA?

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

(Incorrect)

To Activate and execute the program in the application

(Correct)

Derived Column headings from the data element

To supply suitable values for any input parameters

Explanation
Question 6: Correct
You want to import ABAP workbench request into SAP SYSTEM P81. The ABAP
workbench request contains a single SAP HANA view CV_SCARR that belongs to
package ZPKG_DEV.
 Which pre-requisites are mandatory for an implicit development of the SAP HANA
view onto the database?
There are 2 correct answer

Package ZPKG_DEV is listed in the table SNHI_DUP_PREWORK

(Correct)

SYSTEM P81 has SAP HANA as primary database

(Correct)

View CV_SCARR has deployment mode A.

Package ZPKG_DEV has deployment mode A

Question 7: Correct
What are the two main methods to add a system to the SAP HANA Studio? There
are 2 correct answers.

By Importing a Landscape

(Correct)

Manually

(Correct)

Automatically


By Resource console

Explanation
Question 8: Incorrect
What are the main capabilities of SAP Business Objects Analysis for Office?
There are 2 correct answers.

Analyze data with the design panel

(Correct)

Sort data by characteristics

(Incorrect)

Suggests style sets for crosstabs

Convert crosstab cells to formula

(Correct)

Explanation
Question 9: Incorrect
Which of the following tools and programming techniques use the SQL Data
Definition Language?
There 2 correct answers.

CDS Access Control

(Correct)


CDS Data Definition

(Incorrect)

ABAP Dictionary

Open SQL

(Correct)

Question 10: Correct
What views will be most efficient for General Modeling Principles? There are 2
correct answers.

Attribute view

(Correct)

Column view

Schema view

Analytical view

(Correct)

Explanation
Question 11: Correct
 Which data sources can you use for SAP list viewer with integrated data access?
There are 3 correct answers.

Internal table

External view

(Correct)

CDS View

(Correct)

Database Table

(Correct)

Database Procedure

Explanation
Question 12: Incorrect
How will you select a preference for Validation rules?

Windows- Preferences-SAP HANA-Modeler-Validation Rules

(Correct)

Windows- SAP HANA-Preferences-Modeler-Validation Rules

 (Incorrect)

Windows- SAP HANA-Modeler-Preferences-Validation Rules

Windows- Modeler - Preferences-SAP HANA-Validation Rules

Explanation
Question 13: Correct
What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2
correct answers.

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

It displays the database execution plan for all SQL statements.

It collects monitoring data asynchronously without additional database interaction.

(Correct)

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

(Correct)

Explanation
Question 14: Correct
What are the supported joins in CDS view? There are 2 correct answers.

Upper join


Left outer join

(Correct)

Operators joint

Inner join

(Correct)

Explanation
Question 15: Correct
What are the ABAP development guidelines? There are 2 correct answers.

Extensions to ABAP Language

(Correct)

Improved tools for performance analysis

(Correct)

Improved hybrid components for SAP HANA

Consuming Only ABAP contents for SAP HANA

Explanation
 Question 16: Incorrect
Which of the following take advantage of the computing power of multiple CPUs
used by SAP HANA? There are 2 correct answers.

Columnar data storage

(Incorrect)

Parallel processing

(Correct)

Database table compression

(Incorrect)

Partitioning

(Correct)

Explanation
Question 17: Correct
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.

Left outer joins in open SQL statements

Native SQL statements

(Correct)


ORDER BY Clauses in Open SQL statements

Direct access to a cluster on the database

(Correct)

Code that relies on implicit database sorting

(Correct)

Explanation
Question 18: Incorrect
How to call the stored procedures in ABAP code?

CDS view

(Incorrect)

Open SQL

Native SQL

(Correct)

Only SQL

Explanation
 Question 19: Incorrect
You have an SQLScript procedure with a table input parameter xyz. 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?

@xyz

(Incorrect)

{xyz}

:xyz

(Correct)

xyz
Explanation
Question 20: Incorrect
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?

ROW

COLUMN

GLOBAL TEMPORARY

(Incorrect)


LOCAL TEMPORARY

(Correct)

Explanation
Question 21: Correct
Which of the following categories of parameters can you use in the definition of
an AMDP?
There are 3 correct answers.

Returning

Importing

(Correct)

Receiving

Exporting

(Correct)

Changing

(Correct)

Question 22: Correct
Which form of services is responsible for defining and consuming semantically
rich data models?


Conditional services

Core Data Services

(Correct)

Modell-II services

ITe services

Explanation
Question 23: Correct
What output does The SAP HANA provide as a unique combination of hardware
and software innovations?

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

Huge potential to optimize AMDP application DATA Tables

The ability to create new complex processes with ABAP application cloud

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

(Correct)
 Explanation
Question 24: Correct
What are the main concepts of the SAP HANA database? There are 3 correct
answers.

Tools combinations

Compression

(Correct)

Partitioning

(Correct)

Object store

Column Store

(Correct)

Explanation
Question 25: Correct
Which rules does SAP recommended to improve the performance of ABAP report
on SAP HANA? There are 2 correct answers.

Perform all calculations and aggregations in the ABAP layer


 Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES

(Correct)

Use array variants of INSERT UPDATE MODIFY and DELETE

(Correct)

Explanation
Question 26: Correct
Which of the following is a limitation when you create an external view?

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

You can only use native SQL to consume the external view

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

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

(Correct)

Explanation
Question 27: Incorrect
What is the purpose of an ABAP project in ABAP Development Tools for eclipse?
There are 2 correct answers.


It is used to transport ABAP repository objects.

(Incorrect)

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

(Correct)

It represents the connection to the SAP HANA server

It represents the connection to an ABAP system

(Correct)

Explanation
Question 28: Correct
Which steps do you have to perform when defining a view using CDS?
There are 3 correct answers.

Define the type mapping between ABAP and HANA

Use DDL statement DEFINE VIEW and SQL like syntax

(Correct)

Specify the name of the SQL view in ABAP dictionary

 (Correct)

Create a proxy object for the defined view

Create a data definition in your ABAP package

(Correct)

Question 29: Incorrect
What are the helpful features of source code editor in ADT ? There are 2 correct
answers.

Creating Method Definitions from Implementation Parts

(Correct)

Creating Parts for Interface Methods

Creating interface from Method Calls

(Incorrect)

Creating Method Implementations from the Method Definition

(Correct)

Explanation
Question 30: Correct
Which code-to-data capability supports- Extended view definitions and Better
SQL- 92 standard support in open SQL?


Database oriented programming model

(Correct)

Database for sophisticated analysis

SAP HANA specific features

New SQL parser used in model

Explanation
Question 31: Correct
How to create a core data services (CDS) view? There are 3 correct answers.

Use data services tools for updates

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

(Correct)

Use the ABAP Development Tools for SAP NetWeaver.

(Correct)


 Use additional annotations marked with the @sign

(Correct)

Use SQL capabilities for Netweaver

Explanation
Question 32: Incorrect
What are the elements of ABAP Database Integration? There are 3 correct
answers.

DB client-server

(Incorrect)

Other DB

(Correct)

Client database handling

(Incorrect)

DB For ABAP

(Correct)

Application server

(Correct)

Explanation
 Question 33: Incorrect
What do you understand by The SAP HANA Software Optimization?

Provide combinations of Objects and Partitioning

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

(Correct)

Huge potential for hybrid database

Speed up the processing within the database

(Incorrect)

Explanation
Question 34: Correct
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.

Technology store

Re-use component store

Column store

(Correct)


Development Store

Raw store

(Correct)

Explanation
Question 35: Incorrect
Which tools can you use to provide input data for SQL performance tuning work
list (transaction SWLT)?
There are 3 correct answers. 

SQL trace (ST05)

(Incorrect)

Database performance monitor (DB50)

Code inspector (SCI)

(Correct)

SQL monitor (SQLM)

(Correct)

ABAP test cockpit (ATC)

 (Correct)

Question 36: Incorrect
What is the main purpose of SAML for SAP HANA Studio?

SAML may be selected as an Owner?s authentication method when creating users in

the SAP HANA Studio

(Incorrect)

The SAP HANA database supports login of Owners only

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

(Correct)

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

Explanation
Question 37: Correct
Which of the following feature is not supported by ALV with IDA?

Double click

Editing values

(Correct)


 Excel export

Personalization
Question 38: Incorrect
AMDP can detect 3 types of syntax errors in active or inactive source code. What
are these errors ? There are 3 correct answers.

Database independent syntax errors

(Correct)

Database platform syntax errors

(Incorrect)

SQLScript errors

(Correct)

HANA specific syntax errors

(Correct)

UNION specific syntax errors

Explanation
Question 39: Incorrect
When to use Enhanced Open SQL? There are 2 correct answers .


 To view scalar components

(Incorrect)

To access system fields

(Correct)

Need the query in one piece of code only

(Correct)

At the time of Dictionary Views

Explanation
Question 40: Incorrect
Perspectives that are available in the SAP HANA Studio? There are 3 correct
answers.

The SAP HANA Modeler perspective

(Correct)

The Resources perspective

(Correct)

The technology & innovation perspective


 The Information perspective

(Incorrect)

The Administration Console perspective

(Correct)

Explanation
Question 41: Incorrect
You use native SQL to access the SAP HANA database. What should you do to
retrieve the correct data? There are 3 correct answers.

Use a Comma-separated column list

(Correct)

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

(Correct)

Use the UP TO n ROWS addition

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

(Incorrect)

Explicitly handle the client field

(Correct)
 Explanation
Question 42: Correct
Which of the following are performance recommendations when using SAP
HANA? There are 2 correct answers.

Avoid transferring large result sets between database and client applications.

(Correct)

Define indexes on the columns that are used in calculations.

Filter data in lower layers.

(Correct)

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

Explanation
Question 43: Correct
What are the purposes of tools in SAP HANA system that is an eclipse-based
integrated development environment? There are 3 correct answers.

Administer

(Correct)

Monitor

(Correct)


Selecting

Configure

(Correct)

Organizing

Explanation
Question 44: Incorrect
Which tools can you use to provide input data for the SQL performance tuning
work list (Transaction SWLT)? There are 3 correct answers.

Code inspector (transaction SCI)

(Correct)

Data base performance monitor (transaction DB50)

SQL monitor (transaction SQLM)

(Correct)

ABAP test cockpit (transaction ATC)

(Correct)


SQL Trace (transaction ST05)

(Incorrect)

Explanation
Question 45: Correct
The new bottlenecks avoided by addressing two challenges, what are they? There
are 2 correct answers.

Avoid idling CPU cores

(Correct)

Avoid optimizing data

Avoid single network

Avoid CPU cache misses

(Correct)

Explanation

Attempt 1
All questions
Question 1: Incorrect
An analytic privilege consists of several restrictions. What are they? There 3
correct answers.

Validity restrictions
 (Correct)

Activity restrictions

(Correct)

Cube restrictions

(Correct)

View restrictions

(Incorrect)

Analytic restrictions

(Incorrect)

Explanation
Question 2: Incorrect
What are the guidelines for optimizing ABAP code running on HANA? There are 3
correct answers.

Technical settings

(Correct)

Open SQL settings


 Column store

(Correct)

High-speed data analysis

(Incorrect)

DB specific properties

(Correct)

Explanation
Question 3: Incorrect
Which of the following is not a Golden Rule for Open SQL?

Minimize the Amount of Data Transferred

(Incorrect)

Minimize the Number of Database Accesses

Keep the result set large

(Correct)

Reduce the Database Load

Explanation
Question 4: Incorrect
 How many result sets are returned when an SAP HANA database procedure is
called using the CALL WITH OVERVIEW statement?

One result set

(Correct)

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

(Incorrect)

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

Two result sets

Explanation
Question 5: Incorrect
Hybrid Data Management System combining different paradigms in one system.
What are the capabilities associated with the Hybrid Data Management system?
There are 3 correct answers.

Built-in support for planning

(Correct)

Text indexing capabilities

Traditional disk-based tables

 (Correct)

Linguistic search capabilities

(Incorrect)

Text analysis and search

(Correct)

Explanation
Question 6: Incorrect
How  will you launch the debugger?  If you want to debug an ABAP program using
ABAP development tools (ADT).

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

Set a breakpoint in the ABAP program and execute the program

(Correct)

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

Choose the Run --> Debug options in the menu

(Incorrect)

Explanation
Question 7: Incorrect
Which of the following are View Annotations?
 There are 3 correct answers.

Authority checking

(Correct)

View Name

(Correct)

Client Handling

(Correct)

Semantics for Amount / Currency Code

(Incorrect)

Question 8: Incorrect
For which of the following expressions and built in functions in core data services
(CDS) View you must provide alias? There are 3 correct answers.

Currency Conversion

(Correct)

Unit conversion

(Correct)


CASE expression

(Correct)

CASTE Expression

Nested CASE expression

(Incorrect)

Explanation
Question 9: Correct
Which of the following objects can you use in the ABAP layer when using the top-
down approach to bring code to data?
There 2 correct answers.

CDS views

(Correct)

Calculation view

AMDP

(Correct)

Stored procedures
 Question 10: Incorrect
Which of the following tasks can you perform with SQL monitor transaction SQLM
?

Capture the SQL profile of an application

(Correct)

Combine static and dynamic performance analysis results

(Incorrect)

Display the execution plan of an SQL statement

Search for problematic SELECT* statements

Explanation
Question 11: Incorrect
What are the key points that should be kept in mind while performing the non
automatic update in SAP HANA Transport Container? There are 2 correct
answers.

Changes to Delta Container

You need to refresh the content of the container manually

(Correct)


 Automatic release of units

(Incorrect)

Take snapshot manually before releasing of the container

(Correct)

Explanation
Question 12: Correct
User XYZ creates and activates a design-time object. In which schema is the run
object generated?

_SYS_BIC

(Correct)

XYZ

SYSTEM

_SYS_BI
Question 13: Correct
What is the main function of Static Code Analysis?

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

(Correct)


Integrates with SAP Solution Manager

Integrated into ABAP Development Tools and ABAP Workbench

ABAP source code with performance optimization potential

Explanation
Question 14: Correct
Which of the following option provides access to the views and database
procedures that you can consume in the ABAP environment?

System Perspective

Catalogue outlook

Modeler Perspective

(Correct)

Open Content outlook

Explanation
Question 15: Correct
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.


The same number of columns

(Correct)

Columns of identical types

All key fields

Columns of compatible types

(Correct)

Explanation
Question 16: Incorrect
An access control (DCL source) defines access restrictions for a given CDS view.
These resctrictions are implicitly evaluated when the CDS view is accessed in the
following places?
There are 2 correct answers.

In ABAP open SQL

(Correct)

In definition of  another CDS view

(Incorrect)


 In data preview in ADT

(Correct)

In data browser (SE16)

Question 17: Correct
The SAP HANA database is a hybrid in-memory database that combines few
technologies within. What are these technologies? There are 3 correct answers.

Time-based database technology

Row-based database technology

(Correct)

Value-based database technology

Object-based database technology

(Correct)

Column-based database technology

(Correct)

Explanation
Question 18: Incorrect
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. Open the package

2.Select take snapshot and Save
3.Activate the SAP HANA Delivery unit
4.Activate the SAP HANA transport container

1.Open the ABAP transport request

2.Select take snapshot and Save
3.Activate the SAP HANA transport container

(Correct)

1.Open the SAP HANA transport container

2.Select take snapshot and Save
3.Activate the SAP HANA Transport Container

1.Open the SAP HANA delivery unit

2.Select take snapshot and Save
3.Activate the SAP HANA Delivery unit
3.Activate the SAP HANA transport container

(Incorrect)

Explanation
Question 19: Incorrect
What are the important features offers by SAP HANA to upload data from flat
files? There are 2 correct answers.

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

(Incorrect)


The supported file types for upload are: .cssv, .xlls, and .xlsxxx

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

(Correct)

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

(Correct)

Explanation
Question 20: Incorrect
What information can you specify using annotations (@) when you define a Core
Data Services (CDS) view in an ABAP system? There are 3 correct answers.

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

(Incorrect)

The client dependency of the CDS view

(Correct)

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

(Correct)


 The join conditions of the CDS view

(Incorrect)

The name of the representation of the CDS view in the ABAP dictionary

(Correct)

Explanation
Question 21: Correct
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?

A value that you calculate based on the number of tables

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

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

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

(Correct)

Explanation
Question 22: Incorrect
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.

High Performance and Scalability

 (Correct)

Support for system tables

Analytical DBMS features

(Incorrect)

Hybrid data and management system

(Correct)

Explanation
Question 23: Incorrect
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.

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

The database independency of your report can be lost.

(Correct)

Client handling needs to be done explicitely in the the Native SQL statement.

(Correct)


 The ABAP system checks the syntax of the Native SQL statements.

(Incorrect)

Explanation
Question 24: Incorrect
How SAP HANA supports SQL? There are 3 correct answers.

As a means to define

(Correct)

Manipulate data

(Correct)

Transferring data

(Incorrect)

Read

(Correct)

As a Data Calculator

Explanation
Question 25: Correct
What are the uses of SQL Trace (ST05)? There are 3 correct answers.

Detect redundant or identical select statements

 (Correct)

Applying Code inspector

Display record of all database access

(Correct)

Locate database performance issues

(Correct)

Locate work base issues

Explanation
Question 26: Correct
Which of the following features does the ABAP Test Cockpit offer that the ABAP
code Inspector does not offer?
There are 2 correct answers.

Configuration of check variants

Documented checks

Enhanced distribution of results

(Correct)


Flexible schedule of check runs

(Correct)

Explanation
Question 27: Correct
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.

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

(Correct)

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

(Correct)

All Keywords are case sensitive.

All arithmetic expressions can be used for all type of variables.

Explanation
Question 28: Correct
Which of the following is a limitation when you create an external view?

You must use ADT ABAP Development Tool to create an external view

(Correct)


You can use only native SQL to consume external view

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

You must know the underlying tables and join conditions of SAP HANA view
Question 29: Correct
What are the two main factors of SAP HANA Innovations and Challenges? There
are 2 correct answers.

SAP software technology and innovations

(Correct)

Hardware technology and innovations

(Correct)

DBMS technology and innovations

SAP BW innovations

Explanation
Question 30: Correct
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 ?


NEXT_PACKAGE

(Correct)

GET_METADATA

SET_PARAM

SET_PARAM_TABLE

Explanation
Question 31: Correct
What helps you to resolve errors  or warnings reported about the code?

Quick Fix

(Correct)

Debug perspective

ABAP debugger

Code execution
 Explanation
Question 32: Correct
What is an attribute view and what are its practices? There are 3 correct answers.

Used in diagrammatic Projections

May contain filters

(Correct)

May use in calculation views

(Correct)

Used to join tables

(Correct)

May contains flow charts

Explanation
Question 33: Incorrect
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.

Create an input parameter for the ADDRESS field



Map the ADDRESS field to a constant value

(Correct)

Exclude the ADDRESS field from the union

(Correct)

Create a restricted column for the ADDRESS field

(Incorrect)

Explanation
Question 34: Correct
ANSI SQL owns features and adds languages, these languages divided into three
parts. What are they? There are 3 correct answers.

Data Manipulation Language

(Correct)

The Database Language

Data Transferred Language

The Data Control Language

(Correct)


The Data Definition Language

(Correct)

Explanation
Question 35: Incorrect
You use the ABAP trace (SAT) to measure the run time of a program. In a class,
method A checks the validity of its importing parameters and calls method B.
What pattern of gross and net run time would you expect to see the in the ABAP
trace results for method A?

The gross and net run times are identical

The net run time is greater than the gross run time

(Incorrect)

The net run time is equal to Zero

The net run time is less than the gross run time

(Correct)

Explanation
Question 36: Incorrect
You created and activated database procedure. How can you call this procedure?
There are 2 correct answers.

By using Sap Analysis for Microsoft office



By a core data services view

(Incorrect)

By a script-based calculation view

(Correct)

By another database procedure

(Correct)

Explanation
Question 37: Correct
When would you use a column store table instead of a row store table? There are
2 correct answers.

When the table has a small number of records

When you require aggregation and analysis of values

(Correct)

When you want to enable a full-text search of the table

(Correct)

When there are mainly distinct values in the table

 Explanation
Question 38: Correct
What all are the factors involved in working with ADT ?.  There are 3 correct
answers.

ABAP Class

(Correct)

ABAP interface

(Correct)

Workbench programs

ABAP programs

(Correct)

Module interface

Explanation
Question 39: Incorrect
What are the different views provided by the ABAP Profiling? There are 2 correct
answers.

Database accesses

(Correct)


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

(Correct)

Performance Check methods

Metadata accesses

(Incorrect)

Explanation
Question 40: Incorrect
You made changes to an object B used by an ABAP managed database procedure
(AMDP). You did not changes the AMDP itself. Now you execute a program that
calls this AMDP. In which cases does the call trigger the creation of the database
procedure in SAP HANA? There are 2 correct answers.

B is an AMDP method

(Correct)

B is an SAP HANA view

(Incorrect)

B is a stored procedure.

(Incorrect)


 B is an ABAP Dictionary table

(Correct)

Explanation
Question 41: Incorrect
What are some of the features available in SAP List Viewer with integrated data
access (SALV IDA)? There are 3 correct answers.

Display diagrams

(Correct)

Group rows

(Correct)

Edit cells

Search in content

(Correct)

Double-click on rows

(Incorrect)

Explanation
Question 42: Correct
What are the two types of editors available in ADT? There are 2 correct answers.


 ABAP (native)

Eclipse (native)

(Correct)

Client (native)

SAP (GUI)

(Correct)

Explanation
Question 43: Incorrect
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.

HANA Specific features

(Incorrect)

Database Optimization

Buffer system Optimization

Transparent Optimizations
 (Correct)

Explanation
Question 44: Correct
Which tasks does the ABAP managed database (AMDP) framework perform?
There are 2 correct answers.

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

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

(Correct)

Delete the obsolete versions of the database procedure asynchronously

(Correct)

Delete the obsolete versions of the database procedure synchronously

Explanation

Free questions :-