E_BW4HANA207 Online Practice Questions and Answers

You use the SAP BW/4HANA Transfer Cockpit to prepare your SAP BW system for an in-place conversion to SAP BW/4HANA.

Which functions are provided by this cockpit? Note: There are 2 correct answers to this question.

A. Execute Pre-Checks

B. Transfer 3.x DataFlow into 7.x DataFlows

C. Transfer Bex Queries into BW Queries

D. Transfer Standard Authorizations

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

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 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

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.

Youwant 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

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

In SAP BW/4HANA you decide to switch on the External Tier (COLD Store) for a DataStore object

(advanced) based on the Data Tiering Optimization (DTO)concept.

Where can the data be managed?

Note: there are 2 correct answers to this question.

A. In an SAP IQ database

B. In SAP HANA on an extension node

C. In SAP HANA Native Storage Extension

D. In the file system of a Hadoop cluster

For which SAP Cloud system does SAP recommend using the SAP HANA SDI and its Odata adapter to load data into SAP BW/4HANA?

A. SAP C/4HANA

B. SAP SuccessFactors

C. SAP S/4HANA Cloud

D. SAP Ariba

You would like to implement a virtual scenario in yur SAP BW/4HANA system. Which approach does SAP recommend for this kind of scenario?

Note: There are 3 correct answer to this question.

A. Integrate external data into SAP BW/4HANA based on the Write Interface-ebabledDataStore object.

B. Model a CompositeProvider which combines data from multiple SAP BW/4HANA InfoProviders and SAP HANA Views.

C. Generate external SAP HANA view of SAP BW/4HANA InfoProviders to consume SAP BW/4HANA data in SAP HANA.

D. Define an Open ODS View which integrates an SAP HANA table into SAP BW/4HANA.

E. Load SAP HANA dat into SAP BW/4HANA InfoProviders based on the Operational Data Provisioning (ODP) framework.