FV2023_HA_17_SU1

In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer. Editor shortcut options. Statement Template options. Code formatting option. Code completion option.

One of your SAP systems needs to be migrated from its current database to an SAP HANA 3 answers to this question. • Left outer joins in open SQL statements. • Native SQL statements. • ORDER BY Clauses in Open SQL statements. • Code that relies on implicit database sorting. • Direct access to a cluster on the database.

Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question. • Create a new version of the database when the AMDP is first called. • Delete the obsolete versions of the database procedure asynchronously. • Delete the obsolete versions of the database procedure synchronously. • Create a new version of the database when the AMDP is first activated.

AMDP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers to this question. • Database independent syntax errors. • SQLScript errors. • UNION specific syntax errors. • HANA specific syntax errors. • Database platform syntax errors.

What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question. • By Resource console. • Manually. • Automatically. • By Importing a Landscape.

Name the views that are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question. • The Security view. • The System Monitor view. • The Administration view. • The Landscape view.

Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? There are 3 correct answers to this question. • De-pooling and de-clustering. • Definition of an enhancement category. • Changes of data class. • Definition of full-text indexes. • Storage type for tables.

Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL? Please choose the correct answer. • Database for sophisticated analysis. • New SQL parser used in model. • SAP HANA specific features. • Database oriented programming model.

What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question. • An open platform for developing new ABAP-related tools. • A set of open, language- and platform-independent APIs. • A set of Eclipse data pool and Client- Open platform. • An open platform for developing powerful database view. • A brand new ABAP development experience on top of the Eclipse platform.

You define and implement an AM DP. What do you have to list after the USING clause? There are 3 correct answers to this question. • SAP HANA views used in procedure body. • ABAP dictionary tables used in procedure body. • ABAP dictionary views used in procedure body. • CE function used in procedure Body. • AMDP Used in Procedure Body.

Which features does the source code editor provide in ABAP Development Tools (ADT)? There are 2 correct answers to this question. • Form-based Class Builder. • Quick Fix. • Content Assist. • Screen Painter.

Why is not a key factor of ALV for HAN A? Please choose the correct answer. • Derived column headings from the data element. • The data display is restricted to a maximum of 2 billion cell. • To activate and execute the program in the application. • To supply suitable values for any input parameters.

You follow the Code-to-Data paradigm in your ABAP coding. Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecessary load away from the database"? Choose the correct answer. • The in-memory capabilities of SAP HANA allow calculations to be performed on the database layer, which helps to avoid unnecesary movement of data. • Then in-memory architecture of SAP HANA prevents the transfer of large datasets between the database layer and the application layer. • The transfer of coding to the database reduces the memory consumption of associated ABAP Dictionary tables in the application layer. • The data-intensive calculations can be performed on SAP Netweaver Application Server ABAP when code-to-data mode is switched on.

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. • Index search. • Weights for ranking. • Point base ranking. • Fuzzy search. • Freestyle search.

What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question. • Use native SQL to access SAP HANA built-in functions. • Aggregate data on the database, and transfer the results to the ABAP layer. • Perform expensive calculations on the database. • Transfer all data from the database to the ABAP layer, and then aggregate the results. • Perform expensive calculations on the ABAP application server.

What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question. • A new and advanced Open SQL. • Buffer system services. • Advanced and specific models. • Core Data services.

What made SAP HANA possible? There are 2 correct answers to this question. • Improved hardware technology. • RAM limitation. • Technology and innovations. • CPU with single core network.

What is the central goal of using SAP HANA? Please choose the correct answer. • Accelerate Performance. • To set Priorities for system. • Monitor database for record keeping. • Positive Impact on Business.

What are some of the features available SAP List Viewer with integrated data access (SALV_IDA)? There are 3 correct answers to this question. • Double-click on rows. • Edit cells. • Search in content. • Display diagrams. • Group rows.

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. • Unit conversión. • CASTE Expression. • CASE expresión. • Currency Conversion. • Nested CASE expression.

