E Hanaaw 12 14

9/16/2018 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep
SAP Certified Development Specialist - ABAP for SAP

HANA - Full
You got 38 of 40 possible points.

Your score: 95 %
Question Results
Question: Score 1 of 1
What are the features associated with ABAP CDS?
There are 3 correct answers to this question.
Response:
Read
Create
Export
Distribution
Update
What are the steps involved in supporting a database oriented programming

model?
Response:
Advanced and specific models
A new and advanced Open SQL
Core Data services
https://www.erpprep.com/node/9094/take 1/17
Buffer system services
What are the benefits includes with SAP HANA Full Text Search?
There are 2 correct answers to this question
Response:
Fewer data duplication and movement
Easy to use modeling tool
Large number of toolkits are available
Exploit structured contents in SQL
What are the benefits associated with The SAP HANA real-time Operational
analytics?
Response:
Query Speed support
Fast insights into business activity
Simplification of massive data
High modeling flexibility
What are the different views provided by the ABAP Profiling?
Response:
Performance Check methods
Metadata accesses
Database accesses
A Hitlist of the most time-consuming programs or methods
When are referential joins executed in analytical views?
Choose the correct answer
Response:
When fields are selected
When fields from both the tables are requested
When fields are optimized
When all the tables are optimized
Name the views that are available to administer and monitor one or several SAP
HANA systems?
Response:
The Security view
The Landscape view
The Administration view
The System Monitor view
What are the two Profitability Analysis available with CO-PA Scenario in SAP
HANA Modeling?
Response:
Account-based Profitability
Costing-based Profitability
Product-based Profitability
Service-based profitability
You are implementing an ABAP Managed Database Procedures (AMDP) for SAP
HANA. What do you have to do in the corresponding ABAP class?
Please choose the correct answer.
Response:
Set the visibility of the corresponding class method in the declaration section to
PUBLIC.
Implement the interface IF_AMDP_MARKER_HDB.
Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
Implement the ABAP AMDP_HDB Event Handler.
What are the ABAP development guidelines?
Response:
Improved hybrid components for SAP HANA
Consuming Only ABAP contents for SAP HANA
Extensions to ABAP Language

Improved tools for performance analysis
Explain how and when to create calculated columns - Using Graphical Modeling
Tools?
Response:
Calculated columns also support non-measure attributes as part of the calculation.
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
The calculation could be an arithmetic or character manipulation.
Time characteristics based calculation columns
List down the elements involved in User Management and Security in SAP HANA?
Response:
Assign job security
Create users
Work management
Manage users
Assign security
Open SQL largely standardized, three sub-languages. What are these sub-
languages?
Response:
Data Manipulation Language (DML)
The Data Definition Language (DDL)
Data Transferring Language(DTL)
The Data Control Language (DCL)
Data Evaluation Language(DEL)
What are the two types of editors available in ADT?
Response:
Client (native)
Eclipse (native)
ABAP (native)
SAP (GUI)
Which of the following option provides access to the views and database
procedures that you can consume in the ABAP environment?
Response:
Open Content outlook
Modeler Perspective
Catalogue outlook
System Perspective
Which of the following is not involved in database table of “The New ABAP SQL
Monitor – Architecture”?
Response:
Critical data table
Performance data table
Selection data table
Runtime monitor data
What are the three best approach for Transitioning and optimizing ABAP
applications to SAP HANA?
Response:
Innovate
Detect
Optimize
Scaling
Tuning
Discuss the conditions required to ensure the Referential Integrity?
Response:
Referential integrity holds true in both the directions
There are three joins in the table
There is at least one join in the other table
There are two joins in the able
What should you do to follow the code-to-data approach to programming?

Response:
Perform expensive calculations on the database.
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.
Perform expensive calculations on the ABAP application server.
Hybrid Data Management System – Combining different paradigms in one

system. Discuss capabilities associated with the Hybrid Data Management
system?
Response:
Text indexing capabilities
Linguistic search capabilities
Built-in support for planning
Traditional disk-based tables
Text analysis and search
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?

Response:
Write only
Read only
Read-update
Read-write
ABAP 7.4 provides support for optimizing ABAP applications running on SAP
HANA. What are these Transparent Optimizations?
Response:
Re- use components have been extended or optimized for SAP HANA
Performance analysis tools have been improved
The ABAP language and the OpenSQL language have been extended
The consumption of SAP HANA artifacts was simplified
Do all the data processing in Application server
Name some perspectives that are available in the SAP HANA Studio?
Response:
The Administration Console perspective
The technology & innovation perspective
The Resources perspective
The Information perspective
The SAP HANA Modeler perspective
List down the four main concepts of the SAP HANA database?
Response:
Object store
Tools combinations
Partitioning
Compression
Column Store
Which is not a Golden Rule for Open SQL?
Response:
Minimize the Number of Database Accesses
Reduce the Database Load
Keep the result set large
Minimize the Amount of Data Transferred
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?
Response:
:it_books
it_books
{it_books}
@it_books
What are functions of the ABAP Managed Database Procedure (AMDP)

