1. Home
  2. SAP
  3. SAP Certified Associate
  4. C_BW4H_2505
  5. SAP Certified Associate - Data Engineer - SAP BW/4HANA Questions and Answers

Pass the SAP SAP Certified Associate C_BW4H_2505 Questions and answers with CertsForce

 SAP Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

What are benefits of using an InfoSource in a data flow?Note: There are 2 correctanswers to this question.

Options:
A.

Splitting a complex transformation into simple parts without storing intermediate data

B.

Providing the delta extraction information of the source data

C.

Realizing direct access to source data without storing them

D.

Enabling a data transfer process (DTP) to execute multiple sequential transformations

Expert Solution
Questions # 2:

In a BW query with cells, you need to overwrite the initial definition of a cell.Which cell types can you use?Note: There are 2 correctanswers to this question.

Options:
A.

Formula cell

B.

Help cell

C.

Selection cell

D.

Reference cell

Expert Solution
Questions # 3:

What does a CompositeProvicer allow you to do in SAP BW/4HANA?Note: There are 3 correctanswers to this question.

Options:
A.

Join two ABAP CDS views

B.

Define new restricted key figures

C.

Create new calculated fields

D.

Combine InfoProviders using Joins and Unions

E.

Integrate SAP HANA calculation views

Expert Solution
Questions # 4:

You created a generic DataSource in SAP ERP, but did not release the DataSource for Operational Data Provisioning (ODP).What is the effect in SAP BW/4HANA?

Options:
A.

The ODP DataSource has to be created using the ODP_HANA source system type.

B.

The ODP DataSource has to be created using the ODP_SAP source system type.

C.

The ODP DataSource cannot be replicated using the ODP_SAP source system type.

D.

The ODP DataSource can be generated using the DataFlow generation feature.

Expert Solution
Questions # 5:

You need to derive an architecture overview model from a key figure matrix. Which is the first step you need to take?

Options:
A.

Identify transformations.

B.

Identify sources.

C.

Analyze storage requirements.

D.

Define data marts.

Expert Solution
Questions # 6:

What are the prerequisites for deleting business partner attribute master data in SAP BW/4HANA? Note: There are 2 correctanswers to this question.

Options:
A.

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

B.

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

C.

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

D.

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

Expert Solution
Questions # 7:

Which of the following are possible delta-specific fields for a generic DataSource in SAP S/4HANA? Note: There are 3 correctanswers to this question.

Options:
A.

Calendar day

B.

Request ID

C.

Numeric pointer

D.

Record mode

E.

Time stamp

Expert Solution
Questions # 8:

Which data deletion options are offered for a Standard DataStore Object (advanced)?Note: There are 3 correctanswers to this question.

Options:
A.

Selective deletion of data

B.

Selective deletion including data of subsequent targets

C.

Request-based data deletion

D.

Deletion of data from all tables

E.

Deletion of all data from active table only

Expert Solution
Questions # 9:

You create a report with SAP Crystal Reports for Enterprise and need an analysis view as a data source.Which tool can you use to create this analysis view?

Options:
A.

SAP Lumira, designer edition

B.

SAP BusinessObjects Web Intelligence

C.

SAP Analysis for Microsoft Office

D.

SAP Crystal Reports for Enterprise

Expert Solution
Questions # 10:

What are benefits of separating master data from transactional data in SAP BW/4HANA?Note: There are 3 correctanswers to this question.

Options:
A.

Reducing the number of database tables

B.

Ensuring referential integrity on your transactional data

C.

Avoiding generation of SID values

D.

Allowing different data load frequency

E.

Providing language-dependent master data texts

Expert Solution
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions