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

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" "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 compounding characteristic for "PRODUCT". B. Use "COUNTRY" as a navigation attribute for "PRODUCT". C. Use "SERIAL_NO" as a transitive attribute for "PRODUCT". D. Use "COUNTRY" as a compounding characteristic for "PRODUCT".

Correct Answer: A

Question 2

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

A. DataStore Object (advanced) B. Composite Provider C. InfoObject type Key Figure D. Hierarchy E. Open ODS View

Correct Answer: A,B,E

Question 3

You want to build an SAP HANA HDI calculation view of data category CUBE, but you get a "no measure defined" error.For the business requirement, a measure does not make sense.Besides changing the data category to DIMENSION, what do you have to do?

A. Switch from an aggregation node to a star join node. B. Switch from an aggregation node to a projection node. C. Switch from a projection node to a star join node. D. Switch from a projection node to an aggregation node.

Correct Answer: D

Question 4

For InfoObject ADDRESS, the High Cardinality flag has been set. However, ADDRESS has an attribute CITY without the High Cardinality flag.What is the effect on SID values in this scenario?

A. SID values are generated when data for InfoObject ADDRESS is loaded. B. SID values are generated when InfoObject CITY is activated. C. SID values are not stored for InfoObject ADDRESS. D. SID values are generated when InfoObject ADDRESS is activated.

Correct Answer: A

Question 5

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 correctanswers to this question.

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

Correct Answer: A,D

Question 6

You are allowed to run a BW query, but the data selection is only partially covered by your authorizations.
What happens related to the BW query in this scenario?

A. The BW query starts and shows an error message. B. The BW query starts and the unauthorized values are 0. C. The BW query starts and only the authorized data is displayed. D. The BW query does not start running.

Correct Answer: C

Question 7

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

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

Correct Answer: A,C,D

Question 8

Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP)? Note: There are 2 correctanswers to this question.

A. DataStore Object (advanced) B. Open ODS view C. InfoSource D. CompositeProvider

Correct Answer: A,D

Question 9

What are the prerequisites for deleting business partner attribute master data in SAP BW/4HANA? Note:
There are 2 correctanswers to this question.

A. In SAP BW/4HANA there must be no hierarchy data related to business partner values that should be deleted. B. There must be no BW query as InfoProvider in SAP BW/4HANA that uses business partner as a free characteristic. C. In SAP BW/4HANA there must be no analysis authorizations related to business partner values that should be deleted D. There must be no transaction data in a DataStore Object (advanced) referring to business partner values that should be deleted.

Correct Answer: A,D

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