E_HANABW_13 Online Practice Questions and Answers

What do you have to consider when you create a query with multiple structures?

A. You must use one structure in the report columns and one structure the report rows.

B. You can only use one structure without key figures in a query.

C. You can only use one structure with key figures in a query.

D. By using both the structures in the rows or in the columns you can avoid formula collision.

E. You must use a maximum of two structures.

Which objects are mandatory when you create a transactional data flow in operational data provisioning? Note: There are 2 correct answers to this question.

A. Data transfer process

B. Info Package

C. Real-time daemon

D. Transformation

Navigational attributes behave in a query like which of the following?

A. Attributes

B. None of above

C. Variables

D. Characteristics

E. Filters

XML would be good for: Choose the correct answer(s):

A. Extracting from another BI system.

B. Extracting from a SAP R/3 system

C. Efficiently loading 10,000 records.

D. Loading a shopping cart from an Internet application

The goal of implementing SAP Business Warehouse is to move the reporting burden from the ERP system? Determine whether this statement is true or false.

A. True

B. False

You create an advanced DataStore object (DSO) and select the standard DSO template. Which of the following settings are applied automatically?

Note: There are 2 correct answers to this question.

A. Activate data

B. Unique data records

C. Write change log

D. All characteristics are key

What are the main benefits of database partitioning on DataStore objects (advanced)? Note: There are 2 correct answers to this question.

A. Data is not distributed across all nodes in scale-out systems.

B. The memory footprint is reduced on the SAP HANA database.

C. System performance is optimized and very large tables are supported.

D. Data compression is higher compared to non-partitioned DataStore objects (advanced).

E. The data is distributed across all nodes in scale-out systems.

Which of the following is a key consideration when implementing a modern data warehouse with SAP BW/4HANA?

A. A suitable combination of technology, architecture, and development process is essential.

B. You should avoid agile development approaches as they come with the risk of insufficient up-front CH performance optimization.

C. Technology alone will solve all your problems.

D. Query performance is the most important consideration in a data warehouse implementation.

You create a transformation from a DataSource to a standard DataStore object.

The DataSource provides an after-image delta. Which key figure aggregation type do you select?

A. Overwrite

B. Maximum

C. Minimum

D. Summation

What is the role of the CompositeProvider in SAP BW/4HANA?

A. It is the successor of the BW InfoCube.

B. It is a virtual object to combine data from SAP BW/4HANA and SAP HANA via join or union.

C. It is the planning engine in SAP BW/4HANA.

D. It is the core object for persistency in SAP BW/4HANA.c