SAP C_BW4H_2505 Exam Practice Test Instant Access

Question 1

In a DataStore object (advanced) of type Data Mart, which request-based deletion is possible?

AAny not activated request in the inbound table

BOnly the most recent request in the active data table

CAny request in the active data table

DOnly the most recent not activated request in the inbound table

Answer : A, D

Question 2

What does a CompositeProvicer allow you to do in SAP BW/4HANA?Note: There are 3 correct answe rs to this questio n.

AJoin two ABAP CDS views

BDefine new restricted key figures

CCreate new calculated fields

DCombine InfoProviders using Joins and Unions

EIntegrate SAP HANA calculation views

Answer : B, C, D

Question 3

For which use case would you need to model a transitive attribute?

AGenerate a transient provider for a BW query on master data attributes

BStore time-dependent snapshots of master data attributes

CLoad attributes using the enhanced master data update

DReport on navigational attributes of navigational attributes

Answer : D

Question 4

For which scenarios do you use the SAP HANA model focus? Note: There are 2 correct answe rs to this questio n.

ALoad snapshots using ABAP CDS Views.

BBuild views procedures using SQL script.

CDefine ABAP Managed Database Procedures in data flows.

DDefine calculations using geospatial functions.

Answer : B, D

Question 5

In an SAP HANA smart data integration flowgraph, which transformation options are available?Note: There are 3 correct answe rs to this questio n.

ASplit datasets

BCall an ABAP function module

CInctude a stored procedure

DRun an SAP HANA analysis process

ECombine datasets

Answer : A, C, E

Question 6

In an SAP HANA HDI Calculation View, you need to combine attributes data (left table) and the data's language-dependent texts (right table) using a text join.What should you select to restrict the result set to the logon language?

AThe logon language in the left table

BThe join cardinality between both tables

CThe language column in the left table

DThe language column in the right table

Answer : D

Question 7

Why do you set Read Access Type to "SAP HANA View" in a BW InfoObject?

ATo report master data attributes which are defined in calculation views

BTo generate an SAP HANA calculation view, data category Dimension

CTo enable parallel loading of master data texts

DTo use the InfoObject as an association within an Open ODS view

Answer : A

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