E_BW4HANA207 Online Practice Questions and Answers

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)

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

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

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

You use an Open Hub Destination to distribute SAP BW/4HANA data to a table managed by an SAP

database.

Which technologiescan be used?

Note: There are 2 correct answers to this question.

A. Operational Data Provisioning (ODP)

B. Database Connection (DBCON)

C. Smart Data Access (SDA)

D. Remote Function Call (RFC)

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)

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

How does column-basedstorage enable data 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

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