S/4 Hana Certificaiton

Page 1

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

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 1/17

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:

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 2/17
DB client-server

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

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 3/17

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

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 4/17

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

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 5/17

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

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 6/17

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?

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 7/17

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

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 8/17

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:

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 9/17

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:

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 10/17
SYS_BIC SYSTEM SYS_BI STUDENT A

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:

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 11/17

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

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 12/17
it
{it
:it books @it books
books
books}

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.

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 13/17

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

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 14/17

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

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 15/17
Write only

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

5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 16/17
Read only
5/23/2021 SAP Certified Development Specialist - ABAP for SAP HANA - Full | ERPPrep https://www.erpprep.com/node/9094/take 17/17 Money Back Guarantee Testimonial FAQs Privacy Policy Terms and Conditions About Us Join Us Contact Us

Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.