C_P2WBW_2505 Exam Training Practice Tests (SAP Certified Associate - Data Engineer

Question 1

For a report, you would like to highlight the deviation from predefined threshold values for a key figure. Which BW query feature do you use?

A. Exception B. Formula cell C. Key figure property D. Condition

Correct Answer: A

Question 2

For which requirements do you suggest an SAP HANA modeling focus rather than an SAP BW/4HANA modeling focus? Note: There are 2 correct answers to this question.

A. Finding the best match using a fuzzy search B. Reporting on a harmonized set of master data C. Leveraging SQL in-house knowledge D. Loading snapshots or deltas from different sources on a periodic basis

Correct Answer: A,C

Question 3

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

A. Load attributes using the enhanced master data update B. Store time-dependent snapshots of master data attributes C. Report on navigational attributes of navigational attributes D. Generate a transient provider for a BW query on master data attributes

Correct Answer: C

Question 4

How can the delta merge process be initiated in SAP BW/4HANA? Note: There are 2 correct answers to this question.

A. By using the SAP BW/4HANA data load monitor B. By using a specific process type in a process chain C. By setting a specific flag in the transformation D. By setting a specific flag in the data transfer process

Correct Answer: B,D

Question 5

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

A. Realizing direct access to source data without storing them B. Providing the delta extraction information of the source data C. Splitting a complex transformation into simple parts without storing intermediate data D. Enabling a data transfer process (DTP) to execute multiple sequential transformations

Correct Answer: A,C

Question 6

Which node type is available for both graphical modeling of SAP HANA HDI Calculation Views (XS Advanced) and SAP HANA Calculation Views (XS Classic)?

A. Rank B. Non Equi Join C. Graph D. Minus

Correct Answer: B

Question 7

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?

A. The logon language in the left table B. The language column in the right table C. The language column in the left table D. The join cardinality between both tables

Correct Answer: B

Question 8

In which ODP context is the operational delta queue (ODQ) managed by the target system?

A. ODP_CDS B. ODP_SAP C. ODP HANA D. ODP_BW

Correct Answer: C

Question 9

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

A. Only the most recent request in the active data table B. Any request in the active data table C. Only the most recent not activated request in the inbound table D. Any not activated request in the inbound table

Correct Answer: C

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