SAP Certified Development Specialist - ABAP for SAP
HANA - Full
You got 35 of 38 possible points.
Your score was: 92 %
Question Results
Question: Score 1 of 1
Which steps do you have to perform when defining a view using core data
services (CDS)?
There are 3 correct answers to this question.
Response:
Define the type mapping between ABAP and SAP HANA
Use the DDL statement DEFINE VIEW and SQL like Syntax
Create a proxy object for the defined view.
Create a data definition in your ABAP package
Specify the name of the SQL view in ABAP Dictionary
Question: Score 1 of 1
What allows you to resolve errors quickly or warnings reported about the
code?
Please choose the correct answer.
Response:
ABAP debugger
Code execution
Debug perspective
Quick Fix
Question: Score 1 of 1
What do you understand by The SAP HANA Software Optimization?
Choose the correct answer
Response:
Speed up the processing within the database
Provide combinations of Objects and Partitioning
Huge potential for hybrid database
Bring logic to where the data is calculated first, then only move to results
Question: Score 1 of 1
What are the supported joins in CDS view?
There are 2 correct answers to this question.
Response:
Operators joint
Upper join
Left outer join
Inner join
Question: Score 1 of 1
What are the two layers of ABAP system interacts with its database?
There are 2 correct answers to this question.
Response:
The Client database interface
The Database specific library
The Database independent interface
The Data Storage interface
Question: Score 1 of 1
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?
Please choose the correct answer.
Response:
@it_books
{it_books}
:it_books
it_books
Question: Score 1 of 1
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:
Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
Implement the ABAP AMDP_HDB Event Handler.
Set the visibility of the corresponding class method in the declaration section
to PUBLIC.
Implement the interface IF_AMDP_MARKER_HDB.
Question: Score 1 of 1
What are best practices when programming in ABAP for SAP HANA?
There are 2 correct answers to this question.
Response:
Eliminate nested SELECT statements to reduce the overall number of
database accesses
Use a column list in the SELECT clause to ensure that you only read a
column if it is really required
Calculate aggregations using ABAP code on the application server to limit
database load
Use repeated SELECT SINGLE statements to ensure that you only read arrow
if it is really required
Question: Score 1 of 1
When would you use a column store table instead of a row store table?
There are 2 correct answers to this question.
Response:
When you want to enable a full-text search of the table
When you require aggregation and analysis of values
When there are mainly distinct values in the table
When the table has a small number of records
Question: Score 1 of 1
What are the principles of Using HANA Transport Containers properly?
There are 3 correct answers to this question.
Response:
Takes a ‘snapshot’ of all SAP HANA objects of delivery unit
To create Transport container of delivery unit
Automatic update for all export methods
Release of Transport request
Import of Transport Request
Question: Score 1 of 1
In an ABAP Core Data services (CDS) view, what must you do expose an
association for use in another CDS view?
Please choose the correct answer.
Response:
SPECIFY THE OTHER VIEWS IN WHICH THE ASSOCIATION CAN BE USED
Include all fields used in the ON condition in projection list
specify an alias for the target entity
define the cardinality for the target entity
Question: Score 1 of 1
How will you hide the attributes that are not required for client
consumption?
Choose the correct answer
Response:
By setting the hidden property flag of the attribute column
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
Question: Score 1 of 1
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.
Response:
The table contains only a small number of records.
The table contains data that you want to aggregate.
The table contains text that you want to search.
The table contains mainly distinct values per column across rows.
Question: Score 1 of 1
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
Response:
Fuzzy search
Freestyle search
Weights for ranking
Index search
Point base ranking
Question: Score 1 of 1
What are the three best approach for Transitioning and optimizing ABAP
applications to SAP HANA?
There are 3 correct answers to this question.
Response:
Innovate
Detect
Optimize
Scaling
Tuning
Question: Score 1 of 1
What are the two Profitability Analysis available with CO-PA Scenario in
SAP HANA Modeling?
There are 2 correct answers to this question
Response:
Costing-based Profitability
Service-based profitability
Product-based Profitability
Account-based Profitability
Question: Score 1 of 1
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
Response:
Shared file systems for only one server
High availability configuration
Active clusters for all servers
Services-Name and index server on all nodes
Question: Score 1 of 1
How SAP HANA supports SQL?
There are 3 correct answers to this question.
Response:
As a means to define
Read
Transferring data
As a Data Calculator
Manipulate data
Question: Score 1 of 1
What are the benefits includes with SAP HANA Full Text Search?
There are 2 correct answers to this question
Response:
Exploit structured contents in SQL
Large number of toolkits are available
Easy to use modeling tool
Fewer data duplication and movement
Question: Score 1 of 1
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.
Response:
ORDER BY Clauses in Open SQL statements
Direct access to a cluster on the database
Native SQL statements
Left outer joins in open SQL statements
Code that relies on implicit database sorting
Question: Score 1 of 1
You import an ABAP workbench request into a 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.
Response:
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 has primary database
Question: Score 1 of 1
Which features does the source code editor provide in ABAP Development
Tools (ADT)?
There are 2 correct answers to this question.
Response:
Screen Painter
Quick Fix
Form-based Class Builder
Content Assist
Question: Score 1 of 1
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.
Response:
Unit conversion
CASTE Expression
Currency Conversion
CASE expression
Nested CASE expression
Question: Score 1 of 1
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.
Response:
Hybrid data and management system
Analytical DBMS features
Support for system tables
High Performance and Scalability
Question: Score 1 of 1
What are the Parameters for Analytical and Calculation view?
There are 3 correct answers to this question.
Response:
To store data for critical analysis
Create a copy of a report
Specifying unit of measurement
Passing other values to be used in calculations
Setting a filter for columns
Question: Score 1 of 1
Open SQL largely standardized, three sub-languages. What are these sub-
languages?
There are 3 correct answers to this question
Response:
Data Evaluation Language(DEL)
The Data Definition Language (DDL)
Data Transferring Language(DTL)
The Data Control Language (DCL)
Data Manipulation Language (DML)
Question: Score 1 of 1
Which is not a Golden Rule for Open SQL?
Please choose the correct answer.
Response:
Reduce the Database Load
Keep the result set large
Minimize the Number of Database Accesses
Minimize the Amount of Data Transferred
Question: Score 0 of 1
What are the Guidelines for optimizing ABAP code running on HANA?
There are 3 correct answers to this question.
Response:
DB specific properties
Column store
High-speed data analysis
Open SQL settings
Technical settings
Question: Score 1 of 1
What are the features of New Open SQL?
There are 2 correct answers to this question.
Response:
Supports specific units of database
Supports arithmetic and string expressions
Supports Code adjustment model
Supports conditional expressions
Question: Score 1 of 1
What are the features associated with ABAP CDS?
There are 3 correct answers to this question.
Response:
Create
Distribution
Export
Read
Update
Question: Score 1 of 1
Which of the following tools and programming techniques use the SQL
data definition language?
There are 2 correct answers to this question.
Response:
Open SQL
Core data service (CDS) access control
Core data services (CDS) data definition
ABAP Dictionary
Question: Score 0 of 1
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.
Response:
The join conditions of the CDS view
The extent to which records of the CDS view should be buffered on the
application server
The client dependency of the CDS view
The logic for aggregations, grouping records, and filtering groups of the CDS
view
The name of the representation of the CDS view in the ABAP dictionary
Question: Score 1 of 1
Which of the following option provides access to the views and database
procedures that you can consume in the ABAP environment?
Please choose the correct answer.
Response:
Catalogue outlook
Open Content outlook
Modeler Perspective
System Perspective
Question: Score 0 of 1
Which of the following tasks can you perform with SQL monitor
(transaction SQLM)?
Response:
Search for problematic SELECT* statements
Display the execution plan of an SQL statement
Combine static and dynamic performance analysis results
Capture the SQL profile of an application
Question: Score 1 of 1
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.
Response:
linguistic search
Isolation search
Fuzzy search
ACID search
freestyle search
Question: Score 1 of 1
Explain Transitioning ABAP Code to SAP HANA – Performance
Considerations?
There are 3 correct answers to this question.
Response:
Some codes immediately run faster
Classical performances recommendations for open SQL remain valid
Some codes transferred to other systems
Some shifts in priorities, examples, nested selects(higher) indices(lower)
Some codes impacted positively and should be priorities
Question: Score 1 of 1
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.
Response:
A BADI definition
AN enhancement spot
A database procedure
A BADI fallback implementation
A BADI simple implementation
Question: Score 1 of 1
What are the two different kinds of Identifiers used to represent names
used in SQL statement?
There are 2 correct answers to this question
Response:
Delimited identifiers
Numeric identifiers
Undelimited Identifiers
Limited identifiers
Money Back Guarantee Testimonial FAQs Privacy Policy Terms and Conditions About Us
Join Us Contact Us
