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
+
-
Process and Overview
+
-
HANA Admin Certification
+
-
HANA Modeling Certification
+
-
ABAP for HANA Certifications
+
-
BW on HANA Certifications
+
-
SAPUI5/Fiori Certifications
+
-
HCP Certifications
+
-
S4HANA Certifications
+
-
Old HANA Certifications

ABAP for HANA Certification E_HANAAW151 - Sample Questions

In our previous article All about SAP HANA Certifications we provided the list of all SAP HANA certifications and their details. We also provided basic details of the certification E_HANAAW151 at E_HANAAW151 Overview.
Now let us see what kind of questions you can expect in this certification.

Note: We highly recommend you to also check below articles:
  1. How to book SAP Certification - Prerequisites, Eligibility and Cost
  2. E_HANAAW151 Practice Quiz

E_HANAAW151 Questions and Answers

Question 1: You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the database. In the check parameters, which value would you use for the percentage of fields that are effectively used?
  1. "A lower value than on a traditional, row-store only based database
  2. "The same value as on a traditional, row-store only based database
  3. A value that you calculate based on the number of tables
  4. "A higher value than on a traditional, row-store only based database
Answer: D
Question 2: What should you do to follow the code-to-data approach to programming? Note: There are 2 correct answers to this question.
  1. Perform expensive calculations on the database
  2. "Transfer all data from the database to the ABAP layer, and then aggregate the results
  3. "Aggregate data on the database, and transfer the results to the ABAP layer
  4. Perform expensive calculations on the ABAP application server
Answer: A,C
Question 3: What are functions of the ABAP Managed Database Procedure (AMDP) framework? Note: There are 2 correct answers to this question.
  1. It deletes obsolete versions of the database procedure asynchronously
  2. It creates the database procedure when the AMDP is first called
  3. It creates the database procedure when the AMDP is first activated
  4. It deletes obsolete versions of the database procedure synchronously
Answer: A,B
Question 4: What information can you specify using annotations (marked with the @ sign) when you define a Core Data Services (CDS) view in an ABAP system? Note: There are 3 correct answers to this question.
  1. "The logic for aggregations, grouping records, and filtering groups of the CDS view
  2. The extent to which records of the CDS view should be buffered on the application server
  3. The name of the representation of the CDS view in the ABAP dictionary
  4. The client dependency of the CDS view
Answer: B,C,D
Question 5: You have an SQLScript procedure with a table input parameter it_books. You want to use theparameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter?
  1. {it_books}
  2. :it_books
  3. >it_books
  4. it_books
Answer: B
Question 6: What are the steps involved in SAP HANA Evolution? There are 3 correct answers to this question.
  1. ABAP can access SAP HANA
  2. ABAP can run on SAP HANA
  3. Optimized ABAP on SAP HANA
  4. ABAP applications on SAP HANA
Answer: A,B,C
Question 7: Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)?
  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
Answer: B
Question 8: Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources?
  1. Content folder
  2. Security folder
  3. Provisioning folder
  4. Administration folder
Answer: C
Question 9: You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNTcolumn for each sales order (column SO_ID). Which SELECT statement would you use in the definition?
  1. "select from snwd_so { so_id, sum(net_amount) as sum_amount } order by so_id
  2. "select from snwd_so { so_id, sum(net_amount) as sum_amount } group by net_amount
  3. "select from snwd_so { so_id, sum(net_amount) as sum_amount }
  4. "select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id
Answer: D
Question 10: What made SAP HANA possible? There are 2 correct answers to this question
  1. CPU with single core network
  2. Improved hardware technology
  3. Technology and innovations
  4. RAM limitation
Answer: B,C


Question 11: What are the Functions of Transaction DBACOCKPIT. There are 2 correct answers to this question.
  1. Maintain only HANA specific objects
  2. Use Schema for the Connections
  3. "Maintain, Monitor and test secondary database connection
  4. Used to access local or remote database system
Answer: C,D
Question 12: What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question.
  1. Applying Code inspector
  2. Display record of all database access
  3. Detect redundant or identical select statements
  4. Locate database performance issues
Answer: B,C,D
Question 13: Which of the following are characteristics of a referential join? (Choose two)
  1. It requires referential integrity between right and left tables
  2. "If a field is selected from the right table, it acts similar to a left outer join
  3. It assumes referential integrity between right and left tables
  4. "If a field is selected from the right table, it acts similar to an inner join
Answer: C,D
Question 14: Which of the following SAP HANA schemas contains the runtime objects of activated views?
  1. _SYS_STATISTICS
  2. _SYS_REPO
  3. _SYS_BI
  4. _SYS_BIC
Answer: D
Question 15: For what purpose do you use SQL Script in SAP HANA? (Choose two)
  1. To transfer a large amount of data between engines
  2. To achieve very high performance on SELECT statements
  3. To combine two analytic views
  4. To create database procedures
Answer: C,D
Question 16: You have a table of transactional data with different transaction types. You want to createan analytic view for only one of the transaction types. How can you ensure that only rows with the required transaction type are displayed in the analytic view?
  1. Create an input parameter
  2. Create a filter on the table
  3. Create a calculated column
  4. Create a restricted column
Answer: B
Question 17: In SAP HANA studio, in which of the following can you create users? (Choose two)
  1. The Administration console
  2. The Roles node
  3. The Content node
  4. The SQL editor
Answer: A,D
Question 18: You want to use a UNION to combine two information objects in a calculation view. Which steps do you have to perform? (Choose two)
  1. Define a constant column in the target
  2. Sort the columns in the output structure
  3. Connect the information objects to the UNION node
  4. Define the mapping of columns of the information objects
Answer: C,D
Question 19: You have created a graphical calculation view with a large number of columns. Which of the following do you use to ensure that only required columns are shown when querying the created view? (Choose two)
  1. Function CE_PROJECTION
  2. The Type selection in the semantics area
  3. Projection nodes
  4. The Hidden checkbox in the semantics area
Answer: C,D
Question 20: You want to run a report on data with multiple currencies. You want to allow end users toselect the target currency at runtime. Which options does SAP recommend for defining the currency conversion? (Choose two)
  1. Currency conversion during data load
  2. A CE_CONVERSION function in a calculation view
  3. Measures enabled for conversion in an analytic view
  4. A calculated column in an analytic view
Answer: B,C

What’s next?
Check E_HANAAW151 Practice Quiz



Support us by sharing this article.



Explore More
Close X
Close X

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