Free SAP Certified Development Specialist – ABAP for SAP HANA 2.0 Exam E_HANAAW_14 Exam Practice Test

Discuss the conditions required to ensure the Referential Integrity? There are 2 correct answers to this question

• There are three joins in the table
• Referential integrity holds true in both the directions
• There is at least one join in the other table
• There are two joins in the table

Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources? Choose the correct answer

• Administration folder
• Content folder
• Security folder
• Provisioning folder

In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement? Please choose the correct answer.

• ROW
• GLOBAL TEMPORARY
• COLUMN
• LOCAL TEMPORARY

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

How will you select a preference for Validation rules? Choose the correct answer

• Windows- SAP HANA-Modeler-Preferences-Validation Rules
• Windows- Preferences-SAP HANA-Modeler-Validation Rules
• Windows- Modeler- Preferences-SAP HANA-Validation Rules
• Windows- SAP HANA-Preferences-Modeler-Validation Rules

What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

• Use Schema for the Connections
• Maintain, Monitor and test secondary database connection
• Maintain only HANA specific objects
• Used to access local or remote database system

You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAPHANA is used as the dbIn the check parameters, which value would you use for the percentage of fields that are effectively used?Please choose the correct answer.

• A value that you calculate based on the number of tables
• A higher value than on a traditional, row-store only based database
• A lower value than on a traditional, row-store only based database
• The same value as on a traditional, row-store only based database

ABAP 7.4 provide support for optimizing ABAP applications running on SAP HAN

• What are these transparent optimizations? (3 ans)
• Performance analysis tools have been improved
• Do all the data processing in Application server
• The consumption of SAP HANA artifacts was simplified
• Re-use components have been extended or optimized for SAP HANA
• The ABAP language and the Open SQL language have been extended

Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question

• Convert crosstab cells to formula
• Analyze data with the design pane
• Suggests style sets for crosstabs
• Sort data by characteristics

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.

• The ABAP system check the syntax of the Native SQL statements
• Client handling needs to be done explicitely in the Native SQL statement
• The database independency of your report can be lost
• Hashed or sorted tables must be used with the INTO CORRESPONDING FIELDS keyword