Which of the following are performance recommendations when using SAP HANA?
2 OPTIONS Move data-intensive calculations from the database to an application server. Filter data in lower layers. Avoid transferring large result sets between database and client applications. Define indexes on the columns that are used in calculations.
What are the supported joins in CDS view?
2 Left outer join Inner join Operators joint Upper join.
Which of the following are characteristics of an external view?
3 It can be used in Open SQL statements for database updates. It can be used as a data type in ABAP programs. 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.
What is an attribute view and what are its practices?
3 Used to join tables May contains flow charts Used in diagrammatic Projections May contain filters May use in calculation views.
Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources?
Content folder Administration folder Provisioning folder Security folder.
Which form of services is responsible for defining and consuming semantically rich data models?
Conditional services ITe services Modell-II services Core Data Services
.
Discuss the conditions required to ensure the Referential Integrity?
2 There are two joins in the able There are three joins in the table There is at least one join in the other table Referential integrity holds true in both the directions.
What are the two types of editors available in ADT?
2 SAP (GUI) ABAP (native) Eclipse (native) Client (native).
If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. The following parameters are available?
3 Index search Fuzzy search Freestyle search Point base ranking Weights for ranking.
When would you use a column store table instead of a row store table?
2 When there are mainly distinct values in the table When the table has a small number of records When you want to enable a full-text search of the table When you require aggregation and analysis of values.
Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL?
Database oriented programming model Database for sophisticated analysis SAP HANA specific features New SQL parser used in model.
What are the steps involved in SAP HANA Evolution?
3 ABAP can access SAP HANA ABAP can run on SAP HANA Optimized ABAP on SAP HANA ABAP applications on SAP HANA ABAP as accelerator on SAP HANA.
What are the components of The Enterprise Procurement Model Demo Scenario?
3 Sales Procurement Product Services Stock.
Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”?
Critical data table Runtime monitor data Selection data table Performance data table.
What are the benefits of using the SQL Monitor (transaction SQLM)?
2 It collects monitoring data asynchronously without additional database interaction. It can be active in a production system with minimal performance overhead. It displays the database execution plan for all SQL statements. It schedules ABAP programs to monitor and log all database accesses.
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?
SET_PARAM_TABLE GET_METADATA NEXT_PACKAGE SET_PARAM.
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?
2 Screen editing Quickfix Form-based class builder Content assistance.
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?
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 } select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id.
Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment?
System Perspective Modeler Perspective Open Content outlook Catalogue outlook.
When to use Enhanced Open SQL?
2 To view scalar components Need the query in one piece of code only To access system fields At the time of Dictionary Views.
The SAP HANA database is a hybrid in-memory database that combines Few technologies within. What are these technologies?
3 Time-based database technology Row-based database technology Column-based database technology Object-based database technology Value-based database technology.
To upload data from flat files, SAP HANA offers several features. What are these important features?
2 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 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.
What are the two types of editors available in ADT?
2 ABAP (native)
Eclipse (native)
SAP (GUI) Client (native).
How will you select a preference for Validation rules?
Windows- SAP HANA-Preferences-Modeler-Validation Rules Windows- Modeler – Preferences-SAP HANA-Validation Rules Windows- Preferences-SAP HANA-Modeler-Validation Rules Windows- SAP HANA-Modeler-Preferences-Validation Rules.
What are the Possible Approaches with AS ABAP < 7.4 SP02?
2 Interaction with Database Stored Procedures Consume using native SQL SQL units.
How to call the stored procedures in ABAP code?
Open SQL Native SQL CDS view Only SQL.
Which of the following are performance recommendations when using SAP HANA?
2 Define indexes on the columns that are used in calculations. Move data-intensive calculations from the database to an application server. Avoid transferring large result sets between database and client applications. Filter data in lower layers.
What are functions of the ABAP Managed Database Procedure (AMDP) framework?
2 It deletes obsolete versions of the database procedure asynchronously It creates the database procedure when the AMDP is first called. It creates the database procedure when the AMDP is first activated.
It deletes obsolete versions of the database procedure synchronously.
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?
:it_books it_books {it_books} @it_books.
What are the benefits includes with SAP HANA Full Text Search?
2 Fewer data duplication and movement Easy to use modeling tool Exploit structured contents in SQL Large number of toolkits are available.
Which is not a Golden Rule for Open SQL?
Keep the result set large Minimize the Amount of Data Transferred Minimize the Number of Database Accesses
Reduce the Database Load.
What do you understand by The SAP HANA Software Optimization?
Speed up the processing within the database Provide combinations of Objects and Partitioning Bring logic to where the data is calculated first, then only move to results Huge potential for hybrid database.
What do you have to consider if you want to use Native SQL in your 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?
2 Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword. The database independency of your report can be lost. Client handling needs to be done explicitely in the the Native SQL statement. The ABAP system checks the syntax of the Native SQL statements.
When are referential joins executed in analytical views?
When fields are selected When fields from both the tables are requested When fields are optimized When all the tables are optimized.
Explain The Authorization Concept and the types of privileges associated with it?
3 System privileges Object privileges Analytic privileges Delta privileges Application privileges.
Your customer wants to migrate to SAP HANA and you want to identify which business processes should be optimized. Which of the following steps must you perform to get this information?
2 Combine the results of the SQL Monitor with the results of an ABAP runtime analysis. Activate the new SQL Monitor in a productive system. Combine the results of the SQL Monitor with the results of a static source code analysis Activate the new SQL Monitor in a development system.
What allows you to resolve errors quickly or warnings reported about the code?
ABAP debugger Quick Fix Code execution Debug perspective.
How will you hide the attributes that are not required for client consumption?
By setting the hidden property flag of the attribute in the View By setting the hidden property flag of the attribute column By setting the hidden property flag of the attribute in the Semantics screen By setting the hidden property flag of the attribute provider.
DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types?
2 Column store Row store Re-use component store Development Store Technology store.
What are the principles of Using HANA Transport Containers properly?
3
Automatic update for all export methods Takes a ‘snapshot’ of all SAP HANA objects of delivery unit Release of Transport request Import of Transport Request To create Transport container of delivery unit.
|
