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
+
-
SAP Cloud Certifications
+
-
S4HANA Certifications
+
-
SAP BW/4HANA Certifications
+
-
Old HANA Certifications

BW on HANA Certification E_HANABW151 - Sample Questions

Info: This certification is obsolete from 30th September, 2017. Click here to check the latest certification on BW on HANA - E_HANABW_12.
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_HANABW151 at E_HANABW151 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_HANABW151 Practice Quiz

Certification E_HANABW151 - Questions and Answers

Question 1: Which type of objects can you view using the SAP HANA Live Browser? Note: There are 3 correct answers to this question.
  1. Calculation views
  2. Query views
  3. SAP HANA analytic privileges
  4. Private views
Answer A,B,D
Question 2: What is the result when the Trigger Delta Merge process chain step is executed for a given data target?
  1. The delta between the new data and the already loaded data is calculated in the data target
  2. Data is transferred from the delta store to the main store of the data target
  3. The before and after images of the delta queue are merged and sent to the data target
  4. Only data from the delta queue is extracted and merged into the data target
Answer B
Question 3: You generate an advanced DataStore object out of an Open ODS view based on an SAP HANA table with the Generate DataFlow function. Which data load technique is used?
  1. InfoPackage without a persistent staging area (PSA)
  2. InfoPackage with a persistent staging area (PSA)
  3. SAP Landscape Transformation (SLT)
  4. Data transfer process (DTP) with direct access
Answer D
Question 4: Which objects can you use to go from a persistent to a logical data warehouse based on new layered scalable architecture (LSA++) for SAP Business Warehouse 7.4? Note: There are 2 correct answers to this question.
  1. Open ODS view
  2. Virtual key figures
  3. New Eclipse-based CompositeProvider
  4. VirtualProvider
Answer A,C
Question 5: What should you do after an InfoCube is converted to be in-memory optimized?
  1. Review customer-specific programs that access tables belonging to the InfoCube
  2. Delete obsolete process types from process chains containing the InfoCube
  3. Activate all MultiProviders that include the InfoCube
  4. Reload data into the InfoCube
Answer A
Question 6: Your customer runs SAP Business Warehouse (SAP BW) 7.4 on SAP HANA and would like to build a BEx Query on top of an existing native SAP HANA calculation view. The query should make use of a master data hierarchy that is already available in SAP BW. What is the recommended approach for this scenario?
  1. Create a SAP BusinessObjects BI Universe and copy the hierarchy from SAP BW to the field of the SAP HANA calculation view
  2. Create a VirtualProvider and associate all fields of the SAP HANA view with SAP BW InfoObjects
  3. Create a CompositeProvider in Eclipse and associate the relevant field of the SAP HANA calculation view with the corresponding SAP BW InfoObject
  4. Create a TransientProvider and associate only the relevant field of the SAP HANA calculation view with the corresponding SAP BW InfoObject
Answer C
Question 7: Where are Extended Tables stored?
  1. They are cached in the SAP HANA in-memory RAM
  2. They are physically located in a special SAP HANA schema in a memory data columnar storage
  3. They are temporarily located in a compressed disk-based data columnar storage
  4. They are physically located in a compressed disk-based data columnar storage
Answer D
Question 8: What are the two views of the SAP HANA Analytics Frame work for the SAP Business Suite? There are 2 correct answers to this question.
  1. Provided by SAP
  2. Enhance Virtualization
  3. Built by customer
  4. Migrate to HANA
Answer A,C
Question 9: What are the three main components of Semantically Partitioned Objects (SPOs) allow users to create a semantic partition once and use it repeatedly? There are 3 correct answers to this question.
  1. Master Providers
  2. Infosources
  3. Part Providers
  4. Cluster Data
Answer A,B,C
Question 10: When Data Store objects can only be converted to SAP HANA optimized Data Store objects? There are 2 correct answers to this question.
  1. Allow faster modeling
  2. They are not part of a Hybrid Provider
  3. Increase the amount of storage
  4. They are not supplied with data using real-time data acquisition
Answer B,D


