SAP C_BW4H_214 Exam Practice Test Instant Access

Question 1

"Which SAP BW/4HANA objects support the feature of generating an external SAP HANA View?" Note: There are 2 correct answers to this question.

AOpen ODS view

BSemantic group object

CComposite Provider

DBW query .

Answer : A, C

The feature of generating an external SAP HANA view is used to expose SAP BW/4HANA objects as SAP HANA calculation views, which can be consumed by other SAP HANA tools or applications. The following SAP BW/4HANA objects support this feature:

* Open ODS view, which is a flexible object that can be created on top of any source system and can be used as a source for other objects such as CompositeProviders or BW queries. An Open ODS view can have an external SAP HANA view generated automatically during activation or manually using the context menu option Generate External SAP HANA View.

* Composite Provider, which is a powerful object that can combine data from different InfoProviders using join or union operations. A Composite Provider can have an external SAP HANA view generated automatically during activation or manually using the context menu option Generate External SAP HANA View.

Question 2

"You have already loaded data from a non-sap system into SAP Data Wharehouse Cloud. You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA system" What do you need to use to combine data?

ABW SHEL Migration

BBW Remote migration

CSAP ABAP Connection

DSAP BW/4HANA Model Transfer.

Answer : C

* C. SAP ABAP Connection: This is what you need to use to combine data from a non-sap system and an InfoCube of your SAP BW powered by SAP HANA system using SAP Data Warehouse Cloud. You can use an SAP ABAP connection to connect to your SAP BW system and access the InfoCube data as a remote table. You can then join this remote table with the data from the non-sap system that you have already loaded into SAP Data Warehouse Cloud using a graphical view12.

* 1 https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/0c9d6f0a6c4a4b8e8b3f7e5c0a3d6f9d.html

* 2 https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/5c9a6c8b6c4a4b8e8b3f7e5c0a3d6f9d.html

Question 3

What are the reasons for implementing CompositeProviders? Note: There are 2 correct answers to this question.

ATo store snapshots for reporting

BTo provide an interface for BW queries

CTo persist combined data for reporting

DTo provide a virtual data mart layer

Answer : B, D

Question 4

What are benefits of using an InfoSource in a data flow? Note: There are 2 correct answers to this question.

AReducing the numer of transformations for scenarios with many sources and targets

BConnecting sequetial trnsformartions in the data flow without storing the data again

CReducing the numer od data transfer processes (DTP)

DStoring the extraction delta information of the data source file

Answer : C, D

Question 5

Why is the start process a special type of process in a process chain? Note: There are 2 correct answers to this question.

AOpen ODS view of type Facts

BCalculation View of type Dimension

COpen ODS view of type Master Data

DInfoObjetc of type Characteristic

Answer : C, D

Question 6

Which of the following are possible delta-specific field for a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question.

ARecord mode

BCalendar day

CRequest ID

DTime stamp

ENumeric pointer

Answer : B, D, E

Question 7

Which SAP BW/4HANA objetcs can be used as sources of a data transfer process (DTP)? Note: There are 3 correct answers to this

question.

AInfoSource

BOpen Hub Destination

CDataStore Objetc (advanced)

DCompositeProvider

ESAP HANA Analysis Process

Answer : C, D, E

SAP C_BW4H_214 SAP Certified Application Associate - Reporting, Modeling and Data acquisition with SAP BW/4HANA Exam Practice Test