C_BW4HANA_20 Online Practice Questions and Answers

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 objects can you combine using a CompositeProvider? Note: There are 2 correct answers to this question.

A. SAP HANA calculation views

B. CompositeProvider

C. InfoSources

D. Key figures

Which SAP Landscape Transformation Replication Server cockpit operation removes all data from the trigger table?

A. Suspend Replication and Resume Replication

B. Stop Replication and Resume Replication

C. Suspend Replication and Start Replication

D. Stop Replication and Start Replication

Which variables types allow filter values to be determined based on the user's authorizations? Note: There are 2 correct answers to this question.

A. Characteristic value variable

B. Formula variable

C. Hierarchy node variable

D. Hierarchy variable

Which of the following are strengths of SAP S/4HANA embedded analytics? Note: There are 2 correct answers to this question.

A. Operational data is accessed in real time.

B. Redundant data is reduced.

C. Cross-system consistency is generated.

D. Historical data for strategic decisions is stored.

You want to use the SAP HANA concept of semantic types as part of the currency conversion mechanism. You decide to use semantic type Amount with Currency Code within your SAP HANA calculation view. Which currency reference can be assigned to the measure? Note: There are 3 correct answers to this question.

A. A fixed currency

B. A currency from a currency conversion

C. A currency from another column

D. A currency from an SAP HANA content calculation view

E. A currency from SAP BW customizing

Which objects can be affected by the key date in a BW query? Note: There are 2 correct answers to this question.

A. Hierarchies

B. Attributes

C. Text variables

D. Key figures

Why do you recommend the virtual data mart layer? Note: There are 2 correct answers to this question.

A. To build an interface for queries and reports

B. To combine different InfoProviders using Join operations or Union operations

C. To combine centrally managed data with local files

D. To build corporate memory for reconstructions

You need to view the SAP HANA calculation views, SAP BW DataSources, and InfoAreas in the same SAP HANA studio perspective. What should you do?

A. Attach an SAP BW project to an SAP HANA system.

B. Attach an SAP HANA system to an SAP BW project.

C. Attach an ABAP project to an SAP BW project.

D. Attach an SAP BW project to an ABAP project.

You create a transformation from a DataSource to a DataStore object (advanced). The DataSource provides an after-image delt

A. Which key figure aggregation type do you select?

B. Summation

C. Minimum

D. Maximum

E. Overwrite