E_HANABW_12 Questions


E_HANABW_12 Full Name:


SAP Certified Application Specialist - SAP BW powered by HANA SPS12 (Edition 2016)

Disclaimer: 

 These sample questions are for self-evaluation purposes only and do not appear on the actual certification exams. Answering the sample questions correctly is no guarantee that you will pass the certification exam. The certification exam covers a much broader spectrum of topics, so do make sure you have familiarized yourself with all topics listed in the exam competency areas before taking the certification exam.

E_HANABW_12 Question:


01.  Which types of objects can you view using the SAP HANA Live Browser? Note: There are 3 correct answers to this question

a) Open ODS views
b) Query views
c) Calculation views
d) Core Data Services views
e) Private views

Answer: b, c, e

02. What happens when the “Trigger Delta Merge” process variant is executed for a given data target in a process chain?

a) The delta between the new data and the already loaded data is calculated in the data target.
b) Data is transferred from the delta store to the main store of the data target.
c) The before and after images of the delta queue are merged and sent to the data target.
d) Only data from the delta queue is extracted and merged into the data target.

Answer: b

03.  You generate a DataStore object (advanced) out of an Open ODS view based on an SAP HANA table with the Generate DataFlow function. Which data load technique is used?

a) InfoPackage without a persistent staging area (PSA)
b) InfoPackage with a persistent staging area (PSA)
c) Data transfer process (DTP) with Real Time Data Acquisition (RDA)
d) Data transfer process (DTP) with direct access

Answer: d

04.  Which objects are recommended to go from a persistent data warehouse to a logical data warehouse based on the new layered scalable architecture (LSA++) for SAP Business Warehouse 7.5? Note: There are 2 correct answers to this question

a) BW InfoSet
b) Open ODS view
c) MultiProvider
d) CompositeProvider

Answer: b, d

05. What should you do after an InfoCube is converted to be SAP HANA optimized?

a) Reactivate all Transformations that include the InfoCube.
b) Delete all aggregates that belong to this InfoCube.
c) Reload data into the InfoCube.
d) Review customer-specific programs that access the InfoCube tables.

Answer: d

06. Your customer runs SAP Business Warehouse (SAP BW) 7.5 on SAP HANA and would like to build an SAP BW 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?

a) Create a CompositeProvider and associate the relevant field of the SAP HANA calculation view with the corresponding SAP BW InfoObject.
b) Create an Analytical Index and associate only the relevant field of the SAP HANA calculation view with the corresponding SAP BW InfoObject
c) Create an external SAP HANA view for the InfoObject and combine this with the existing SAP HANA calculation view.
d) Create a VirtualProvider and associate all fields of the SAP HANA view with SAP BW InfoObjects.

Answer: a

07.  Where are Extended Tables stored? 

a) They are temporarily located in the cache in the SAP HANA inmemory RAM.
b) They are physically located in a special SAP HANA schema in a memory data columnar storage.
c) They are temporarily located in a compressed disk-based data columnar storage.
d) They are physically located in a compressed disk-based data columnar storage.

Answer: d

08. Why does SAP recommend using SAP Landscape Transformation (SLT) real-time replication to SAP Business Warehouse powered by SAP HANA?
Note: There are 2 correct answers to this question.

a) To replicate SAP data from an SAP Business Suite system instead of using complex extractors
b) To replicate SAP Event Stream Processor data
c) To replicate data from SAP S/4HANA by using CDS views
d) To add delta capabilities where no standard extractor is available

Answer: c, d

09. What is the function of an SAP HANA Live private view?

a) To encapsulate SQL transformations on one or several database tables.
b) To expose the business data in SAP Business Suite systems.
c) To provide the value list for a specific business entity.
d) To provide a direct interface to an analytical application.

Answer: a

10.  Which objects can you use as a direct Data Source within an SAP HANA analysis process (HAP)? Note: There are 2 correct answers to this question.

a) SAP BW InfoSource
b) SAP HANA Table
c) SAP HANA Calculation View
d) SAP BW CompositeProvider

Answer: b, d

No comments:

Post a Comment