SAP Certified Application Specialist - SAP BW powered by HANA SPS12 (Edition 2016) (E_HANABW_12) Free Practice Test

Question 1

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.
Response:

A. Main table

B. Delta table

C. Entry table

D. History table

E. Log table

Correct Answer: A,B,D

Question 2

Identify which of the following function is not a part of Accelerated Planning Functions?
Please choose the correct answer.
Response:

A. Aggregation

B. Faster modelling

C. Conversions

D. Disaggregation

Correct Answer: B

Question 3

What combines data from multiple provider sand builds the union sets for the relevant data?
Please choose the correct answer.
Response:

A. A Left Inner

B. A Join

C. A Union

D. A Inner

Correct Answer: C

Question 4

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

A. Calculation views

B. Extended views

C. SAP HANA analytic privileges

D. Private views

E. Query views

Correct Answer: A,D,E

Question 5

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?
Please choose the correct answer.
Response:

A. Create a VirtualProvider and associate all fields of the SAP HANA view with SAP BW
InfoObjects.

B. Create a SAP BusinessObjects BI Universe and copy the hierarchy from SAP BW to the field of the SAP HANA calculation view.

C. Create a TransientProvider and associate only the relevant field of the SAP HANA calculation view with the corresponding SAP BW InfoObject.

D. Create a CompositeProvider in Eclipse and associate the relevant field of the SAP
HANA calculation view with the corresponding SAP BW InfoObject.

Correct Answer: D

Question 6

What is the result when the Trigger Delta Merge process chain step is executed for a given data target?
Please choose the correct answer.
Response:

A. Only data from the delta queue is extracted and merged into the data target.

B. The before and after images of the delta queue are merged and sent to the data target.

C. The delta between the new data and the already loaded data is calculated in the data target.

D. Data is transferred from the delta store to the main store of the data target.

Correct Answer: D

Question 7

How can you model the following elements within an attribute view and to define the relationships between the various tables to model ?
There are 2 correct answers to this question.
Response:

A. Source System handling

B. Calculated attributes

C. Transformations / DTP

D. Simple attributes

Correct Answer: B,D

Question 8

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.
Response:

A. VirtualProvider

B. New Eclipse-based CompositeProvider

C. Virtual key figures

D. Open ODS view

Correct Answer: B,D

Question 9

What creates heavy loads on the DBMS?
Please choose the correct answer.
Response:

A. Meta data

B. Log changes

C. Delta calculation

D. Activation algorithm

Correct Answer: D

Welcome to TestSimulate

SAP Certified Application Specialist - SAP BW powered by HANA SPS12 (Edition 2016) (E_HANABW_12) Free Practice Test