SAP C_BW4H_2505 Exam Questions Instant Access

Question 1

What are the prerequisites for deleting business partner attribute master data in SAP BW/4HANA? Note: There are 2 correct answe rs to this questio n.

AThere must be no BW query as InfoProvider in SAP BW/4HANA that uses business partner as a free characteristic.

BIn SAP BW/4HANA there must be no hierarchy data related to business partner values that should be deleted.

CThere must be no transaction data in a DataStore Object (advanced) referring to business partner values that should be deleted.

DIn SAP BW/4HANA there must be no analysis authorizations related to business partner values that should be deleted

Answer : B, C

Question 2

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 3

You have an existing field-based data flow that follows the layered scalable architecture (LSA++) concept. To meet a new urgent business requirement for field you want to leverage a hierarchy of an existing characteristic without changing the transformation.How can you achieve this? Note: There are 2 correct answe rs to this questio n.

AAssign hierarchy properties to the field in the BW Query

BAdd the characteristic to the DataStore object (advanced)

CAssociate the field with the characteristic in the Open ODS View

DAssociate the field with the characteristic in the CompositeProvider

Answer : C, D

Question 4

You want to build a web-based dashboard with interactive visualizations using scripting.Which SAP tool can you use to create this?

ASAP Crystal Reports

BSAP Analytics Cloud

CSAP Smart Business Cockpits

DSAP BusinessObjects Web Intelligence
SAP BW/4HANA Project and Modeling Process

Answer : B

Question 5

You use a measure with semantic type "Amount with Currency Code" in your SAP HANA HDI calculation view.Which kind of currency reference can be assigned to the measure?Note: There are 2 correct answe rs to this questio n.

AAcolumn from another SAP HANA view

BA fixed currency from table TCURC

CAnother column of the same SAP HANA view

DA variable in the same SAP HANA view

Answer : C, D

Question 6

When loading master data for a material, you want to look at the new values before they are released for reporting.How can you make this possible?Note: There are 2 correct answe rs to this questio n.

AWhen you define the data transfer process, select the 'Get All New Data Request by Request' setting.

BWhen you define the attributes of the material characteristic, select the ''Time Dependent' setting.

CWhen you define the material characteristic, select the ''Enhanced Master data update'' setting.

DWhen you define the data transfer process, select the ''Set manually'' setting for ''Overall status of request''.

Answer : A, D

Question 7

For InfoObject ADDRESS, the High Cardinality flag has been set. However, ADDRESS has an attribute CITY without the High Cardinality flag.What is the effect on SID values in this scenario?

ASID values are generated when InfoObject ADDRESS is activated.

BSID values are generated when data for InfoObject ADDRESS is loaded.

CSID values are generated when InfoObject CITY is activated.

DSID values are not stored for InfoObject ADDRESS.

Answer : B

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