E_BW4HANA204 Online Practice Questions and Answers

You want to create an SAP BW Query showing data loading statistics provided by the SAP BW/4HANA

statisical analysis.

Which object does SAP deliver to provide data for your SAP BW Query?

A. Open ODS View

B. ABAP CDS View

C. Badl Provider

D. DataStore object (advanced)

Why do you create a Semantic Group?

A. To create folders for SAP BW Query elements

B. To load InfoObject attribute with Enhanced Master Data Update

C. To generate multiple similar DataStore objects (advanced)

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

You create a DataStore object (advanced) with only the setting ""Sraging DataStore Object"" and ""Reporting-Enabled"" selected.

Which table or combination of tables is used when data is extracted from this DataStore object (advanced) in a data flow?

A. The union of the Inbound table and the Changelog table

B. The union of the Inbound table and the Active Data table

C. Inbound table only

D. Active Data table only

Which objects can be used as components in a CompositeProvicler in SAP BW/4HANA? Note: There are 3 correct answers to this question.

A. CompositeProvider

B. Open ODS View

C. SAP HANA Calculation View.

D. BW Query

E. SAP ABAP CDS View

You use a customer master data table as a left table and a transactional sales data table as a right table within a graphical SAP HANA Calculation View.

You want to focus in your report on transactional data showing both: customers with sales volume and without.

Which join type should be used?

A. Full Outer Join

B. Referential Join

C. Left Outer Join

D. Right Outer Join

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

A customer wants to know the difference between LSA and LSA+ + to define a layered scalable architecture.

Which layers are only presented in LSA+ + ? Note: There are 2 correct answers to this question.

A. Open Operational Data Store Layer

B. EDW Propagation Layer

C. Corporate Memory

D. BW Workspace Layer

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 COLD tier 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 Archiving Process (DAP) for the DataStore object (advanced)

D. Define the planned temperature for each partition

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

A. To enable parallel loading

B. To enable transitive attributes

C. Toenabledelta capability

D. To enable XXL attributes

How does column-based storageenabledata to be read faster in SAP HANA?

A. Individual columns contain all of the information for ine record

B. Individual columns are read-optimized by writing into a main store and a delta store

C. Individual columns can be transferred to an SAP HANA optimized row-based format for faster access

D. Individual columns can be processed at the same time by different CPU cores