SAP C_BW4H_2505 Exam Questions Instant Access

Question 1

You are allowed to run a BW query, but the data selection is only partially covered by your authorizations.What happens related to the BW query in this scenario?

AThe BW query starts and the unauthorized values are 0.

BThe BW query starts and only the authorized data is displayed.

CThe BW query does not start running.

DThe BW query starts and shows an error message.

Answer : B

Question 2

You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI) real-time update scenario.Which fields are added to the DataSource automatically?Note: There are 3 correct answe rs to this questio n.

ASDI_LENTITY_COUNTER

BSDILCHANGE_SEQUENCE

CSDILCHANGE_TIME

DSDILCHANGE_TYPE

ESDILRECORD_MODE

Answer : B, C, D

Question 3

Which data deletion options are offered for a Standard DataStore Object (advanced)?Note: There are 3 correct answe rs to this questio n.

ASelective deletion of data

BSelective deletion including data of subsequent targets

CRequest-based data deletion

DDeletion of data from all tables

EDeletion of all data from active table only

Answer : A, D, E

Question 4

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 5

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

Question 6

You want to create an HD! Calculation View (data category Dimension) and integrate it into an HDI Calculation View (data category Cube with Star Join) of the same HDI container.What is the first required step you need to take?

ACreate and build the HDI Calculation View (data category Dimension).

BCreate and build the HDI Calculation View (data category Cube with Star Join).

CCreate a synonym for the HDI Calculation View (data category Cube with Star Join).

DCreate a synonym for the HDI Calculation View (data category Dimension).

Answer : A

Question 7

For which requirements do you suggest an SAP HANA modeling focus rather than an focus? Note: There are 2 correct answe rs to this questio n.

AFinding the best match using a fuzzy search

BLoading snapshots or deltas from different sources on a periodic basis

CLeveraging SQL in-house knowledge

DReporting on a harmonized set of master data

Answer : A, C

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