SAP Certified Development Specialist - ABAP For SAP HANA - Full

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

Your score was: 40 %
Question Results
Question: Score 1 of 1
Which step of the Guided Performance Analysis should you perform in the product on system?
Please choose the correct answer.
Response:
Building a work list with SQL Performance Tuning Work list (SWLT)
Executing a check run with ABAP Test Cockpit (ATC)
Performing an inspection with Code Inspector (SCI)
Collecting data with SQL Monitor (SQLM)
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?
Response:
PREV_FUNC_REG
FUNCTIONAL_DB
PERFORMANCE_DB
FUNCTIONAL_CHECK
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.
Response:
The database independency of your report can be lost.
The ABAP system checks the syntax of the Native SQL statements.
Client handling needs to be done explicitely in the the Native SQL statement.
Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword.
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?

Response:
SQL Monitor was activated with a fitter that excludes database table Y.
Database table Y is a buffered table.
SQL Monitor was activated for a specific application server.
Program X was executed in the background.
The data has NOT yet been transferred to the SQL Monitor database tables.
What all are the Types of Applications based on SAP HANA?
Response:
New or Native SAP HANA
Innovation based on SAP HANA
Data Mart based on SAP HANA
Server based on SAP HANA
You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after
the USING clause?
Response:
ABAP Dictionary tables used in the procedure body
ABAP Dictionary views used in the procedure body
SAP HANA views used in the procedure body
CE functions used in the procedure body
AMDPs used in the procedure body
What is the main purpose of SAML for SAP HANA Studio?

Response:
SAML may be selected as an Owner’s authentication method when creating users in the SAP HANA
Studio
The assertion is issued by a user after the client was successfully authenticated
The SAP HANA database supports login of Owners only
To support scenarios where clients are not directly connected to the SAP HANA Database
Which of the following is not an element of Analytical view?

Response:
Read Data from the joined database tables
Currency conversion is not applicable
Join fact tables
Used to Joined table
Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database?
Response:
Definition of full-text indexes
De-pooling and de-clustering
Definition of an enhancement category
Changes of data class
Storage type for tables

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 the Column Store storage type
SELECT * statements on tables with more than a specified number of fields
SELECT * statements on tables with more than 100,000 records
SELECT * statements where fewer than a specified percentage of all fields are effectively used
List down the elements involved in User Management and Security in SAP HANA?
Response:
Create users
Assign job security
Work management
Manage users
Assign security
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?
Response:
ORDER BY Clauses in Open SQL statements
Left outer joins in open SQL statements
Direct access to a cluster on the database
Native SQL statements
Code that relies on implicit database sorting
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 feature can you use to improve the performance of data transformation in the Extract, Transform
and Load (ETL) process?
Response:
Service Adaptation Description Language (SADL)
Process Agent Framework (PAF)

ABAP Managed Database Procedures (AMDP)
ABAP Messaging Channels (AMC)
What all are the steps to perform -To enable type-ahead for an input field on a screen?
Response:
Check Pre-Requisites
Identify Elementary Search Help
Process on all the input fields
Automatic updates of all the input fields
Switch on proposal search for input fields
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?
Response:
Existence check for Secondary Indexes
Missing ORDER BY or SORT after SELECT
Use of Native SQL and DB Hints
Direct access to Table Pools/Cluster
How to create a core data services view?
Response:
Use data services tools for updates
Use SQL capabilities for Netweaver
Use DDL statement DEFINE VIEW and SQL-like syntax to define the view
Use additional annotations – marked with the @ sign
Use the ABAP Development Tools for SAP NetWeaver.
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?
Response:
select from snwd_so { so_id, sum(net_amount) as sum_amount }
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
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
Which system schema contains the column views of activated objects?

Response:
_SYS_XS
_SYS_REPO
_SYS_BIC
_SYS_BI
What views will be most efficient for General Modeling Principles?

Response:
Schema view
Analytical view
Attribute view
Column view
Which of the following are characteristics of an external view?
Response:
It allows access to an SAP HANA information view with Open SQL.
It is an ABAP Dictionary object type.
It defines the underlying SAP HANA information view.
It can be used as a data type in ABAP programs.
It can be used in Open SQL statements for database updates.
What do you understand by The SAP HANA Software Optimization?

Response:
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
What are the basic principles of ALV SAP HANA?

Response:
Only retrieve the database data which is to be displayed on screen
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
Data described declaratively instead of passing big internal tables
Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in
the Classical ABAP workbench?
Response:
Core Data service (CDS) view
ABAP program containing new Open SQL
Full-text index
Database procedure proxy
External view
Which of the following are view annotations for a CDS view?

