E_BW4HANA207 Online Practice Questions and Answers

You model an Open ODS View on an SAP HANA table. You would like to persist the datain an SAP

BW/4HANA object based on the 'Generate Dataflow...' function.

Which objects are created automatically?

Note: there are 3 correct answers to thi s question.

A. DataStore object (advanced)

B. DataSource

C. InfoPackage

D. InfoSource

E. Transformation

Which of the following SAP BW/4HANA objects support the automatic generation of external SAP HANA views?

Note: There are 2 correct answers to this question.

A. Open ODS View

B. BW Query

C. InfoObject Characteristic

D. DataSource

In an SAP BW/4HANA system you olan to leverage Data Tiering Optimization (DTO) for a DataStore

object (advanced).

Which activities are required to set up the HOT tier as well as the COLDtier for this object properly?

Note: there are 2 correct answers to this question.

A. Define partitions for the DataStore object (advanced)

B. Choose between Temperature Maintencance "On Partition Level" or "On Object Level"

C. Create a Data ArchivingProcess (DAP) for the DataStore object (advanced)

D. Define the planned temperature for each partition

Which features have been removed from SAP BW/4HANA compared to SAP BW powered by SAP HANA? Note: There are 2 correct answers to this question.

A. Analysis Process Designer (TC: RSANWB)

B. Analysis Authorizations (TC: RSECADMIN)

C. Customer Exit variable using RSR00001 (TC: CMOD)

D. Modeling option of secondary indices for DataStore objects (advanced)

Which effects do you expect for a BW Query if youset the SAP HANA runtime mode, called ""Operations in SAP HANA"", to the value ""[^(Standard)""?

Note: There are 2 correct answers to this question.

A. A cluster of InfoProviders with a homogenous mapping is created (expert mode 3).

B. The user can manually choose the expert mode 3,8 or 9 by himself.

C. The system supports the calculation of condition (expert mode 9).

D. The system supports formulas with a complex currency or unite (expert mode 8).

Why do you create a Semantic Group?

A. To create folders for SAP BW Query elements

B. To loadInfoObject attribute with Enhanced Master Data Update

C. To generate multiple similar DataStore objects (advanced)

D. To define settings for Data Tiering Optimization (DTO)

Why do you use the ' "Enhanced Master Data Update"" setting inthe definition of an InfoObject? Note: there are 2 correct answers to this question.

A. To enable parallel loading

B. To enable transitive attributes

C. To enable delta capability

D. To enable XXL attributes

Which steps are required to set up a real-time data streaming process based on the ""SAP HANA Smart Data Access (HANA_SDA)"" source system in SAP BW/4HANA?

Note: There are 3 correct answers to this question.

A. Set upan Open ODS view based on the SAP HANA remote source and associate InfoObjects to U each field.

B. Create a CompositeProvider on top of the DataStore object (advanced) and define a BW Query on top of it.

C. Create a DataStore obhet (advanced) and a Transformation including DTP connecting the BW DataSource.

D. Create n SAP HANA remote source based on an SAP HANA Smart Data Integration adapter and a 1-1 BW DataSource related to it.

E. Create a Process Chain that executes the DTP, set it to "Streaming mode", andschedule it.

What is a valid scenario using the External Tier (COLD Store) in the SAP BW/4HANA Data Tiering Optimization (DTO) concept?

A. To move a large amount of historical data needs to be read occasionally in SAP BW Queries

B. To improve the qery performance of an SAPBW Query for aggregated year-to-date values

C. To reduce the TCO bases on the implementation of the Active/ Non-Active Data Concept

D. To create an offline archive for transactional data to ensure legal requirements are fulfilled

You want to load data from an SAP BW/4HANA system into another SAP BW/4HANA system using

Operational Data Provisioning (ODP) of type ODP_BW.

Which objects can be used as a source?

Note: There are 3 correct answers to this question.

A. DataStore object (advanced)

B. ABAP CDS View

C. InfoObject Characteristic

D. CompositeProvider

E. Open ODS View