SAP Certified Development Specialist - ABAP For SAP HANA - Full

SAP Certified Development Specialist - ABAP for SAP HANA - Full
You got 23 of 40 possible points.

Your score was: 58 %
Question Results
Question: Score 1 of 1
What all are the factors involved in Working with ADT

There are 3 correct answers to this question.
Response:
Module interface
ABAP programs
ABAP interface
ABAP Class
Workbench programs
What output does The SAP HANA provide as a unique combination of hardware and software innovations?
Please choose the correct answer.
Response:
Huge potential to optimize AMDP application DATA Tables
Huge potential to maximize the number of disk blocks in the application
Huge potential to optimize business applications that are running on SAP HANA
The ability to create new complex processes with ABAP application cloud
You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data?
Response:
Use a Comma-separated column list
Use the UP TO n ROWS addition
Specify the database schema if it is not the user's default schema
Use the tilde symbol (~) to separate qualifier from column name
Explicitly handle the client field
Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database?
Response:
Changes of data class
De-pooling and de-clustering
Definition of full-text indexes
Storage type for tables
Definition of an enhancement category
What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP
HANA database?
Response:
The database independency of your report can be lost.
Client handling needs to be done explicitely in the the Native SQL statement.
The ABAP system checks the syntax of the Native SQL statements.
Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword.
What are the different types of Calculation View?

Response:
Graphical Calculation View
Text-Based Calculation
Scripted Calculation View
OLAP Calculation View
Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”?
Response:
Critical data table
Selection data table
Performance data table

Runtime monitor data
Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA?
Response:
Parallel processing
Database table compression
Dictionary encoding
Columnar data storage
(skipped)
What is the Limitations of ALV for SAP HANA?
Response:
Restricted to 5000 records / unit
Without currency / unit consideration
No unit / currency split if aggregating amounts / currency values
Restricted to 10,000 records
All unit / currency restricted to 10,00,00 records
You want to perform an SAP HANA full-text search on column COL of database table TAB. Which of the
following conditions have to be fulfilled?
Response:
Table TAB is located in column store
Column COL is of type TEXT or SHORTTEXT
A full text index exists for column COL of table TAB
The application server release is 7.40 SP05 or higher
Which of the following is a limitation when you create an external view?

Response:
You must use the ABAP Development tools (ADT) TO CREATE the external 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 know the underlying tables and join conditions of the SAP HANA view.
What should you do to follow the code-to-data approach to programming?

Response:
Aggregate data on the database, and transfer the results to the ABAP layer.
Transfer all data from the database to the ABAP layer, and then aggregate the results.
Perform expensive calculations on the ABAP application server.
Perform expensive calculations on the database.

Use native SQL to access SAP HANA built-in functions.
(skipped)
Hybrid Data Management System – Combining different paradigms in one system. Discuss
capabilities associated with the Hybrid Data Management system?
Response:
Traditional disk-based tables
Text analysis and search
Built-in support for planning
Text indexing capabilities
Linguistic search capabilities
(skipped)
You define a core data services (CDS) View. For which of the following expressions and built
in functions must you provide alias?
Response:
Unit conversion
CASTE Expression
Currency Conversion
CASE expression
Nested CASE expression

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?
Response:
Code completion options
Code formatting options
Statement template options
Editor shortcut key options
The new bottlenecks avoided by addressing two challenges, what are they?
Response:
Avoid single network
Avoid CPU cache misses
Avoid idling CPU cores
Avoid optimizing data
How SAP HANA supports SQL?

Response:
Manipulate data
As a Data Calculator
Read
Transferring data
As a means to define
When using an SAP HANA full text search, what do you have to keep in mind?
Response:
The SCORE( ) function is required to ensure the best hits of your search appear on top.
The full-text index is always updated asynchronously.
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.
Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in
the Classical ABAP workbench?
Response:
Full-text index
External view
ABAP program containing new Open SQL
Core Data service (CDS) view
Database procedure proxy

What are the two different kinds of Identifiers used to represent names used in SQL statement?
Response:
Delimited identifiers
Limited identifiers
Undelimited Identifiers
Numeric identifiers
You implement an ABAP-managed database procedure (AMDP). Within this AMDP, you want to query data
from calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb.
How can you address the calculation view?

Response:
_SYS_ BIC."ha400.prirndb/CA_BOOKINGS_COUNT"
"ha400.primdb::CA_BOOKINGS_COUNT"
"ha400.pr mdb/CA_BOOKINGS_COUNT"
_SYS_ BIC."ha400.primdb::CA_BOOKINGS_COUNT"
Which of the below statements are true for SAP HANA Studio?
Response:
SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to
develop artifacts in a HANA server.
SAP HANA Studio is integrated in SAP GUI > 7.40
SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user
authorizations, to create new or modify existing models of data etc
SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.
Discuss the conditions required to ensure the Referential Integrity?

