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

Question 1

You want to create an HD! Calculation View (data category Dimension) and integrate it into an HDI Calculation View (data category Cube with Star Join) of the same HDI container.What is the first required step you need to take?

A. Create and build the HDI Calculation View (data category Cube with Star Join).

B. Create a synonym for the HDI Calculation View (data category Cube with Star Join).

C. Create a synonym for the HDI Calculation View (data category Dimension).

D. Create and build the HDI Calculation View (data category Dimension).

Correct Answer: D

Question 2

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

A. Exp to level

B. Display text nodes

C. Sort direction

D. Position of child nodes

E. Time dependency

Correct Answer: A,C,D

Question 3

With SAP BW/4HANA, the new HANA-optimized business content is designed according to the LSA++ framework.Which technical namespace is assigned to identify the new SAP ERP-related business content?

A. /BW4/

B. /IMO/

C. /CPMB/

D. /SFA/

Correct Answer: B

Question 4

What are benefits of separating master data from transactional data in SAP BW/4HANA?Note: There are 3 correctanswers to this question.

A. Avoiding generation of SID values

B. Allowing different data load frequency

C. Reducing the number of database tables

D. Providing language-dependent master data texts

E. Ensuring referential integrity on your transactional data

Correct Answer: B,D,E

Question 5

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 only the authorized data is displayed.

B. The BW query does not start running.

C. The BW query starts and the unauthorized values are 0.

D. The BW query starts and shows an error message.

Correct Answer: A

Question 6

You have already loaded data from a non-SAP system into . You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA.What do you need to use to combine the data?

A. SAP BW Shell Migration

B. SAP BW Remote Migration

C. SAP BW/4HANA Model Transfer

D. SAP ABAP Connection

Correct Answer: D

Question 7

What are benefits of using an InfoSource in a data flow?Note: There are 2 correctanswers to this question.

A. Providing the delta extraction information of the source data

B. Splitting a complex transformation into simple parts without storing intermediate data

C. Realizing direct access to source data without storing them

D. Enabling a data transfer process (DTP) to execute multiple sequential transformations

Correct Answer: B,D

Question 8

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 a projection node to an aggregation node.

B. Switch from a projection node to a star join node.

C. Switch from an aggregation node to a projection node.

D. Switch from an aggregation node to a star join node.

Correct Answer: A

Question 9

You created an Open ODS View on an SAP HANA database table to virtually consume the data in SAP BW
/4HANReal-time reporting requirements have now changed 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 correctanswers to this question.

A. DataStore object (advanced)

B. Data source

C. Transformation

D. CompositeProvider

E. SAP HANA calculation view

Correct Answer: A,B,C

Welcome to TestSimulate

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