E_BW4HANA207 Online Practice Questions and Answers

You are running SAP S/4HANA On-Premise.

You would like to extract data to SAP BW/4HANA.

Which tool does SAP recommend to evaluate the metadata of CDS-based extractors?

A. SAP S/4HANA Query Browser

B. SAP BW/4HANA Cockpit

C. SAP BW/4HANA Modeling Tools

D. SAP S/4HANA View Browser

You want to use a referential join for a combination of transactional data (left table) and master data (right table).

How will thisreferential join be processed? Note: there are 2 correct answers to this question.

A. It is executed only when columns from both tables are requested

B. It shows all transactional data with an existing master data record

C. It shows all master data to assure the referential integrity

D. It is an inner join that assumes that referential integrity is given

You want to load a customer table to SAP BW/4HANA in delta mode.

The customer table is managed in SAP S/4HANA Cloud. Each record has an UTC time stamp.

What is recommended approach to implement this extraction?

A. Create a DataSource in SAP S/4HANA which leverages the generic delta based on the time stamp.

B. Create an ABAP CDS View in SAP S/4HANA which is enabled for extraction and model the Change Delta Capture (CDC) logic based on the time stamp.

C. Create an ABAP CDS View in SAP S/4HANA which is enabled for extraction and generates the delta based on the time stamp.

D. Create an SAP HANA CDS View in SAP SS/4HANA which leverages a procedure to generate the delta based on the time stamp.

Which transformation rules do support SAP HANA Runtime? Note: There are 3 correct answers to this question.

A. ABAP end routine

B. SQL procedure in an SAP HANA FlowGraph

C. ABAP Field rountine

D. SQL script field routine

E. Lookup from DataStore object (advanced)

Which SAP HANA XS classic information view can you convert directly into an SAP HANA HDI Calculation View?

A. SAP HANA Calculation View (scripted)

B. SAP HANA Analytic View

C. SAP HANA Attribute View

D. SAP HANA Calculation View (graphical)

What is the recommended and supported way to virtually consume data in SAP BW/4HANA based on SAP ABAP CDS View?

A. Model a CompositeProvider which consumes an SAP HANA Calculation View which refers to the u SAP ABAP CDS View.

B. Model a CompositeProvide which directly consumes the SAO ABAP CDS View.

C. Model an Open View of source type "Dattabase Table or View" which refers to the SAP ABAP CDS U View.

D. Model an Open ODS View of source type "DataSource (BW)"which refers to the SAP ABAP CDS U View.

What is a valid data target in an SAPMHANA Analysis Process without using a Data Trasfer Process?

A. DataStore object (advanced)

B. InfoObject with Attributes

C. SAP HANA Database Table

D. CompositeProvider

A customer uses an SAP BW 7.5system powered by SAP HANA with the SAP BW/4HANA Starter Addon.

The system mode is set to ""B4H mode"".

How will the system be affected?

A. 3.x Data Flows can still be used if they are registered in the whitelist

B. Semantically Partitioned Objects (SPOs)can be maintainedwith the SAP BW/4HANA Modeling U Tools

C. SAP BW/4HANA Modeling Tools are needed to maintain BW Queries

D. MultiProviders are automatically converted into CompositeProviders

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

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.

Which process types of process chains became obsolete in SAP BW/4HANA comoared to SAP BW powered by SAP HANA?

Note: there are 2 correct answers to this question.

A. Execute Analysis Process (APD)

B. Execute Data Archiving Process (DAO)

C. Trigger Delta Merge

D. Attribute Change Run

You enable a DataStore object(advanced) for reporting by switching on the ""External SAP HANA view"" flag in the settings.

Which authorizations are used when you consume the generated SAP HANA view directly?

A. The generated analytic privileges in SAP HANA

B. The authorizations forthe HDI container access in SAP HANA

C. The combination of the generated analytic privileges in SAP HANA and the analysis authorizations in SAP BW/4HANA

D. The analysis authorizations in SAP BW/4HANA

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

You want to load datafrom SAP Ariba to SAP BW/4HANA. Which object in SAP BW/4HANA does SAP recommend to use for this scenario?

A. DataStore of type ODP_CDS

B. Write Interface-Enabled DataStore Object

C. Direct Update DataStore Object

D. DataStore of type ODP_HANA