framework?
Response:
It creates the database procedure when the AMDP is first called.
It creates the database procedure when the AMDP is first activated.
It deletes obsolete versions of the database procedure asynchronously
It deletes obsolete versions of the database procedure synchronously.
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?
Response:
Include the client field in the join condition.
Include the client field in the field list.
Use the CLIENT SPECIFIED addition.
Include the client field in the WHERE condition.
The source code editor in ADT provides many helpful features. What are these
helpful features?
Response:
Creating Parts for Interface Methods
Creating Method Definitions from Implementation Parts
Creating interface from Method Calls
Creating Method Implementations from the Method Definition
Which features does the source code editor provide in ABAP Development Tools
for SAP NetWeaver?
Response:
Quickfix
Screen editing
Content assistance
Form-based class builder
An Analytic Privilege consists of several restrictions. What are they?
There 3 correct answers to this question
Response:
Validity restrictions
Activity restrictions
Cube restrictions
Analytic restrictions
View restrictions
Which of the following option is not the main capability of SAP BusinessObjects
Analysis for OLAP?
Response:
Create data by members and tables
Insert filter components
Create Presentations
Swap axes
How SAP HANA supports SQL?
Response:
As a means to define
Manipulate data
Read
As a Data Calculator
Transferring data
Which of the following is not an element of Analytical view?
Response:
Join fact tables
Currency conversion is not applicable
Used to Joined table
Read Data from the joined database tables
Explain Transitioning ABAP Code to SAP HANA – Performance Considerations?

Response:
Some codes transferred to other systems
Some shifts in priorities, examples, nested selects(higher) indices(lower)
Classical performances recommendations for open SQL remain valid
Some codes impacted positively and should be priorities
Some codes immediately run faster
Explain the Enterprise Information System of - SAP HANA Implementation

Scenarios?
Response:
All HANA Combinations on one platform
Business Suite on HANA / BW on SAP HANA
HANA Accelerators
HANA Modeling
All SAP applications on one SAP HANA platform
What information can you specify using annotations (marked with the @ sign)
when you define a Core Data Services (CDS) view in an ABAP system?
Response:
The extent to which records of the CDS view should be buffered on the application
server
The join conditions of the CDS view
The name of the representation of the CDS view in the ABAP dictionary
The client dependency of the CDS view
The logic for aggregations, grouping records, and filtering groups of the CDS view
Which form of services is responsible for defining and consuming semantically

rich data models?
Response:
Modell-II services
Core Data Services
Conditional services
ITe services
To upload data from flat files, SAP HANA offers several features. What are these
important features?
Response:
The supported file types for upload are: .cssv, .xlls, and .xlsxxx
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
The new table always has a 2:2 mapping between the file and table columns
Discuss different types of engines associated with The SAP HANA architecture?
Response:
OPAX engine
Join engine
OLAP engine
Analytic engine
Money Back Guarantee Testimonial FAQs Privacy Policy Terms and Conditions About Us Join Us
Contact Us

E Hanaaw 12 14

Uploaded by

Copyright:

Available Formats

E Hanaaw 12 14

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

E Hanaaw 12 14

Uploaded by

Copyright:

Available Formats

9/16/2018 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep

SAP Certified Development Specialist - ABAP for SAP

You got 38 of 40 possible points.

What are the features associated with ABAP CDS?

There are 3 correct answers to this question.

What are the steps involved in supporting a database oriented programming

There are 2 correct answers to this question.

Advanced and specific models

A new and advanced Open SQL

Core Data services

Buffer system services

There are 2 correct answers to this question

Fewer data duplication and movement

Easy to use modeling tool

Large number of toolkits are available

Exploit structured contents in SQL

Query Speed support

Fast insights into business activity

Simplification of massive data

High modeling flexibility

What are the different views provided by the ABAP Profiling?

There are 2 correct answers to this question.

Performance Check methods

A Hitlist of the most time-consuming programs or methods

When are referential joins executed in analytical views?

Choose the correct answer

When fields are selected

When fields from both the tables are requested

When fields are optimized

When all the tables are optimized

There are 2 correct answers to this question

The Security view

The Landscape view

The Administration view

The System Monitor view

There are 2 correct answers to this question

Please choose the correct answer.

Implement the interface IF_AMDP_MARKER_HDB.

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

Implement the ABAP AMDP_HDB Event Handler.

What are the ABAP development guidelines?

There are 2 correct answers to this question.

Improved hybrid components for SAP HANA

Consuming Only ABAP contents for SAP HANA

Extensions to ABAP Language

Improved tools for performance analysis

There are 3 correct answers to this question

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

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

The calculation could be an arithmetic or character manipulation.

Time characteristics based calculation columns

There are 3 correct answers to this question

Assign job security

There are 3 correct answers to this question

Data Manipulation Language (DML)

The Data Definition Language (DDL)

Data Transferring Language(DTL)