Response:
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
There are three joins in the table
What are the features associated with ABAP CDS?

Response:
Read
Update
Distribution
Create
Export
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?
Response:
SELECT * statements on tables with more than a specified number of fields
SELECT * statements on tables with more than 100,000 records
SELECT * statements on tables with the Column Store storage type
SELECT * statements where fewer than a specified percentage of all fields are effectively used
(skipped)
What are the key points that should be kept in mind while performing the Nonautomatic
update in SAP HANA Transport Container?
Response:
Changes to Delta Container
You need to refresh the content of the container manually
Take snapshot manually before releasing of the container
Automatic release of units
What are the steps that supported several tools, which in total result in a Guided Performance
Optimization?
Response:
A new tool called SQL Monitor to determine the priority if different programs access the database
intensively
The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime
consumption
Tools analyzing performance at run-time, to determine if critical constructs
A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and
performance issues.
What are the two types of editors available in ADT?

Response:
ABAP (native)
SAP (GUI)
Client (native)
Eclipse (native)
An Analytic Privilege consists of several restrictions. What are they?

Response:
Validity restrictions
Analytic restrictions
Activity restrictions
View restrictions
Cube restrictions
You are programming a report that reads data from a secondary HANA database (DB). What do you need
to consider in your SQL statement?
Response:
All tables and fields you are using must exist in the ABAP Dictionary of the Secondary DB.
You have to use native SQL when reading data from the secondary DB.
You have to specify the DB schema explicity in your statement.
You have to specify the DB connection explicitly in your statement.
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?
Response:
COLUMN
GLOBAL TEMPORARY
ROW
LOCAL TEMPORARY
Which of the following are view annotations for a CDS view?

Response:
Semantics
Buffering type
Client handling
Access control
Environment
You are debugging in ABAP Development Tools in Eclipse. What features are available?
Response:
Watch points
Debugger scripting
Memory usage analysis
Conditional breakpoints
Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA?
Response:
Use array variants of INSERT UPDATE MODIFY and DELETE
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

When are referential joins executed in analytical views?

Response:
When fields from both the tables are requested
When all the tables are optimized
When fields are selected
When fields are optimized
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?
Response:
GET_METADATA
SET_PARAM_TABLE
NEXT_PACKAGE
SET_PARAM
Which engine is used to execute Analytic View?

Response:
SQL Engine
OLAP Engine
Join Engine
Calc Engine
What are the components of The Enterprise Procurement Model Demo Scenario?
Response:
Product
Services
Procurement
Stock
Sales
What are the Parameters for Analytical and Calculation view?

Response:
Setting a filter for columns
Specifying unit of measurement
Passing other values to be used in calculations
Create a copy of a report
To store data for critical analysis

What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event
of a disaster?
Response:
High availability configuration
Services-Name and index server on all nodes
Shared file systems for only one server
Active clusters for all servers
Money Back Guarantee Testimonial FAQs Privacy Policy Terms and Conditions About Us Join Us Contact Us

SAP Certified Development Specialist - ABAP For SAP HANA - Full

Uploaded by

Copyright:

Available Formats

SAP Certified Development Specialist - ABAP For SAP HANA - Full

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

SAP Certified Development Specialist - ABAP For SAP HANA - Full

Uploaded by

Copyright:

Available Formats

SAP Certified Development Specialist - ABAP for SAP HANA - Full

You got 23 of 40 possible points.

What all are the factors involved in Working with ADT

Huge potential to optimize AMDP application DATA Tables

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

Use a Comma-separated column list

Use the UP TO n ROWS addition

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

Explicitly handle the client field

Changes of data class

De-pooling and de-clustering

Definition of full-text indexes

Storage type for tables

Definition of an enhancement category

The database independency of your report can be lost.

What are the different types of Calculation View?

Graphical Calculation View

Scripted Calculation View

OLAP Calculation View

Critical data table

Selection data table

Performance data table

Database table compression

Columnar data storage

Restricted to 5000 records / unit

Without currency / unit consideration

No unit / currency split if aggregating amounts / currency values

Restricted to 10,000 records

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

Table TAB is located in column store

Column COL is of type TEXT or SHORTTEXT

A full text index exists for column COL of table TAB

The application server release is 7.40 SP05 or higher

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

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

Perform expensive calculations on the ABAP application server.

Perform expensive calculations on the database.

Traditional disk-based tables

Text analysis and search

Built-in support for planning

Text indexing capabilities

Linguistic search capabilities

Nested CASE expression

Code completion options

Code formatting options

Statement template options

Editor shortcut key options

Avoid single network

Avoid CPU cache misses

Avoid idling CPU cores

Avoid optimizing data

How SAP HANA supports SQL?

The full-text index is always updated asynchronously.

ABAP program containing new Open SQL

Core Data service (CDS) view

Database procedure proxy

How can you address the calculation view?

Discuss the conditions required to ensure the Referential Integrity?