SAP Certified Development Specialist - ABAP for SAP HANA - Full
You got 31 of 40 possible points.
Your score: 78 %
Question Results
Question:
What are the benefits includes with SAP HANA Full Text Search?
There are 2 correct answers to this question
Response:
Easy to use modeling tool
Exploit structured contents in SQL
Large number of toolkits are available
Fewer data duplication and movement
Question:
What are the elements of ABAP Database Integration?
There are 3 correct answers to this question
Response:
Application server
Client database handling
DB For ABAP
Other DB
Score 0 of 1
Score 1 of 1
Question:
Score 1 of 1
When using an SAP HANA full text search, what do you have to keep in mind? Please choose the correct answer
Response:
SAP HANA has to be the primary database to create a full text search.
The full-text index is always updated asynchronously.
The LIKE operator is required in your SELECT statement to implement fuzzy logic.
The SCORE( ) function is required to ensure the best hits of your search appear on top
Question:
Score 1 of 1
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 to this question.
Response:
All key fields
Columns of compatible types
The same number of columns
Columns of identical types
Question:
Score 1 of 1
Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP?
Choose the correct answer
Response:
Swap axes
Insert filter components
Create data by members and tables
Create Presentations
Question:
Score 1 of 1
Which form of services is responsible for defining and consuming semantically rich data models?
Please choose the correct answer.
Response:
Core Data Services
Modell-II services
ITe services
Conditional services
Question:
Score 1 of 1
Explain how and when to create calculated columns - Using Graphical Modeling Tools?
There are 3 correct answers to this question
Response:
It is possible to nest so that one calculated column, in turn, is based on other calculated columns
Calculated columns also support non-measure attributes as part of the calculation.
The calculation will be opened in a read-only mode
Time characteristics based calculation columns
The calculation could be an arithmetic or character manipulation
Question:
What are the basic principles of ALV SAP HANA?
There are 2 correct answers to this question.
Response:
Data described declaratively instead of passing big internal tables
The ALV Optimization for SAP HANA to display data on the screen
Score 1 of 1
To ensure that the user chooses the data on the selection screen is displayed
Only retrieve the database data which is to be displayed on screen
Question:
What benefits does SAP HANA Data Compression provide?
There are 2 correct answers to this question.
Response:
Optimized data partitioning
Optimized access to column store tables
Increased parallel processing
Reduced memory consumption
Question:
Score 1 of 1
Score 1 of 1
What are functions of the ABAP Managed Database Procedure (AMDP) framework?
There are 2 correct answers to this question.
Response:
It deletes obsolete versions of the database procedure asynchronously
It creates the database procedure when the AMDP is first activated
It deletes obsolete versions of the database procedure synchronously
It creates the database procedure when the AMDP is first called.
Question:
Score 0 of 1
What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)?
There are 3 correct answers to this question.
Response:
Define all method parameters to be passed by value.
List all ABAP Dictionary tables used in the procedure body in the USING clause.
Specify the database system and the language.
Use scalar types for all AMDP method parameters. Mark the AMDP method as a READ-ONLY database procedure.
Question:
Score 1 of 1
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?
Please choose the correct answer.
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 so id
select from snwd so { so id, sum(net amount) as sum amount } group by net amount
Question:
Score 1 of 1
You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause?
There are 3 correct answers to this question.
Response:
AMDP used in the procedure body
ABAP Dictionary views used in the procedure body
SAP HANA views used in the procedure body
CE function used in the procedure body
ABAP Dictionary table used in the procedure body
Question:
Score 0 of 1
Discuss different types of engines associated with The SAP HANA architecture?
There are 2 correct answers to this question
Response:
OLAP engine
Join engine
Analytic engine
OPAX engine
Question:
Score 1 of 1
You have created a CDS view and used aias names for some of its elements. In which of the following cases is the alias name mandatory?
There are 3 correct answers to this question.
Response:
CASE order type WHEN 'A' THEN 1 ELSE 0 END AS order type
ASSOCIATION TO sflight AS _flights
SUM(revenue) AS total revenue
crtdby AS created by CAST('USO' AS abap.cuky) AS currency key
Question:
Score 1 of 1
Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.
Response:
Database Procedure
CDS View
Database Table
External view
Internal table
Question:
Score 1 of 1
Which of the following tasks can you perform with SQL monitor (transaction SQLM)?
Response:
Display the execution plan of an SQL statement
Combine static and dynamic performance analysis results
Search for problematic SELECT* statements
Capture the SQL profile of an application
Question:
Score 1 of 1
What are the two main factors of SAP HANA Innovations and Challenges?
There are 2 correct answers to this question
Response:
HW technology and innovations
SAP SW technology and innovations
DBMS technology and innovations
SAP BW innovations
Question:
Name some perspectives that are available in the SAP HANA Studio?
There are 3 correct answers to this question
Response:
The Administration Console perspective
The Resources perspective
The SAP HANA Modeler perspective
The technology & innovation perspective
The Information perspective
Question:
What views will be most efficient for General Modeling Principles?
There are 2 correct answers to this question
Response:
Attribute view
Column view
Schema view
Analytical view
Score 1 of 1
Score 1 of 1
Question:
Score 1 of 1
You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause?
There are 3 correct answers to this question.
Response:
CE functions used in the procedure body
ABAP Dictionary views used in the procedure body
ABAP Dictionary tables used in the procedure body
SAP HANA views used in the procedure body
AMDPs used in the procedure body
Question:
Score 1 of 1
You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)?
There are 2 correct answers to this question.
Response:
It supports where-usedlist
It supports exception handing.
It supports locking and commit handling.
It has syntax check at compile time.
Question:
Score 1 of 1
Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.
Response:
Delete the obsolete versions of the database procedure asynchronously
Create a new version of the database when the AMDP is first activated
Delete the obsolete versions of the database procedure synchronously
Create a new version of the database when the AMDP is first called
Question:
Score 0 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:
Product-based Profitability
Service-based profitability
Costing-based Profitability
Account-based Profitability
Question:
Score 1 of 1
User STUDENT A create and activates a design-time object. In which schema is the run object generated?
Please choose the correct answer.
Response:
Question:
Score 1 of 1
In addition to closing the result set, what does the CLOSE method of the CL_SQL_RESULT SET class when using ABAP Database Connectivity (ADBC) do?
Please choose the correct answer
Response:
Release packages
Update packages
Update resources
Release resources
Question:
Score 1 of 1
Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)?
There are 3 correct answers to this question.
Response:
Changing
Importing Returning
Receiving
Exporting
Question:
Score 0 of 1
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 to this question.
Response:
Map the ADDRESS field to a constant value
Create an input parameter for the ADDRESS field
Create a restricted column for the ADDRESS field
Exclude the ADDRESS field from the union
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:
Question:
Score 0 of 1
What are the benefits associated with The SAP HANA real-time Operational analytics?
There are 2 correct answers to this question
Response:
High modeling flexibility
Query Speed support
Simplification of massive data
Fast insights into business activity
Question:
Score 1 of 1
Explain The Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question.
Response:
Application privileges
System privileges
Delta privileges
Object privileges
Analytic privileges
Question:
Score 1 of 1
Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA), and NOT the SAP HANA Transport Container (HTC).
Why would you choose HTA?
There are 2 correct answers to this question.
Response:
Because you automatically add changed objects to the transport request.
Because you always transport entire SAP HANA content packages
Because you can manually re-deploy objects after a failed import.
Because you use the technique that is recommended by SAP.
Question:
Score 0 of 1
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?
There are 2 correct answers to this question.
Response:
X is an AMDP method
X is an ABAP Dictionary table
X is a stored procedure.
X is an SAP HANA view
Question:
Score 0 of 1
Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer?
There are 2 correct answers to this question.
Response:
Documented checks
Flexible schedule of check runs
Configuration of check variants
Enhanced distribution of results
Question:
What are the different views provided by the ABAP Profiling?
There are 2 correct answers to this question
Response:
Performance Check methods
Database accesses
Metadata accesses
A Hitlist of the most time-consuming programs or methods
Score 1 of 1
Question:
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
Score 1 of 1
Bring logic to where the data is calculated first, then only move to results
Question:
Score 0 of 1
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?
Please choose the correct answer.
Response: SET PARAM TABLE GET METADATA SET PARAM NEXT PACKAGE
Question:
Score 1 of 1
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?
Please choose the correct answer.
Response: Read-update
Read-write
Question:
Score 1 of 1
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?
There are 2 correct answers to this question.
Response:
Form-based class builder
Quickfix
Content assistance
Screen editing
Question:
Score 1 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 client dependency of the CDS view
The extent to which records of the CDS view should be buffered on the application server
The name of the representation of the CDS view in the ABAP dictionary
The logic for aggregations, grouping records, and filtering groups of the CDS view
The join conditions of the CDS view