C-P2WBW-2505 Exam Training Practice Tests (SAP Certified Associate - Data Engineer

Question 1

Your company manufactures products with country-specific serial numbers.
For this scenario, you have created 3 custom characteristics with the technical names "PRODUCT", "COUNTRY" and "SERIAL_NO". How do you need to model the characteristic "PRODUCT" to store different attribute values for serial numbers?

A. Use "COUNTRY" as compounding characteristic for "PRODUCT". B. Use "SERIAL_NO" as compounding characteristic for "PRODUCT". C. Use "COUNTRY" as a navigation attribute for "PRODUCT". D. Use "SERIAL_NO" as a transitive attribute for "PRODUCT".

Correct Answer: B

Question 2

You created an Open ODS View on an SAP HANA database table to virtually consume the data in SAP BW/4HANA. Real-time reporting requirements have now changed and you are asked to persist the data in SAP BW/4HANA.
Which objects are created when using the "Generate Data Flow" function in the Open ODS View editor? Note: There are 3 correct answers to this question.

A. Data source B. Transformation C. SAP HANA calculation view D. DataStore object (advanced) E. CompositeProvider

Correct Answer: A,B,D

Question 3

You have an existing field-based data flow that follows the LSA++ concept. To meet a new urgent business requirement for a field, you want to leverage a hierarchy of an existing characteristic without changing the transformation.
How can you achieve this? Note: There are 2 correct answers to this question.

A. Associate the field with the characteristic in the Composite Provider B. Associate the field with the characteristic in the Open ODS View C. Add the characteristic to the DataStore object (advanced) D. Assign hierarchy properties to the field in the BW Query

Correct Answer: A,B

Question 4

You are involved in an SAP BW/4HANA project focusing on General Ledger reporting and want to use the SAP ERP standard DataSource OFI_GL_14 (New GL Items), which is not active in your SAP ERP system. Which transactions can be used to activate this DataSource? Note: There are 2 correct answers to this question.

A. Transaction RSDS (DataSource Repository) in the SAP BW/4HANA system B. Transaction RSA5 (Installation of DataSource from Business Content) in the SAP ERP system C. Transaction RSORBCT (Data Warehousing Workbench: BI Content) in the SAP BW/4HANA system D. Transaction RSA2 (DataSource Repository) in the SAP ERP system

Correct Answer: B,C

Question 5

You use InfoObject B as a display attribute for InfoObject A. Which object properties prevent you from changing InfoObject B into a navigational attribute for InfoObject A? Note: There are 3 correct answers to this question.

A. Data Type "Character String" is set in InfoObject A. B. Conversion Routine "ALPHA" is set in InfoObject C. Attribute Only is set in InfoObject D. High Cardinality is set in InfoObject E. InfoObject B is defined as a Key Figure.

Correct Answer: B,C,D

Question 6

Which are purposes of the Open Operational Data Store layer in the layered scalable architecture (LSA++) of SAP BW/4HANA? Note: There are 2 correct answers to this question.

A. Real-time reporting on source system data without staging B. Harmonization of data from several source systems C. Transformations on data based on business logic D. Initial staging of source system data

Correct Answer: A,B

Question 7

Which are purposes of the Open Operational Data Store layer in the layered scalable architecture (LSA++) of SAP BW/4HANA? Note: There are 2 correct answers to this question.

A. Real-time reporting on source system data without staging B. Harmonization of data from several source systems C. Transformations on data based on business logic D. Initial staging of source system data

Correct Answer: A,B

Question 8

What are some of the variable types in a BW query that can use the processing type SAP HANA Exit? Note: There are 2 correct answers to this question.

A. Text B. Characteristic value C. Formula D. Hierarchy node

Correct Answer: B,C

Question 9

Why should you run an SAP HANA delta merge? Note: There are 2 correct answers to this question.

A. To combine the query cache from different executions B. To decrease memory consumption C. To improve the read performance of InfoProviders D. To move the most recent data from disk to memory

Correct Answer: B,C

SAP Certified Associate - Data Engineer - SAP BW/4HANA - C-P2WBW-2505 Exam Practice Test