Response:
Client handling
Access control
Environment
Buffering type
Semantics
User STUDENT_A creates and activates a design-time object. In which schema is the runtime object
generated?
Response:
_SYS_ BIC
_SYS_ BI
STUDENT_A
SYSTEM
Which of the below statements are true for SAP HANA Studio?
Response:
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 an Eclipse-based, integrated development environment (IDE) that is used to
develop artifacts in a HANA server.
SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.
SAP HANA Studio is integrated in SAP GUI > 7.40
The new bottlenecks avoided by addressing two challenges, what are they?
Response:
Avoid optimizing data

Avoid idling CPU cores
Avoid single network
Avoid CPU cache misses
SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANA has to meet.
What are these goals?
Response:
Support for system tables
Hybrid data and management system
Analytical DBMS features
High Performance and Scalability
What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA?
Response:
Scaling
Optimize
Tuning
Innovate
Detect
Which of the following features were added to the ABAP dictionary to support the SAP HANA database?
Response:
De-pooling and de-clustering
Definition of enhancement category
Change of data class
Storage type for tables
Definition of full-text indexes
What is the central goal of using SAP HANA?

Response:
Monitor database for record keeping
Positive Impact on Business
Accelerate Performance
To set Priorities for system
Which code-to-data capability is responsible for the Optimizations & Translation of “Open SQL SELECT FOR
ALL ENTRIES “clauses into native SQL?
Response:
Transparent Optimizations
Buffer system Optimization
HANA Specific features
Database Optimization
What is the Limitations of ALV for SAP HANA?

Response:
Without currency / unit consideration
All unit / currency restricted to 10,00,00 records
Restricted to 10,000 records
No unit / currency split if aggregating amounts / currency values
Restricted to 5000 records / unit
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 AMDP.
In which cases does the call trigger the creation of the database procedure in SAP HANA?
Response:
X is an SAP HANA view
X is an ABAP Dictionary table
X is an AMDP method
X is a stored procedure.
What are the Parameters for Analytical and Calculation view?

Response:
Create a copy of a report
Setting a filter for columns
To store data for critical analysis
Specifying unit of measurement
Passing other values to be used in calculations
Which features does the source code editor provide in ABAP Development Tools (ADT)?
Response:
Content Assist
Form-based Class Builder
Screen Painter
Quick Fix
When would you use a column store table instead of a row store table?
Response:
When there are mainly distinct values in the table

When you require aggregation and analysis of values
When you want to enable a full-text search of the table
When the table has a small number of records
You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation
node. This is the data that goes into the aggregation node:
What does the result of the aggregation look like?

Response:
Option B
Option D
Option C
Option A
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 16 of 40 possible points.

Executing a check run with ABAP Test Cockpit (ATC)

Performing an inspection with Code Inspector (SCI)

Collecting data with SQL Monitor (SQLM)

The database independency of your report can be lost.

What could be the reason?

Database table Y is a buffered table.

SQL Monitor was activated for a specific application server.

Program X was executed in the background.

New or Native SAP HANA

Innovation based on SAP HANA

Data Mart based on SAP HANA

Server based on SAP HANA

ABAP Dictionary tables used in the procedure body

ABAP Dictionary views used in the procedure body

SAP HANA views used in the procedure body

CE functions used in the procedure body

AMDPs used in the procedure body

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

The SAP HANA database supports login of Owners only

Which of the following is not an element of Analytical view?

Read Data from the joined database tables

Currency conversion is not applicable

Join fact tables

Used to Joined table

Definition of full-text indexes

De-pooling and de-clustering

Definition of an enhancement category

Changes of data class

Storage type for tables

SELECT * statements on tables with the Column Store storage type

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

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

Assign job security

Left outer joins in open SQL statements

Direct access to a cluster on the database

Native SQL statements

Code that relies on implicit database sorting

How can you address the calculation view?

Service Adaptation Description Language (SADL)

Process Agent Framework (PAF)

ABAP Messaging Channels (AMC)

Identify Elementary Search Help

Process on all the input fields

Automatic updates of all the input fields

Switch on proposal search for input fields

Existence check for Secondary Indexes

Missing ORDER BY or SORT after SELECT

Use of Native SQL and DB Hints

Direct access to Table Pools/Cluster

Use data services tools for updates

Use SQL capabilities for Netweaver

Use additional annotations – marked with the @ sign

Use the ABAP Development Tools for SAP NetWeaver.

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

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