SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
SAP HANA Certifications
+
-
C_HANAIMP151
+
-
C_HANAIMP142
+
-
C_HANASUP_1
+
-
C_HANATEC142
+
-
E_HANAAW142
+
-
E_HANABW141
+
-
E_HANAINS142
+
-
P_HANAIMP142
+
-
E_HANABW151
+
-
E_HANAINS151
+
-
E_HANAAW151
+
-
C_HANATEC151
SAP HANA Certification E_HANAAW142 - Sample Questions

In our previous article SAP HANA Certification E_HANAAW142 we provided the details of the certification E_HANAAW142.
In this article we will provide some sample questions for this certification.

You may also check:
  1. Which of the following are characteristics of an external view?  Note: There are 3 correct answers to this question.
    1. It can be used as a data type in ABAP programs.
    2. It is an ABAP Dictionary object type.
    3. It allows access to an SAP HANA information view with Open SQL.
    4. It defines the underlying SAP HANA information view.
    5. It can be used in Open SQL statements for database updates.
  2. Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement. Which of the following changes to the SELECT statement can you use to retrieve the same data as before?  Note: There are 2 correct answers to this question.
    1. Include the client field in the WHERE condition.
    2. Use the CLIENT SPECIFIED addition.
    3. Include the client field in the join condition.
    4. Include the client field in the field list.
  3. 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.
    1. Release packages
    2. Update packages
    3. Release resources
    4. Update resources
  4. You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? Please choose the correct answer.
    1. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
    2. Implement the interface IF_AMDP_MARKER_HDB.
    3. Implement the ABAP AMDP_HDB Event Handler.
    4. Set the visibility of the corresponding class method in the declaration section to PUBLIC.
  5. Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer.
    1. Create a graph comparing the runtimes of ABAP code before and after optimization.
    2. Combine information from static ABAP code scans with runtime data from the SQL Monitor.
    3. Combine information from static ABAP code scans with runtime data from the SQL Trace tool.
    4. Estimate the new total runtime of optimized code.
  6. What are the benefits of using the SQL Monitor (transaction SQLM)? Note: There are 2 correct answers to this question.
    1. It collects monitoring data asynchronously without additional database interaction.
    2. It can be active in a production system with minimal performance overhead.
    3. It displays the database execution plan for all SQL statements.
    4. It schedules ABAP programs to monitor and log all database accesses.
  7. Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver? Note: There are 2 correct answers to this question.
    1. Screen editing
    2. Quickfix
    3. Form-based class builder
    4. Content assistance
  8. In which of the following situations could a row store table be more suitable than a column store table? Note: There are 2 correct answers to this question.
    1. The table contains data that you want to aggregate.
    2. The table contains only a small number of records.
    3. The table contains mainly distinct values per column across rows.
    4. The table contains text that you want to search.
  9. Which of the following are performance recommendations when using SAP HANA? Note: There are 2 correct answers to this question.
    1. Define indexes on the columns that are used in calculations.
    2. Move data-intensive calculations from the database to an application server.
    3. Avoid transferring large result sets between database and client applications.
    4. Filter data in lower layers.
  10. 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.
  1. Write only
  2. Read only
  3. Read-update
  4. Read-write
Answers:
1 A, B, C
2 A, C
3 C
4 B
5 B
6 A, B
7 B, D
8 B, C
9 C, D
10 B

Reference: https://training.sap.com



Support us by sharing this article.



Explore More
Close X
Close X

2 thoughts on “SAP HANA Certification Sample Questions and Dumps – E_HANAAW142

  1. kumar says:

    Hi ,

    i am taking the ABAP on HANA certification 2014 edition. I am wondering if you have any dumps for this exam certification.

    Your help would be much appreciated.

    Thanks

    Anil

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy