C_BW4HANA_20 Online Practice Questions and Answers

Which objects of an SAP HANA calculation view of DIMENSION data category can you re-use if you define an SAP calculation view of CUBE data category with star join? Note: There are 2 correct answers to this question.

A. Aggregation method

B. Hierarchy assignment

C. Attribute assignment

D. Measure assignment

Why can tasks be executed faster if the application uses SAP HANA as a database?

A. The application layer takes over tasks of the database layer.

B. The database layer takes over tasks of the application layer.

C. The user interface layer takes over tasks of the application layer.

D. The application layer takes over tasks of the user interface layer.

You need to create a CompositeProvider to combine data from an SAP HANA calculation view with a DataStore object (advanced). Which of the following Eclipse perspectives do you use?

A. JavaScript perspective

B. BW modeling perspective

C. ABAP perspective

D. SAP HANA modeler perspective

You define a temporal condition for a temporal join in a calculation view. Which column data types are

supported?

Note: There are 3 correct answers to this question.

A. Integer

B. Date

C. Decimal

D. Boolean

E. Timestamp

Which SAP tool do you suggest to create a pixel-precise formatted report?

A. SAP Lumira, discovery edition

B. SAP Analysis for OLAP

C. SAP Crystal Reports for Enterprise

D. SAP Analytics Cloud

What must you do first if you need to define help cells for formulas in the cell editor?

A. Define two formulas in a structure.

B. Define two structures in a query.

C. Define two selections in a structure.

D. Reuse a structure in a second query.

What can you create within the SAP BW data flow object? Note: There are 2 correct answers to this question.

A. InfoAreas

B. Key figures

C. InfoProviders

D. Transformations

You load a DataStore object (advanced) every night. Where can you delete the request you loaded two nights ago without deleting the last request?

A. From a DataStore object (advanced) based on the model template InfoCube if the request is NOT v u activated.

B. From a DataStore object (advanced) based on the model template InfoCube if the request is activated.

C. From a DataStore object (advanced) based on the model template Standard DataStore object if the request is activated and you execute a full load.

D. From a DataStore object (advanced) based on the model template Standard DataStore object if the request is activated.

Which SAP BW/4HANA objects can keep persistent data? Note: There are 2 correct answers to this question.

A. Key figure InfoObjects

B. InfoSource

C. Characteristics InfoObjects

D. DataStore object (advanced)

When do you recommend using an external hierarchy? Note: There are 3 correct answers to this question.

A. The hierarchical structure will be time-dependent.

B. The structure will contain formulas.

C. The structure will depend on the order of the row characteristics.

D. The structure exists in the source system.

E. The query data will be restricted to a hierarchy node.