SAP Certified Associate - Data Engineer - SAP BW/4HANA - C_P2WBW

QUESTION NO: 1
Which data deletion options are offered for a Standard DataStore Object (advanced)? Note: There are 3 correct answers to this question.

A. Deletion of all data from active table only B. Selective deletion of data C. Deletion of data from all tables D. Request-based data deletion E. Selective deletion including data of subsequent targets

Correct Answer: B,C,D

QUESTION NO: 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 correct answers to this question.

A. Formula cell B. Selection cell C. Reference cell D. Help cell

Correct Answer: A,B

QUESTION NO: 3
Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question.

A. Display text nodes B. Time dependency C. Sort direction D. Position of child nodes E. Expand to level

Correct Answer: C,D,E

QUESTION NO: 4
Which of the following are possible delta-specific fields for a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question.

A. Time stamp B. Numeric pointer C. Record mode D. Calendar day E. Request ID

Correct Answer: A,B,D

QUESTION NO: 5
Which features of an SAP BW/4HANA InfoObject are intended to reduce physical data storage space? Note: There are 2 correct answers to this question.

A. Enhanced master data update B. Transitive attribute C. Compounding characteristic D. Reference characteristic

Correct Answer: B,D

QUESTION NO: 6
What is the maximum number of reference characteristics that can be used for one key figure with a multi-dimensional exception aggregation in a BW query?

A. 10 B. 3 C. 5 D. 7

Correct Answer: C

QUESTION NO: 7
You create an SAP HANA HDI Calculation View.
What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? Note: There are 3 correct answers to this question.

A. You can create restricted columns. B. You can provide default time characteristics. C. You can aggregate measures as a sum. D. You can combine master data and transactional data. E. You can persist transactional data.

Correct Answer: C,D,E

QUESTION NO: 8
Which solution enables advanced Al and machine learning models on combined SAP and third-party data?

A. SAP AI Launchpad B. SAP Analytics Cloud C. SAP Datasphere D. SAP Databricks

Correct Answer: D

QUESTION NO: 9
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. Reporting on a harmonized set of master data B. Loading snapshots or deltas from different sources on a periodic basis C. Finding the best match using a fuzzy search D. Leveraging SQL in-house knowledge

Correct Answer: C,D

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