C_BW4HANA_27 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 of the following methods supports the SAP HANA data virtualization approach with OBDC technology?

A. SAP HANA smart data access

B. SAP HANA smart data integration

C. SAP Landscape Transformation Replication Server

D. SAP Data Services

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

Why do you recommend modeling a data layer in SAP BW/4HANA? Note: There are 2 correct answers to this question.

A. To pre-define a data layout

B. To fulfill snapshot requirements

C. To immediately display changed entries

D. To homogenize and cleanse data from different sources

Which objects can you use as components in a CompositeProvider in SAP BW/4HANA? Note: There are 2 correct answers to this question.

A. BW query

B. Open ODS view

C. CompositeProvider

D. Semantic group

What must you do to define an Inventory InfoProvider in SAP BW/4HANA? Note: There are 3 correct answers to this question.

A. Select the All Characteristics are Key model property.

B. Select the Unique Data Records model property.

C. Assign at least one non-cumulative key figure.

D. Assign at least one cumulative key figure.

E. Select the Inventory model property.

Which query property do you set to minimize the initial run time for the query read mode?

A. Read all data at once.

B. Read data individually from InfoProvider.

C. Cache is inactive.

D. Read data when you navigate or expand hierarchies.

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

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