Which of the following tasks can you perform with SQL monitor (transaction SQLM)?. • Combine static and dynamic performance analysis results. • Display the execution plan of an SQL statement. • Capture the SQL profile of an application. • Search for problematic SELECT* statements.

You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question. • By a core data services view. • By another database procedure. • By a script-based calculation view. • By using Sap Analysis for Microsoft office.

What are the benefits associated with The SAP HANA real-time Operational analytics? There are 2 correct answers to this question. • Fast insights into business activity. • Query Speed support. • Simplification of massive data. • High modeling flexibility.

To upload data from flat files, SAP HANA offers several features. What are these important features? There are 2 correct answers to this question. • The application suggests the column name and data type for the new tables, and it is possible to edit them. • The supported file types for upload are: .cssv, .xlls, and .xlsxxx. • The new table always has a 2:2 mapping between the file and table columns. • When loading new data in the table, it gets appended to the existing data.

Which form of services is responsible for defining and consuming semantically rich data models. Please choose the correct answer. • Core Data Services. • Conditional services. • Modell services. • IT services.

What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA DB? There are 2 correct answer to this question. • Client handling needs to be done explicitly in the Native SQL statement. • Hashed or sorted tables must be used with the INTO CORRESPONDING FIELDS keyword. • The database independency of your report can be lost. • The ABAP system check the syntax of the Native SQL statements.

The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question. • Avoid single network. • Avoid idiling CPU cores. • Avoid optimizing data. • Avoid CPU cache misses.

Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment?. • Modeler Perspective. • Open Content outlook. • Catalogue Outlook. • System Perspective.

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. • Define the cardinality for the target entity. • Include all fields used in the ON condition in projection list. • Specify an alias for the target entity. • Specify the other views in which the association can be used.

What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question. • Create. • Update. • Read. • Delete/Edit Table.

What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question. • Exploit structured contents in SQL. • Fewer data duplication and movement. • Easy to use modeling tool. • Large number of toolkits are available.

What you must do when you define and implement an ABAP Managed Database Procedure AMDP? (3 ans) There are 3 correct answers to this question. • Use Scalar types for all the AMDP method parameters. • Mark the AMDP method as read-only. • List all the ABAP dictionary tables used in the procedure body in the USING clause. • Define all the method parameters to pass by value. • Specify the database system and language.

Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question. • Create a data definition in your ABAP package. • Define the type mapping between ABAP and SAP HANA. • Create a proxy object for the defined view. • Specify the name of the SQL view in ABAP Dictionary. • Use the DDL statement DEFINE VIEW and SQL like Syntax.

Discuss the conditions required to ensure the Referential Integrity? There are 2 correct answers to this question. • There is at least one join in the other table. • There are two joins in the table. • Referential integrity holds true in both the directions. • There are three joins in the table.

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. In which cases does the call trigger the creation of the database procedure in SAP HANA? There are 2 correct answers to this question. • X is an SAP HANA view. • X is a stored procedure. • X is an AMDP method. • X is an ABAP Dictionary table.

You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD). Which SELECT statement would you use in the definition? Please choose the correct answer. • select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd. • select from snwd_so {sojd, sum(net_amount) as sum_amount}. • 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 sojd.

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. • @it_books. • it_books. • {it.books}. • :it_books.

What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question. • All fields in the GROUP BY clause must be separated by commas. • All arithmetic expressions can be used for all type of variables. • All ABAP variables must be escaped with a proceeding @ sign. • All Keywords are case sensitive.

What are the steps involved in SAP HANA Evolution? There are 3 correct answers to this question. • ABAP can run on SAP HANA. • ABAP applications on SAP HANA. • Optimized ABAP on SAP HANA. • ABAP can access SAP HANA. • ABAP as accelerator on SAP HANA.

How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement? Please choose the correct answer. • As many result sets as there are input parameters in the procedure. • Two result sets. • One result set. • As many result sets as there are table output parameters in the procedure.