C_BW4H_2505 SAP Certified Associate - Data Engineer - SAP BW/4HANA Questions and Answers

Which development object needs to be built to generate an HDI Container?

You create an SAP HANA HDI Calculation View.What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? Note: There are 3 correctanswers to this question.

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

In SAP Web IDE for SAP HANA, you have imported a project including an HDB module with calculation views.What do you need to do in the project settings before you can successfully build the HDB module?

Which recommendations should you follow to optimize BW query performance? Note: There are 3 correctanswers to this question.

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

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?

Which of the following are possible delta-specific fields for a generic DataSource in SAP S/4HANA? Note: There are 3 correctanswers to this question.

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?

For a report, you would like to highlight the deviation from predefined threshold values for a key figure.Which BW query feature do you use?

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

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

Which SAP BW/4HANA objects support the feature of generating an external SAP HANA View? Note: There are 2 correctanswers to this question.

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

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?

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

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.

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?

Which source types are available to create a generic DataSource in SAP ERP? Note: There are 3 correctanswers to this question.

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?

You are involved in an SAP BW/4HANA project focusing on General Ledger reporting want to use the SAP ERP stard 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 correctanswers to this question.