How do you model plant-specific attributes for the characteristic material?

A. Compound the material and the plant.

B. Define navigation attributes for the characteristic material.

C. Define time-dependent attributes for the characteristic material.

D. Join the material and the plant.

Which object is a target of an SAP BW transformation?

A. InfoObject of type Characteristic

B. CompositeProvider

C. InfoObject of type Key Figure

D. Open ODS view

Why do you define a custom table as a row store table? Note: There are 2 correct answers to this question.

A. The table will be integrated into a native SAP HANA calculation view.

B. Aggregation and fast search is required for query execution.

C. When the table is accessed, all columns of a single record are processed.

D. The values in the columns are different. Therefore, data compression would NOT have much effect.

Which sources types can you select when you create an Open ODS view? Note: There are 3 correct answers to this question.

A. SAP BW DataSource

B. Characteristic \

C. Virtual table using SAP HANA smart data access

D. Transformation

E. InfoSource

Which SAP BW/4HANA features support the code-to-data principle? Note: There are 3 correct answers to this question.

A. SAP HANA models as part providers in CompositeProviders

B. ABAP Managed Database Procedures in an SAP BW/4HANA transformation

C. Query settings fo read near-line storage data

D. Activation of a DataStore object (advanced)

E. Global transfer routines for master data harmonization

In which sequence does SAP recommen for the data model design concept?

A. 1. Transformations i--I

2.

Reporting requirements

3.

Sources of data

4.

Storage requirements

B. 1. Reporting requirements

2.

Sources of data

3.

Transformations

4.

Storage requirements

C. 1. Storage requirements

2.

Transformations

3.

Sources of data

4.

Reporting requirements

D. 1. Transformations i--I

2.

Sources of data

3.

Reporting requirements

4.

Storage requirements

You loaded a 5 MB table from a source system to SAP BW/4HAN

A. How do you explain that the size of the table is reduced to 1 MB?

B. The target is defined as column store and a delta merge job was executed.

C. The target is defined as row store and a delta merge job was executed.

D. The target is defined as row store without delta merge execution.

E. The target is defined as coiumn store without delta merge execution.

For which InfoProvider types can you select navigation attributes? Note: There are 2 correct answers to this question.

A. CompositeProvider

B. Open ODS views

C. DataStore object (advanced) of type standard DataStore object

D. DataStore object (advanced) of type InfoCube

Which condition must you ensure if you want to replicate data based on a view with SAP Landscape Transformation Replication Server?

A. View-based data result sets must be kept persistent first until data replication can take place.

B. An SAP HANA source system must be defined to consume the view.

C. Each table of the view requires a defined trigger to enable data replication.

D. One table as part of the view has to be defined as primary table and is used to trigger data replication.

You identified a variable that is based on time characteristic OCALMONTH and returns the current quarter. Which offset do you need to retrieve the corresponding quarter of the previous year?

A. -12

B. -4

C. -1

D. -3