Question 11: The table for active data is a temporal table that consists of three components. What are they? There are 3 correct answers to this question.
  1. Main table
  2. Entry table
  3. Delta table
  4. History table
Answer A,C,D
Question 12: Which rules can you define in an SAP Landscape Transformation (SLT) transformation process? There are 2 correct answers to this question.
  1. Log-based rules
  2. Parameter-based rules
  3. Trigger-based rules
  4. Event-based rules
Answer B,D
Question 13: How can you select a composite provider to view last accessed before a certain date?
  1. Analytic index
  2. Local provider
  3. Unlock workspace
  4. Clear workspace
Answer D
Question 14: Which objects can you use to go from a persistent to a logical data warehouse based on new layered scalable architecture (LSA++) for SAP Business Warehouse 7.4? There are 2 correct answers to this question.
  1. Virtual key figures
  2. New Eclipse-based Composite Provider
  3. Open ODS view
  4. Virtual Provider
Answer B,C
Question 15: The database-dependent part of the SAP database interface can be found in its own library and dynamically linked to whom?
  1. SAP BW
  2. SAP BWA
  3. SAP TERP
  4. SAP Kernel
Answer D
Question 16: To which class of provider is a MultiProvider assigned in a workspace?
  1. local
  2. central
  3. virtual
  4. composite
Answer B
Question 17: Which of the following is not a feature of Agile Data Mart Layer and BW Workspace Layer?
  1. Resulting LSA++
  2. Reduce layer size
  3. Migrate to HANA ?optimize object
  4. Streamline EDW core
Answer B
Question 18: Which is responsible for a powerful design environment to build visually compelling reports without compromising productivity?
  1. SAP Crystal Reports
  2. Work Space
  3. Monitoring workspaces
  4. InfoProviders
Answer A
Question 19: What are the key benefits of Key Benefits of Enterprise Data Warehousing? There are 2 correct answers to this question.
  1. Rigidness
  2. Integration
  3. Blockage of info
  4. Reusability
Answer B,D
Question 20: What all are the elements of LSA? There are 3 correct answers to this question.
  1. Virtualization Layer only on top of Architected Data Mart and only UNION (MultiProvider)
  2. "Result of transformations stored in additional persistent Layer, i.e. Architected Data Mart
  3. Reading from a DSO is faster
  4. No reporting on Propagator
Answer A,B,D
Question 21: How you can see where the first data row begins, and how many headers there are?
  1. Display Data
  2. Core Data
  3. DB Data
  4. Meta Data
Answer A
Question 22: How can you transport the Composite Provider from transaction RSLIMOBW? What are the prerequisites? There are 2 correct answers to this question.
  1. Modelling data
  2. The Composite Provider does not contain an analytic index
  3. The Info Providers that make up the Composite Provider are already available in the production system
  4. Analytical tools
Answer B,C
Question 23: The migration of the database to HANA will show significant performance gains. What are they? There are 2 correct answers to this question.
  1. "Result of transformations stored in additional persistent Layer, i.e. Architected Data Mart
  2. Virtualization Layer only on top of Architected Data Mart and only UNION
  3. The query performance will be significantly faster
  4. "There will be less volume on the database even if the data volume itself remains the same, since indices are no longer necessary
Answer C,D
Question 24: What are the main forms of data use in Operational Reporting within Classic Data Warehousing? There are 2 correct answers to this question.
  1. Strategic for aggregated data
  2. Operational for granular data
  3. Upload data for customers
  4. Systematic data
Answer A,B
Question 25: Which is not an element of BI Projects Built on Customer LSA Standards?
  1. Storage Management standards
  2. SAPíS -LSA standards
  3. Customer- LSA operations standards
  4. Customer-LSA implementation standards
Answer A
Question 26: Which one is not the advanced features of SAP NetWeaver BW, Powered by SAP HANA?
  1. HANA-optimized InfoCube
  2. Full database functionality
  3. Publishing SAP HANA models into BW
  4. HANA-optimized Data Store Objects
Answer B



Have you got some more sample questions for this certification? Share those in comment section and help others!

What’s Next?


Challenge yourself! Check how much you can score in the exam - E_HANABW151 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