C-P2WBW-2505 by SAP Valid Free Exam Practice Test

Question 1

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 join cardinality between both tables B. The language column in the left table C. The language column in the right table D. The logon language in the left table

Correct Answer: C

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. Transformation B. Data source C. CompositeProvider D. SAP HANA calculation view E. DataStore object (advanced)

Correct Answer: A,B,E

Question 3

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?

A. The ODP DataSource can be generated using the DataFlow generation feature. 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 has to be created using the ODP HANA source system type.

Correct Answer: C

Question 4

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?

A. SAP Lumira, designer edition B. SAP Analysis for Microsoft Office C. SAP BusinessObjects Web Intelligence D. SAP Crystal Reports for Enterprise

Correct Answer: C

Question 5

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

A. By automating data ingestion pipelines B. By eliminating the need for rebuilding data structures and business logic externally C. By providing pre-built connectors to various data sources D. By streamlining data governance processes and minimizing the need for complex data security configurations

Correct Answer: B

Question 6

Why do you set Read Access Type to "SAP HANA View" in a BW InfoObject?

A. To report master data attributes which are defined in calculation views B. To generate an SAP HANA calculation view, data category Dimension C. To enable parallel loading of master data texts D. To use the InfoObject as an association within an Open ODS view

Correct Answer: B

Question 7

What are the reasons for implementing Composite Providers? Note: There are 2 correct answers to this question.

A. To provide an interface for BW queries B. To provide a virtual data mart layer that combines existing BW models C. To directly expose an SAP HANA table from an external schema D. To persist combined data for reporting

Correct Answer: A,B

Question 8

When loading master data for a material, you want to look at the new values before they are released for reporting How can you make this possible? Note: There are 2 correct answers to this question.

A. When you define the data transfer process, select the "Set manually" setting for "Overall status of request". B. When you define the attributes of the material characteristic, select the "Time Dependent" setting. C. When you define the material characteristic, select the "Enhanced Master data update" setting D. When you define the data transfer process, select the "Get All New Data Request by Request" setting

Correct Answer: A,C

Question 9

In an SAP HANA smart data integration flowgraph, which transformation options are available? Note: There are 3 correct answers to this question.

A. Split datasets B. Include a stored procedure C. Call an ABAP function module D. Combine datasets E. Run an SAP HANA analysis process

Correct Answer: A,B,D

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