SAP Certified Associate - Data Engineer - SAP BW/4HANA (C-P2WBW-2505) Free Practice Test

Question 1

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

A. Store time-dependent snapshots of master data attributes

B. Report on navigational attributes of navigational attributes

C. Load attributes using the enhanced master data update

D. Generate a transient provider for a BW query on master data attributes

Correct Answer: B

Question 2

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. Hierarchy node

B. Text

C. Formula

D. Characteristic value

Correct Answer: C,D

Question 3

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 "SERIAL_NO" as a transitive attribute for "PRODUCT".

B. Use "SERIAL_NO" as compounding characteristic for "PRODUCT".

C. Use "COUNTRY" as compounding characteristic for "PRODUCT".

D. Use "COUNTRY" as a navigation attribute for "PRODUCT".

Correct Answer: B

Question 4

You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue.
Using key figure properties in the BW query, which two scenarios regarding result presentation can be achieved? Note: There are 2 correct answers to this question.

A. One result row with the sales revenue sum of all 100 customers

B. One result row with the sales revenue sum of the top 10 customers

C. One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of all 100 customers

D. One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers

Correct Answer: B,D

Question 5

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 Databricks

D. SAP Datasphere

Correct Answer: C

Question 6

The Database Explorer in the Web IDE for SAP HANA provides a data file import wizard to create a table in SAP HANA from a flat file. What are possible actions after the system suggests the target structure? Note: There are 3 correct answers to this question.

A. Change the order of the fields in the target table.

B. Remove leading zeroes for a target table field.

C. Switch the table type between row store and column store.

D. Adjust the suggested data type of the target table fields.

E. Define sorting properties for a target table field.

Correct Answer: A,C,D

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. Harmonization of data from several source systems

B. Transformations on data based on business logic

C. Real-time reporting on source system data without staging

D. Initial staging of source system data

Correct Answer: A,C

Question 8

Which objects in SAP BW/4HANA allow you to use both fields and InfoObjects in their definition? Note: There are 3 correct answers to this question.

A. DataStore Object (advanced)

B. InfoObject Type Key Figure

C. Open ODS View

D. BADI Provider

E. CompositeProvider

Correct Answer: A,C,E

Question 9

How does integrating SAP Databricks within SAP Business Data Cloud reduce IT overhead for customers?

A. By eliminating the need for rebuilding data structures and business logic externally

B. By streamlining data governance processes and minimizing the need for complex data security configurations

C. By automating data ingestion pipelines

D. By providing pre-built connectors to various data sources

Correct Answer: A

Welcome to TestSimulate

SAP Certified Associate - Data Engineer - SAP BW/4HANA (C-P2WBW-2505) Free Practice Test