SAP C_BW4H_2505 Exam Questions Instant Access

Question 1

You want to access data from a table residing in an external database using an SAP HANA SDA remote source.Which other SAP HANA element is required to access its data?

AFlowgraph

BVirtual Table

CTable Function

DReplication Task

Answer : B

Question 2

What are benefits of separating master data from transactional data in SAP BW/4HANA?Note: There are 3 correct answe rs to this questio n.

AReducing the number of database tables

BEnsuring referential integrity on your transactional data

CAvoiding generation of SID values

DAllowing different data load frequency

EProviding language-dependent master data texts

Answer : B, D, E

Question 3

Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answe rs to this questio n.

ACreate linked components.

BInclude fewer drill-down characteristics in the initial view.

CUse matory characteristic value variables.

DUse the include mode within filter restrictions.

EUse the dereference option for reusable filters.

Answer : B, C, D

Question 4

Your company manufactures products with country-specific serial numbers.For this scenario you have created 3 custom characteristics with the technical names "PRODUCT" "COUNTRY" "SERIAL_NO".How do you need to model the characteristic "PRODUCT" to store different attribute values for serial numbers?

AUse 'COUNTRY' as a navigation attribute for 'PRODUCT'.

BUse 'SERIAL_NO' as a transitive attribute for 'PRODUCT'.

CUse 'COUNTRY' as a compounding characteristic for 'PRODUCT'.

DUse 'SERIAL_NO' as a compounding characteristic for 'PRODUCT'.

Answer : D

Question 5

The Database Explorer in the Web IDE for SAP HANA provides a data file import wizard to create a table in SAP HANA from a flat file.What are possible actions after the system suggests the target structure?Note: There are 3 correct answe rs to this questio n.

ADefine sorting properties for a target table field.

BSwitch the table type between row store and column store.

CChange the order of the fields in the target table.

DRemove leading zeroes for a target table field.

EAdjust the suggested data type of the target table fields.

Answer : C, D, E

Question 6

Which objects values can be affected by the key date in a BW query? Note: There are 3 correct answe rs to this questio n.

ADisplay attributes

BBasic key figures

CTime characteristics

DHierarchies

ENavigation attributes

Answer : B, D, E

Question 7

What is the maximum number of reference characteristics that can be used for one key figure with a multi- dimensional exception aggregation in a BW query?

A10

Answer : C

SAP Certified Associate - Data Engineer - SAP BW/4HANA C_BW4H_2505 Exam Questions